A data processing method and apparatus

Abstract

The application discloses a kind of data processing method and device, it is related to computer technical field.The specific embodiment of the method includes: in response to the operation instruction of multiple form controls of preset, according to multiple form controls and corresponding operation instruction, generate form template;Determine the user information with authority corresponding to form template;According to the user information with authority, form template is sent to corresponding user with authority, so that the user with authority fills in data based on form template;Receive the form template filled with data sent by the user with authority;Based on the data processing strategy of preset and the form template filled with data, process data.The embodiment can effectively improve the security of data.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of computer, in particular to a data processing method and device. BACKGROUND

[0002] Various business scenarios such as warehouse-in goods, warehouse-out goods statistics, warehouse personnel situation management, and revenue and expenditure statistics of each regional organization all involve data collection, statistics, analysis and other data processing processes.

[0003] At present, in the process of processing data of various business scenarios, data related to the scene is collected through an excel table, and the collected data is further processed through the excel table.

[0004] In the process of implementing the present application, the inventors have found that at least the following problems exist in the prior art:

[0005] The existing data processing method through the excel table has low data security due to the openness of the excel table. SUMMARY

[0006] Therefore, the embodiments of the present application provide a data processing method and device, which can effectively improve the security of data.

[0007] To achieve the above object, according to one aspect of the embodiments of the present application, a data processing method is provided, comprising:

[0008] In response to an operation instruction of a plurality of preset form controls, a form template is generated according to the plurality of form controls and the corresponding operation instruction;

[0009] User information with authority corresponding to the form template is determined;

[0010] The form template is sent to the corresponding user with authority according to the user information with authority, so that the user with authority fills in data based on the form template;

[0011] The form template filled in with data sent by the user with authority is received;

[0012] The data is processed based on the form template filled in with data and a preset data processing strategy.

[0013] Preferably, the data processing method further comprises: setting a plurality of form rows / form columns, and setting a data name for each form row / form column;

[0014] The form template is generated, comprising:

[0015] According to the plurality of form controls and the corresponding operation instructions, corresponding data types are configured for the plurality of form rows / form columns;

[0016] The data names of the plurality of form rows / form columns and the corresponding data types are combined to obtain the form template.

[0017] Preferably, configuring the corresponding data types for the plurality of form rows / form columns comprises:

[0018] From the data names of the plurality of form rows / form columns, any unselected data name is selected;

[0019] According to the received operation instruction for at least one of the form controls, at least one of the form controls is determined for the selected data name, and the corresponding data type is configured for the selected data name, wherein the operation instruction comprises any one of the following instructions: a drag instruction, a copy instruction, a control code filling instruction, and a mapping instruction;

[0020] It is judged whether all the form rows / form columns have been selected,

[0021] If yes, the step of combining the data names of the plurality of form rows / form columns and the corresponding data types is performed.

[0022] Preferably, sending the form template to the corresponding user with authority comprises:

[0023] A reporting task is generated for the form template;

[0024] The reporting task is inserted into a task queue corresponding to the user with authority, so that the user with authority obtains the reporting task through the task queue.

[0025] Preferably, after the form template is sent to the corresponding user with authority, further comprising:

[0026] When the user with authority fills in data based on the form template,

[0027] For each of the form rows / form columns in the form template, the following is performed:

[0028] The data filled in by the user with authority for the form rows / form columns is obtained;

[0029] It is verified whether the data filled in the form rows / form columns meets the data type of the form rows / form columns, and if not, an indication of filling data error is fed back to the user with authority, so that the user with authority fills in again.

[0030] Preferably, processing the data comprises:

[0031] For the case that the received number of the data-filled form templates is multiple,

[0032] Combining the multiple data-filled form templates into one data table.

[0033] Preferably, combining the multiple data-filled form templates into one data table comprises:

[0034] Constructing one data table;

[0035] Mapping the data name of the data-filled form template into the table field name in the data table;

[0036] Mapping the filled data in the multiple data-filled form templates into the field value corresponding to the table field name.

[0037] Preferably,

[0038] The preset data processing strategy comprises a statistical index item, a measurement item and a data analysis mode;

[0039] Processing the data further comprises:

[0040] When receiving a selection operation on at least two table field names, dividing the field values corresponding to the selected at least two table field names into the statistical index item and the measurement item;

[0041] Using the data analysis mode to analyze the field values divided into the statistical index item and the measurement item to obtain an analysis result report.

[0042] Preferably, the data processing method further comprises:

[0043] Providing multiple report display components;

[0044] In response to receiving a selection operation on any report display component, displaying the analysis result report by using the selected report display component.

[0045] In a second aspect, an embodiment of the present application provides a data processing apparatus, comprising: a template generation unit, an interaction unit and a data processing unit, wherein,

[0046] The template generation unit generates a form template according to multiple form controls and corresponding operation instructions in response to operation instructions on the multiple form controls;

[0047] The interaction unit is configured to determine user information with authority corresponding to the form template, send the form template to the corresponding user with authority according to the user information with authority, so that the user with authority fills in data based on the form template, and receive the form template filled in with data sent by the user with authority.

[0048] The data processing unit is configured to process the data based on the form template filled in with data and a preset data processing strategy.

[0049] The above-mentioned embodiment of the application has the following advantages or beneficial effects: the form template is generated by using various form controls and corresponding operation instructions, the form template is sent to the corresponding user with authority according to the user information with authority, the user with authority fills in data based on the form template, the user with authority fills in data through the form template, and the user with authority only fills in data managed by the user and cannot see data filled in by other users with authority, that is, only the user with authority can obtain the form template, the user with authority fills in data based on the form template and cannot obtain data filled in by other users with authority, and the security of data is improved.

[0050] In addition, the form template is generated by using various form controls and corresponding operation instructions, so that the configuration of the form template is flexible, and the user with authority fills in data based on the form template, so that the data is unified and standardized.

[0051] The further effects of the above-mentioned non-conventional optional mode will be described in the following combined with the specific embodiments. BRIEF DESCRIPTION OF DRAWINGS

[0052] The accompanying drawings serve to better understand the application and do not constitute an improper limitation on the application. Among them:

[0053] Figure 1 is a schematic diagram of the main process of the data processing method according to the embodiment of the application;

[0054] Figure 2 is a schematic diagram of the main process of configuring corresponding data types for multiple form rows / form columns according to the embodiment of the application;

[0055] Figure 3 is a schematic diagram of the main process of sending the form template to the corresponding user with authority according to the embodiment of the application;

[0056] Figure 4is a schematic diagram of the main process of a user checking the data filled in the form row / form column according to an embodiment of the present application;

[0057] Figure 5 is a schematic diagram of merging a plurality of form templates filled with data into a data table according to an embodiment of the present application;

[0058] Figure 6 is a schematic diagram of the main unit of a data processing device according to an embodiment of the present application;

[0059] Figure 7 is an exemplary system architecture diagram to which an embodiment of the present application can be applied;

[0060] Figure 8 is a structural schematic diagram of a computer system of a terminal device or a server suitable for implementing an embodiment of the present application. DETAILED DESCRIPTION

[0061] Exemplary embodiments of the present application are described below with reference to the accompanying drawings, which include various details of the embodiments of the present application to assist in understanding, and should be considered as merely exemplary. Thus, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the present application. Also, for the sake of brevity and clarity, descriptions of well-known functions and constructions are omitted from the following description.

[0062] At present, users mainly use reports, forms, etc. to count various data such as the quantity of goods entering a warehouse, the quantity of goods leaving a warehouse, the management of warehouse personnel, the income and expenditure of each regional organization, etc. In order to count offline data in an online manner while ensuring the security of data, etc., an embodiment of the present application provides a data processing method.

[0063] Figure 1 is a data processing method according to an embodiment of the present application, as shown in Figure 1 the data processing method can include the following steps:

[0064] Step S101: in response to an operation instruction for a plurality of preset form controls, generating a form template according to the plurality of form controls and the corresponding operation instruction;

[0065] The form control refers to a control that can set a table type for a table on a page. The table type can be a number type, a text type, a date type, a single selection type, a multiple selection type, etc. Generally, one form control can set one table type.

[0066] The form template can include a form row or a form column, and the form row or the form column can include a data name and a data type corresponding to the data name. As shown in Table 1 below.

[0067] Table 1

[0068] Data name 1 Data name 2 Data name 3 Data name 4 Data name 5

[0069] Wherein, each data name corresponds to a corresponding data type, for example, the data name is name, and the corresponding data type can be text, for example, the data name is contact information, and the corresponding data type is number, the data name is the form filling date, and the corresponding data type is date, etc.

[0070] Step S102: determining the user information with authority corresponding to the form template;

[0071] Wherein, the user information with authority can be the user's mailbox, username, and other information that can represent the user's unique identifier. The user information with authority determined in this step S102 can be multiple user information with authority, such as multiple user mailboxes with authority, multiple user names with authority, etc.

[0072] Step S103: according to the user information with authority, sending the form template to the corresponding user with authority, so that the user with authority fills in the data based on the form template;

[0073] For example, the user information with authority is the mailbox of multiple users with authority, then this step can directly distribute and send the form template to multiple users with authority through the mailbox of multiple users with authority, or generate a corresponding access link for the form template and send the access link to the user with authority through the mailbox of multiple users with authority.

[0074] Step S104: receiving the form template filled with data sent by the user with authority;

[0075] Step S105: based on the form template filled with data and the preset data processing strategy, processing the data.

[0076] Wherein, the preset data processing strategy can include multiple data analysis methods, such as detailed table analysis method, aggregated table analysis method, pivot table analysis method, pie chart analysis method, column chart analysis method, line chart analysis method, Sankey chart analysis method, funnel chart analysis method, etc. At the same time, the preset data processing strategy can filter data through a data filter, and dynamically process the results required to be presented by the report using the filtered data, providing strong support for decision makers.

[0077] It is worth mentioning that the implementation mode of the above step S102 can provide all selectable users to the administrator, the administrator can select the user with the authority, if selected, the form is only distributed to the selected user with the authority, and only the selected user with the authority can submit the data; further, the user with the authority can be further subdivided, and has the distribution and mail notification function. If the user with the authority is not selected, it is an open form, anyone can open the form link to fill in. Here, the fuzzy search function is used to automatically associate the search system with the corresponding account, and the autocomplete component of elementUi (ui framework) can be used, and js asynchronous request of background account data can be used.

[0078] In Figure 1 In the embodiment shown, the form template is generated through various form controls and corresponding operation instructions; and the user information with the authority corresponding to the form template is determined, so that the form template is sent to the corresponding user with the authority according to the user information with the authority, so that the user with the authority fills in the data based on the form template, that is, the user with the authority can fill in the data through the form template, and the user with the authority only needs to fill in the data managed by himself, and cannot see the data filled in by other users with the authority, that is, the scheme provided by the embodiment of the application can only be obtained by the user with the authority, and the user with the authority cannot obtain the data filled in by other users with the authority, which can effectively improve the security of the data.

[0079] In addition, due to the form template, the form template can be generated through various form controls and corresponding operation instructions, so that the configuration of the form template is flexible; at the same time, since the user with the authority fills in the data based on the form template, the data is unified and standardized.

[0080] In addition, the scheme provided by the embodiment of the application can improve the security of offline data collection, and due to the controllability of the form template, the data granularity is smaller and the controllability is stronger. Online data template (each type of data can be limited by rules) can be made and automatically distributed to the corresponding personnel for offline data collection.

[0081] In the embodiment of the application, the data processing method can further include: setting a plurality of form rows / form columns, and setting a data name for each of the form rows / form columns; accordingly, generating the form template can include: configuring a corresponding data type for a plurality of the form rows / form columns according to the plurality of form controls and the corresponding operation instructions; combining the data names of the plurality of form rows / form columns and the corresponding data types to obtain the form template.

[0082] In the embodiment of the present application, as shown in Figure 2 The above configuring the data type corresponding to each of the plurality of form rows / form columns can include the following steps:

[0083] Step S201: selecting any unselected data name from the data names of the plurality of form rows / form columns;

[0084] For example, for each data name shown in Table 1 above, the data name 1, the data name 2, …, and the data name 5 shown in Table 1 can be sequentially selected by this step.

[0085] Step S202: determining at least one form control for the selected data name and configuring the data type corresponding to the selected data name according to the received operation instruction for at least one form control, wherein the operation instruction includes any one of the following instructions: a drag instruction, a copy instruction, a control code filling instruction, and a mapping instruction;

[0086] The drag instruction means that the form control can be dragged into the corresponding data name to set the data type corresponding to the form control for the data name.

[0087] The copy instruction means that the form control is copied and pasted to the corresponding data name to set the data type corresponding to the form control for the data name.

[0088] The control code filling instruction means that the corresponding data name is filled in the code corresponding to the form control to set the data type corresponding to the form control for the data name.

[0089] The mapping instruction means that a mapping relationship between the form control and the data name is constructed to set the data type corresponding to the form control for the data name.

[0090] Step S203: determining whether all the form rows / form columns have been selected, if yes, performing step S204; otherwise, performing step S201;

[0091] Step S204: combining the data names of the plurality of form rows / form columns and the corresponding data types.

[0092] The combination of this step S204 can obtain the form template shown in Table 1 above, and the data names in the form template have corresponding data types.

[0093] In the embodiment of the present application, as shown in Figure 3 The above sending the form template to the corresponding user with the authority can include the following steps:

[0094] Step S301: generating a filling task for the form template;

[0095] Step S302: inserting the filling task into a task queue corresponding to the user with the authority, so that the user with the authority obtains the filling task through the task queue.

[0096] The filling task is used to manage the form to be filled for the user, so as to avoid the user forgetting and improve the user experience. In addition, the task queue can also monitor whether there is no user with the authority returning the form template filled with data, so that the whole collection process is controllable, and the information of the personnel who have filled and the personnel who have not filled and the data submitted by each personnel can be clearly seen.

[0097] In the embodiment of the present application, as shown in Figure 4 After the form template is sent to the corresponding user with the authority, the following steps can be further included:

[0098] When the user with the authority fills data based on the form template, the following steps can be performed for each form row / form column in the form template:

[0099] Step S401: obtaining the data filled by the user with the authority for the form row / form column;

[0100] Step S402: checking whether the data filled in the form row / form column meets the data type of the form row / form column, if yes, ending the current process, otherwise, performing step S403;

[0101] Step S403: feeding back an indication of filling data error to the user with the authority, so that the user with the authority fills again.

[0102] The above process ensures the accuracy of the data type filled by the user, so as to further ensure the accuracy of subsequent data processing.

[0103] In the embodiment of the present application, the above processing the data can include: in the case that the number of the form templates filled with data received is multiple, merging multiple form templates filled with data into one data table.

[0104] In the embodiment of the present application, as shown in Figure 5 Merging multiple form templates filled with data into one data table can include the following steps:

[0105] Step S501: constructing a data table;

[0106] Step S502: mapping the data name of the form template filled with data into the table field name in the data table;

[0107] Step S503: mapping the data filled in the plurality of form templates filled with data into the field value corresponding to the table field name.

[0108] Through the above process, the forms sent by multiple users with permissions are uniformly managed.

[0109] In the embodiment of the application, the preset data processing strategy can include a statistical index item, a measurement item, and a data analysis method. Correspondingly, processing the data can further include: when receiving a selection operation on at least two of the table field names, dividing the field values corresponding to the selected at least two table field names into the statistical index item and the measurement item; using the data analysis method to analyze the field values divided into the statistical index item and the measurement item to obtain an analysis result report.

[0110] The statistical index item and the measurement item correspond to the data analysis method. For example, when the data analysis method is a column chart analysis method or a line chart analysis method, the statistical index item corresponds to the statistical index value of the horizontal coordinate of the column chart analysis method or the line chart analysis method, and the measurement item corresponds to the measurement value of the vertical coordinate of the column chart analysis method or the line chart analysis method. The measurement value corresponds to the statistical index value, that is, the measurement value is obtained based on the statistical index value.

[0111] Through the above steps S501 to S503, the collected form data is converted and processed, each data name is mapped into a table field name, and finally structured into a data table that can be used for analysis. The data table can be stored in a database such as TiDB, which can support online transaction processing / online analytical processing, realize one-key horizontal scaling, strong consistency of multiple copy data security, distributed transactions, compatibility with MySQL protocol and ecology, convenient migration, and extremely low operation and maintenance cost.

[0112] In the embodiment of the application, the data processing method can further include: providing a plurality of report display components; and in response to receiving a selection operation on any of the report display components, displaying the analysis result report using the selected report display component.

[0113] The collected data form is automatically dropped into a table, and an analysis report can be directly made using the collected data. The analysis ability of the collected data is improved.

[0114] As Figure 6As shown, the embodiment of the present application provides a data processing device 600, which can include a template generation unit 601, an interaction unit 602 and a data processing unit 603, wherein,

[0115] The template generation unit 601 generates a form template according to the plurality of form controls and the corresponding operation instructions in response to an operation instruction of the preset plurality of form controls.

[0116] The interaction unit 602 determines user information with authority corresponding to the form template, sends the form template to the corresponding user with authority to make the user with authority fill in data based on the form template according to the user information with authority, and receives the form template filled in with data sent by the user with authority.

[0117] The data processing unit 603 processes the data based on the form template filled in with data and a preset data processing strategy.

[0118] In the embodiment of the present application, the template generation unit 601 is further configured to set a plurality of form rows / form columns, set a data name for each form row / form column, configure a corresponding data type for the plurality of form rows / form columns according to the plurality of form controls and the corresponding operation instructions, and combine the data names of the plurality of form rows / form columns and the corresponding data types to obtain the form template.

[0119] In the embodiment of the present application, the template generation unit 601 is further configured to select any unselected data name from the data names of the plurality of form rows / form columns.

[0120] According to the received operation instruction for at least one form control, at least one form control is determined for the selected data name, and a corresponding data type is configured for the selected data name, wherein the operation instruction includes any one of a drag instruction, a copy instruction, a control code filling instruction and a mapping instruction; and it is judged whether all the form rows / form columns have been selected, and if so, the step of combining the data names of the plurality of form rows / form columns and the corresponding data types is executed.

[0121] In the embodiment of the present application, the interaction unit 602 generates a filling task for the form template, inserts the filling task into a task queue corresponding to the user with authority, so that the user with authority obtains the filling task through the task queue.

[0122] In the embodiment of the present application, the interaction unit 602 is further configured to, when the user with the permission fills in data based on the form template, for each form row / form column in the form template, perform the following: obtaining the data filled in by the user with the permission for the form row / form column; checking whether the data filled in the form row / form column meets the data type of the form row / form column, and if not, feeding back an indication of filling data error to the user with the permission, so that the user with the permission fills in again.

[0123] In the embodiment of the present application, the data processing unit 603 is configured to, when the number of the form templates with filled-in data received is more than one, combine the plurality of form templates with filled-in data into one data table.

[0124] In the embodiment of the present application, the data processing unit 603 is configured to construct a data table, map the data name of the form template with filled-in data into a table field name in the data table, and map the data filled in the plurality of form templates with filled-in data into a field value corresponding to the table field name.

[0125] In the embodiment of the present application, the preset data processing strategy includes a statistical index item, a measurement item, and a data analysis manner; and the data processing unit 603 is configured to, when receiving a selection operation on at least two table field names, divide the field values corresponding to the selected at least two table field names into the statistical index item and the measurement item, and analyze the field values divided into the statistical index item and the measurement item by using the data analysis manner to obtain an analysis result report.

[0126] In the embodiment of the present application, the data processing unit 603 is further configured to provide a plurality of report display components, and in response to receiving a selection operation on any report display component, display the analysis result report by using the selected report display component.

[0127] Figure 7 An exemplary system architecture 700 to which the data processing method or the data processing apparatus of the embodiments of the present application can be applied is shown.

[0128] As Figure 7As shown, the system architecture 700 can include terminal devices 701, 702, 703, a network 704, a server 705, and a database 706. The network 704 is used to provide a communication link medium between the terminal devices 701, 702, 703 and the server 705, between the terminal devices 701, 702, 703 and the database 706, and between the server 705 and the database 706. The network 704 can include various connection types, such as wired, wireless communication links, or optical fiber cables, etc.

[0129] A user can use the terminal devices 701, 702, 703 to interact with the server 705 through the network 704 to receive or send messages, etc. Various communication client applications can be installed on the terminal devices 701, 702, 703, such as web browser applications, search applications, instant messaging tools, email clients, social platform software, etc. (only as examples).

[0130] The terminal devices 701, 702, 703 can receive various form controls sent by the server 705 through various communication client applications installed, and send operation instructions of the form controls through the terminal devices 701, 702, 703; the server 705 receives the operation instructions of the form controls to generate a form template. The terminal devices 701, 702, 703 can also receive the form template sent by the server 705 through various communication client applications installed, so that a user with authority can access the form template through the terminal devices 701, 702, 703.

[0131] The terminal devices 701, 702, 703 can obtain form data or analysis reports, etc. from the database 706 through various communication client applications installed.

[0132] The terminal devices 701, 702, 703 can be various electronic devices with display screens and supporting web browsing, including but not limited to smart phones, tablet computers, laptop computers, desktop computers, etc.

[0133] The server 705 can be a server providing various services, such as a background management server supporting a form template filled with data provided by a user using a terminal device 701, 702, 703 (only as an example). The background management server can generate a form template and analyze a form template filled with data, etc., and feed back the processing results (such as report analysis results, data analysis charts - only as examples) to the terminal device.

[0134] The database 706 can also store the form template filled with data received by the server 705 and the analysis results of the data such as reports, etc.

[0135] It should be noted that the data processing method provided by the embodiments of the present application is generally executed by the server 705, and accordingly, the data processing apparatus is generally arranged in the server 705.

[0136] It should be understood that, Figure 7 The number of terminal devices, networks, servers and databases in the above-mentioned system is merely illustrative. Any number of terminal devices, networks, servers and databases can be provided according to the implementation needs.

[0137] Reference will be made to Figure 8 which shows a structural schematic diagram of a computer system 800 suitable for implementing the terminal device of the embodiments of the present application. Figure 8 The terminal device or server shown is merely an example and should not bring any limitation to the functions and use range of the embodiments of the present application.

[0138] As shown in Figure 8 , the computer system 800 includes a central processing unit (CPU) 801 which can perform various appropriate actions and processes according to programs stored in a read-only memory (ROM) 802 or programs loaded from a storage portion 808 into a random access memory (RAM) 803. Various programs and data required for the operation of the system 800 are also stored in the RAM 803. The CPU 801, the ROM 802 and the RAM 803 are connected to each other through a bus 804. An input / output (I / O) interface 805 is also connected to the bus 804.

[0139] The following components are connected to the I / O interface 805: an input portion 806 including a keyboard, a mouse, etc.; an output portion 807 including a display such as a cathode ray tube (CRT), a liquid crystal display (LCD), etc., and a speaker, etc.; a storage portion 808 including a hard disk, etc.; and a communication portion 809 including a network interface card such as a LAN card, a modem, etc. The communication portion 809 performs communication processing via a network such as the Internet. A drive 810 is also connected to the I / O interface 805 as needed. A removable recording medium 811 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, etc. is attached to the drive 810 as needed, so that a computer program read therefrom is installed into the storage portion 808 as needed.

[0140] In particular, the processes described above with reference to the flow charts can be implemented as a computer software program in accordance with the embodiments disclosed herein. For example, embodiments disclosed herein include a computer program product which includes a computer program tangibly embodied on a computer readable medium, the computer program containing program code for executing the methods illustrated by the flow charts. In such embodiments, the computer program can be downloaded and installed from a network via the communication portion 809 and / or installed from a removable media 811. When the computer program is executed by the central processing unit (CPU) 801, the above-described functions defined in the system of the present invention are performed.

[0141] It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination thereof. The computer readable storage medium may, for example, be, but is not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, device or apparatus, or any combination thereof. More specific examples of the computer readable storage medium can include, but are not limited to, an electrical connection having one or more wires, a portable computer diskette, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination thereof. In the present invention, the computer readable storage medium can be any tangible medium that contains or stores a program that can be used by or in connection with an instruction execution system, apparatus or device. In the present invention, the computer readable signal medium can include a data signal propagated in a baseband or as a carrier wave in a propagated data signal, in which the computer readable program code is carried. Such a propagated data signal can take many forms, including but not limited to, an electromagnetic signal, an optical signal or any suitable combination thereof. The computer readable signal medium can also be any computer readable medium that can send, propagate or transfer a program for use by or in connection with an instruction execution system, apparatus or device. The program code contained on the computer readable medium can be transmitted using any suitable medium, including but not limited to, wireless, wire line, optical fiber cable, RF, etc., or any suitable combination thereof.

[0142] The computer program product of the present application can be a computer program embodied on a computer readable medium. The computer program product can be stored in the memory 130 and executed by the processor 120 under the control of the operating system. The computer program product can include a set of instructions that, when executed by the processor 120, causes the processor 120 to carry out the steps of the present application. The computer readable medium can be a floppy disk, a CD-ROM, a DVD, a Blu-ray Disc, a hard disk, a USB flash drive, a memory card, a ROM, a PROM, an EPROM, an EEPROM, or a FLASH memory.

[0143] The units described in the embodiments of the present application can be implemented by software, or by hardware, or by a combination of software and hardware. The units described can be arranged in a processor, for example, a processor can be described as including a template generation unit, an interaction unit, and a data processing unit. In some cases, the names of the units do not constitute a limitation on the units themselves, for example, the template generation unit can also be described as a unit that generates a form template according to a plurality of form controls and corresponding operation instructions.

[0144] As another aspect, the present application also provides a computer readable medium, which can be included in the device described in the above embodiments, or can exist separately and not be assembled into the device. The computer readable medium carries one or more programs, which, when executed by the device, cause the device to include: generating a form template according to a plurality of form controls and corresponding operation instructions in response to operation instructions of the plurality of form controls; determining user information with authority corresponding to the form template; sending the form template to the corresponding user with authority according to the user information with authority, so that the user with authority fills in data based on the form template; receiving the form template filled in with data sent by the user with authority; and processing the data based on the form template filled in with data and a preset data processing strategy.

[0145] According to the technical scheme of the embodiment of the present application, the form template is generated through various form controls and corresponding operation instructions, and the user information with the authority corresponding to the form template is determined, so that the form template is sent to the corresponding user with the authority according to the user information with the authority, so that the user with the authority fills in the data based on the form template, that is, the user with the authority can fill in the data through the form template, and the user with the authority obtains the form template, which only needs to fill in the data managed by the user and cannot see the data filled in by other users with the authority, that is, only the user with the authority can obtain the form template according to the scheme provided by the embodiment of the present application, and the user with the authority fills in the data based on the form template and cannot obtain the data filled in by other users with the authority, so that the security of the data can be effectively improved.

[0146] In addition, the form template can be generated through various form controls and corresponding operation instructions, so that the configuration of the form template is flexible, and meanwhile, the user with the authority fills in the data based on the form template, so that the data is unified and standardized.

[0147] The above specific embodiments do not constitute a limitation on the protection scope of the present application. Those skilled in the art should understand that various modifications, combinations, sub-combinations and substitutions can be made depending on design requirements and other factors. Any modification, equivalent replacement and improvement made within the spirit and principle of the present application should be included in the protection scope of the present application.

Claims

1. A data processing method, characterized in that, include: In response to operation instructions for a variety of preset form controls, a form template is generated based on the variety of form controls and the corresponding operation instructions; Determine the authorized user information corresponding to the form template; Based on the authorized user information, the form template is sent to the corresponding authorized user so that the authorized user can fill in the data based on the form template; Receive a form template containing data sent by the authorized user; The data is processed based on a form template containing filled-in data and a preset data processing strategy. The preset data processing strategy includes: statistical indicators, measurement items, and data analysis methods; Further includes: setting multiple form rows / form columns, and setting a data name for each of the form rows / form columns; The generated form template includes: Configure corresponding data types for multiple form rows / columns based on the various form controls and their corresponding operation instructions; The form template is obtained by combining the data names and corresponding data types of the multiple form rows / columns; Processing the data includes: For cases where there are multiple received form templates with filled data, a data table is constructed; the data names of the form templates with filled data are mapped to the table field names in the data table; the data filled in from multiple form templates with filled data are mapped to the field values ​​corresponding to the table field names; When a selection operation for at least two of the table field names is received, the field values ​​corresponding to the selected at least two table field names are assigned to the statistical indicator items and the measurement items; using the data analysis method, the field values ​​assigned to the statistical indicator items and the measurement items are analyzed to obtain an analysis result report.

2. The data processing method according to claim 1, characterized in that, Configure the corresponding data types for the multiple form rows / form columns, including: Select any data name that has not been selected from the data names of the multiple form rows / columns; Based on the received operation instructions for at least one of the form controls, at least one of the form controls is determined for the selected data name, and a corresponding data type is configured for the selected data name, wherein the operation instructions include any one of the following: drag and drop instructions, copy instructions, control code filling instructions, and mapping instructions; Determine whether all of the form rows / columns have been selected. If so, then perform the step of combining the data names and corresponding data types of the multiple form rows / columns.

3. The data processing method according to claim 1, characterized in that, Sending the form template to the corresponding authorized user includes: Generate a form filling task for the form template; The data entry task is inserted into the task queue corresponding to the authorized user, so that the authorized user can obtain the data entry task through the task queue.

4. The data processing method according to claim 1 or 2, characterized in that, After sending the form template to the corresponding authorized user, the process further includes: When an authorized user fills in data based on the form template For each of the form rows / columns in the form template, execute: Obtain the data filled in by the authorized user for the form row / the form column; The system verifies whether the data entered in the form row / column meets the data type requirements of the form row / column. If not, it sends an error message to the authorized user so that the authorized user can re-enter the data.

5. The data processing method according to claim 1, characterized in that, Further includes: Offers a variety of report display components; In response to receiving a selection operation for any of the report display components, the analysis result report is displayed using the selected report display component.

6. A data processing apparatus, characterized in that, include: The template generation unit, the interaction unit, and the data processing unit are included. The template generation unit, in response to operation instructions for a variety of preset form controls, generates a form template based on the variety of form controls and the corresponding operation instructions; The interaction unit is used to determine the authorized user information corresponding to the form template; send the form template to the corresponding authorized user according to the authorized user information, so that the authorized user fills in data based on the form template; and receive the form template with data filled in sent by the authorized user. The data processing unit is used to process the data based on a form template containing the data and a preset data processing strategy; the preset data processing strategy includes: statistical indicators, measurement items, and data analysis methods. The template generation unit is further configured to set multiple form rows / columns and set a data name for each form row / column; configure corresponding data types for the multiple form rows / columns according to the various form controls and the corresponding operation instructions; and combine the data names and corresponding data types of the multiple form rows / columns to obtain the form template. The data processing unit is also used for: For cases where there are multiple received form templates with filled data, a data table is constructed; the data names of the form templates with filled data are mapped to the table field names in the data table; the data filled in from multiple form templates with filled data are mapped to the field values ​​corresponding to the table field names; When a selection operation for at least two of the table field names is received, the field values ​​corresponding to the selected at least two table field names are assigned to the statistical indicator items and the measurement items; using the data analysis method, the field values ​​assigned to the statistical indicator items and the measurement items are analyzed to obtain an analysis result report.

7. A data processing electronic device, characterized in that, include: One or more processors; Storage device for storing one or more programs. When the one or more programs are executed by the one or more processors, the one or more processors implement the method as described in any one of claims 1-5.

8. A computer-readable medium having a computer program stored thereon, characterized in that, When the program is executed by the processor, it implements the method as described in any one of claims 1-5.

Images