2021SC@SDUSC

Coupon function （ One ）

This article and the next article , We focus on JPress Coupon function items related to financial management .JPress The main function of the article 、 Page functions 、 Commodity function and accessory function . Coupons are an essential part of commodity functions ,JPress From creation 、 management 、 Use 、 Records and other aspects perfectly present the creation of coupons 、 Use 、 Circulation mode .

One 、 Functional presentation

1.1 Coupon function

Select control panel coupons , Fill in relevant information , If only members are available 、 Absolute prescription 、 State, etc , Click on the submit , Generate coupons .

After successful creation, the interface is as follows , Show coupon details .

Click Assign coupons , You can distribute discounts to corresponding users .

Finally, you can see the list of coupons , There are users 、 Collection time and other relevant information .

1.2 Database tables involved

coupon： Coupon , Record the basic information of the created coupon .

coupon_code： Coupon code , Record the distribution of coupons 、 Key information such as generated discount code .

coupon_used_record： Coupon usage record .

Two 、 Add ：JFinal ActiveRecord-Model

We are JPress In the operation database ？ Thanks to JFinal Of ActiveRecord. In the previous post , We introduced ActiveRecord Of DB+Record Patterns and paginate Pagination API, This time you need to be familiar with ActiveRecordPlugin And Model, To better understand the code .

2.1 ActiveRecord

• ActiveRecord yes JFinal One of the core components , adopt ActiveRecord To manipulate the database , Will greatly reduce the amount of code , Greatly improve development efficiency .
• ActiveRecord The core of the model is ： One Model Object uniquely corresponds to a record in the database table , The corresponding relationship depends on the primary key value of the database table . therefore ,ActiveRecord The schema requires that the database table must have a primary key .
• So in the previous code analysis , We do not operate the database with a specific object , But rely on Model object .

2.2 ActiveRecordPlugin

• ActiveRecord As a JFinal Of Plugin And there is , So you need to use it in JFinalConfig Middle configuration ActiveRecordPlugin.
• ActiveReceord It defines addMapping(String tableName, Class<? extends Model> modelClass>) Method , The method The database table name is established to Model The mapping relation of .

2.3 Model

• Model yes ActiveRecord One of the most important components in , It acts as MVC In the pattern Model part . Here are Model Define sample code ：

public class User extends Model<User> {
        public static final User dao = new User().dao();}

• In the above code User By inheritance Model, There are many convenient ways to operate the database . stay User Declarative dao Static objects are defined to facilitate query operations , This object is not necessary . be based on ActiveRecord Of Model There is no need to define properties , There is no need to define getter、setter Method , There is no need to XML To configure , There is no need to Annotation To configure , Greatly reduces the amount of code .

3、 ... and 、 Yes Model Specific use examples of

We use CouponServiceProvider give an example .

3.1 Inherit JbootServiceBase

Inherit JbootServiceBase<M extends JbootModel<M>>, Add... To generics model Object of operation , And call related methods .

public class CouponServiceProvider extends JbootServiceBase<Coupon> implements CouponService {
    

    @Inject
    private CouponCodeService couponCodeService;

    @Inject
    private CouponUsedRecordService usedRecordService;

    @Override
    public void doSyncTakeCount(long couponId) {
    
        long count = couponCodeService.queryCountByCouponId(couponId);
        Coupon coupon = findById(couponId);
        coupon.setTakeCount(count);
        update(coupon);
    }
}

3.2 call JbootServiceBase Methods

• The calling method is , Pass in the object to be operated , You can operate the database .
• For example, in the above example code doSyncTakeCount(long couponId) Methods update(coupon), In the end in JbootServiceBase The method calls are as follows ：

public boolean update(M model) {
    
    boolean result = model.update();
    if (result) {
    
        this.shouldUpdateCache(3, model, model._getIdValue());
    }

    return result;
}

Use Model To the database 、 Update the cache .

Four 、 summary

This article starts with the panel function and usage of coupons 、 Yes Model A supplement to the concept 、 Yes Model Describe the code of the actual operation database , This is beneficial to our understanding of the underlying implementation of the following code . The next article coupon function （ Two ） I'll tell you more about JPress Relevant codes of coupon operation in .