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