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.Patrol;
|
import com.fzzy.igds.domain.PatrolConf;
|
import com.fzzy.igds.domain.PatrolRecord;
|
import com.fzzy.igds.mapper.PatrolConfMapper;
|
import com.fzzy.igds.mapper.PatrolMapper;
|
import com.fzzy.igds.mapper.PatrolRecordMapper;
|
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;
|
import java.util.Map;
|
|
@Slf4j
|
@Service
|
public class PatrolService {
|
|
@Resource
|
private PatrolMapper patrolMapper;
|
@Resource
|
private PatrolRecordMapper patrolRecordMapper;
|
@Resource
|
private PatrolConfMapper patrolConfMapper;
|
|
|
/*--------------------巡更主表管理------------------*/
|
/**
|
* 查询7天内的所有巡更记录信息
|
*
|
* @return
|
*/
|
public List<Patrol> getWeekList() {
|
|
Date end = new Date();
|
Date start = DateUtil.getNewByDay(end, -6);
|
|
QueryWrapper<Patrol> queryWrapper = new QueryWrapper<>();
|
|
queryWrapper.ge("create_time", DateUtil.getCurZero(start));
|
|
queryWrapper.le("create_time", DateUtil.getNextZero(end));
|
|
return patrolMapper.selectList(queryWrapper);
|
}
|
|
/**
|
* 根据条件分页查询数据
|
*
|
* @param page
|
* @param param
|
*/
|
public void pagePatrolData(Page<Patrol> page, IgdsBaseParam param) {
|
QueryWrapper<Patrol> queryWrapper = new QueryWrapper<>();
|
if (StringUtils.isNotBlank(param.getDeptId())) {
|
queryWrapper.like("dept_id", param.getDeptId());
|
} else {
|
if (StringUtils.isNotBlank(param.getCompanyId())) {
|
queryWrapper.likeRight("dept_id", param.getCompanyId());
|
}
|
}
|
if (null != param.getStart()) {
|
queryWrapper.ge("create_time", DateUtil.getCurZero(param.getStart()));
|
}
|
if (null != param.getEnd()) {
|
queryWrapper.le("create_time", DateUtil.getCurZero(param.getEnd()));
|
}
|
|
patrolMapper.selectPage(page, queryWrapper);
|
}
|
|
/*--------------------巡更轨迹表管理------------------*/
|
/**
|
* 根据巡更ID查询具体点位信息
|
*
|
* @param
|
* @return
|
*/
|
public List<PatrolRecord> getRecordByPatrolId(String patrolId,String userId,String confId) {
|
|
if(StringUtils.isBlank(patrolId)){
|
return null;
|
}
|
|
QueryWrapper<PatrolRecord> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("patrol_id", patrolId);
|
queryWrapper.eq("user_id", userId);
|
queryWrapper.eq("conf_id", confId);
|
queryWrapper.orderByDesc("id");
|
|
return patrolRecordMapper.selectList(queryWrapper);
|
}
|
/*--------------------巡更轨迹表管理------------------*/
|
|
/**
|
* 根据巡更ID查询具体点位信息
|
*
|
* @param
|
* @return
|
*/
|
public List<PatrolRecord> getRecordByPatrolId(Map<String, String> param) {
|
String patrolId = param.get("patrolId");
|
|
if (StringUtils.isBlank(patrolId)) {
|
return null;
|
}
|
String userName = param.get("name");
|
|
QueryWrapper<PatrolRecord> queryWrapper = new QueryWrapper<>();
|
queryWrapper.eq("patrol_id", patrolId);
|
|
if (userName != null) {
|
queryWrapper.eq("user_id", userName);
|
}
|
queryWrapper.orderByDesc("id");
|
return patrolRecordMapper.selectList(queryWrapper);
|
}
|
|
|
/*--------------------巡更配置表管理------------------*/
|
/**
|
* 查询库区下所有配置信息
|
* @param param
|
* @return
|
*/
|
public List<PatrolConf> listPatrolConf(IgdsBaseParam param) {
|
|
if(null == param){
|
param = new IgdsBaseParam();
|
}
|
QueryWrapper<PatrolConf> queryWrapper = new QueryWrapper<>();
|
if(StringUtils.isNotEmpty(param.getName())){
|
queryWrapper.like("name", param.getName());
|
}
|
if(StringUtils.isNotBlank(param.getDeptId())){
|
queryWrapper.like("dept_id", param.getDeptId());
|
}else {
|
if(StringUtils.isNotBlank(param.getCompanyId())){
|
queryWrapper.likeRight("dept_id", param.getCompanyId());
|
}
|
}
|
return patrolConfMapper.selectList(queryWrapper);
|
}
|
|
public BaseResp addPatrolConf(PatrolConf conf) {
|
conf.setId(ContextUtil.generateId());
|
conf.setCompanyId(ContextUtil.getCompanyId());
|
conf.setUpdateBy(ContextUtil.getLoginUserName());
|
conf.setUpdateTime(new Date());
|
conf.setCreateBy(ContextUtil.getLoginUserName());
|
conf.setCreateTime(new Date());
|
|
return patrolConfMapper.insert(conf) > 0 ? BaseResp.success() : BaseResp.error("添加失败");
|
}
|
|
public BaseResp updatePatrolConf(PatrolConf conf) {
|
conf.setUpdateBy(ContextUtil.getLoginUserName());
|
conf.setUpdateTime(new Date());
|
return patrolConfMapper.updateById(conf) > 0 ? BaseResp.success() : BaseResp.error("更新失败");
|
}
|
|
public BaseResp deletePatrolConf(PatrolConf conf) {
|
return patrolConfMapper.deleteById(conf) > 0 ? BaseResp.success() : BaseResp.error("删除失败");
|
}
|
|
|
}
|
