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.SnapRecord;
|
import com.fzzy.igds.mapper.SnapRecordMapper;
|
import com.fzzy.igds.utils.ContextUtil;
|
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 SnapRecordService {
|
|
@Resource
|
private SnapRecordMapper snapRecordMapper;
|
|
/**
|
* 分页查询数据
|
*
|
* @param page
|
* @param param
|
*/
|
public void listPage(Page<SnapRecord> page, IgdsBaseParam param) {
|
QueryWrapper<SnapRecord> queryWrapper = getQueryWrapper(param);
|
snapRecordMapper.selectPage(page, queryWrapper);
|
}
|
|
/**
|
* 封装查询条件
|
*
|
* @param param
|
*/
|
public QueryWrapper<SnapRecord> getQueryWrapper(IgdsBaseParam param) {
|
QueryWrapper<SnapRecord> 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.getDepotId())) {
|
queryWrapper.eq("depot_id", param.getDepotId());
|
}
|
//标签检索
|
if (StringUtils.isNotBlank(param.getKey())) {
|
queryWrapper.like("tags", param.getKey());
|
}
|
//抓拍时间检索
|
if (param.getStart() != null && param.getEnd() != null) {
|
queryWrapper.between("snap_time", param.getStart(), param.getEnd());
|
}
|
|
queryWrapper.orderByDesc("create_time");
|
|
return queryWrapper;
|
}
|
|
/**
|
* 查询所有数据
|
*
|
* @param param
|
* @author sgj
|
* @date 2025/12/10
|
*/
|
public List<SnapRecord> listAll(IgdsBaseParam param) {
|
|
if (null == param)
|
return snapRecordMapper.selectList(null);
|
|
QueryWrapper<SnapRecord> queryWrapper = new QueryWrapper<>();
|
if (StringUtils.isNotEmpty(param.getName())) {
|
queryWrapper.like("name", param.getName());
|
}
|
return snapRecordMapper.selectList(queryWrapper);
|
}
|
|
/**
|
* 新增数据
|
*
|
* @param snapRecord
|
* @author sgj
|
* @date 2025/12/10
|
*/
|
public BaseResp addData(SnapRecord snapRecord) {
|
snapRecord.setId(ContextUtil.generateId());
|
snapRecord.setCompanyId(ContextUtil.getCompanyId());
|
snapRecord.setUpdateBy(ContextUtil.getLoginUserName());
|
snapRecord.setUpdateTime(new Date());
|
snapRecord.setCreateBy(ContextUtil.getLoginUserName());
|
snapRecord.setCreateTime(new Date());
|
return snapRecordMapper.insert(snapRecord) > 0 ? BaseResp.success() : BaseResp.error("添加失败");
|
}
|
|
/**
|
* 更新数据
|
*
|
* @param snapRecord
|
* @author sgj
|
* @date 2025/12/10
|
*/
|
public BaseResp updateData(SnapRecord snapRecord) {
|
snapRecord.setUpdateBy(ContextUtil.getLoginUserName());
|
snapRecord.setUpdateTime(new Date());
|
return snapRecordMapper.updateById(snapRecord) > 0 ? BaseResp.success() : BaseResp.error("更新失败");
|
}
|
|
/**
|
* 删除数据
|
*
|
* @param snapRecord
|
* @author sgj
|
* @date 2025/12/10
|
*/
|
public BaseResp deleteData(SnapRecord snapRecord) {
|
return snapRecordMapper.deleteById(snapRecord) > 0 ? BaseResp.success() : BaseResp.error("删除失败");
|
}
|
|
}
|
