CN109409958B

CN109409958B - Method for quickly updating point balance in point overdue system

Info

Publication number: CN109409958B
Application number: CN201811267595.1A
Authority: CN
Inventors: 陈熙; 杨雪梅; 漆尧; 唐军
Original assignee: Sichuan Changhong Electric Co Ltd
Current assignee: Sichuan Changhong Electric Co Ltd
Priority date: 2018-10-29
Filing date: 2018-10-29
Publication date: 2021-11-16
Anticipated expiration: 2038-10-29
Also published as: CN109409958A

Abstract

The invention discloses a method for quickly updating the balance of points in a point overdue system, which comprises the following steps: establishing a scoring system consisting of a user table and a water flow meter, wherein the user table comprises an id field and a cash field; adding a last _ off _ date field and an off _ case field in the user table; updating the off _ case field at each point consumed; when the execution point expires, the point to be deducted when the next execution point expires is calculated. The invention additionally maintains the accumulated point balance deducted at the next time of expiration, when the user accumulated point is obtained, the current time is compared with the expiration time, if the current time reaches the expiration time, the available accumulated point balance is the accumulated point balance deducted by the deduction integral value; and returning the integral balance when the time is not reached, and realizing the quick and non-delay execution of the operation of deducting the overdue integral.

Description

Method for quickly updating point balance in point overdue system

Technical Field

The invention relates to the technical field of point data processing, in particular to a method for quickly updating point balance in a point overdue system.

Background

Currently, points are used as a sales promotion means for effectively expanding user groups and improving user loyalty. The point expiration strategy can screen target active users and reduce the maintenance cost of the users, so that the point expiration time is very necessary to be set for a point system so as to timely execute expiration operation on the points of the users. The conventional method for realizing the overdue credit is generally divided into two methods, one method is to acquire each credit and deduct the credit if the credit is not consumed after the overdue time is reached. The other is that the integral acquired in a certain time period is deducted without spending after reaching the set expiration time, and the first method has complex implementation logic and large calculation amount. Thus, many implementations currently employ the second approach. The second current implementation is that user points are expired one by one after the expiration time is reached, the execution process may last for several hours or even longer, and the point zero clearing may delay in the point expiration execution process.

Disclosure of Invention

The invention aims to provide a method for quickly updating the balance of an integral in an integral overdue system, which is used for solving the problem that the integral zero clearing is delayed due to longer integral overdue execution time in the prior art.

The invention solves the problems through the following technical scheme:

a method for quickly updating point balances in a point expiration system, comprising:

step S100: establishing a credit system consisting of a user table and a water flow meter, wherein the user table comprises an id field and a case field, the id field is used for uniquely identifying a user, and the case field is used for identifying the current credit balance;

step S200: adding a last _ off _ date field and an off _ case field in a user table, wherein the last _ off _ date field is used for identifying the expiration time of the last executed integral, and the off _ case field is used for identifying the integral to be deducted when the next executed integral expires;

step S300: updating the off _ case field at each point consumed;

step S400: when the execution point expires, the point to be deducted when the next execution point expires is calculated.

Further, the step S300 specifically includes:

step S310: acquiring the integral balance of the user:

inquiring a user table, detecting whether last _ off _ date plus an integration period is smaller than the current date, if so, returning a value obtained by subtracting an off _ case field from a case field as the current integration balance, otherwise, returning a case field value as the user balance;

step S320: the user consumes the points:

comparing whether the current credit balance is larger than the consumption amount, if so, entering the next step, otherwise, returning to fail;

step S330: judging whether the sum of the last _ off _ date field and an integration period is less than the current date, if so, deducting the case, and generating a flow chart record; otherwise, deducting case and deducting off _ case, and generating a flow table record.

Further, in step S330, when off _ case is deducted, if off _ case is smaller than the consumption credit amount, off _ case is cleared.

Further, the step S400 specifically includes:

step S410: searching a user table for a user needing to perform an integral expiration operation;

step S420: performing a case subtraction of off _ case for the user, and modifying last _ off _ date to be a current time value;

step S430: scanning the flow water meter, acquiring the integral quantity which is acquired by the current user within the required expiration period but is not spent, and filling the integral quantity into an off _ case field to obtain the value of the next expiration integral;

step S440: and circularly executing the steps S410-S430 until all the users have executed the expiration of the integration.

Compared with the prior art, the invention has the following advantages and beneficial effects:

the invention additionally maintains the accumulated point balance deducted at the next time of expiration, when the user accumulated point is obtained, the current time is compared with the expiration time, if the current time reaches the expiration time, the available accumulated point balance is the accumulated point balance deducted by the deduction integral value; and returning the point balance when the time is not reached, changing the point overdue executed at the end of the point period into real-time deduction of the overdue point of the user when the point is consumed each time, and calculating the point overdue executed next time, thereby realizing quick and delay-free execution of point overdue deduction operation.

Drawings

FIG. 1 is a flow chart of the present invention for obtaining user-available points;

FIG. 2 is a flow chart of the consumer points consumed in the present invention;

fig. 3 is a flow chart of the present invention for performing expiration of credits.

Detailed Description

The present invention will be described in further detail with reference to examples, but the embodiments of the present invention are not limited thereto.

Example 1:

referring to fig. 1, a method for quickly updating a credit balance in a credit expiration system includes:

1. database table establishment

The user table of the prior art bonus point system is added with fields, the user table of the prior art bonus point system is shown as the following table 1, and the flow meter of the prior art is shown as the following table 2:

TABLE 1 user table of prior art integrating system

TABLE 2 flow chart of integrating system in prior art

Adding a last _ off _ date field and an off _ case field in table 1, results in table 3 below,

TABLE 3 user table of integral system

2. Obtaining a user point balance

And inquiring a user table (user table) through the id of the user to obtain user data, if last _ off _ date plus a period is less than the current date, returning a case-off _ case as an integral balance, and otherwise, returning a case field value as the integral balance.

The specific process is as shown in fig. 1, first obtain user id from user table, query data from user table and give amplitude to u, query whether data u exists, if yes, obtain current period y, judge whether last _ off _ date of u plus a period equals to y, if yes, subtract off _ case field value from case field and return to case field of u, otherwise, return to case field value; if u does not exist, returning that the user does not exist.

3. Consumer points of consumption

Comparing whether the obtained integral balance is larger than the consumption amount and not larger than the return failure; if the sum of last _ off _ date and a period is larger than the current date, the sum is smaller than the current date, the user's case is deducted if the sum is smaller than the current date, otherwise, the case is deducted and off _ case is deducted, if the off _ case is smaller than the consumption integral amount when the off _ case is deducted, only setting the off _ case to be zero, and generating a running water record.

Specifically, as shown in fig. 2, a user id is obtained, a number of expenditure points out _ case is obtained, data u is queried through the user id, an available point uc of the user is obtained, whether the available point uc of the user is greater than the number of expenditure points out _ case is judged, if yes, whether the current year is equal to last _ off _ year of u is judged, if yes, out _ case is subtracted from off _ case of u, and if the result is less than 0, the value is set to 0; otherwise, subtracting out _ case from the case field of the user and updating the database to generate a running record; if the user available points uc are less than the number of expenditure points out _ case, the points balance is prompted to be insufficient.

4. Performing point expiration

Acquiring a current period, inquiring a user table, finding out data with last _ off _ case smaller than the current period, wherein the part of users need to execute integral expiration operation, subtracting off _ case from a case value to modify last _ off _ date into a current period value, scanning the flow water meter, acquiring the integral quantity which is acquired by the current user in the period needing expiration at this time but is not spent, and filling the integral quantity into an off _ case field.

Specifically, as shown in fig. 3, the user who is less than the current time after adding one period to the value of last _ off _ date field in the query user table puts in list; the following operations are performed one by one for the users in the list table:

taking out a user u, removing the user u from the list, subtracting off _ case from the case of the user u, setting last _ off _ year as the current period, and generating an integral overdue running water;

the point flow is scanned to get the total amount that will be needed the next time the points are obtained during the expiration period but not consumed, and the off _ case field is filled.

When the user point balance is obtained, whether the current time reaches the time of expiration is checked, if not, a case is directly returned as an available balance, and if the time of expiration reaches, the case minus off _ case is returned as the available balance, namely, the balance after the point which should be expired is deducted. Therefore, the purpose of deducting the overdue credit number of the user in real time is achieved. And finally, generating running water one by one and executing correlation operation of integral expiration. The deduction of the credit balance when the credit expires is executed in advance. According to the thought, the off _ case field needs to be updated when each consumption point is expired, and when the executed point is expired, the value of the next expired point is calculated, so that when the point is consumed, the point balance is acquired through the point balance acquisition method, whether the balance is enough to be consumed is judged, and because the expired point is consumed preferentially, the off _ case is required to be correspondingly deducted when the point is consumed, so that the next expired point can be maintained in real time. When the executed integral is overdue, firstly, last _ off _ date is detected to judge whether the executed integral is overdue or not, repeated execution of overdue is prevented, balance is deducted next, a running water record is generated, a running water meter is scanned again, the part, which is not consumed, of the integral acquired in the next overdue time period is calculated, and the part is filled in an off _ case field, namely the improved integral is overdue.

Although the present invention has been described herein with reference to the illustrated embodiments thereof, which are intended to be preferred embodiments of the present invention, it is to be understood that the invention is not limited thereto, and that numerous other modifications and embodiments can be devised by those skilled in the art that will fall within the spirit and scope of the principles of this disclosure.

Claims

1. A method for quickly updating point balance in a point expiration system, comprising:

step S300: updating the off _ case field when each point is consumed specifically includes:

step S310: acquiring the integral balance of the user:

step S320: the user consumes the points:

step S330: judging whether the sum of the last _ off _ date field and an integration period is less than the current date, if so, deducting the case, and generating a flow chart record; otherwise, deducting the case and deducting the off _ case to generate a flow chart record;

2. The method of claim 1, wherein in step S330, when off _ case is deducted, if off _ case is smaller than consumption credit amount, then off _ case is cleared.

3. The method for rapidly updating the balance of points in the point expiration system according to claim 2, wherein the step S400 specifically comprises: