2.7.18

shikeyin

2024-01-11 65da8373531677b1c37a98f53eaa30c892f35e5a

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
package com.ishop.merchant.service;
 
import com.ishop.merchant.BalanceRecordConstants;
import com.ishop.model.po.EbUserBalanceRecord;
import com.walker.db.Sorts;
import com.walker.db.page.GenericPager;
import com.walker.infrastructure.utils.NumberFormatUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import org.springframework.stereotype.Service;
 
@Service
public class UserBalanceServiceImpl extends BaseServiceImpl {
 
    private final Sorts.Sort timeSort = Sorts.DESC().setField("create_time");
 
    /**
     * 查询个人余额变动列表。
     * @param recordType 记录类型：all-全部，expenditure-支出，income-收入，recharge-充值
     * @param userId
     * @return
     * @date 2023-09-13
     */
    public GenericPager queryPageBalanceList(String recordType, long userId){
        EbUserBalanceRecord param = new EbUserBalanceRecord();
        param.setUid(userId);
//        if(StringUtils.isNotEmpty(recordType)){
//            param.setLinkType(recordType);
//        }
        if(recordType.equals("expenditure")){
            param.setType(BalanceRecordConstants.BALANCE_RECORD_TYPE_SUB);
        } else if(recordType.equals("income")){
            param.setType(BalanceRecordConstants.BALANCE_RECORD_TYPE_ADD);
        } else if(recordType.equals("recharge")) {
            param.setType(BalanceRecordConstants.BALANCE_RECORD_TYPE_ADD);
            param.setLinkType(BalanceRecordConstants.BALANCE_RECORD_LINK_TYPE_RECHARGE);
        }
        return this.selectSplit(param, timeSort);
    }
 
    /**
     * 统计用户账户，余额充值总金额
     * @param userId
     * @return
     */
    public double queryTotalRechargeRecord(long userId){
        Double total = this.queryForObject(SQL_TOTAL_RECHARGE, new Object[]{userId}, Double.class);
        if(total == null){
            return 0;
        }
        return NumberFormatUtils.scaleAccuracy2(total);
    }
 
    /**
     * 统计用户账户，余额消费总金额
     * @param userId
     * @return
     * @date 2023-09-09
     */
    public double queryTotalMonetaryRecord(long userId){
        Double total = this.queryForObject(SQL_TOTAL_MONETARY, new Object[]{userId}, Double.class);
        if(total == null){
            return 0;
        }
        return NumberFormatUtils.scaleAccuracy2(total);
    }
 
    private static final String SQL_PAGE_LIST = "";
    private static final String SQL_TOTAL_MONETARY = "select sum(amount) total from eb_user_balance_record where uid=? and link_type='order' and type=2";
    private static final String SQL_TOTAL_RECHARGE = "select sum(amount) total from eb_user_balance_record where uid=? and link_type='recharge' and type=1";
}