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 getWeekList() { Date end = new Date(); Date start = DateUtil.getNewByDay(end, -6); QueryWrapper 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 page, IgdsBaseParam param) { QueryWrapper 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 getRecordByPatrolId(String patrolId,String userId,String confId) { if(StringUtils.isBlank(patrolId)){ return null; } QueryWrapper 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 getRecordByPatrolId(Map param) { String patrolId = param.get("patrolId"); if (StringUtils.isBlank(patrolId)) { return null; } String userName = param.get("name"); QueryWrapper 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 listPatrolConf(IgdsBaseParam param) { if(null == param){ param = new IgdsBaseParam(); } QueryWrapper 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("删除失败"); } }