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.ReagentMapper;
|
import com.ruoyi.lims.pojo.Reagent;
|
import com.ruoyi.lims.service.ReagentService;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
@Transactional(rollbackFor = Exception.class)
|
public class ReagentServiceImpl extends ServiceImpl<ReagentMapper, Reagent> implements ReagentService {
|
|
@Override
|
public IPage<Reagent> listPage(Page<Reagent> page, Reagent query) {
|
QueryWrapper<Reagent> wrapper = new QueryWrapper<>();
|
if (query != null) {
|
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.getSpecification()), "specification", query.getSpecification());
|
wrapper.like(StringUtils.isNotEmpty(query.getCategory()), "category", query.getCategory());
|
wrapper.like(StringUtils.isNotEmpty(query.getUnit()), "unit", query.getUnit());
|
wrapper.like(StringUtils.isNotEmpty(query.getSupplier()), "supplier", query.getSupplier());
|
wrapper.like(StringUtils.isNotEmpty(query.getStorageCondition()), "storage_condition", query.getStorageCondition());
|
wrapper.like(StringUtils.isNotEmpty(query.getLocation()), "location", query.getLocation());
|
wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus());
|
wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark());
|
wrapper.like(StringUtils.isNotEmpty(query.getMaintainer()), "maintainer", query.getMaintainer());
|
}
|
wrapper.orderByDesc("id");
|
return baseMapper.selectPage(page, wrapper);
|
}
|
}
|