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 implements PartnerExpiredCommissionService { @Override public HttpResult queryPage(Page page,PartnerExpiredCommission expiredCommission) { QueryWrapper 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 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)); } }