经销商管理

doum

2025-12-12 89029e9ade03f3139c6afcd6bac48d9a668875f3

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
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
package com.doumee.service.business.impl;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.doumee.core.model.PageData;
import com.doumee.core.model.PageWrap;
import com.doumee.core.utils.Utils;
import com.doumee.dao.business.join.LabelsJoinMapper;
import com.doumee.dao.business.join.MonthlySettlementJoinMapper;
import com.doumee.dao.business.model.Areas;
import com.doumee.dao.business.model.Fund;
import com.doumee.dao.business.model.Labels;
import com.doumee.dao.business.model.MonthlySettlement;
import com.doumee.service.business.MonthlySettlementService;
import com.github.yulichang.wrapper.MPJLambdaWrapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import java.util.List;
 
@Service
public class MonthlySettlementServiceImpl  implements MonthlySettlementService {
 
 
    @Autowired
    private MonthlySettlementJoinMapper monthlySettlementJoinMapper;
    @Override
    public MonthlySettlement findOne(MonthlySettlement monthlySettlement) {
        MPJLambdaWrapper<MonthlySettlement> query = new MPJLambdaWrapper<>();
      //  query.eq("DATE_FORMAT(t.CREATE_DATE, '%Y-%m')","DATE_FORMAT( LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 MONTH)), '%Y-%m')");
        query.orderByDesc(MonthlySettlement::getCreateTime);
        query.last("limit 1");
        MonthlySettlement result=monthlySettlementJoinMapper.selectOne(query);
        return result;
    }
 
    @Override
    public void update(MonthlySettlement monthlySettlement) {
        monthlySettlementJoinMapper.updateById(monthlySettlement);
    }
 
    @Override
    public Integer intsert(MonthlySettlement monthlySettlement) {
       return monthlySettlementJoinMapper.insert(monthlySettlement);
    }
 
    @Override
    public PageData<MonthlySettlement> findPage(PageWrap<MonthlySettlement> pageWrap) {
        IPage<MonthlySettlement> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
        MPJLambdaWrapper<MonthlySettlement> queryWrapper = new MPJLambdaWrapper<>();
        Utils.MP.blankToNull(pageWrap.getModel());
 
        queryWrapper.selectAll(MonthlySettlement.class);
        queryWrapper.select("(select sum(NUM) from fund f " +
                " where f.ISDELETED=0 and  f.TYPE=0  and  DATE_FORMAT(t.CREATE_TIME, '%Y-%m')= DATE_FORMAT(f.CREATE_DATE, '%Y-%m') ) as monthAdd");
        queryWrapper.select("(select sum(NUM) from fund f " +
                " where f.ISDELETED=0 and  f.TYPE=1 and  DATE_FORMAT(t.CREATE_TIME, '%Y-%m')= DATE_FORMAT(f.CREATE_DATE, '%Y-%m') ) as monthSub");
 
        queryWrapper.eq(pageWrap.getModel().getYear()!=null,MonthlySettlement::getYear,pageWrap.getModel().getYear());
        queryWrapper.orderByDesc(MonthlySettlement::getCreateTime);
        IPage<MonthlySettlement> result = monthlySettlementJoinMapper.selectJoinPage(page, MonthlySettlement.class, queryWrapper);
 
        return PageData.from(result);
    }
 
    @Override
    public List<MonthlySettlement> Listall(MonthlySettlement pageWrap) {
        MPJLambdaWrapper<MonthlySettlement> queryWrapper = new MPJLambdaWrapper<>();
 
        queryWrapper.selectAll(MonthlySettlement.class);
 
        queryWrapper.select("(select sum(NUM) from fund f " +
                " where f.ISDELETED=0 and  f.TYPE=0  and  DATE_FORMAT(t.CREATE_TIME, '%Y-%m')= DATE_FORMAT(f.CREATE_DATE, '%Y-%m') ) as monthAdd");
        queryWrapper.select("(select sum(NUM) from fund f " +
                " where f.ISDELETED=0 and  f.TYPE=1 and  DATE_FORMAT(t.CREATE_TIME, '%Y-%m')= DATE_FORMAT(f.CREATE_DATE, '%Y-%m') ) as monthSub");
 
        queryWrapper.eq(pageWrap.getYear()!=null,MonthlySettlement::getYear,pageWrap.getYear());
 
        queryWrapper.orderByDesc(MonthlySettlement::getCreateTime);
        List<MonthlySettlement> result = monthlySettlementJoinMapper.selectJoinList(MonthlySettlement.class, queryWrapper);
 
        return result;
    }
 
 
}