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.ExperimentResourceMapper; import com.ruoyi.lims.pojo.ExperimentResource; import com.ruoyi.lims.service.ExperimentResourceService; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; @Service @Transactional(rollbackFor = Exception.class) public class ExperimentResourceServiceImpl extends ServiceImpl implements ExperimentResourceService { @Override public IPage listPage(Page page, ExperimentResource query) { QueryWrapper wrapper = new QueryWrapper<>(); if (query != null) { // ID filters if (query.getExperimentId() != null) { wrapper.eq("experiment_id", query.getExperimentId()); } wrapper.like(StringUtils.isNotEmpty(query.getExperimentCode()), "experiment_code", query.getExperimentCode()); wrapper.like(StringUtils.isNotEmpty(query.getResourceType()), "resource_type", query.getResourceType()); wrapper.like(StringUtils.isNotEmpty(query.getResourceCode()), "resource_code", query.getResourceCode()); wrapper.like(StringUtils.isNotEmpty(query.getResourceName()), "resource_name", query.getResourceName()); wrapper.like(StringUtils.isNotEmpty(query.getUnit()), "unit", query.getUnit()); wrapper.like(StringUtils.isNotEmpty(query.getUsageTime()), "usage_time", query.getUsageTime()); wrapper.like(StringUtils.isNotEmpty(query.getStatus()), "status", query.getStatus()); wrapper.like(StringUtils.isNotEmpty(query.getRemark()), "remark", query.getRemark()); } wrapper.orderByDesc("id"); return baseMapper.selectPage(page, wrapper); } @Override public java.util.List listByExperimentOrSample(ExperimentResource query) { QueryWrapper w = new QueryWrapper<>(); if (query != null && query.getExperimentId() != null) { w.eq("experiment_id", query.getExperimentId()); } w.orderByAsc("id"); return baseMapper.selectList(w); } }