CN110135798A - Commission calculation method, platform, computer equipment and computer readable storage medium - Google Patents
Commission calculation method, platform, computer equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN110135798A CN110135798A CN201910301320.3A CN201910301320A CN110135798A CN 110135798 A CN110135798 A CN 110135798A CN 201910301320 A CN201910301320 A CN 201910301320A CN 110135798 A CN110135798 A CN 110135798A
- Authority
- CN
- China
- Prior art keywords
- commission
- factor
- rule
- data table
- preset data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 27
- 238000000034 method Methods 0.000 claims abstract description 36
- 230000004044 response Effects 0.000 claims abstract description 9
- 238000006243 chemical reaction Methods 0.000 claims description 28
- 238000005538 encapsulation Methods 0.000 claims description 21
- 238000004590 computer program Methods 0.000 claims description 9
- 238000012545 processing Methods 0.000 claims description 8
- 238000012216 screening Methods 0.000 claims description 7
- 238000000605 extraction Methods 0.000 claims description 3
- 230000008859 change Effects 0.000 claims description 2
- 239000000284 extract Substances 0.000 abstract description 6
- 230000008569 process Effects 0.000 description 12
- 238000012544 monitoring process Methods 0.000 description 11
- 230000005540 biological transmission Effects 0.000 description 5
- 230000007547 defect Effects 0.000 description 5
- 230000000694 effects Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000007246 mechanism Effects 0.000 description 4
- 238000004891 communication Methods 0.000 description 2
- 238000001914 filtration Methods 0.000 description 2
- 238000010295 mobile communication Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
- G06Q10/1057—Benefits or employee welfare, e.g. insurance, holiday or retirement packages
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Data Mining & Analysis (AREA)
- Game Theory and Decision Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This disclosure relates to which a kind of commission calculation method, is applied to commission computing platform, this method comprises: obtaining corresponding commission rule encoding according to commission computations in response to the commission computations that user terminal is sent；Preset data table is obtained from database, and judges whether preset data table meets data check rule, wherein preset data table calculates the factor for storing commission；In the case where preset data table meets data check rule, extracts all commissions for including in preset data table and calculate the factor；According to commission rule encoding, corresponding commission computation rule is matched, wherein Coverage factor type in commission computation rule；It is calculated from all commissions and filters out the commission calculating factor corresponding with factor pattern in the factor；The factor is calculated according to commission computation rule and the commission corresponding with factor pattern filtered out, calculates commission.The disclosure additionally provides a kind of commission computing platform, a kind of computer equipment and a kind of computer readable storage medium.
Description
Technical field
The present invention relates to field of computer technology, and in particular to commission calculation method, platform, computer equipment and computer
Readable storage medium storing program for executing.
Background technique
Commission is one of business activity remuneration.In enterprise, usually by Human Resource Department according to already present servant
Golden calculation calculates commission.But in reality scene, often it is related to multiple product, the corresponding commission meter of every kind of product
Calculation mode may be different, at this time, it may be necessary to manually search the corresponding commission calculation of different product and calculate commission, cause to consume
When demand longer and that be unable to satisfy flexible configuration.
Summary of the invention
Disclosure purpose is to provide a kind of commission calculation method, platform, computer equipment and computer readable storage medium,
With at least solve commission in the prior art calculate take a long time, can not flexible configuration defect.
An aspect of this disclosure provides a kind of commission calculation method, is applied to commission computing platform, above method packet
Include: the commission computations sent in response to user terminal obtain corresponding commission rule according to above-mentioned commission computations and compile
Code；Preset data table is obtained from database, and judges whether above-mentioned preset data table meets data check rule, wherein on
It states preset data table and calculates the factor for storing commission；Meet the situation of above-mentioned data check rule in above-mentioned preset data table
Under, it extracts all commissions for including in above-mentioned preset data table and calculates the factor；According to above-mentioned commission rule encoding, matching is corresponded to
Commission computation rule, wherein Coverage factor type in above-mentioned commission computation rule；It is calculated in the factor from above-mentioned all commissions
It filters out commission corresponding with above-mentioned factor pattern and calculates the factor；And according to above-mentioned commission computation rule and filter out with it is upper
It states the corresponding commission of factor pattern and calculates the factor, calculate commission.
In accordance with an embodiment of the present disclosure, the above method further include: according to above-mentioned commission rule encoding, from above-mentioned database
Conversion results type and conversion results title are obtained, and above-mentioned all commissions are calculated into the factor according to above-mentioned conversion results class
Type and above-mentioned conversion results title are packaged, and obtain factor encapsulation package；And it is above-mentioned from above-mentioned all commission calculating factors
In filter out corresponding with above-mentioned factor pattern commission and calculate the factor, comprising: filtered out from above-mentioned factor encapsulation package with it is above-mentioned
The corresponding commission of factor pattern calculates the factor.
In accordance with an embodiment of the present disclosure, the above method further include: inquire the first database sentence for verifying data；It looks into
It askes in above-mentioned database for storing the file of above-mentioned data check rule；And it is called by above-mentioned first database sentence
File is stated, to obtain above-mentioned data check rule.
In accordance with an embodiment of the present disclosure, the above method further include: inquiry is for storing above-mentioned commission to above-mentioned database
In specified tables of data the second database statement；And above-mentioned commission is stored to above-mentioned by above-mentioned second database statement
In specified tables of data.
In accordance with an embodiment of the present disclosure, the above method further include: be unsatisfactory for above-mentioned data check in above-mentioned preset data table
In the case where rule, Xiang Shangshu user terminal returns to the information for stopping calculating commission.
In accordance with an embodiment of the present disclosure, the above method further include: calculated above-mentioned commission is returned into above-mentioned user terminal.
Another aspect of the disclosure provides a kind of commission computing platform, comprising: first obtain module, in response to
The commission computations that user terminal is sent obtain corresponding commission rule encoding according to above-mentioned commission computations；Handle mould
Block for obtaining preset data table from database, and judges whether above-mentioned preset data table meets data check rule,
In, above-mentioned preset data table calculates the factor for storing commission；Extraction module, for meeting above-mentioned number in above-mentioned preset data table
In the case where verifying rule, extracts all commissions for including in above-mentioned preset data table and calculate the factor；Matching module is used for
According to above-mentioned commission rule encoding, corresponding commission computation rule is matched, wherein Coverage factor class in above-mentioned commission computation rule
Type；Screening module filters out commission calculating corresponding with above-mentioned factor pattern for calculating from above-mentioned all commissions in the factor
The factor；And computing module, for according to above-mentioned commission computation rule and the commission corresponding with above-mentioned factor pattern filtered out
The factor is calculated, commission is calculated.
In accordance with an embodiment of the present disclosure, above-mentioned platform further include: second obtains module, for being compiled according to above-mentioned commission rule
Code obtains conversion results type and conversion results title and package module from above-mentioned database, for will be above-mentioned all
Commission calculates the factor and is packaged according to above-mentioned conversion results type and above-mentioned conversion results title, obtains factor encapsulation package；With
And above-mentioned screening module is also used to: filtered out from above-mentioned factor encapsulation package corresponding with above-mentioned factor pattern commission calculate because
Son.
In accordance with an embodiment of the present disclosure, above-mentioned platform further include: the first enquiry module, for inquiring for verifying data
First database sentence；Second enquiry module, for inquiring in above-mentioned database for storing the text of above-mentioned data check rule
Part；And first calling module, for by the above-mentioned file of above-mentioned first database sentence calling, to obtain above-mentioned data check
Rule.
In accordance with an embodiment of the present disclosure, above-mentioned platform further include: third enquiry module, for inquiring for by above-mentioned commission
Store the second database statement of the specified tables of data in above-mentioned database；And second calling module, for by above-mentioned
Second database statement stores above-mentioned commission into above-mentioned specified tables of data.
In accordance with an embodiment of the present disclosure, above-mentioned platform further include: the first return module, for above-mentioned preset data table not
In the case where meeting above-mentioned data check rule, Xiang Shangshu user terminal returns to the information for stopping calculating commission.
In accordance with an embodiment of the present disclosure, above-mentioned platform further include: the second return module is used for calculated above-mentioned commission
Return to above-mentioned user terminal.
Another aspect of the disclosure provides a kind of computer equipment, including memory, processor and is stored in
On reservoir and the computer program that can run on a processor, for realizing such as when above-mentioned processor executes above-mentioned computer program
The step of upper described in any item methods.
The another aspect of the disclosure provides a kind of computer readable storage medium, is stored thereon with computer program,
The step of when above-mentioned computer program is executed by processor for realizing described in any item methods as above.
The commission calculation method that the disclosure provides, after the commission computations for receiving user terminal transmission, according to
The commission computations obtain corresponding commission rule encoding, then judge whether preset data table meets data check rule,
All commissions are extracted from preset data table if meeting and calculate the factor, corresponding commission meter is inquired according to commission rule encoding
Rule is calculated, since the factor pattern of the factor is calculated in the commission computation rule comprising calculating the commission that this commission needs to use,
Therefore it can further be calculated from all commissions and filter out the commission calculating factor corresponding with the factor pattern in the factor, and according to
Commission computation rule and the commission corresponding with factor pattern filtered out calculate the factor, calculate this commission.In this way, for difference
Product, a series of data can be obtained according to the corresponding commission rule encoding of the product and calculate commission, and then are avoided
In the prior art commission calculate take a long time, can not flexible configuration defect, realize flexibly through various commission calculating sides
Formula calculates the technical effect of the commission of each product.
Detailed description of the invention
Fig. 1 diagrammatically illustrates the flow chart of the commission calculation method according to the embodiment of the present disclosure；
Fig. 2 diagrammatically illustrates the flow chart of the commission calculation method according to another embodiment of the disclosure；
Fig. 3 diagrammatically illustrates the block diagram of the commission computing platform according to the embodiment of the present disclosure；And
Fig. 4 is diagrammatically illustrated according to the hard of the computer equipment for being adapted for carrying out commission calculation method of the embodiment of the present disclosure
Part configuration diagram.
Specific embodiment
It is with reference to the accompanying drawings and embodiments, right in order to which the objects, technical solutions and advantages of the disclosure are more clearly understood
The disclosure is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the disclosure, not
For limiting the disclosure.Based on the embodiment in the disclosure, those of ordinary skill in the art are not before making creative work
Every other embodiment obtained is put, the range of disclosure protection is belonged to.
The commission calculation method that the disclosure provides, after the commission computations for receiving user terminal transmission, according to
The commission computations obtain corresponding commission rule encoding, then judge whether preset data table meets data check rule,
All commissions are extracted from preset data table if meeting and calculate the factor, corresponding commission meter is inquired according to commission rule encoding
Rule is calculated, since the factor pattern of the factor is calculated in the commission computation rule comprising calculating the commission that this commission needs to use,
Therefore it can further be calculated from all commissions and filter out the commission calculating factor corresponding with the factor pattern in the factor, and according to
Commission computation rule and the commission corresponding with factor pattern filtered out calculate the factor, calculate this commission.In this way, for difference
Product, a series of data can be obtained according to the corresponding commission rule encoding of the product and calculate commission, and then are avoided
In the prior art commission calculate take a long time, can not flexible configuration defect, realize flexibly through various commission calculating sides
Formula calculates the technical effect of the commission of each product.
Fig. 1 diagrammatically illustrates the flow chart of the commission calculation method according to the embodiment of the present disclosure.
As shown in Figure 1, the commission calculation method may include step S101~step S106, in which:
Step S101 is obtained corresponding in response to the commission computations that user terminal is sent according to commission computations
Commission rule encoding.
In embodiment of the disclosure, the corresponding commission rule encoding of each product, also corresponds to a channel type,
Wherein, product may include regular major class and regular group, may include multiple regular groups, each rule in regular major class
Group can be used to indicate where this secondary calculation uses the commission of type.For example, for some product, corresponding commission coding rule
It is then NQMX, channel type is canal in 01-, and regular major class is canal detail in 03-, and regular group is canal detail commission in 0301-
Regular (interior employee).
In embodiment of the disclosure, user can input commission rule encoding in user terminal, and pass through user
Terminal sends commission computations to commission computing platform, and commission computing platform can be in response to the commission computations, and obtain
Take commission rule encoding corresponding with commission computations.
Step S102 obtains preset data table from database, and judges whether preset data table meets data check rule
Then, wherein preset data table calculates the factor for storing commission.
In embodiment of the disclosure, it is also necessary to obtain data check rule, therefore, which can also wrap
It includes: inquiring the first database sentence for verifying data；The file of rule is verified in inquiry database for storing data；With
And file is called by first database sentence, to obtain data check rule.Wherein, data check rule can be present count
According to being stored with data in table.
For example, searching the first SQL statement for data check corresponding with commission rule encoding, and searches and store the number
According to the drl file for verifying rule, the drl file, and then available data check then are called according to these first SQL statements
Rule.
Step S103, preset data table meet data check rule in the case where, extract preset data table in include
All commissions calculate the factor.
In accordance with an embodiment of the present disclosure, preset data table may include one or more.Meet data in preset data table
It, can be by these present counts since preset data table is to calculate the factor for storing commission in the case where verifying rule
According to all being extracted comprising all commission calculating factors in table.
For example, there are three preset data tables.The commission for including in first preset data table calculates the factor are as follows: has mortgage to count
Mention coefficient be 0.3, be 10,000 yuan without mortgage commission, to have mortgage commission be 50,000 yuan, to borrow commission be 1000 yuan to i.Second present count
The factor is calculated according to the commission for including in table are as follows: actively monitoring coefficient is 0.3, sale control coefficient is 0.4, product monitoring coefficient is
0.2, general headquarters' adjustment factor is 0.2, reserved parameter 1 is 3, reserved parameter 2 is 4, reserved parameter 3 is 0.5.Third preset data
The commission for including in table calculates the factor are as follows: annual commission is 10,000 yuan, protection commission is 300 yuan, assistant director's commission is 5000 yuan, adjusts
Saving commission is 2000 yuan.Due to there are data in these three preset data tables, then show that these preset data tables meet data
Verify rule, at this point it is possible to will have mortgage meter mention coefficient be 0.3, be 10,000 yuan without mortgage commission, to have mortgage commission be 50,000 yuan, i
Loan commission is 1000 yuan, actively monitoring coefficient is 0.3, sale control coefficient is 0.4, product monitoring coefficient is 0.2, general headquarters are adjusted
Coefficient is 0.2, reserved parameter 1 is 3, reserved parameter 2 is 4, reserved parameter 3 is 0.5, annual commission is 10,000 yuan, protection commission is
300 yuan, assistant director's commission be 5000 yuan, to adjust commission be that 2000 yuan of wholes extract.
As a kind of optional embodiment, which can also include: to be unsatisfactory for data in preset data table
In the case where verifying rule, the information for stopping calculating commission is returned to user terminal.And then it may remind the user that this commission meter
Calculate failure.
Further, in the case where preset data table meets data check rule, the institute for including in preset data table is extracted
After some commissions calculate the factor, which can also include: to be obtained from database according to commission rule encoding
Conversion results type and conversion results title；And all commissions are calculated into the factor according to conversion results type and conversion results
Title is packaged, and obtains factor encapsulation package.Wherein, conversion results type can be the type of factor encapsulation package, may include
List, Map, conversion results title can be the title of factor encapsulation package, may include checkList, checkMap.
For example, conversion results type corresponding with commission rule encoding NQMX is List, conversion results are entitled
CheckList can will then have mortgage meter to mention coefficient and be 0.3, is 10,000 yuan without mortgage commission, have that mortgage commission is 50,000 yuan, i is borrowed
Commission is 1000 yuan, actively monitoring coefficient is 0.3, sale control coefficient is 0.4, product monitoring coefficient is 0.2, general headquarters adjust system
Number is 0.2, reserved parameter 1 is 3, reserved parameter 2 is 4, reserved parameter 3 is 0.5, annual commission is 10,000 yuan, protection commission is
300 yuan, assistant director's commission be 5000 yuan, adjust commission and be 2000 yuan and be encapsulated in entitled checkList, type is the factor of List
In encapsulation package.
Step S104 matches corresponding commission computation rule, wherein in commission computation rule according to commission rule encoding
Coverage factor type.
In embodiment of the disclosure, there are a variety of commission calculation codes, each commission rule encoding is associated with one kind
Commission computation rule.When calculating the commission of a certain product, commission computing platform can according to the commission rule encoding of acquisition, and
Commission computation rule corresponding with the commission rule encoding is matched from numerous commission computation rules, then according to the commission
Computation rule calculates this commission.Also, calculate commission be actually by this commission for being related to of calculating calculate the factor by
It is calculated according to the commission computation rule, wherein it include at least one factor pattern in commission computation rule, what this was related to
Commission calculates the factor and just belongs to these factor patterns, wherein the corresponding commission of each factor pattern calculates the factor.
In accordance with an embodiment of the present disclosure, the corresponding commission computation rule of commission rule encoding NQMX can be with are as follows:
Commission=(no mortgage commission+there is mortgage commission+i to borrow commission) × actively monitor coefficient
× sale control coefficient × product monitoring coefficient × general headquarters' adjustment factor × reserved parameter 1
× reserved parameter 2 × reserves parameter 3+ year commission+adjusting commission+protection commission
Wherein, no mortgage commission, have mortgage commission, i borrow commission, actively monitor coefficient, sale control coefficient, product monitoring
Coefficient, general headquarters' adjustment factor, reserved parameter 1, reserved parameter 2, reserved parameter 3, annual commission, adjusting commission and protection commission are equal
For factor pattern.
In embodiment of the disclosure, the corresponding commission computation rule of commission rule encoding NQMX can store more respectively
In a drl file.
For example, being stored in 2 drl files, wherein first drl file can be without mortgage commission, have mortgage commission
It is added with i loan commission and then monitors coefficient, general headquarters' adjustment factor, reserved ginseng with active monitoring coefficient, sale control coefficient, product
Number 1, reserved parameter 2, reserved parameter 3 are multiplied, and second drl file can be annual commission, adjust commission and protection commission phase
Add.
Step S105 is calculated from all commissions and is filtered out the commission calculating factor corresponding with factor pattern in the factor.
Wherein, it is calculated from all commissions and filters out the commission calculating factor corresponding with factor pattern in the factor, can wrap
It includes: filtering out commission corresponding with factor pattern from factor encapsulation package and calculate the factor.
In embodiment of the disclosure, any in order to make to adapt to since there are numerous commission computation rules
All commissions can be calculated the factor and be encapsulated in factor encapsulation package by commission computation rule in conjunction with above-described embodiment.Meter every time
When calculating commission, corresponding commission is just filtered out from factor encapsulation package and calculates the factor.It is calculated for this commission, commission
Computing platform can calculate in the factor automatically from all commissions for including in factor encapsulation package and filter out the servant used with this
The corresponding commission of factor pattern in golden computation rule calculates the factor.
For example, factor encapsulation package be above-described embodiment in entitled checkList, type be List encapsulation package, then from
The commission corresponding with above-mentioned factor pattern filtered out in the factor encapsulation package calculates the factor are as follows: is 10,000 yuan, has without commission is mortgaged
Mortgage commission is 50,000 yuan, i loan commission is 1000 yuan, actively monitoring coefficient is 0.3, sale control coefficient is 0.4, product monitoring
Coefficient is 0.2, general headquarters' adjustment factor is 0.2, reserved parameter 1 is 3, reserved parameter 2 is 4, reserved parameter 3 is 0.5, annual commission
For 10,000 yuan, adjust that commission is 2000 yuan, protection commission is 300 yuan.
Step S106 calculates the factor according to commission computation rule and the commission corresponding with factor pattern filtered out, calculates
Commission.
For example, commission=(10000+50000+1000) × 0.3 × 0.4 × 0.2 × 0.2 × 3 × 4 × 0.5+10000+
2000+300=14506.8 first.
In accordance with an embodiment of the present disclosure, if commission computation rule is respectively stored in multiple drl files, then according to each
A drl file calculates after commission, it is also necessary to summarize the commission calculated separately out.For example, according to first drl file
The commission 1=(10000+50000+1000) of calculating × 0.3 × 0.4 × 0.2 × 0.2 × 3 × 4 × 0.5=2206.8 member, second
The commission 2 that a drl file calculates is 10000+2000+300=12300 member, commission 1 and commission 2 summarize available
Commission=2206.8+12300=14506.8 member.
In accordance with an embodiment of the present disclosure, which can also include: inquiry for storing commission to data
Second database statement of the specified tables of data in library；And commission is stored to specified tables of data by the second database statement
In.
For example, this commission calculated is can then to preset to settle accounts commission A to mechanism A by the commission of mechanism A
A is stored into the specified tables of data 1 of database, then after the commission A that mechanism A has been calculated, can be incited somebody to action by the second SQL statement
Commission A is stored into specified tables of data 1.
Further, after storage is completed, which can also include: output for prompting commission to be calculated as
The information of function.
As a kind of optional embodiment, which can also include: that calculated commission is returned to user
Terminal.
In embodiment of the disclosure, to count final calculated commission convenient for user, embodiment of the disclosure is being counted
After calculating commission, calculated commission can also be returned to corresponding user terminal, so that user can be according to user terminal
The commission of upper display is counted.Wherein, the user terminal includes but is not limited to that the electronics such as desktop computer, laptop are set
It is standby.
The commission calculation method that the disclosure provides, after the commission computations for receiving user terminal transmission, according to
The commission computations obtain corresponding commission rule encoding, then judge whether preset data table meets data check rule,
All commissions are extracted from preset data table if meeting and calculate the factor, corresponding commission meter is inquired according to commission rule encoding
Rule is calculated, since the factor pattern of the factor is calculated in the commission computation rule comprising calculating the commission that this commission needs to use,
Therefore it can further be calculated from all commissions and filter out the commission calculating factor corresponding with the factor pattern in the factor, and according to
Commission computation rule and the commission corresponding with factor pattern filtered out calculate the factor, calculate this commission.In this way, for difference
Product, a series of data can be obtained according to the corresponding commission rule encoding of the product and calculate commission, and then are avoided
In the prior art commission calculate take a long time, can not flexible configuration defect, realize flexibly through various commission calculating sides
Formula calculates the technical effect of the commission of each product.
Fig. 2 diagrammatically illustrates the flow chart of the commission calculation method according to another embodiment of the disclosure.
As shown in Fig. 2, the commission calculation method includes step S201~step S208, in which:
Step S201 obtains commission rule encoding；
Step S202 inquires the SQL statement for verifying data, calls the drl file for being stored with data check rule；
Step S203, whether verifying preset data table meets data check rule, executes step S208 if not, if executing
Step S204；
Step S204 inquires the SQL statement of advance data, and advance data is packaged into List or Map；
Step S205, inquiry are stored with the drl file of commission computation rule, in conjunction with the set inquired in advance data,
Dimension is summarized as desired in the drl file for being stored with commission computation rule；
Step S206 inquires the SQL statement of postposition data configuration, and the postposition data obtained after calculating in conjunction with commission execute
Data landing；
Step S207 will be prompted to meter and hire successful information return interface；
Step S208 stops meter and hires, and the information that will be prompted to meter servant's failure returns to interface.
The commission numerical procedure of the embodiment of the present disclosure may include four processes, be respectively: the preposition number of 1- data check, 2-
It is calculated according to, 3- commission, 4- postposition data, wherein advance data is also known as commission and calculates the factor, and postposition data are also known as commission.
In accordance with an embodiment of the present disclosure, after the commission triggered in response to user terminal calculates signal, available servant
Golden rule encoding, subsequently into the data check SQL statement in the process of 1- data check, i.e., configured in querying flow allocation list
(having referred to as first database sentence), then in rule searching allocation list DRL_TYPE=1- data check configure be stored with data
The drl file of rule is verified, the drl file for being stored with data check rule is then called by data check SQL statement, into one
Step verifies whether preset data table meets data check rule, hires if not satisfied, then stopping meter, and will be prompted to meter and hire failure
Information returns to interface；If satisfied, then entering in the process of 2- advance data.It, can be according to servant in the process of 2- advance data
Golden rule encoding and regular group, process is the SQL statement of 2- advance data in querying flow allocation list, is then by process
The SQL statement of 2- advance data calls preset data table, and (is also known as turned according to<result type>that configures in flow config table
Change result type) and<result name>(also known as conversion results title), all commissions in preset data table are calculated into the factor
It is encapsulated in a total commResultMap.Further, the process calculated into 3- commission, in the stream that the 3- commission calculates
Cheng Zhong, the SQL statement that inquiry commission calculates, and the drl file for being stored with commission computation rule is inquired, it is calculated by commission
SQL statement calls the drl file for being stored with commission computation rule, includes factor pattern in commission computation rule, from
The commission calculating factor for belonging to the factor pattern is found in commResultMap, and combines commission computation rule, is tieed up as desired
Degree (for example, calculating commission for mechanism) calculates commission.Subsequently into the process of 4- postposition data, in the process of 4- postposition data
In, the SQL statement (also known as the second database statement) of inquiry storage commission, by the SQL statement of the storage commission by commission
It stores in specified tables of data, to realize that data are landed.Further, it will be prompted to meter and hire the boundary that successful information returns to user terminal
Face.
It should be noted that commission computation rule is potentially stored in multiple drl files in the process that 3- commission calculates,
For each drl file, the process of 3- commission calculating, the drl to all storage commission computation rules can be executed
File has been performed both by after the process of 3- commission calculating, each time implementing result can be summarized, and then obtain this public affairs
The commission for the embodiment opened.
Fig. 3 diagrammatically illustrates the block diagram of the commission computing platform according to the embodiment of the present disclosure.
As shown in figure 3, the commission computing platform 300 may include the first acquisition module 310, processing module 320, extract mould
Block 330, matching module 340, screening module 350 and computing module 360, in which:
The commission computations that first acquisition module 310 is used to send in response to user terminal, according to commission computations
Obtain corresponding commission rule encoding；
Processing module 320 is used to obtain preset data table from database, and judges whether preset data table meets data
Verify rule, wherein preset data table calculates the factor for storing commission；
Extraction module 330 is used to extract in preset data table in the case where preset data table meets data check rule
All commissions for including calculate the factor；
Matching module 340 is used to match corresponding commission computation rule according to commission rule encoding, wherein commission calculates
Coverage factor type in rule；
Screening module 350 be used to calculate from all commission filtered out in the factor commission corresponding with factor pattern calculate because
Son；And
Computing module 360 be used for according to commission computation rule and the commission corresponding with factor pattern filtered out calculating because
Son calculates commission.
The commission computing platform that the disclosure provides, after the commission computations for receiving user terminal transmission, according to
The commission computations obtain corresponding commission rule encoding, then judge whether preset data table meets data check rule,
All commissions are extracted from preset data table if meeting and calculate the factor, corresponding commission meter is inquired according to commission rule encoding
Rule is calculated, since the factor pattern of the factor is calculated in the commission computation rule comprising calculating the commission that this commission needs to use,
Therefore it can further be calculated from all commissions and filter out the commission calculating factor corresponding with the factor pattern in the factor, and according to
Commission computation rule and the commission corresponding with factor pattern filtered out calculate the factor, calculate this commission.In this way, for difference
Product, a series of data can be obtained according to the corresponding commission rule encoding of the product and calculate commission, and then are avoided
In the prior art commission calculate take a long time, can not flexible configuration defect, realize flexibly through various commission calculating sides
Formula calculates the technical effect of the commission of each product.
As a kind of optional embodiment, commission computing platform can also include: the second acquisition module, for according to commission
Rule encoding obtains conversion results type and conversion results title and package module from database, for by all servants
Gold calculates the factor and is packaged according to conversion results type and conversion results title, obtains factor encapsulation package；And screening module
It is also used to: filtering out commission corresponding with factor pattern from factor encapsulation package and calculate the factor.
As a kind of optional embodiment, commission computing platform can also include: the first enquiry module, be used for for inquiring
Verify the first database sentence of data；Second enquiry module verifies rule for inquiring for storing data in database
File；And first calling module, for calling file by first database sentence, to obtain data check rule.
As a kind of optional embodiment, commission computing platform can also include: third enquiry module, be used for for inquiring
By the second database statement of specified tables of data of the commission storage into database；And second calling module, for passing through the
Two database statements store commission into specified tables of data.
As a kind of optional embodiment, commission computing platform can also include: the first return module, in present count
In the case where being unsatisfactory for data check rule according to table, the information for stopping calculating commission is returned to user terminal.
As a kind of optional embodiment, commission computing platform can also include: the second return module, for that will calculate
Commission return user terminal.
Fig. 4 is diagrammatically illustrated according to the hard of the computer equipment for being adapted for carrying out commission calculation method of the embodiment of the present disclosure
Part configuration diagram.In the present embodiment, computer equipment 400 is that one kind can be according to the instruction for being previously set or storing, certainly
The dynamic equipment for carrying out numerical value calculating and/or information processing.For example, it may be smart phone, tablet computer, laptop, platform
Formula computer, rack-mount server, blade server, tower server or Cabinet-type server (including independent server,
Or server cluster composed by multiple servers) etc..As shown, include, but is not limited to: can for computer equipment 400
Connection memory 410, processor 420, network interface 430 are in communication with each other by system bus.Wherein:
Memory 410 includes at least a type of computer readable storage medium, and readable storage medium storing program for executing includes flash memory, hard
Disk, multimedia card, card-type memory (for example, SD or DX memory etc.), random access storage device (RAM), static random-access
Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), may be programmed read-only storage at read-only memory (ROM)
Device (PROM), magnetic storage, disk, CD etc..In some embodiments, memory 410 can be computer equipment 400
Storage inside module, such as the hard disk or memory of the computer equipment 400.In further embodiments, memory 410 can also be with
It is the External memory equipment of computer equipment 400, such as the plug-in type hard disk being equipped in the computer equipment 400, intelligent storage
Block (Smart Media Card, referred to as SMC), secure digital (Secure Digital, referred to as SD) card, flash card
(Flash Card) etc..Certainly, memory 410 can also both including computer equipment 400 storage inside module and also including it
External memory equipment.In the present embodiment, memory 410 commonly used in storage be installed on computer equipment 400 operating system and
Types of applications software, such as the program code of commission calculation method etc..In addition, memory 410 can be also used for temporarily storing
The Various types of data that has exported or will export.
Processor 420 can be central processing unit (Central Processing Unit, abbreviation in some embodiments
For CPU), controller, microcontroller, microprocessor or other data processing chips.The processor 420 is commonly used in control meter
Calculate machine equipment 400 overall operation, such as execute with computer equipment 400 carry out data interaction or communication it is relevant control and
Processing etc..In the present embodiment, program code or processing data of the processor 420 for being stored in run memory 410.
Network interface 430 may include radio network interface or wired network interface, which is commonly used in counting
It calculates to establish between machine equipment 400 and other computer equipments and communicate to connect.For example, network interface 430 is by passing through network by based on
Calculate machine equipment 400 be connected with exterior terminal, between computer equipment 400 and exterior terminal establish data transmission channel and lead to
Letter connection etc..Network can be intranet (Intranet), internet (Internet), global system for mobile communications
(Global System of Mobile communication, referred to as GSM), wideband code division multiple access (Wideband Code
Division Multiple Access, referred to as WCDMA), 4G network, 5G network, bluetooth (Bluetooth), the nothings such as Wi-Fi
Line or cable network.
It should be pointed out that Fig. 4 illustrates only the computer equipment with component 410-430, it should be understood that simultaneously
All components shown realistic are not applied, the implementation that can be substituted is more or less component.
In the present embodiment, the commission calculation method being stored in memory 410 can also be divided into one or more
A program module, and it is performed by one or more processors (the present embodiment is processor 420), to complete the present invention.
The present embodiment also provides a kind of computer readable storage medium, and computer readable storage medium is stored thereon with calculating
Machine program, when computer program is executed by processor realize embodiment in commission calculation method the step of.
In the present embodiment, computer readable storage medium include flash memory, hard disk, multimedia card, card-type memory (for example,
SD or DX memory etc.), random access storage device (RAM), static random-access memory (SRAM), read-only memory (ROM),
Electrically erasable programmable read-only memory (EEPROM), programmable read only memory (PROM), magnetic storage, disk, CD
Deng.In some embodiments, computer readable storage medium can be the internal storage unit of computer equipment, such as the calculating
The hard disk or memory of machine equipment.In further embodiments, computer readable storage medium is also possible to the outer of computer equipment
The plug-in type hard disk being equipped in portion's storage equipment, such as the computer equipment, intelligent memory card (Smart Media Card, letter
Referred to as SMC), secure digital (Secure Digital, referred to as SD) card, flash card (Flash Card) etc..Certainly, computer
Readable storage medium storing program for executing can also both including computer equipment internal storage unit and also including its External memory equipment.The present embodiment
In, computer readable storage medium is installed on the operating system and types of applications software of computer equipment, example commonly used in storage
The program code of commission calculation method in such as embodiment.In addition, computer readable storage medium can be also used for temporarily
Store the Various types of data that has exported or will export.
Obviously, those skilled in the art should be understood that each module of the above-mentioned embodiment of the present invention or each step can be with
It is realized with general computing device, they can be concentrated on a single computing device, or be distributed in multiple computing devices
On composed network, optionally, they can be realized with the program code that computing device can perform, it is thus possible to by it
Store and be performed by computing device in the storage device, and in some cases, can be held with the sequence for being different from herein
The shown or described step of row, perhaps they are fabricated to each integrated circuit modules or will be multiple in them
Module or step are fabricated to single integrated circuit module to realize.In this way, the embodiment of the present invention be not limited to it is any specific hard
Part and software combine.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure or equivalent flow shift made by bright specification and accompanying drawing content is applied directly or indirectly in other relevant skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of commission calculation method is applied to commission computing platform, which is characterized in that the described method includes:
In response to the commission computations that user terminal is sent, corresponding commission rule is obtained according to the commission computations and is compiled
Code；
Preset data table is obtained from database, and judges whether the preset data table meets data check rule, wherein institute
It states preset data table and calculates the factor for storing commission；
In the case where the preset data table meets the data check rule, the institute for including in the preset data table is extracted
Some commissions calculate the factor；
According to the commission rule encoding, match corresponding commission computation rule, wherein in the commission computation rule comprising because
Subtype；
It is calculated from all commissions and filters out the commission calculating factor corresponding with the factor pattern in the factor；And
The factor is calculated according to the commission computation rule and the commission corresponding with the factor pattern filtered out, calculates commission.
2. the method according to claim 1, wherein the method also includes:
According to the commission rule encoding, conversion results type and conversion results title are obtained from the database, and
All commissions are calculated the factor to be packaged according to the conversion results type and the conversion results title, are obtained
To factor encapsulation package；And
Described calculate from all commissions filters out the commission calculating factor corresponding with the factor pattern, packet in the factor
It includes:
Commission corresponding with the factor pattern is filtered out from the factor encapsulation package calculates the factor.
3. the method according to claim 1, wherein the method also includes:
Inquire the first database sentence for verifying data；
It inquires in the database for storing the file of the data check rule；And
The file is called by the first database sentence, to obtain the data check rule.
4. the method according to claim 1, wherein the method also includes:
Inquire the second database statement for the specified tables of data by commission storage into the database；And
The commission is stored into the specified tables of data by second database statement.
5. the method according to claim 1, wherein the method also includes:
In the case where the preset data table is unsatisfactory for the data check rule, Xiang Suoshu user terminal, which returns, to be stopped calculating
The information of commission.
6. the method according to claim 1, wherein the method also includes:
The calculated commission is returned into the user terminal.
7. a kind of commission computing platform characterized by comprising
First obtains module, and the commission computations for sending in response to user terminal are obtained according to the commission computations
Take corresponding commission rule encoding；
Processing module for obtaining preset data table from database, and judges whether the preset data table meets data core
Look into rule, wherein the preset data table calculates the factor for storing commission；
Extraction module, for extracting the present count in the case where the preset data table meets the data check rule
The factor is calculated according to all commissions for including in table；
Matching module, for matching corresponding commission computation rule, wherein the commission meter according to the commission rule encoding
Calculate Coverage factor type in rule；
Screening module filters out commission calculating corresponding with the factor pattern for calculating from all commissions in the factor
The factor；And
Computing module, for according to the commission computation rule and the commission corresponding with the factor pattern filtered out calculate because
Son calculates commission.
8. platform according to claim 7, which is characterized in that the platform further include:
Second obtains module, for according to the commission rule encoding, obtaining conversion results type from the database and turning
Change result name, and
Package module, for all commissions to be calculated the factor according to the conversion results type and the conversion results name
Title is packaged, and obtains factor encapsulation package；And
The screening module is also used to: filtered out from the factor encapsulation package corresponding with factor pattern commission calculate because
Son.
9. a kind of computer equipment, can run on a memory and on a processor including memory, processor and storage
Computer program, which is characterized in that the processor executes any for realizing claim 1 to 6 when the computer program
The step of item the method.
10. a kind of computer readable storage medium, is stored thereon with computer program, which is characterized in that the computer program
The step of when being executed by processor for realizing any one of claim 1 to 6 the method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910301320.3A CN110135798A (en) | 2019-04-15 | 2019-04-15 | Commission calculation method, platform, computer equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910301320.3A CN110135798A (en) | 2019-04-15 | 2019-04-15 | Commission calculation method, platform, computer equipment and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110135798A true CN110135798A (en) | 2019-08-16 |
Family
ID=67570068
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910301320.3A Pending CN110135798A (en) | 2019-04-15 | 2019-04-15 | Commission calculation method, platform, computer equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110135798A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111680971A (en) * | 2020-05-25 | 2020-09-18 | 泰康保险集团股份有限公司 | Commission calculating system and method |
| CN111882286A (en) * | 2020-06-19 | 2020-11-03 | 五八到家有限公司 | Method, device, equipment and storage medium for processing extracted data |
| CN112685437A (en) * | 2020-12-28 | 2021-04-20 | 平安普惠企业管理有限公司 | Configuration-based commission calculation method, device, equipment and storage medium |
| CN113391800A (en) * | 2021-05-19 | 2021-09-14 | 广州有信科技有限公司 | Configurable commission settlement method, device and computer readable storage medium |
| CN113822717A (en) * | 2021-09-24 | 2021-12-21 | 杭州同泽信息技术服务有限公司 | Method and device for calculating commission of local production enterprise |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106651677A (en) * | 2016-12-08 | 2017-05-10 | 杭州销冠网络科技有限公司 | Intelligent calculation method and system |
| CN107220757A (en) * | 2017-05-23 | 2017-09-29 | 上海最会保网络科技有限公司 | A kind of system and method for rule configuration and parsing |
| CN108009909A (en) * | 2017-11-29 | 2018-05-08 | 金色家园网络科技有限公司 | financial information processing method and device |
| CN108647936A (en) * | 2018-05-08 | 2018-10-12 | 中国平安人寿保险股份有限公司 | Commission distribution method, device, computer equipment and storage medium |
| CN109359277A (en) * | 2018-10-22 | 2019-02-19 | 众安在线财产保险股份有限公司 | Data monitoring method, equipment and computer storage medium |
-
2019
- 2019-04-15 CN CN201910301320.3A patent/CN110135798A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106651677A (en) * | 2016-12-08 | 2017-05-10 | 杭州销冠网络科技有限公司 | Intelligent calculation method and system |
| CN107220757A (en) * | 2017-05-23 | 2017-09-29 | 上海最会保网络科技有限公司 | A kind of system and method for rule configuration and parsing |
| CN108009909A (en) * | 2017-11-29 | 2018-05-08 | 金色家园网络科技有限公司 | financial information processing method and device |
| CN108647936A (en) * | 2018-05-08 | 2018-10-12 | 中国平安人寿保险股份有限公司 | Commission distribution method, device, computer equipment and storage medium |
| CN109359277A (en) * | 2018-10-22 | 2019-02-19 | 众安在线财产保险股份有限公司 | Data monitoring method, equipment and computer storage medium |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111680971A (en) * | 2020-05-25 | 2020-09-18 | 泰康保险集团股份有限公司 | Commission calculating system and method |
| CN111680971B (en) * | 2020-05-25 | 2023-08-18 | 泰康保险集团股份有限公司 | Commission calculating system and method |
| CN111882286A (en) * | 2020-06-19 | 2020-11-03 | 五八到家有限公司 | Method, device, equipment and storage medium for processing extracted data |
| CN112685437A (en) * | 2020-12-28 | 2021-04-20 | 平安普惠企业管理有限公司 | Configuration-based commission calculation method, device, equipment and storage medium |
| CN113391800A (en) * | 2021-05-19 | 2021-09-14 | 广州有信科技有限公司 | Configurable commission settlement method, device and computer readable storage medium |
| CN113391800B (en) * | 2021-05-19 | 2022-03-15 | 广州有信科技有限公司 | Configurable commission settlement method, device and computer readable storage medium |
| CN113822717A (en) * | 2021-09-24 | 2021-12-21 | 杭州同泽信息技术服务有限公司 | Method and device for calculating commission of local production enterprise |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110135798A (en) | Commission calculation method, platform, computer equipment and computer readable storage medium | |
| CN108958714B (en) | Business component type development method and device, computer equipment and storage medium | |
| CN110413269A (en) | Interface coding method, server and computer readable storage medium | |
| CN107766132A (en) | Multi-task scheduling method, application server and computer-readable recording medium | |
| CN107958016A (en) | Function pages method for customizing and application server | |
| CN108428104A (en) | Wages computational methods, application server and computer readable storage medium | |
| CN109299129A (en) | Data query method, apparatus, computer equipment and the storage medium of natural language | |
| CN107103453A (en) | Public emolument computational methods and system | |
| CN112330444A (en) | Platform multi-bank access calling method, system and device | |
| CN112035344A (en) | Multi-scenario test method, device, equipment and computer readable storage medium | |
| CN109146095A (en) | The treating method and apparatus of multiservice system problem | |
| CN110599354A (en) | Online reconciliation method, system, computer device and computer-readable storage medium | |
| CN110502530A (en) | Database functions call method, system, computer equipment and storage medium | |
| CN110532279A (en) | Big data platform authority control method, device, computer equipment and storage medium | |
| CN109447384A (en) | Verification method, device, equipment and the storage medium of air control system | |
| CN107844711A (en) | Data manipulation authority partition method, application server and computer-readable recording medium | |
| CN111314424B (en) | Component management method and system of service platform | |
| CN112416488A (en) | User portrait implementation method and device, computer equipment and computer readable storage medium | |
| CN111159226A (en) | Index query method and system | |
| CN110533524A (en) | Lost contact restorative procedure and system based on business connection map | |
| CN110502482A (en) | User interface configuration method, system and data manipulation method | |
| CN110191097A (en) | Detection method, system, equipment and the storage medium of login page safety | |
| CN106484391A (en) | Dynamic Service autgmentability | |
| CN106529942A (en) | NFC card access method and terminal | |
| CN108805725A (en) | Risk case confirmation method, server and computer readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190816 |