| | |
| | | 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.Patrol; |
| | | import com.fzzy.igds.mapper.PatrolMapper; |
| | | import com.fzzy.igds.utils.ContextUtil; |
| | | import com.fzzy.igds.utils.DateUtil; |
| | | import com.ruoyi.common.core.text.Convert; |
| | | 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 |
| | |
| | | if (StringUtils.isNotBlank(param.getDeptId())) { |
| | | queryWrapper.eq("dept_id", param.getDeptId()); |
| | | } |
| | | |
| | | if (StringUtils.isNotBlank(param.getUserName())) { |
| | | queryWrapper.like("user_name", param.getUserName()); |
| | | } |
| | | if (StringUtils.isNotBlank(param.getConfName())) { |
| | | queryWrapper.like("conf_name", param.getConfName()); |
| | | } |
| | | |
| | | queryWrapper.orderByDesc("create_time"); |
| | | |
| | | return queryWrapper; |
| | | } |
| | | |
| | | /** |
| | | * 通过id查询单条数据 |
| | | * |
| | | * @param id |
| | | * @author sgj |
| | | * @date 2025/12/10 |
| | | */ |
| | | public Patrol selectById(String id) { |
| | | return patrolMapper.selectById(id); |
| | | } |
| | | |
| | | /** |
| | | * 新增数据 |
| | | * |
| | | * @param param |
| | | * @author sgj |
| | | * @date 2025/12/10 |
| | | */ |
| | | public int insertData(Patrol param) { |
| | | if (StringUtils.isEmpty(param.getId())) { |
| | | param.setId(ContextUtil.generateId()); |
| | |
| | | return patrolMapper.insert(param); |
| | | } |
| | | |
| | | /** |
| | | * 更新数据 |
| | | * |
| | | * @param param |
| | | * @author sgj |
| | | * @date 2025/12/10 |
| | | */ |
| | | public int updateData(Patrol param) { |
| | | return patrolMapper.updateById(param); |
| | | } |
| | | |
| | | public void deleteDataById( String ids) { |
| | | /** |
| | | * 通过id删除一条数据 |
| | | * |
| | | * @param ids |
| | | * @author sgj |
| | | * @date 2025/12/10 |
| | | */ |
| | | public void deleteDataById(String ids) { |
| | | String[] recordIds = Convert.toStrArray(ids); |
| | | for (String recordId : recordIds) { |
| | | patrolMapper.deleteById(recordId); |
| | | } |
| | | } |
| | | |
| | | /** |
| | | * 查询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); |
| | | } |
| | | } |