Data processing method, device, equipment, and storage medium

Abstract

The present invention relates to the field of data analysis, and discloses a data processing method, device, equipment and storage medium. The method comprises: obtaining the business data to be processed in the commission calculation system, and extracting the sales data of at least one salesperson therefrom for analysis to obtain all product data; according to the product data, calling the corresponding data processing rules from the preset data processing rule library; based on the commission calculation rules in the data processing rule set, performing commission calculation on all product data, and outputting the total business commission of the salesperson. The present invention can solve the technical problems that different marketing departments have a variety of different commission calculation rules, and the commission calculation method is relatively single and cannot flexibly adapt to the rapidly changing marketing environment. Among them, the business data of the salesperson can be stored in the blockchain.

Description

Technical Field

[0001] The present invention relates to the field of data analysis, and in particular to a data processing method, device, equipment and storage medium. Background Art

[0002] With the progress of society and economic development, people are paying more attention to aspects such as medical care and property safety, and the insurance business is developing rapidly.

[0003] In order to adapt to the needs of business development, the business commission calculation system on the market is mainly customized for each business, and the commission calculation system developed cannot be applied to other business commission calculations. The sales commission calculation rules are basically customized for specific businesses. Different industries and businesses have different solutions for commission calculations, and the cost of customized development is high.

[0004] Moreover, since insurance sales may be long-term and sold in multiple periods, the commission ratios for different periods may be different, or a single sales behavior may involve multiple people in the commission calculation, the marketing department may have a variety of different commission calculation rules, resulting in the current system being unable to achieve compatible use of rules, which increases the complexity of business sales commission calculation. Summary of the invention

[0005] The main purpose of the present invention is to solve the technical problem that the existing commission calculation method is relatively simple and cannot flexibly adapt to the rapidly changing marketing environment.

[0006] A first aspect of the present invention provides a data processing method, comprising:

[0007] Acquire the business data to be processed in the commission calculation system, clean the business data to be processed, and extract business data of at least one salesperson based on the cleaned data, wherein the business data to be processed includes sales data of at least one business;

[0008] Analyze the sales data to obtain all product data in the sales data;

[0009] According to the product data, calling corresponding data processing rules from a preset data processing rule library, wherein the data processing rules are commission calculation rules for the salesperson selling the product data;

[0010] Based on the commission calculation rules in the data processing rule set, commission calculation is performed on all the product data, and the total business commission of the salesperson is output.

[0011] Optionally, in a first implementation of the first aspect of the present invention, before obtaining the business data to be processed in the commission calculation system, performing data cleaning on the business data to be processed, and extracting business data of at least one salesperson based on the cleaned data, the method further includes:

[0012] Obtaining business scenarios included in the commission calculation system, and analyzing business requirements and the business scenarios to obtain commission calculation factors for commission calculation, wherein the commission calculation factors include commission participants, product types, and transaction dates;

[0013] Based on the commission calculation factors, determining the commission calculation rules corresponding to each of the business scenarios, wherein each of the commission calculation factor groups corresponds to a fixed commission calculation rule;

[0014] Defining a commission calculation factor data model, and combining the commission calculation factors to obtain a commission calculation factor set;

[0015] Based on the commission calculation factor set, a mapping relationship between the commission calculation factors and the commission calculation rules is established to obtain a mapping relationship set.

[0016] Optionally, in a second implementation of the first aspect of the present invention, the obtaining of the business data to be processed in the commission calculation system, and performing data cleaning on the business data to be processed, and extracting business data of at least one salesperson based on the cleaned data includes:

[0017] Receive data cleaning requests;

[0018] Determining a data cleaning rule according to the data cleaning request, wherein the data cleaning rule includes a cleaning characteristic factor and a cleaning condition satisfied by the cleaning characteristic factor;

[0019] Acquire the business data to be processed in the commission calculation system, and determine the characteristic factor value corresponding to the cleaning characteristic factor according to the business data to be processed in the commission calculation system;

[0020] The business data to be processed is cleaned according to the data cleaning rule and the characteristic factor value to obtain business data of at least one salesperson.

[0021] Optionally, in a third implementation of the first aspect of the present invention, analyzing the sales data to obtain all product data in the sales data includes:

[0022] A sales data input interface is set on the interface of the preset product transaction system, and online or offline product sales data is input automatically or manually through the sales data input interface, wherein the preset product transaction system is provided with an order database and an execution script;

[0023] Calling the execution script, training the order data in the product sales data according to the preset execution rules, and generating an order queue;

[0024] Based on the order queue, all product data in the sales data is obtained.

[0025] Optionally, in a fourth implementation of the first aspect of the present invention, calling a corresponding data processing rule from a preset data processing rule library according to the product data includes:

[0026] Parsing the product data to obtain keywords corresponding to the product data, and retrieving parameter fields according to the keywords, wherein the parameter fields include commission calculation factors, and the commission calculation factors and commission calculation rules have a preset corresponding relationship;

[0027] Obtaining a preset data table from a database, and determining whether the preset data table satisfies a data verification rule, wherein the preset data table is used to store commission calculation factors;

[0028] If the preset data table satisfies the data verification rule, all commission calculation factors corresponding to the product data in the preset data table are obtained based on the parameter field;

[0029] Receiving a data processing rule matching request, and matching a data processing rule corresponding to the product data from a preset data processing rule library according to the commission calculation factor, to obtain a data processing rule set for the business data to be processed;

[0030] Determining the priority of the data processing rule in the data processing rule set by a preset data priority calculation method;

[0031] The data processing rule with the highest priority is called in descending order of priority of the data processing rules.

[0032] Optionally, in a fifth implementation of the first aspect of the present invention, the performing commission calculation on all the product data based on the commission calculation rule in the data processing rule set and outputting the total commission of the salesperson includes:

[0033] Receive a commission calculation instruction, and obtain a corresponding commission rule code according to the commission calculation instruction;

[0034] According to the commission rule code and the commission calculation rule, commission calculation is performed on all the product data to obtain a calculation result;

[0035] According to the calculation result, the total commission of the salesperson is output.

[0036] Optionally, in a sixth implementation of the first aspect of the present invention, before obtaining the business data to be processed in the commission calculation system, performing data cleaning on the business data to be processed, and extracting business data of at least one salesperson based on the cleaned data, the method further includes:

[0037] The management attributes of the salesmen are obtained, and the salesmen for which commissions are to be calculated are classified into ordinary salesmen and management staff according to the management attributes, wherein the management staff include first-level management staff and second-level management staff for managing the first-level management staff, and the management relationship between the salesmen is obtained.

[0038] A second aspect of the present invention provides a data processing device, comprising:

[0039] A cleaning module, used to obtain the business data to be processed in the commission calculation system, and perform data cleaning on the business data to be processed, and extract business data of at least one salesperson based on the cleaned data, wherein the business data to be processed includes sales data of at least one business;

[0040] An analysis module, used to analyze the sales data to obtain all product data in the sales data;

[0041] A calling module, used to call corresponding data processing rules from a preset data processing rule library according to the product data, wherein the data processing rules are commission calculation rules for the salesperson selling the product data;

[0042] A calculation module is used to perform commission calculation on all the product data based on the commission calculation rules in the data processing rule set, and output the total business commission of the salesperson.

[0043] Optionally, in a first implementation of the second aspect of the present invention, the data processing device further includes:

[0044] An acquisition module is used to acquire business scenarios included in the commission calculation system, and analyze business requirements and the business scenarios to obtain commission calculation factors for commission calculation, wherein the commission calculation factors include commission participants, product types, and transaction dates;

[0045] A determination module, used to determine the commission calculation rules corresponding to each of the business scenarios based on the commission calculation factors, wherein each of the commission calculation factor groups corresponds to a fixed commission calculation rule;

[0046] A definition module, used to define a commission calculation factor data model, and to combine the commission calculation factors to obtain a commission calculation factor set;

[0047] An establishment module is used to establish a mapping relationship between the commission calculation factors and the commission calculation rules based on the commission calculation factor set to obtain a mapping relationship set.

[0048] Optionally, in a second implementation of the second aspect of the present invention, the cleaning module is specifically used for:

[0049] Receive data cleaning requests;

[0050] Determining a data cleaning rule according to the data cleaning request, wherein the data cleaning rule includes a cleaning characteristic factor and a cleaning condition satisfied by the cleaning characteristic factor;

[0051] Acquire the business data to be processed in the commission calculation system, and determine the characteristic factor value corresponding to the cleaning characteristic factor according to the business data to be processed in the commission calculation system;

[0052] The business data to be processed is cleaned according to the data cleaning rule and the characteristic factor value to obtain business data of at least one salesperson.

[0053] Optionally, in a third implementation of the second aspect of the present invention, the analysis module is specifically used to:

[0054] A sales data input interface is set on the interface of the preset product transaction system, and online or offline product sales data is input automatically or manually through the sales data input interface, wherein the preset product transaction system is provided with an order database and an execution script;

[0055] Calling the execution script, training the order data in the product sales data according to the preset execution rules, and generating an order queue;

[0056] Based on the order queue, all product data in the sales data is obtained.

[0057] Optionally, in a fourth implementation of the second aspect of the present invention, the data processing device further includes:

[0058] A parsing module, used to parse the product data, obtain keywords corresponding to the product data, and retrieve parameter fields according to the keywords, wherein the parameter fields include commission calculation factors, and the commission calculation factors and commission calculation rules have a preset corresponding relationship;

[0059] A judgment module, used for obtaining a preset data table from a database and judging whether the preset data table satisfies a data verification rule, wherein the preset data table is used to store commission calculation factors; if the preset data table satisfies the data verification rule, then all commission calculation factors corresponding to the product data in the preset data table are obtained based on the parameter field;

[0060] A matching module, used to receive a data processing rule matching request, and match the data processing rule corresponding to the product data from a preset data processing rule library according to the commission calculation factor to obtain a data processing rule set for the business data to be processed; and determine the priority of the data processing rule in the data processing rule set by a preset data priority calculation method;

[0061] The calling module is used to call the data processing rule with the highest priority according to the order of priority of the data processing rules from high to low.

[0062] Optionally, in a fifth implementation of the second aspect of the present invention, the calculation module includes:

[0063] A receiving unit, used for receiving a commission calculation instruction and obtaining a corresponding commission rule code according to the commission calculation instruction;

[0064] A calculation unit, used to perform commission calculation on all the product data according to the commission rule code and the commission calculation rule to obtain a calculation result;

[0065] The output unit is used to output the total commission of the salesperson according to the calculation result.

[0066] Optionally, in a sixth implementation of the second aspect of the present invention, the data processing device further includes:

[0067] A classification module is used to obtain the management attributes of salesmen, and classify the salesmen for which commissions are to be calculated into ordinary salesmen and management staff according to the management attributes, wherein the management staff includes first-level management staff and second-level management staff for managing the first-level management staff, and obtain the management relationship between the salesmen.

[0068] A third aspect of the present invention provides a data processing device, comprising: a memory and at least one processor, wherein instructions are stored in the memory, and the memory and the at least one processor are interconnected via a line;

[0069] The at least one processor calls the instructions in the memory to enable the data processing device to execute the above-mentioned data processing method.

[0070] A fourth aspect of the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores instructions, which, when executed on a computer, enable the computer to execute the above-mentioned data processing method.

[0071] In the technical solution provided by the present invention, all product data are obtained by obtaining the business data to be processed in the commission calculation system and extracting the sales data of at least one salesperson therefrom for analysis; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data to output the total business commission of the salesperson. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order. BRIEF DESCRIPTION OF THE DRAWINGS

[0072] Figure 1 A schematic diagram of a first embodiment of a data processing method of the present invention;

[0073] Figure 2 A schematic diagram of a second embodiment of the data processing method of the present invention;

[0074] Figure 3 A schematic diagram of a third embodiment of the data processing method of the present invention;

[0075] Figure 4 is a schematic diagram of a fourth embodiment of the data processing method of the present invention;

[0076] Figure 5 is a schematic diagram of a fifth embodiment of the data processing method of the present invention;

[0077] Figure 6 It is a schematic diagram of a first embodiment of a data processing device of the present invention;

[0078] Figure 7 is a schematic diagram of a second embodiment of a data processing device of the present invention;

[0079] Figure 8 The figure is a schematic diagram of an embodiment of a data processing device of the present invention. DETAILED DESCRIPTION

[0080] The embodiments of the present invention provide a data processing method, device, equipment and storage medium. In the technical solution of the present invention, the business data to be processed that has been cleaned in the commission calculation system is obtained, and the sales data of at least one salesperson is extracted therefrom; the sales data is analyzed to obtain all product data; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data, and the total business commission of the salesperson is output. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order.

[0081] 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.

[0082] For ease of understanding, the specific process of the embodiment of the present invention is described below. Figure 1 , a first embodiment of the data processing method in the embodiment of the present invention includes:

[0083] 101. Obtain the pending business data in the commission calculation system, clean the pending business data, and extract business data of at least one salesperson based on the cleaned data;

[0084] In this embodiment, the business data of the ordinary staff is cached in the preset database. When calculating the commission, the business data of the ordinary staff is first obtained, and the commission calculation result of the ordinary staff is obtained according to the ordinary staff commission calculation formula, and the business data of the popular staff is cached in the memory.

[0085] 102. Analyze the sales data to obtain all product data in the sales data;

[0086] In this embodiment, the main information included in the sales data to be counted includes: customer name, customer account, order data and other fields. The order data mainly includes a list of goods consumed by the customer and basic information of the goods, order creation time information, order amount to be paid and basic information of the verification end account corresponding to the order, etc.

[0087] In this embodiment, the product traded in each order, the product type, quantity, unit price, transaction completion time, etc. are determined based on the order data.

[0088] 103. According to the product data, select a corresponding data processing rule from a preset data processing rule library to obtain a data processing rule set for the business data to be processed;

[0089] In this embodiment, the product traded in each order, the product type, quantity, unit price, transaction completion time, etc. are determined based on the order data, the commission calculation factor corresponding to the product is determined, and the commission calculation rule corresponding to the order data is matched from the preset rule library based on the mapping relationship between the commission calculation factor and the commission calculation rule. For example, in some business scenarios, the same product or sales can support more than one different mode of commission calculation. For example, for a product, the commission is usually calculated at 10%, and if it is sold during Double 11, an additional commission of 100 yuan will be added on the basis of 10%. Combine multiple commission calculation rules to meet the commission calculation of this scenario.

[0090] In this embodiment, the corresponding relationship can be understood as the corresponding relationship between the commission calculation factor and the rule code of the commission calculation rule. According to the rule code corresponding to the commission calculation factor queried from the mapping relationship set, the corresponding commission calculation rule is queried from the rule base. The set of multiple commission calculation rules is the data processing rule set.

[0091] 104. Based on the commission calculation rules in the data processing rule set, commission calculation is performed on all product data, and the total commission of the salesperson is output.

[0092] In this embodiment, since there are many commission calculation rules, in order to adapt to any commission calculation rule, the above embodiments can be combined to encapsulate all commission calculation factors in the factor encapsulation package. Each time the commission is calculated, the corresponding commission calculation factor can be screened out from the factor encapsulation package. That is, for this commission calculation, the commission calculation platform can automatically screen out the commission calculation factor corresponding to the factor type in the commission calculation rule used this time from all the commission calculation factors contained in the factor encapsulation package. For example, a common scenario in the insurance industry: a salesperson sells a product A and takes a commission of 10% of the sales amount, his superior takes a commission of 5%, and his superior's superior takes a commission of 1%. When the salesperson sells a product B, it is an ordinary sales commission calculation without a hierarchical relationship (percentage, fixed price); for example, if you sell a health insurance, you can get a fixed commission of 1,000 yuan or a fixed percentage of commission, such as 10%. Or, when a product is jointly sold by salesperson A and salesperson B, the commission generated by the product is 10%, and this 10% can be taken by different people according to the configured ratio, and can be split in half, so each person takes 5%. According to the commission calculation rules, calculate the sales commission of the salesperson whose commission is to be calculated.

[0093] In an embodiment of the present invention, all product data is obtained by acquiring the business data to be processed in the commission calculation system and extracting the sales data of at least one salesperson therefrom for analysis; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data to output the total commission of the salesperson. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order.

[0094] See also Figure 2 , a second embodiment of the data processing method in the embodiment of the present invention includes:

[0095] 201. Obtain the business scenarios included in the commission calculation system, analyze the business requirements and business scenarios, and obtain the commission calculation factors for the commission calculation;

[0096] In this embodiment, the business scenarios and business needs are analyzed according to different business scenarios and business needs to obtain the calculation factors for the commission calculation. For example, a common scenario in the insurance industry: a salesperson sells a product A and takes a commission of 10% of the sales amount, his superior takes a commission of 5%, and his superior's superior takes a commission of 1%. When the salesperson sells a product B, it is a normal sales commission calculation without a hierarchical relationship (percentage, fixed price); for example, if you sell a health insurance, you can get a fixed commission of 1,000 yuan or a fixed percentage of commission, such as 10%. Alternatively, when a product is jointly sold by salesperson A and salesperson B, the commission generated by the product is 10%, and this 10% can be taken by different people according to the configured ratio. The amount can be split in half, and each person takes 5%.

[0097] In this embodiment, in some business scenarios, the same product or sales can support more than one different commission calculation mode. For example, for a product, the commission is calculated at 10% of the price at ordinary times, and if it is sold during Double 11, an additional commission of 100 yuan will be added on the basis of 10%. Combine multiple commission calculation rules to meet the commission calculation of this scenario. For some complex and short-term scenarios that cannot be modeled, customized commission calculation can be implemented, and special customized commission calculation can be implemented in the form of JS plug-in.

[0098] 202. Based on the commission calculation factors, determine the commission calculation rules corresponding to each business scenario, wherein each commission calculation factor group corresponds to a fixed commission calculation rule;

[0099] In this embodiment, the commission calculation factors sorted out in the previous step 201 according to business scenarios and business needs are counted, and the commission calculation factors are divided into multiple types, and each commission calculation factor corresponds to a different commission calculation rule.

[0100] 203. Define a commission calculation factor data model, and combine the commission calculation factors to obtain a commission calculation factor set;

[0101] In this embodiment, a calculation factor data model is defined, and the calculation factor is an influencing factor that determines the commission calculation trend. The calculation factors are combined to generate a uniquely determined calculation factor group, and each calculation factor group corresponds to a fixed commission calculation rule.

[0102] 204. Based on the commission calculation factor set, a mapping relationship between the commission calculation factors and the commission calculation rules is established to obtain a mapping relationship set;

[0103] In this embodiment, the mapping relationship between the calculation factor and the commission calculation rule is one-to-one correspondence between different calculation factors. For example, the calculation factor is time; a product is usually calculated at a 10% price commission, and if it is sold during Double 11, an additional commission of 100 yuan will be added on the basis of 10%. The calculation factor is the person who participates in the commission; for example, the commission generated by a product is 10%, and this 10% can be taken by different people according to the configured ratio. It can be split in half, so each person takes 5%.

[0104] 205. Obtain management attributes of the salesperson, and classify the salesperson for which commission is to be calculated into ordinary salespersons and management staff according to the management attributes, wherein the management staff includes first-level management staff and second-level management staff for managing the first-level management staff, and obtain the management relationship between the salespersons;

[0105] In this embodiment, the management attributes of the salesperson may include the attributes of the manager and the attributes of the managed, and the attributes of the manager may also include first-level management staff and second-level management staff. Of course, it is not limited to this, and may also include managers of more levels, such as third-level management staff, fourth-level management staff, and so on. Since some commission calculation rules need to calculate commissions based on levels, it is necessary to obtain the management attributes of the staff (specific to a certain salesperson). For example, 1. A common scenario in the insurance industry: a salesperson sells a product and gets a commission of 10% of the sales amount, his superior gets a commission of 5%, and his superior's superior gets a commission of 1%.

[0106] The acquisition of the management attributes of the staff can directly read the position information of the staff from the staff database, and determine the management attributes of the staff according to the pre-set correspondence between the position information and the management attributes. For example, the position names "salesman" and "business manager" can be associated with the attributes of the managed, and the position names "business supervisor" and "business director" can be associated with the attributes of the manager. Of course, the management attributes of the staff can also be adjusted or modified by the system administrator.

[0107] In the embodiment of the present invention, the calculation of the commission of ordinary staff members needs to extract all business data of ordinary staff members within a predetermined period, extract the business income in the business data, and add up the total number of effective business of the individual, and then calculate the commission calculation result of the ordinary staff members according to the specific commission rules. For example, the business data includes data content such as actual collection, collection to be collected, and arrears, and different data can be extracted as needed.

[0108] In order to reward business performance, the commission rules in different data segments of the total business number are usually different. For example, for the total number of valid businesses X, the commission ratio for the 0-X1 part is A1, the commission ratio for the X1-X2 part is A2, and the commission ratio for the X2-X part is A3, and A3>A2, A2>A1.

[0109] The calculation of the commission of the first-level management staff requires further statistical calculation based on the business data of ordinary staff, extracting the effective part of it. Then, based on the statistical calculation results and combined with the commission calculation rules of the first-level management staff, the commission calculation results of the first-level management staff are obtained. In the same way, based on the business data of the first-level management staff, the business data of the second-level management staff is calculated.

[0110] The management correspondence between ordinary staff and first-level management staff refers to the ordinary staff corresponding to the first-level management staff when calculating commissions. This correspondence is generally determined based on the management relationship of the company or enterprise. Therefore, the management correspondence between the first-level management staff and ordinary staff, and the management correspondence between the first-level management staff and the second-level management staff, can also be determined through the position information of the company or enterprise.

[0111] 206. Obtain the pending business data in the commission calculation system, clean the pending business data, and extract business data of at least one salesperson based on the cleaned data;

[0112] 207. Analyze the sales data to be counted to obtain all product data in the sales data;

[0113] 208. According to the product data, select a corresponding data processing rule from a preset data processing rule library to obtain a data processing rule set for the business data to be processed;

[0114] 209. Based on the commission calculation rules in the data processing rule set, commission calculation is performed on all product data, and the total commission of the salesperson is output.

[0115] Steps 206-209 in this embodiment are similar to steps 101-104 in the first embodiment and are not described again here.

[0116] In an embodiment of the present invention, all product data is obtained by acquiring the business data to be processed in the commission calculation system and extracting the sales data of at least one salesperson therefrom for analysis; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data to output the total commission of the salesperson. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order.

[0117] See also Figure 3 , a third embodiment of the data processing method in the embodiment of the present invention includes:

[0118] 301. Receive a data cleaning request;

[0119] In this embodiment, different business scenarios may require data cleaning, such as: a shopping platform needs to clean a transaction data, and the user can send a data cleaning request to the data cleaning device through the shopping platform or other client. The data cleaning request may include some key data cleaning information, such as: if a transaction data is to be cleaned, the data cleaning request may include the transaction serial number, order number, user names of both parties to the transaction, and other information of the transaction. The data cleaning request may also include data cleaning requirements, such as: what kind of data to clean. The data cleaning request may also correspond to data cleaning scenarios such as: rebate business data cleaning scenarios, order data cleaning scenarios, etc. The data cleaning request in the embodiment of this specification may include an offline data cleaning request, and offline data cleaning can achieve the cleaning of large amounts of data, such as: cleaning the transaction data of the past month to clean out the transaction data that meets the rebate conditions.

[0120] 302. Determine a data cleaning rule according to the data cleaning request, wherein the data cleaning rule includes: a cleaning characteristic factor and a cleaning condition satisfied by the cleaning characteristic factor;

[0121] In this embodiment, different data cleaning requests may have corresponding business scenarios, and different business scenarios correspond to rules or conditions that data needs to meet. For example: for the rebate business scenario, the rebate policy usually sets a certain threshold, and only transactions that reach this threshold will be rebated, or the promotion activities of the shopping platform also need to meet certain conditions to participate in the promotion activities. In this embodiment, according to the data cleaning request, the business scenario of data cleaning can be determined, the business requirements of the corresponding business scenario are obtained, and the corresponding data cleaning rules are defined according to the business requirements. The data cleaning rules may include cleaning characteristic factors and cleaning conditions satisfied by the cleaning characteristic factors. Among them, the cleaning characteristic factors can represent the key features of data cleaning, such as transaction amount, transaction type, transaction source, transaction time, etc. For example: according to the data cleaning request, it is determined that the business scenario corresponding to the data cleaning request is a rebate business, and the business requirements of the rebate business require the rebate transaction to meet the following conditions: 1. The single transaction amount is greater than 10 yuan; 2. False transactions are eliminated; 3. The transaction source is offline scan code payment. Only transactions that meet the above three conditions at the same time can finally participate in the rebate. It can be determined that the cleaning characteristic factors may include: the amount of a single transaction, whether a single transaction is a false transaction, and the source of a single transaction.

[0122] 303. Obtain the business data to be processed in the commission calculation system, and determine the characteristic factor value corresponding to the cleaning characteristic factor according to the business data to be processed in the commission calculation system;

[0123] In this embodiment, after defining the data cleaning rules, the data to be cleaned can be obtained, such as: the original data of the corresponding salesperson can be obtained from the database according to the data cleaning request, and then the characteristic factor value corresponding to the cleaning characteristic factor can be determined according to the data to be cleaned. For example: if data cleaning is performed on a transaction, the order number of the transaction can be obtained according to the data cleaning request, and the original data related to the transaction, i.e., the data to be cleaned, can be obtained according to the order number. Then, the characteristic factor value corresponding to the cleaning characteristic factor can be obtained according to the data to be cleaned, such as: the specific value of the transaction amount, whether it is a false transaction, whether it is an offline scan code payment, etc.

[0124] It should be noted that in the embodiments of this specification, when a data cleaning request is received, the data to be cleaned corresponding to the data cleaning request can be obtained. The specific acquisition time can be set according to actual needs and is not specifically limited in the embodiments of this specification.

[0125] 304. Clean the business data to be processed according to the data cleaning rules and the characteristic factor values ​​to obtain business data of at least one business operator;

[0126] In this embodiment, after determining the characteristic factor value corresponding to the cleaning characteristic factor, data cleaning can be performed according to the data cleaning rules to determine whether each piece of data in the data to be cleaned meets the data cleaning rules. If it meets, it is retained. If it does not meet, the data can be deleted, and the retained data that meets the data cleaning rules is used as the cleaning result data. For example: if you want to clean the transaction data of the rebate business of a salesperson in a certain department in the past 6 months, filter out the transaction data that meets the rebate conditions. After receiving the data cleaning request, you can define the data cleaning rules. According to the data cleaning request, obtain the transaction data of the rebate business of a salesperson in a certain department in the past 6 months as the data to be cleaned, and determine the characteristic factor value corresponding to the cleaning characteristic factor of each transaction data according to the data to be cleaned, such as: the transaction amount of a transaction = 15, the transaction is not a false transaction, and the transaction is an offline scan code payment, and obtain the characteristic factor value of the cleaning characteristic factor corresponding to each transaction in turn. The characteristic factor value of the cleaning characteristic factor of each transaction can be added to the data to be cleaned, and each transaction data can be cleaned according to the data cleaning rules and the characteristic factor value of the cleaning characteristic factor, that is, it is determined whether each transaction data meets the conditions for rebate, that is, whether it meets the data cleaning rules, and the transaction data that meets the conditions for rebate, that is, the sales data to be counted of the salesperson, is screened out, and the data cleaning is completed to obtain the sales data to be counted of the salesperson.

[0127] 305. Analyze the sales data to obtain all product data in the sales data;

[0128] 306. According to the product data, select a corresponding data processing rule from a preset data processing rule library to obtain a data processing rule set for the business data to be processed;

[0129] 307. Based on the commission calculation rules in the data processing rule set, commission calculation is performed on all product data, and the total commission of the salesperson is output.

[0130] Steps 305-307 in this embodiment are similar to steps 102-104 in the first embodiment and are not described again here.

[0131] In an embodiment of the present invention, all product data is obtained by acquiring the business data to be processed in the commission calculation system and extracting the sales data of at least one salesperson therefrom for analysis; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data to output the total commission of the salesperson. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order.

[0132] See also Figure 4 , a fourth embodiment of the data processing method in the embodiment of the present invention includes:

[0133] 401. Obtain the business data to be processed in the commission calculation system, clean the business data to be processed, and extract business data of at least one salesperson based on the cleaned data;

[0134] 402. Setting a sales data input interface on the preset product transaction system interface, and inputting online or offline product sales data automatically or manually through the sales data input interface, wherein the preset product transaction system is provided with an order database and an execution script;

[0135] In this embodiment, an order input interface is set on the product trading system interface, and online or offline product trading orders are input automatically or manually through the order input interface. Offline product trading orders refer to orders from various stores; online product trading orders refer to orders generated directly on the trading website; both online and offline product trading orders need to be input into the product trading system, and the order input method can be automatic or manual.

[0136] 403. Call the execution script to train the order data in the product sales data according to the preset execution rules and generate an order queue;

[0137] In this embodiment, an order database and an execution script are provided in the product trading system, and the execution script is called. The order data in the product trading order is arranged according to an execution rule to generate an order queue and store it in the order database. The execution rules include timed execution rules, batch execution rules, etc.; the timed execution rule is to set the time for the execution rule to start execution on the product trading system; the batch execution rule refers to generating an order queue after arranging the order data in batches according to a certain number. For example, the timed execution rule is used to complete the input of the product trading order. For example, at 12 o'clock every day, the product trading order is cyclically executed and then an order queue is generated to be stored in the order database. The batch execution rule is used to complete the input of the product trading order. For example, the product trading order is cyclically executed in batches of 200 and then an order queue is generated to be stored in the order database.

[0138] 404. Based on the order queue, obtain all product data in the sales data;

[0139] In this embodiment, the order queue contains multiple transaction records, and each transaction record corresponds to an order data. Reading the order data specifically includes: setting a reading interface in the mapping rule interface, calling the reading interface, reading the order data in the order queue, and converting the order data into the conditions of the mapping rule; the mapping rule sets the data that should be filled in the corresponding mapping rule conditions, and using the reading interface, the product transaction order data is placed in the corresponding framework set up under the mapping rule conditions.

[0140] 405. According to the product data, a corresponding data processing rule is selected from a preset data processing rule library to obtain a data processing rule set for the business data to be processed;

[0141] 406. Parse the product data to obtain keywords corresponding to the product data, and retrieve parameter fields according to the keywords, wherein the parameter fields include commission calculation factors, and the commission calculation factors and commission calculation rules have a preset corresponding relationship;

[0142] In this embodiment, a request for parsing product data is received, and a semantic scenario corresponding to the natural language information is obtained; in the corresponding semantic scenario, the product data is parsed using a preset semantic parsing method, and based on the correspondence between preset keywords and filter values, a semantic parsing result that conforms to the product data is obtained.

[0143] Different semantic scenarios correspond to different semantic parsing methods. The server may obtain the correspondence between the pre-set semantic scenarios and the semantic parsing methods, and obtain the semantic parsing method corresponding to the semantic scenario according to the obtained correspondence between the pre-set semantic scenarios and the semantic parsing methods. In the corresponding semantic scenario, the server uses the semantic parsing method corresponding to the semantic scenario to parse the natural language information input by the user.

[0144] Specifically, the server obtains the semantic parsing method corresponding to the semantic scene corresponding to the maximum correlation value according to the correspondence between the semantic scene corresponding to the maximum correlation value and the semantic parsing method. The natural language information is parsed according to the semantic parsing method to obtain the original semantic parsing result. The original semantic parsing result is initially checked using the preset verification rules to obtain the original semantic parsing result that meets the preset verification rules, and the semantic parsing result is obtained based on the original semantic parsing result that meets the preset verification rules. Further, the keywords in the product data are obtained based on the semantic parsing result.

[0145] In this embodiment, the product data is pre-split into multiple parameter fields, and the parameter fields include parameter values. The correspondence between parameter values ​​and keywords is set. Each parameter value can correspond to one keyword or multiple keywords. For example, "transaction record" and "order" conceptually express the same meaning and can correspond to the same keyword. "Completed order" and "transaction successful" conceptually express the same meaning and can also correspond to the same keyword.

[0146] It should be noted that the correspondence between parameter values ​​and keywords can mean that the parameter value itself is a keyword, or that the parameter value and the keyword express the same meaning, or that the parameter value and the keyword have a pre-set binding relationship. The parameter value is stored in a specific parameter field, or a data code is used to represent the data meaning of the parameter field. Only through the parameter setting interface provided by the system can these parameter values ​​be read and set, and the correspondence between the parameter value and the keyword can be set. On the parameter setting interface, the system user uses the text content solidified on the interface to indicate the meaning of these parameter values ​​on the interface.

[0147] 407. Obtain a preset data table from the database, and determine whether the preset data table satisfies the data verification rule, wherein the preset data table is used to store commission calculation factors;

[0148] In this embodiment, it is also necessary to obtain data verification rules. Therefore, the commission calculation method may also include: querying a first database statement for verifying data; querying a file in the database for storing data verification rules; and calling the file through the first database statement to obtain the data verification rules. The data verification rules may be data stored in a preset data table. For example, the first SQL statement for data verification corresponding to the commission rule code is searched, and the drl file storing the data verification rules is searched, and then the drl file is called according to these first SQL statements, so as to obtain the data verification rules.

[0149] 408. If yes, then based on the parameter field, all commission calculation factors corresponding to the product data in the preset data table are obtained;

[0150] In this embodiment, the preset data table may include one or more. In the case where the preset data table meets the data verification rules, since the preset data table is used to store the commission calculation factors, all the commission calculation factors contained in these preset data tables can be extracted. For example, there are three preset data tables. The commission calculation factors contained in the first preset data table are: the secured provision coefficient is 0.3, the unsecured commission is 10,000 yuan, the secured commission is 50,000 yuan, and the i-loan commission is 1,000 yuan. The commission calculation factors contained in the second preset data table are: the active monitoring coefficient is 0.3, the sales monitoring coefficient is 0.4, the product monitoring coefficient is 0.2, the headquarters adjustment coefficient is 0.2, the reserved parameter 1 is 3, the reserved parameter 2 is 4, and the reserved parameter 3 is 0.5. The commission calculation factors contained in the third preset data table are: the annual commission is 10,000 yuan, the protection commission is 300 yuan, the specialist commission is 5,000 yuan, and the adjustment commission is 2,000 yuan. Since there is data in these three preset data tables, it means that these preset data tables meet the data verification rules. At this time, the secured provision coefficient of 0.3, the unsecured provision coefficient of 10,000 yuan, the secured provision coefficient of 50,000 yuan, the i-loan provision coefficient of 1,000 yuan, the active monitoring coefficient of 0.3, the sales monitoring coefficient of 0.4, the product monitoring coefficient of 0.2, the headquarters adjustment coefficient of 0.2, the reserved parameter 1 of 3, the reserved parameter 2 of 4, the reserved parameter 3 of 0.5, the annual provision coefficient of 10,000 yuan, the protection provision coefficient of 300 yuan, the specialist provision coefficient of 5,000 yuan, and the adjustment provision coefficient of 2,000 yuan can all be extracted.

[0151] 409. Receive a data processing rule matching request, and match the data processing rule corresponding to the product data from a preset data processing rule library according to the commission calculation factor to obtain a data processing rule set for the business data to be processed;

[0152] In this embodiment, there are multiple commission calculation factors, and each commission rule factor is associated with a commission calculation rule. When calculating the commission of a certain product, the commission calculation platform can obtain the commission rule factor and match the commission calculation rule corresponding to the commission rule factor from a large number of commission calculation rules, and then calculate the commission this time according to the commission calculation rule. In addition, calculating the commission is actually calculating the commission calculation factors involved in this calculation according to the commission calculation rule, wherein the commission calculation rule contains at least one factor type, and the commission calculation factors involved this time belong to these factor types, wherein each factor type corresponds to a commission calculation factor.

[0153] 410. Determine the priority of the data processing rule in the data processing rule set by using a preset data priority calculation method;

[0154] In this embodiment, when a data processing rule matching request is received, the priority of all data processing rules that match the commission calculation factor is determined according to the data type and the pre-set commission calculation factor for calling the corresponding data processing rule. According to the priority, the data processing rule with the highest priority is selected to calculate the total commission of the salesperson's business data to be processed.

[0155] Calculating the commission is actually calculating the commission calculation factors involved in this calculation according to the commission calculation rules. The commission calculation rules contain at least one factor type, and the commission calculation factors involved this time belong to these factor types, where each factor type corresponds to a commission calculation factor.

[0156] 411. In the order of the priorities of the data processing rules from high to low, call the data processing rule with the highest priority;

[0157] In this embodiment, after calculating the priorities of multiple data processing rules in the data processing rule set that match the commission calculation factor, the data processing rule with the highest priority is called according to the priority. For example, a transaction order data of salesman Zhang San, where the product type is: A; transaction time: November 11, 2019; the department to which the salesman belongs: department a; this transaction order data is analyzed, and three data processing rules (commission calculation rules) are matched respectively: rule 1, rule 2, and rule 3; through the preset data (data processing rule) priority calculation method, it is obtained that rule 3 has the highest priority, and rule 3 with the highest priority is called as the final data processing rule.

[0158] It should be noted that the terminal in this embodiment can be a mobile phone, computer, tablet computer and other devices, which are used to send an order request to the electronic order issuance device. The type of terminal is not limited here.

[0159] 412. Based on the commission calculation rules in the data processing rule set, commission calculation is performed on all product data, and the total commission of the salesperson is output.

[0160] Steps 401, 405, and 412 in this embodiment are similar to steps 101, 103, and 104 in the first embodiment, and are not described again here.

[0161] In an embodiment of the present invention, all product data is obtained by acquiring the business data to be processed in the commission calculation system and extracting the sales data of at least one salesperson therefrom for analysis; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data to output the total commission of the salesperson. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order.

[0162] See also Figure 5 , a fifth embodiment of the data processing method in the embodiment of the present invention includes:

[0163] 501. Obtaining the business data to be processed in the commission calculation system, performing data cleansing on the business data to be processed, and extracting business data of at least one salesperson based on the cleansed data;

[0164] 502. Analyze the sales data to obtain all product data in the sales data;

[0165] 503. According to the product data, a corresponding data processing rule is selected from a preset data processing rule library to obtain a data processing rule set for the business data to be processed;

[0166] 504. Receive a commission calculation instruction, and obtain a corresponding commission rule code according to the commission calculation instruction;

[0167] In this embodiment, each product corresponds to a commission rule code and a channel type, wherein the product may include a rule category and a rule subcategory, and a rule category may include multiple rule subcategories, and each rule subcategory may be used to indicate which type of commission is to be calculated this time. For example, for a certain product, its corresponding commission coding rule is NQMX, the channel type is 01-internal channel, the rule category is 03-internal channel details, and the rule subcategory is 0301-internal channel details commission rule (internal employees).

[0168] In this embodiment, the user can input the commission rule code in the user terminal and send the commission calculation instruction to the commission calculation platform through the user terminal. The commission calculation platform can respond to the commission calculation instruction and obtain the commission rule code corresponding to the commission calculation instruction.

[0169] 505. Perform commission calculation on all product data according to the commission rule code and commission calculation rules to obtain calculation results. Output the total commission of the salesperson based on the calculation results.

[0170] In this embodiment, there are multiple commission calculation codes, and each commission rule code is associated with a commission calculation rule. When calculating the commission of a certain product, the commission calculation platform can obtain the commission rule code and match the commission calculation rule corresponding to the commission rule code from a large number of commission calculation rules, and then calculate the commission this time according to the commission calculation rule. In addition, calculating the commission is actually calculating the commission calculation factors involved in this calculation according to the commission calculation rule, wherein the commission calculation rule contains at least one factor type, and the commission calculation factors involved this time belong to these factor types, wherein each factor type corresponds to a commission calculation factor.

[0171] In this embodiment, since there are many commission calculation rules, in order to adapt to any commission calculation rule, all commission calculation factors can be encapsulated in a factor encapsulation package in combination with the above embodiment. Each time the commission is calculated, the corresponding commission calculation factor can be screened out from the factor encapsulation package. That is, for this commission calculation, the commission calculation platform can automatically screen out the commission calculation factor corresponding to the factor type in the commission calculation rule used this time from all the commission calculation factors contained in the factor encapsulation package.

[0172] Steps 501-503 in this embodiment are similar to steps 101-103 in the first embodiment and are not described again here.

[0173] In an embodiment of the present invention, all product data is obtained by acquiring the business data to be processed in the commission calculation system and extracting the sales data of at least one salesperson therefrom for analysis; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data to output the total commission of the salesperson. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order.

[0174] The above describes the data processing method in the embodiment of the present invention. The following describes the data processing device in the embodiment of the present invention. Figure 6 , a first embodiment of a data processing device in an embodiment of the present invention includes:

[0175] A cleaning module 601 is used to obtain the business data to be processed in the commission calculation system, clean the business data to be processed, and extract business data of at least one salesperson based on the cleaned data, wherein the business data to be processed includes sales data of at least one business;

[0176] An analysis module 602 is used to analyze the sales data to obtain all product data in the sales data;

[0177] The calling module 603 is used to call the corresponding data processing rule from the preset data processing rule library according to the product data, wherein the data processing rule is a commission calculation rule for the salesperson to sell the product data;

[0178] The calculation module 604 is used to perform commission calculation on all the product data based on the commission calculation rules in the data processing rule set, and output the total commission of the salesperson.

[0179] In an embodiment of the present invention, all product data is obtained by acquiring the business data to be processed in the commission calculation system and extracting the sales data of at least one salesperson therefrom for analysis; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data to output the total commission of the salesperson. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order.

[0180] See also Figure 7 , a second embodiment of the data processing device in the embodiment of the present invention, the data processing device specifically comprises:

[0181] A cleaning module 601 is used to obtain the business data to be processed in the commission calculation system, clean the business data to be processed, and extract business data of at least one salesperson based on the cleaned data, wherein the business data to be processed includes sales data of at least one business;

[0182] An analysis module 602 is used to analyze the sales data to obtain all product data in the sales data;

[0183] The calling module 603 is used to call the corresponding data processing rule from the preset data processing rule library according to the product data, wherein the data processing rule is a commission calculation rule for the salesperson to sell the product data;

[0184] The calculation module 604 is used to perform commission calculation on all the product data based on the commission calculation rules in the data processing rule set, and output the total commission of the salesperson.

[0185] In this embodiment, the data processing device further includes:

[0186] The acquisition module 605 is used to acquire the business scenario of commission calculation, and analyze the business demand and the business scenario to obtain the commission calculation factor of the commission calculation, wherein the commission calculation factor includes the person participating in the commission, the product type, and the transaction date;

[0187] A determination module 606, configured to determine the commission calculation rules corresponding to each of the business scenarios based on the commission calculation factors, wherein each of the commission calculation factor groups corresponds to a fixed commission calculation rule;

[0188] A definition module 607 is used to define a commission calculation factor data model, and to combine the commission calculation factors to obtain a commission calculation factor set;

[0189] An establishing module 608 is used to establish a mapping relationship between the commission calculation factors and the commission calculation rules based on the commission calculation factor set to obtain a mapping relationship set.

[0190] In this embodiment, the cleaning module 601 is specifically used for:

[0191] Receive data cleaning requests;

[0192] Determining a data cleaning rule according to the data cleaning request, wherein the data cleaning rule includes a cleaning characteristic factor and a cleaning condition satisfied by the cleaning characteristic factor;

[0193] Acquire the business data to be processed in the commission calculation system, and determine the characteristic factor value corresponding to the cleaning characteristic factor according to the business data to be processed in the commission calculation system;

[0194] The business data to be processed is cleaned according to the data cleaning rule and the characteristic factor value to obtain business data of at least one salesperson.

[0195] In this embodiment, the analysis module 602 is specifically used for:

[0196] A sales data input interface is set on the interface of the preset product transaction system, and online or offline product sales data is input automatically or manually through the sales data input interface, wherein the preset product transaction system is provided with an order database and an execution script;

[0197] Calling the execution script, training the order data in the product sales data according to the preset execution rules, and generating an order queue;

[0198] Based on the order queue, all product data in the sales data is obtained.

[0199] In this embodiment, the data processing device further includes:

[0200] A parsing module 609 is used to parse the product data, obtain keywords corresponding to the product data, and retrieve parameter fields according to the keywords, wherein the parameter fields include commission calculation factors, and the commission calculation factors and commission calculation rules have a preset corresponding relationship;

[0201] A determination module 610 is used to obtain a preset data table from a database and determine whether the preset data table satisfies a data verification rule, wherein the preset data table is used to store commission calculation factors;

[0202] The matching module 611 is used to receive a data processing rule matching request, and match the data processing rule corresponding to the product data from a preset data processing rule library according to the commission calculation factor to obtain a data processing rule set for the business data to be processed; and determine the priority of the data processing rule in the data processing rule set by a preset data priority calculation method;

[0203] The calling module 612 is used to call the data processing rule with the highest priority in descending order of priority of the data processing rules.

[0204] In this embodiment, the calculation module 604 includes:

[0205] The receiving unit 6041 is used to receive a commission calculation instruction and obtain a corresponding commission rule code according to the commission calculation instruction;

[0206] A calculation unit 6042, configured to perform commission calculation on all the product data according to the commission rule code and the commission calculation rule to obtain a calculation result;

[0207] An output unit 6043 is used to output the total commission of the salesperson according to the calculation result;

[0208] In this embodiment, the device further includes:

[0209] The classification module 613 is used to obtain the management attributes of the salesmen, and classify the salesmen for which commissions are to be calculated into ordinary salesmen and management staff according to the management attributes, wherein the management staff includes first-level management staff and second-level management staff for managing the first-level management staff, and obtain the management relationship between the salesmen.

[0210] In an embodiment of the present invention, all product data is obtained by acquiring the business data to be processed in the commission calculation system and extracting the sales data of at least one salesperson therefrom for analysis; according to the product data, the corresponding data processing rules are selected from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; based on the commission calculation rules in the data processing rule set, the commission calculation is performed on all product data to output the total commission of the salesperson. This solution can abstract specific commission distribution scenarios into specific rules based on factors such as product type, commission participants, product quantity and unit price, and calculate the sales commission of the commission participants in the order according to the commission calculation rules corresponding to the products in the order.

[0211] above Figure 6 and Figure 7 The data processing apparatus in the embodiment of the present invention is described in detail from the perspective of modular functional entities, and the data processing device in the embodiment of the present invention is described in detail from the perspective of hardware processing.

[0212] Figure 8 8 is a schematic diagram of the structure of a data processing device provided by an embodiment of the present invention. The data processing device 800 may have relatively large differences due to different configurations or performances, and may include one or more processors (central processing units, CPU) 810 (for example, one or more processors) and a memory 820, and one or more storage media 830 (for example, one or more mass storage devices) storing application programs 833 or data 832. Among them, the memory 820 and the storage medium 830 can be short-term storage or permanent storage. The program stored in the storage medium 830 may include one or more modules (not shown in the figure), and each module may include a series of instruction operations in the data processing device 800. Furthermore, the processor 810 can be configured to communicate with the storage medium 830, and execute a series of instruction operations in the storage medium 830 on the data processing device 800 to implement the steps of the data processing method provided by the above-mentioned method embodiments.

[0213] The data processing device 800 may also include one or more power supplies 840, one or more wired or wireless network interfaces 850, one or more input and output interfaces 860, and / or one or more operating systems 831, such as Windows Server, Mac OS X, Unix, Linux, FreeBSD, etc. It will be appreciated by those skilled in the art that Figure 8 The structure of the data processing device shown does not constitute a limitation on the data processing device provided in the present application, and may include more or less components than shown in the figure, or combine certain components, or arrange the components differently.

[0214] 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. Instructions are stored in the computer-readable storage medium. When the instructions are executed on a computer, the computer executes the steps of the above-mentioned data processing method.

[0215] The blockchain referred to in this invention is a new application mode of computer technologies such as distributed data storage, peer-to-peer transmission, consensus mechanism, encryption algorithm, etc. Blockchain is essentially a decentralized database, a string of data blocks generated by cryptographic methods. Each data block contains a batch of network transaction information, which is used to verify the validity of its information (anti-counterfeiting) and generate the next block. Blockchain can include the underlying blockchain platform, platform product service layer, and application service layer.

[0216] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0217] 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 this understanding, the technical solution of the present invention is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product. The computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform 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), disk or optical disk and other media that can store program codes.

[0218] As described above, the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features thereof may be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A data processing method, applied to a commission calculation system, characterized in that: The data processing method comprises: Acquire the business data to be processed in the commission calculation system, clean the business data to be processed, and extract business data of at least one salesperson based on the cleaned data, wherein the business data to be processed includes sales data of at least one business; Analyze the sales data to obtain all product data in the sales data, wherein the product data at least includes order data; Parsing the order data, obtaining keywords corresponding to the product data and the time when each product transaction is completed to determine the corresponding business scenario, and retrieving parameter fields according to the keywords, wherein the parameter fields include commission calculation factors, and the commission calculation factors and commission calculation rules have a preset corresponding relationship; Obtaining a preset data table from a database, and determining whether the preset data table satisfies a data verification rule, wherein the preset data table is used to store commission calculation factors; If the preset data table satisfies the data verification rule, all commission calculation factors corresponding to the product data in the preset data table are obtained based on the parameter field; Receiving a data processing rule matching request, and matching the data processing rules corresponding to each product in the product data from a preset data processing rule library according to the commission calculation factor and the corresponding business scenario, to obtain a data processing rule set for the business data to be processed; Determining the priority of the data processing rule in the data processing rule set by a preset data priority calculation method; In the order of the priorities of the data processing rules from high to low, the data processing rule with the highest priority is called, wherein the data processing rule is the commission calculation rule for the corresponding product; Based on the commission calculation rules for each product, commission calculation is performed on all the product data, and the total commission of the salesperson is output.

2. The data processing method according to claim 1, characterized in that: Before obtaining the business data to be processed in the commission calculation system, performing data cleaning on the business data to be processed, and extracting business data of at least one salesperson based on the cleaned data, the method further includes: Obtaining business scenarios included in the commission calculation system, and analyzing business requirements and the business scenarios to obtain commission calculation factors for commission calculation, wherein the commission calculation factors include commission participants, product types, and transaction dates; Based on the commission calculation factors, determining the commission calculation rules corresponding to each of the business scenarios, wherein each of the commission calculation factor groups corresponds to a fixed commission calculation rule; Defining a commission calculation factor data model, and combining the commission calculation factors to obtain a commission calculation factor set; Based on the commission calculation factor set, a mapping relationship between the commission calculation factors and the commission calculation rules is established to obtain a mapping relationship set.

3. The data processing method according to claim 2, characterized in that: The obtaining of the business data to be processed in the commission calculation system, performing data cleaning on the business data to be processed, and extracting business data of at least one salesperson based on the cleaned data includes: Receive data cleaning requests; Determining a data cleaning rule according to the data cleaning request, wherein the data cleaning rule includes a cleaning characteristic factor and a cleaning condition satisfied by the cleaning characteristic factor; Acquire the business data to be processed in the commission calculation system, and determine the characteristic factor value corresponding to the cleaning characteristic factor according to the business data to be processed in the commission calculation system; The business data to be processed is cleaned according to the data cleaning rule and the characteristic factor value to obtain business data of at least one salesperson.

4. The data processing method according to claim 1, characterized in that: The sales data is analyzed to obtain all product data in the sales data, including: A sales data input interface is set on the interface of the preset product transaction system, and online or offline product sales data is input automatically or manually through the sales data input interface, wherein the preset product transaction system is provided with an order database and an execution script; Calling the execution script, training the order data in the product sales data according to the preset execution rules, and generating an order queue; Based on the order queue, all product data in the sales data is obtained.

5. The data processing method according to claim 1, characterized in that: The commission calculation rules based on each product are used to calculate the commission for all the product data, and the total commission of the salesperson is output, including: Receive a commission calculation instruction, and obtain a corresponding commission rule code according to the commission calculation instruction; According to the commission rule code and the commission calculation rule, commission calculation is performed on all the product data to obtain a calculation result; According to the calculation result, the total commission of the salesperson is output.

6. The data processing method according to claim 2, characterized in that: Before obtaining the business data to be processed in the commission calculation system, performing data cleaning on the business data to be processed, and extracting business data of at least one salesperson based on the cleaned data, the method further includes: The management attributes of the salesperson are obtained, and the salesperson for whom commissions are to be calculated is classified into ordinary salespersons and management staff according to the management attributes, wherein the management staff includes first-level management staff and second-level management staff for managing the first-level management staff, and the management relationship between the salespersons is obtained.

7. A data processing device, characterized in that: The data processing device comprises: A cleaning module, used to obtain the business data to be processed in the commission calculation system, and perform data cleaning on the business data to be processed, and extract business data of at least one salesperson based on the cleaned data, wherein the business data to be processed includes sales data of at least one business; An analysis module, configured to analyze the sales data to obtain all product data in the sales data, wherein the product data at least includes order data; A calling module is used to parse the order data, obtain the keywords corresponding to the product data and the time when each product transaction is completed to determine the corresponding business scenario, and retrieve the parameter field according to the keywords, wherein the parameter field includes a commission calculation factor, and the commission calculation factor and the commission calculation rule have a preset corresponding relationship; obtain a preset data table from a database, and determine whether the preset data table meets the data verification rule, wherein the preset data table is used to store the commission calculation factor; if the preset data table meets the data verification rule, then based on the parameter field, all commission calculation factors corresponding to the product data in the preset data table are obtained; receive a data processing rule matching request, and according to the commission calculation factor and the corresponding business scenario, match the data processing rules corresponding to each product in the product data from the preset data processing rule library to obtain the data processing rule set for the business data to be processed; determine the priority of the data processing rules in the data processing rule set by a preset data priority calculation method; call the data processing rule with the highest priority in the order of the priorities of the data processing rules from high to low, wherein the data processing rule is the commission calculation rule for the corresponding product; The calculation module is used to perform commission calculation on all the product data based on the commission calculation rules of each product, and output the total business commission of the salesperson.

8. A commission calculation device, characterized in that: The commission calculation device includes a memory, a processor, and a data processing program stored in the memory and executable on the processor. When the data processing program is executed by the processor, the steps of the data processing method according to any one of claims 1 to 6 are implemented.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a data processing program, and when the data processing program is executed by a processor, the steps of the data processing method according to any one of claims 1 to 6 are implemented.

Images