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
|
@Service
|
public class PatrolService {
|
|
@Resource
|
private PatrolMapper patrolMapper;
|
|
public List<Patrol> selectList(Patrol param) {
|
QueryWrapper<Patrol> queryWrapper = getQueryWrapper(param);
|
return patrolMapper.selectList(queryWrapper);
|
}
|
|
/**
|
* 封装查询条件
|
*
|
* @param param
|
*/
|
public QueryWrapper<Patrol> getQueryWrapper(Patrol param) {
|
QueryWrapper<Patrol> 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.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);
|
}
|
|
/**
|
* 通过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);
|
}
|
}
|
