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.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.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()); // } //事件标签 if (StringUtils.isNotBlank(param.getName())) { queryWrapper.like("tags", 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); } /** * 持久化保存 * * @param info */ public void addData(EventInfo info) { if (StringUtils.isBlank(info.getId())) { info.setId(ContextUtil.generateId()); } if (StringUtils.isBlank(info.getCompanyId())) { info.setCompanyId(ContextUtil.getCompanyId()); } info.setUpdateBy(ContextUtil.getLoginUserName()); info.setUpdateTime(new Date()); info.setCreateBy(ContextUtil.getLoginUserName()); info.setCreateTime(new Date()); eventInfoMapper.insert(info); } }