CN109409958A - Integrate the method that balance of points is quickly updated in expired system - Google Patents
Integrate the method that balance of points is quickly updated in expired system Download PDFInfo
- Publication number
- CN109409958A CN109409958A CN201811267595.1A CN201811267595A CN109409958A CN 109409958 A CN109409958 A CN 109409958A CN 201811267595 A CN201811267595 A CN 201811267595A CN 109409958 A CN109409958 A CN 109409958A
- Authority
- CN
- China
- Prior art keywords
- cash
- expired
- integral
- user
- field
- 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.)
- Granted
Links
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
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0207—Discounts or incentives, e.g. coupons or rebates
- G06Q30/0235—Discounts or incentives, e.g. coupons or rebates constrained by time limit or expiration date
-
- 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
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0207—Discounts or incentives, e.g. coupons or rebates
- G06Q30/0208—Trade or exchange of goods or services in exchange for incentives or rewards
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Game Theory and Decision Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention discloses a kind of integrate, and the method for balance of points is quickly updated in expired system, comprising: establishes the integrating system being made of user's table and flowing water table, user's table includes id field and cash field；Increase last_off_date field and off_cash field in user's table；Off_cash field is updated in each total mark of consumption；When execution integral is expired, it is expired by deducted integral to calculate execution integral next time.The present invention compares whether current time has reached expired time when obtaining user integral by the balance of points that one next time of additional maintenance deducts when expired, can be the balance of points subtracted after deducting integrated value with balance of points if reaching expired time；Not up to the time returns to balance of points, realizes that quick, no-delay execution integrates expired deduction operation.
Description
Technical field
The present invention relates to integration data processing technology fields, are that a kind of integrate quickly updates in expired system specifically
The method of balance of points.
Background technique
Currently, integral is used as a kind of effective extending user group, the marketing tool of consumer loyalty degree is improved.Integrate expiration policies
Target any active ues can be screened, user maintenance cost is reduced, therefore is very expired it is necessary to which integral is arranged for integrating system
Time, to execute expired operation to user integral in time.Expired implementation method is integrated at present is generally divided into two kinds, one is
It is obtained for each integral, this integral is not consumed also after reaching expired time, is just subtracted out.Another kind is, for a certain
The integral obtained in a period, reaches not spend also after the expired time of setting and is just subtracted out, the first realization logic compared with
For complexity, calculation amount is larger.Therefore, the second scheme that many implementations use at present.Second of realization at present is to reach
User integral is carried out one by one expired after expired time, it is even more long that implementation procedure may continue several hours, expired integrating
In implementation procedure, the phenomenon that integrate-dump just will appear delay.
Summary of the invention
The purpose of the present invention is to provide a kind of integrate, and the method for balance of points is quickly updated in expired system, for solving
The problem of expired time is longer, and integrate-dump postpones is integrated due to executing in the prior art.
The present invention is solved the above problems by following technical proposals:
A method of it integrates in expired system and quickly updates balance of points, comprising:
Step S100: establishing the integrating system that is made of user's table and flowing water table, user's table include id field and
Cash field, the id field are used for unique identification user, and the cash field is for identifying current integration remaining sum；
Step S200: increase last_off_date field and off_cash field, the last_off_ in user's table
Date field for identify last time execute section point expired time, the off_cash field for identify next time execute integral it is expired
By the integral of deduction；
Step S300: off_cash field is updated in each total mark of consumption；
Step S400: when execution integral is expired, it is expired by deducted integral to calculate execution integral next time.
Further, the step S300 is specifically included:
Step S310: user integral remaining sum is obtained:
User's table is inquired, whether detection last_off_date is less than current date plus an integration period, if so,
The value that cash field subtracts off_cash field is returned as current integration remaining sum, otherwise returns to cash field value as user
Remaining sum；
Step S320: customer consumption integral:
Compare whether current integration remaining sum is greater than consumption number, if it is, entering in next step, otherwise, returns to failure；
Step S330: judging whether last_off_date field is less than current date plus an integration period, if
It is then to deduct cash, generates flowing water table record；Otherwise, it deducts cash and deducts off_cash, generate flowing water table record.
Further, in the step S330, when deducting off_cash, if off_cash is less than total mark of consumption number,
Then off_cash is reset.
Further, the step S400 is specifically included:
Step S410: it is searched from user's table and needs to be implemented the user for integrating expired operation；
Step S420: executing cash to the user and subtract off_cash, and modifying last_off_date is current time
Value；
Step S430: scanning flowing water table obtains active user in the integral that this needs to obtain in expiration period but goes back
The number of points not spent is filled into off_cash field to get expired principal value of integral next time is arrived；
Step S440: circulation executes step S410- step S430, until all use executed per family integrate it is expired.
Compared with prior art, the present invention have the following advantages that and the utility model has the advantages that
The balance of points that the present invention is deducted when expired by one next time of additional maintenance, when obtaining user integral, than
Whether expired time is reached compared with current time, can be after subtracting deduction integrated value with balance of points if reaching expired time
Balance of points；Not up to the time return balance of points, by integration period end execute once integrate it is expired be changed to every time consume product
The expired integral of user is deducted in timesharing in real time, and calculates to execute next time and integrate expired integral, realizes quick, no-delay
It executes and integrates expired deduction operation.
Detailed description of the invention
Fig. 1 is to obtain user in the present invention to use the flow chart of integral；
Fig. 2 is the flow chart of customer consumption integral in the present invention；
Fig. 3 is to execute to integrate expired flow chart in the present invention.
Specific embodiment
The present invention is described in further detail below with reference to embodiment, embodiments of the present invention are not limited thereto.
Embodiment 1:
In conjunction with shown in attached drawing 1, a method of it integrates in expired system and quickly updates balance of points, comprising:
1, database table is built
User's table of integrating system increases field in the prior art, in the prior art user's table such as following table of integrating system
1, flowing water table in the prior art such as table 2:
User's table of the integrating system in the prior art of table 1
The flowing water table of the integrating system in the prior art of table 2
Increase last_off_date field and off_cash field in table 1, obtain the following table 3,
User's table of 3 integrating system of table
2, user integral remaining sum is obtained
By the id of user, inquires user's table (user table), user data is got, if last_off_date is added
A cycle is less than current date, returns to cash-off_cash as balance of points, otherwise returns to cash field value as integral
Remaining sum.
Detailed process first from user's table as shown in Figure 1, obtain user id, and data are inquired from user's table, and simultaneously amplitude is given
U, inquiry data u whether there is, if it does, obtaining current period y, judge that the last_off_date of u is plus a cycle
Cash field is subtracted the value of off_cash field and returns to the cash field of u, otherwise, returned by the no y that is equal to if be equal to
Return the value of cash field；If u is not present, returns to user and be not present.
3, customer consumption integrates
Whether the balance of points for comparing acquisition is greater than consumption number, fails no more than returning；If it is greater than judging whether
Last_off_date is less than current date plus a cycle, is less than current date and deducts user cash, generates flowing water, otherwise,
Cash is deducted, and deducts off_cash, if off_cash is less than total mark of consumption number when deducting off_cash, only with off_
Cash is set as zero, generates Flow Record.
Specifically as shown in Fig. 2, obtaining user id, and expenditure number of points out_cash is obtained, passes through user id and inquire number
According to u, integral uc can be used by obtaining user, judge whether user can be greater than expenditure number of points out_cash with integral uc, if there is
It is greater than, then judges whether current year is equal to the last_off_year of u, if be equal to, the off_cash of u is subtracted into out_
Cash, if result is set to 0 less than 0；Otherwise the cash field of user is subtracted into out_cash and more new data
Library generates Flow Record；If user can be less than expenditure number of points out_cash with integral uc, balance of points is prompted not
Foot.
4, it is expired to execute integral
Current period is obtained, user's table is inquired, finds out the data that last_off_cash is less than current period, this part
User needs to be implemented the expired operation of integral, executes to each user checked out cash value subtracting off_cash modification
Last_off_date is current period value, scans flowing water table, obtains what active user needed to get in expiration period at this
The number of points that integral is not spent also still, is filled into off_cash field.
It is specific as shown in figure 3, the value of last_off_date field adds when being less than current after a cycle in inquiry user's table
Between user be put into list；User in list table is carried out one by one to operate below:
A user u is taken out, and is removed from list, the cash of u is subtracted into off_cash, setting last_off_year is
Current period generates and integrates expired flowing water；
Scanning integral flowing water, obtains the integral for needing to obtain in expiration period next time but the total value that do not consume also, filling
To off_cash field.
By checking whether current time has reached the expired time when obtaining user integral remaining sum, if not up to,
Cash is just directly returned as available balance, if having reached expired time, cash is returned to and subtracts off_cash as available
Remaining sum, that is, being subtracted out should remaining sum after expired integral.To reach the real-time mesh for deducting the expired number of points of user
's.It finally generates flowing water one by one again and executes and integrate expired relevant operation.By the deduction of execution integral balance of points when expired
It executes in advance.According to this thinking, it would be desirable to update off_cash field in each total mark of consumption, be integrated in execution
When the phase, expired principal value of integral next time is calculated, it is therefore desirable to when integrating consumption, by above-mentioned balance of points acquisition methods,
Balance of points is obtained, judges whether remaining sum consumes enough, because of the preferential expired integral of consumer need, when total mark of consumption
Off_cash, which should make, accordingly to reduce, thus can real-time servicing need expired integral next time.When execution integral is expired,
Detection last_off_date first judges whether to execute integral expired, prevents from repeating expired, detains in next step remaining sum
It removes, generates Flow Record, then scan flowing water table, calculate the part that the integral that expired time section obtains next time is not consumed also,
It is filled into off_cash field, here it is improved integral is expired.
Although reference be made herein to invention has been described for explanatory embodiment of the invention, and above-described embodiment is only this hair
Bright preferable embodiment, embodiment of the present invention are not limited by the above embodiments, it should be appreciated that those skilled in the art
Member can be designed that a lot of other modification and implementations, these modifications and implementations will fall in principle disclosed in the present application
Within scope and spirit.
Claims (4)
1. a kind of integrate the method for quickly updating balance of points in expired system characterized by comprising
Step S100: the integrating system being made of user's table and flowing water table is established, user's table includes id field and cash word
Section, the id field are used for unique identification user, and the cash field is for identifying current integration remaining sum；
Step S200: increase last_off_date field and off_cash field, the last_off_date in user's table
Field for identify last time execute section point expired time, the off_cash field for identify next time execute integral it is expired will button
The integral removed；
Step S300: off_cash field is updated in each total mark of consumption；
Step S400: when execution integral is expired, it is expired by deducted integral to calculate execution integral next time.
2. quickly updating the method for balance of points in the expired system of integral according to claim 1, which is characterized in that described
Step S300 is specifically included:
Step S310: user integral remaining sum is obtained:
User's table is inquired, whether detection last_off_date is less than current date plus an integration period, if so, will
The value that cash field subtracts off_cash field is returned as current integration remaining sum, otherwise returns to cash field value as more than user
Volume；
Step S320: customer consumption integral:
Compare whether current integration remaining sum is greater than consumption number, if it is, entering in next step, otherwise, returns to failure；
Step S330: judging whether last_off_date field is less than current date plus an integration period, if it is,
Cash is deducted, flowing water table record is generated；Otherwise, it deducts cash and deducts off_cash, generate flowing water table record.
3. quickly updating the method for balance of points in the expired system of integral according to claim 2, which is characterized in that described
In step S330, when deducting off_cash, if off_cash is less than total mark of consumption number, off_cash is reset.
4. quickly updating the method for balance of points in the expired system of integral according to claim 3, which is characterized in that described
Step S400 is specifically included:
Step S410: it is searched from user's table and needs to be implemented the user for integrating expired operation；
Step S420: executing cash to the user and subtract off_cash, and modifying last_off_date is current time value；
Step S430: scanning flowing water table obtains active user in the integral that this needs to obtain in expiration period but does not spend also
The number of points taken is filled into off_cash field to get expired principal value of integral next time is arrived；
Step S440: circulation executes step S410- step S430, until all use executed per family integrate it is expired.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811267595.1A CN109409958B (en) | 2018-10-29 | 2018-10-29 | Method for quickly updating point balance in point overdue system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811267595.1A CN109409958B (en) | 2018-10-29 | 2018-10-29 | Method for quickly updating point balance in point overdue system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109409958A true CN109409958A (en) | 2019-03-01 |
| CN109409958B CN109409958B (en) | 2021-11-16 |
Family
ID=65470341
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811267595.1A Active CN109409958B (en) | 2018-10-29 | 2018-10-29 | Method for quickly updating point balance in point overdue system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109409958B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113486036A (en) * | 2021-07-07 | 2021-10-08 | 广州博冠信息科技有限公司 | Virtual resource management method and device, electronic equipment and storage medium |
| CN113723940A (en) * | 2021-09-01 | 2021-11-30 | 京东科技控股股份有限公司 | Account data processing method and device, electronic equipment and storage medium |
| CN117611249A (en) * | 2024-01-16 | 2024-02-27 | 杭州数云信息技术有限公司 | Member point information processing method and device, readable storage medium and terminal |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2008054750A2 (en) * | 2006-10-30 | 2008-05-08 | Credit Suisse Securities (Usa) Llc | Generating documentation and approvals for entities and transactions |
| CN102136114A (en) * | 2010-01-21 | 2011-07-27 | 维鹏信息技术(上海)有限公司 | Control method for acquiring coupon by coupon terminal and corresponding system |
| CN103413216A (en) * | 2013-05-16 | 2013-11-27 | 深圳市淘淘谷信息技术有限公司 | Multi-account management payment method |
| CN105117418A (en) * | 2015-07-30 | 2015-12-02 | 百度在线网络技术（北京）有限公司 | Search based service information management system and method |
| CN105469275A (en) * | 2015-11-12 | 2016-04-06 | 广州优识资讯系统有限公司 | Credit data processing method and system based on plurality of merchants |
| CN106960366A (en) * | 2017-03-23 | 2017-07-18 | 深圳市优讯信息技术有限公司 | Integral cycle data processing method, platform |
| CN107563812A (en) * | 2017-09-05 | 2018-01-09 | 广东科杰通信息科技有限公司 | A kind of integrate-dump method, system |
| CN107688934A (en) * | 2017-09-14 | 2018-02-13 | 平安科技（深圳）有限公司 | Integrate deduction method and terminal device |
| CN108154393A (en) * | 2017-12-25 | 2018-06-12 | 株洲市红博医学知识培训指导服务有限公司 | A kind of quadrature conversion method and its system |
| CN108510333A (en) * | 2018-04-27 | 2018-09-07 | 厦门南讯软件科技有限公司 | A kind of more clients integrate the processing method and processing device of fast-aging |
-
2018
- 2018-10-29 CN CN201811267595.1A patent/CN109409958B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2008054750A2 (en) * | 2006-10-30 | 2008-05-08 | Credit Suisse Securities (Usa) Llc | Generating documentation and approvals for entities and transactions |
| CN102136114A (en) * | 2010-01-21 | 2011-07-27 | 维鹏信息技术(上海)有限公司 | Control method for acquiring coupon by coupon terminal and corresponding system |
| CN103413216A (en) * | 2013-05-16 | 2013-11-27 | 深圳市淘淘谷信息技术有限公司 | Multi-account management payment method |
| CN105117418A (en) * | 2015-07-30 | 2015-12-02 | 百度在线网络技术（北京）有限公司 | Search based service information management system and method |
| CN105469275A (en) * | 2015-11-12 | 2016-04-06 | 广州优识资讯系统有限公司 | Credit data processing method and system based on plurality of merchants |
| CN106960366A (en) * | 2017-03-23 | 2017-07-18 | 深圳市优讯信息技术有限公司 | Integral cycle data processing method, platform |
| CN107563812A (en) * | 2017-09-05 | 2018-01-09 | 广东科杰通信息科技有限公司 | A kind of integrate-dump method, system |
| CN107688934A (en) * | 2017-09-14 | 2018-02-13 | 平安科技（深圳）有限公司 | Integrate deduction method and terminal device |
| CN108154393A (en) * | 2017-12-25 | 2018-06-12 | 株洲市红博医学知识培训指导服务有限公司 | A kind of quadrature conversion method and its system |
| CN108510333A (en) * | 2018-04-27 | 2018-09-07 | 厦门南讯软件科技有限公司 | A kind of more clients integrate the processing method and processing device of fast-aging |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113486036A (en) * | 2021-07-07 | 2021-10-08 | 广州博冠信息科技有限公司 | Virtual resource management method and device, electronic equipment and storage medium |
| CN113486036B (en) * | 2021-07-07 | 2023-12-29 | 广州博冠信息科技有限公司 | Virtual resource management method and device, electronic equipment and storage medium |
| CN113723940A (en) * | 2021-09-01 | 2021-11-30 | 京东科技控股股份有限公司 | Account data processing method and device, electronic equipment and storage medium |
| CN113723940B (en) * | 2021-09-01 | 2023-11-03 | 京东科技控股股份有限公司 | Account data processing method and device, electronic equipment and storage medium |
| CN117611249A (en) * | 2024-01-16 | 2024-02-27 | 杭州数云信息技术有限公司 | Member point information processing method and device, readable storage medium and terminal |
| CN117611249B (en) * | 2024-01-16 | 2024-04-16 | 杭州数云信息技术有限公司 | Member point information processing method and device, readable storage medium and terminal |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109409958B (en) | 2021-11-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109409958A (en) | Integrate the method that balance of points is quickly updated in expired system | |
| Van der Linden et al. | Software product family evaluation | |
| Seeanner et al. | Combining the principles of variable neighborhood decomposition search and the fix&optimize heuristic to solve multi-level lot-sizing and scheduling problems | |
| CN106033424B (en) | Data mining method and device | |
| Wang et al. | A two-stage robust programming approach to demand-driven disassembly planning for a closed-loop supply chain system | |
| KR20100069573A (en) | Method, computer program and computer system for assisting in analyzing program | |
| CN115600992A (en) | Project management method based on prediction algorithm | |
| CN116562715B (en) | Index data monitoring method, device, computer equipment and storage medium | |
| Sharma et al. | An empirical approach for early estimation of software testing effort using SRS document | |
| CN116629556A (en) | Recommendation task distribution method and device, storage medium and electronic equipment | |
| CN109285025A (en) | A kind of anti-brush method, system and device of task | |
| JP2004157746A (en) | System for evaluating/predicting/planning/managing environmental efficiency/load of total quantity of a plurality of objects in past/future, evaluating/predicting/planning/managing method, and program for it | |
| CN109272141A (en) | A kind of Power Material plan intelligent declaration method and platform | |
| Gailly et al. | On the symbiosis between enterprise modelling and ontology engineering | |
| Luft et al. | A methodical approach to model and map interconnected decision making situations and their consequences | |
| Heiat et al. | A model for estimating efforts required for developing small-scale business applications | |
| Singh et al. | Evaluation and application of package level metrics in assessing software quality | |
| Silva et al. | ModularityCheck: A tool for assessing modularity using co-change clusters | |
| Zhou et al. | An integrated risk analysis method using spatial interpolation | |
| JP2008204180A (en) | Environmental load evaluation system and method | |
| CN112950295B (en) | Method and device for mining user data, readable storage medium and electronic equipment | |
| Trendowicz et al. | Constructive Cost Model—COCOMO | |
| CN113256270B (en) | Data processing method, data processing device, data processing apparatus, and storage medium | |
| JP5553039B2 (en) | Consumed physical quantity management device, consumed physical quantity management method, and program | |
| Rastogi | An optimal software test case mechanism using grey wolf-FireFly method |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |