package com.fzzy.igds.service; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.fzzy.igds.data.BaseResp; import com.fzzy.igds.data.IgdsBaseParam; import com.fzzy.igds.domain.EventInfo; import com.fzzy.igds.mapper.EventInfoMapper; import com.fzzy.igds.utils.ContextUtil; import com.fzzy.igds.utils.DateUtil; import com.fzzy.work.domain.WorkOrder; import com.ruoyi.common.utils.StringUtils; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; import javax.annotation.Resource; import java.util.Date; import java.util.List; @Slf4j @Service public class EventInfoService { @Resource private EventInfoMapper eventInfoMapper; /** * 分页查询数据 * * @param page * @param param */ public void listPage(Page page, IgdsBaseParam param) { QueryWrapper queryWrapper = getQueryWrapper(param); eventInfoMapper.selectPage(page, queryWrapper); } /** * 封装查询条件 * * @param param */ public QueryWrapper getQueryWrapper(IgdsBaseParam param) { QueryWrapper queryWrapper = new QueryWrapper<>(); param.setCompanyId(ContextUtil.getCompanyId()); queryWrapper.eq("company_id", param.getCompanyId()); //库区检索 if (StringUtils.isNotBlank(param.getDeptId())) { queryWrapper.eq("dept_id", param.getDeptId()); } //仓库检索 if (StringUtils.isNotBlank(param.getDepotId())) { queryWrapper.eq("depot_id", param.getDepotId()); } // 收储公司检索 if (StringUtils.isNotBlank(param.getKey())) { queryWrapper.likeRight("dept_id", param.getKey()); } //抓拍时间检索 if (null != param.getStart()) { queryWrapper.ge("time", param.getStart()); } if (null != param.getEnd()) { queryWrapper.le("time", param.getEnd()); } //事件名称 if (StringUtils.isNotBlank(param.getName())) { queryWrapper.like("name", param.getName()); } queryWrapper.orderByDesc("create_time"); return queryWrapper; } /** * * @param param * @return */ public List getListByParam(IgdsBaseParam param) { if (null == param){ param = new IgdsBaseParam(); } QueryWrapper queryWrapper = new QueryWrapper<>(); if (StringUtils.isNotBlank(param.getCompanyId())) { queryWrapper.eq("company_id", param.getCompanyId()); } if (StringUtils.isNotBlank(param.getDeptId())) { queryWrapper.likeRight("dept_id", param.getDeptId()); } if (null != param.getStart()) { queryWrapper.ge("time", DateUtil.getCurZero(param.getStart())); } if (null != param.getEnd()) { queryWrapper.le("time", DateUtil.getNextZero(param.getEnd())); } return eventInfoMapper.selectList(queryWrapper); } }