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.InstrumentMapper;
|
import com.ruoyi.lims.pojo.Instrument;
|
import com.ruoyi.lims.service.InstrumentService;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
@Transactional(rollbackFor = Exception.class)
|
public class InstrumentServiceImpl extends ServiceImpl<InstrumentMapper, Instrument> implements InstrumentService {
|
|
@Override
|
public IPage<Instrument> listPage(Page<Instrument> page, Instrument query) {
|
QueryWrapper<Instrument> wrapper = new QueryWrapper<>();
|
if (query != null) {
|
wrapper.like(StringUtils.isNotEmpty(query.getInstrumentCode()), "instrument_code", query.getInstrumentCode());
|
wrapper.like(StringUtils.isNotEmpty(query.getInstrumentName()), "instrument_name", query.getInstrumentName());
|
wrapper.like(StringUtils.isNotEmpty(query.getInstrumentModel()), "instrument_model", query.getInstrumentModel());
|
wrapper.like(StringUtils.isNotEmpty(query.getManufacturer()), "manufacturer", query.getManufacturer());
|
wrapper.like(StringUtils.isNotEmpty(query.getSerialNo()), "serial_no", query.getSerialNo());
|
wrapper.like(StringUtils.isNotEmpty(query.getLocation()), "location", query.getLocation());
|
wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus());
|
wrapper.like(StringUtils.isNotEmpty(query.getResponsiblePerson()), "responsible_person", query.getResponsiblePerson());
|
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);
|
}
|
}
|