package com.fzzy.igds.service;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.fzzy.igds.domain.Patrol;
|
import com.fzzy.igds.mapper.PatrolMapper;
|
import com.fzzy.igds.utils.ContextUtil;
|
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.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);
|
}
|
}
|
|
}
|
