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.SampleStockRecordMapper;
|
import com.ruoyi.lims.pojo.SampleStockRecord;
|
import com.ruoyi.lims.service.SampleStockRecordService;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
@Transactional(rollbackFor = Exception.class)
|
public class SampleStockRecordServiceImpl extends ServiceImpl<SampleStockRecordMapper, SampleStockRecord> implements SampleStockRecordService {
|
|
@Override
|
public IPage<SampleStockRecord> listPage(Page<SampleStockRecord> page, SampleStockRecord query) {
|
QueryWrapper<SampleStockRecord> wrapper = new QueryWrapper<>();
|
if (query != null) {
|
// ID filters
|
if (query.getSampleId() != null) { wrapper.eq("sample_id", query.getSampleId()); }
|
wrapper.like(StringUtils.isNotEmpty(query.getSampleCode()), "sample_code", query.getSampleCode());
|
wrapper.like(StringUtils.isNotEmpty(query.getSampleName()), "sample_name", query.getSampleName());
|
wrapper.like(StringUtils.isNotEmpty(query.getRecordType()), "record_type", query.getRecordType());
|
wrapper.like(StringUtils.isNotEmpty(query.getUnit()), "unit", query.getUnit());
|
wrapper.like(StringUtils.isNotEmpty(query.getBeforeStatus()), "before_status", query.getBeforeStatus());
|
wrapper.like(StringUtils.isNotEmpty(query.getAfterStatus()), "after_status", query.getAfterStatus());
|
wrapper.like(StringUtils.isNotEmpty(query.getFromLocation()), "from_location", query.getFromLocation());
|
wrapper.like(StringUtils.isNotEmpty(query.getToLocation()), "to_location", query.getToLocation());
|
wrapper.like(StringUtils.isNotEmpty(query.getOperator()), "operator", query.getOperator());
|
wrapper.like(StringUtils.isNotEmpty(query.getRecipient()), "recipient", query.getRecipient());
|
wrapper.like(StringUtils.isNotEmpty(query.getPurpose()), "purpose", query.getPurpose());
|
wrapper.like(StringUtils.isNotEmpty(query.getRelatedExperiment()), "related_experiment", query.getRelatedExperiment());
|
wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
|
}
|
wrapper.orderByDesc("id");
|
return baseMapper.selectPage(page, wrapper);
|
}
|
|
@Override
|
public java.util.List<SampleStockRecord> listByExperimentOrSample(SampleStockRecord query) {
|
QueryWrapper<SampleStockRecord> w = new QueryWrapper<>();
|
if (query != null && query.getSampleId() != null) {
|
w.eq("sample_id", query.getSampleId());
|
}
|
w.orderByDesc("id");
|
return baseMapper.selectList(w);
|
}
|
}
|