| | |
| | | import com.fzzy.igds.domain.SnapRecord; |
| | | import com.fzzy.igds.mapper.SnapRecordMapper; |
| | | 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; |
| | |
| | | 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()); |
| | | queryWrapper.likeRight("dept_id", param.getKey()); |
| | | } |
| | | //抓拍时间检索 |
| | | if (param.getStart() != null && param.getEnd() != null) { |
| | | queryWrapper.between("snap_time", param.getStart(), param.getEnd()); |
| | | if (null != param.getStart()) { |
| | | queryWrapper.ge("snap_time",param.getStart()); |
| | | } |
| | | if (null != param.getEnd()) { |
| | | queryWrapper.le("snap_time", param.getEnd()); |
| | | } |
| | | //标签检索 |
| | | if (StringUtils.isNotBlank(param.getName())) { |
| | | queryWrapper.like("tags", param.getName()); |
| | | } |
| | | |
| | | queryWrapper.orderByDesc("create_time"); |
| | |
| | | * @author sgj |
| | | * @date 2025/12/10 |
| | | */ |
| | | public List<SnapRecord> listAll(IgdsBaseParam param) { |
| | | |
| | | if (null == param) |
| | | return snapRecordMapper.selectList(null); |
| | | public List<SnapRecord> getListByParam(IgdsBaseParam param) { |
| | | if (null == param){ |
| | | param = new IgdsBaseParam(); |
| | | } |
| | | |
| | | QueryWrapper<SnapRecord> queryWrapper = new QueryWrapper<>(); |
| | | if (StringUtils.isNotEmpty(param.getName())) { |
| | | queryWrapper.like("name", param.getName()); |
| | | if (StringUtils.isNotBlank(param.getDeptId())) { |
| | | queryWrapper.likeRight("dept_id", param.getDeptId()); |
| | | } |
| | | if (null != param.getStart()) { |
| | | queryWrapper.ge("snap_time", DateUtil.getCurZero(param.getStart())); |
| | | } |
| | | if (null != param.getEnd()) { |
| | | queryWrapper.le("snap_time", DateUtil.getNextZero(param.getEnd())); |
| | | } |
| | | queryWrapper.orderByDesc("snap_time"); |
| | | 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()); |
| | | public void addData(SnapRecord snapRecord) { |
| | | if(StringUtils.isBlank(snapRecord.getId())){ |
| | | snapRecord.setId(ContextUtil.generateId()); |
| | | } |
| | | if(StringUtils.isBlank(snapRecord.getCompanyId())){ |
| | | 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("添加失败"); |
| | | snapRecordMapper.insert(snapRecord); |
| | | } |
| | | |
| | | /** |