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.ReagentRecordMapper;
|
import com.ruoyi.lims.pojo.ReagentRecord;
|
import com.ruoyi.lims.service.ReagentRecordService;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
@Transactional(rollbackFor = Exception.class)
|
public class ReagentRecordServiceImpl extends ServiceImpl<ReagentRecordMapper, ReagentRecord> implements ReagentRecordService {
|
|
@Override
|
public IPage<ReagentRecord> listPage(Page<ReagentRecord> page, ReagentRecord query) {
|
QueryWrapper<ReagentRecord> wrapper = new QueryWrapper<>();
|
if (query != null) {
|
// ID filters
|
if (query.getReagentId() != null) { wrapper.eq("reagent_id", query.getReagentId()); }
|
wrapper.like(StringUtils.isNotEmpty(query.getReagentCode()), "reagent_code", query.getReagentCode());
|
wrapper.like(StringUtils.isNotEmpty(query.getReagentName()), "reagent_name", query.getReagentName());
|
wrapper.like(StringUtils.isNotEmpty(query.getRecordType()), "record_type", query.getRecordType());
|
wrapper.like(StringUtils.isNotEmpty(query.getBatchNo()), "batch_no", query.getBatchNo());
|
wrapper.like(StringUtils.isNotEmpty(query.getSupplier()), "supplier", query.getSupplier());
|
wrapper.like(StringUtils.isNotEmpty(query.getOperator()), "operator", query.getOperator());
|
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);
|
}
|
}
|