package com.ruoyi.lims.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.ruoyi.common.utils.StringUtils;
|
import com.ruoyi.lims.mapper.ExperimentResourceMapper;
|
import com.ruoyi.lims.pojo.ExperimentResource;
|
import com.ruoyi.lims.service.ExperimentResourceService;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
@Transactional(rollbackFor = Exception.class)
|
public class ExperimentResourceServiceImpl extends ServiceImpl<ExperimentResourceMapper, ExperimentResource> implements ExperimentResourceService {
|
|
@Override
|
public IPage<ExperimentResource> listPage(Page<ExperimentResource> page, ExperimentResource query) {
|
QueryWrapper<ExperimentResource> wrapper = new QueryWrapper<>();
|
if (query != null) {
|
// ID filters
|
if (query.getExperimentId() != null) { wrapper.eq("experiment_id", query.getExperimentId()); }
|
wrapper.like(StringUtils.isNotEmpty(query.getExperimentCode()), "experiment_code", query.getExperimentCode());
|
wrapper.like(StringUtils.isNotEmpty(query.getResourceType()), "resource_type", query.getResourceType());
|
wrapper.like(StringUtils.isNotEmpty(query.getResourceCode()), "resource_code", query.getResourceCode());
|
wrapper.like(StringUtils.isNotEmpty(query.getResourceName()), "resource_name", query.getResourceName());
|
wrapper.like(StringUtils.isNotEmpty(query.getUnit()), "unit", query.getUnit());
|
wrapper.like(StringUtils.isNotEmpty(query.getUsageTime()), "usage_time", query.getUsageTime());
|
wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus());
|
wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
|
}
|
wrapper.orderByDesc("id");
|
return baseMapper.selectPage(page, wrapper);
|
}
|
|
@Override
|
public java.util.List<ExperimentResource> listByExperimentOrSample(ExperimentResource query) {
|
QueryWrapper<ExperimentResource> w = new QueryWrapper<>();
|
if (query != null && query.getExperimentId() != null) {
|
w.eq("experiment_id", query.getExperimentId());
|
}
|
w.orderByAsc("id");
|
return baseMapper.selectList(w);
|
}
|
}
|