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<EventInfo> page, IgdsBaseParam param) {
|
QueryWrapper<EventInfo> queryWrapper = getQueryWrapper(param);
|
eventInfoMapper.selectPage(page, queryWrapper);
|
}
|
|
/**
|
* 封装查询条件
|
*
|
* @param param
|
*/
|
public QueryWrapper<EventInfo> getQueryWrapper(IgdsBaseParam param) {
|
QueryWrapper<EventInfo> 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<EventInfo> getListByParam(IgdsBaseParam param) {
|
if (null == param) {
|
param = new IgdsBaseParam();
|
}
|
|
QueryWrapper<EventInfo> queryWrapper = new QueryWrapper<>();
|
|
|
if (StringUtils.isBlank(param.getCompanyId())) {
|
param.setCompanyId(ContextUtil.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);
|
}
|
|
}
|
