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 implements InstrumentService { @Override public IPage listPage(Page page, Instrument query) { QueryWrapper 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); } }