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.SampleStockRecordMapper; import com.ruoyi.lims.pojo.SampleStockRecord; import com.ruoyi.lims.service.SampleStockRecordService; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; @Service @Transactional(rollbackFor = Exception.class) public class SampleStockRecordServiceImpl extends ServiceImpl implements SampleStockRecordService { @Override public IPage listPage(Page page, SampleStockRecord query) { QueryWrapper wrapper = new QueryWrapper<>(); if (query != null) { // ID filters if (query.getSampleId() != null) { wrapper.eq("sample_id", query.getSampleId()); } wrapper.like(StringUtils.isNotEmpty(query.getSampleCode()), "sample_code", query.getSampleCode()); wrapper.like(StringUtils.isNotEmpty(query.getSampleName()), "sample_name", query.getSampleName()); wrapper.like(StringUtils.isNotEmpty(query.getRecordType()), "record_type", query.getRecordType()); wrapper.like(StringUtils.isNotEmpty(query.getUnit()), "unit", query.getUnit()); wrapper.like(StringUtils.isNotEmpty(query.getBeforeStatus()), "before_status", query.getBeforeStatus()); wrapper.like(StringUtils.isNotEmpty(query.getAfterStatus()), "after_status", query.getAfterStatus()); wrapper.like(StringUtils.isNotEmpty(query.getFromLocation()), "from_location", query.getFromLocation()); wrapper.like(StringUtils.isNotEmpty(query.getToLocation()), "to_location", query.getToLocation()); wrapper.like(StringUtils.isNotEmpty(query.getOperator()), "operator", query.getOperator()); wrapper.like(StringUtils.isNotEmpty(query.getRecipient()), "recipient", query.getRecipient()); wrapper.like(StringUtils.isNotEmpty(query.getPurpose()), "purpose", query.getPurpose()); wrapper.like(StringUtils.isNotEmpty(query.getRelatedExperiment()), "related_experiment", query.getRelatedExperiment()); wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark()); } wrapper.orderByDesc("id"); return baseMapper.selectPage(page, wrapper); } @Override public java.util.List listByExperimentOrSample(SampleStockRecord query) { QueryWrapper w = new QueryWrapper<>(); if (query != null && query.getSampleId() != null) { w.eq("sample_id", query.getSampleId()); } w.orderByDesc("id"); return baseMapper.selectList(w); } }