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.InstrumentCalibrationMapper; import com.ruoyi.lims.pojo.InstrumentCalibration; import com.ruoyi.lims.service.InstrumentCalibrationService; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; @Service @Transactional(rollbackFor = Exception.class) public class InstrumentCalibrationServiceImpl extends ServiceImpl implements InstrumentCalibrationService { @Override public IPage listPage(Page page, InstrumentCalibration query) { QueryWrapper wrapper = new QueryWrapper<>(); if (query != null) { // ID filters if (query.getInstrumentId() != null) { wrapper.eq("instrument_id", query.getInstrumentId()); } 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.getRecordType()), "record_type", query.getRecordType()); wrapper.like(StringUtils.isNotEmpty(query.getCalibrationOrg()), "calibration_org", query.getCalibrationOrg()); wrapper.like(StringUtils.isNotEmpty(query.getCertificateNo()), "certificate_no", query.getCertificateNo()); wrapper.like(StringUtils.isNotEmpty(query.getCalibrationResult()), "calibration_result", query.getCalibrationResult()); wrapper.like(StringUtils.isNotEmpty(query.getExecutor()), "executor", query.getExecutor()); wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark()); } wrapper.orderByDesc("id"); return baseMapper.selectPage(page, wrapper); } }