java-insagent-pc/src/main/java/com/ydtech/modules/partner/service/Impl/PartnerExpiredCommissionServiceImpl.java

package com.ydtech.modules.partner.service.Impl;


import cn.hutool.core.collection.CollectionUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ydtech.core.page.HttpResult;
import com.ydtech.modules.partner.dao.PartnerExpiredCommissionMapper;
import com.ydtech.modules.partner.model.PartnerExpiredCommission;
import com.ydtech.modules.partner.service.PartnerExpiredCommissionService;
import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class PartnerExpiredCommissionServiceImpl extends ServiceImpl<PartnerExpiredCommissionMapper, PartnerExpiredCommission> implements PartnerExpiredCommissionService {


    @Override
    public HttpResult queryPage(Page page,PartnerExpiredCommission expiredCommission) {
        QueryWrapper<PartnerExpiredCommission> queryWrapper = new QueryWrapper<>();
        queryWrapper.select("id,name,mobile,user_id,grade,grade_after,lock_commission,downgrade_time,expiration,(SELECT `name` FROM sys_dept WHERE sys_dept.id = dept_id) deptName");
        queryWrapper.eq(StringUtils.isNotBlank(expiredCommission.getName()),"name", expiredCommission.getName());
        queryWrapper.eq(StringUtils.isNotBlank(expiredCommission.getMobile()),"mobile", expiredCommission.getMobile());
        queryWrapper.eq(StringUtils.isNotBlank(expiredCommission.getUserId()),"user_id", expiredCommission.getUserId());
        List<String> startTime = expiredCommission.getStartTime();
        if (CollectionUtil.isNotEmpty(startTime) && startTime.size() >= 2){
            String s = startTime.get(0);
            String e = startTime.get(1);
            if (StringUtils.isNotBlank(s) && StringUtils.isNotBlank(e)) {
                queryWrapper.between("expiration", s, e);
            } else if (StringUtils.isNotBlank(s)) {
                queryWrapper.ge("expiration", s);
            } else if (StringUtils.isNotBlank(e)) {
                queryWrapper.le("expiration",e);
            }
        }
        return HttpResult.ok(baseMapper.selectPage(page, queryWrapper));
    }

}