package com.yuanchu.mom.mapper;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.yuanchu.mom.dto.InsOrderPlanDTO;
|
import com.yuanchu.mom.dto.SampleProductDto;
|
import com.yuanchu.mom.dto.SampleProductDto3;
|
import com.yuanchu.mom.pojo.InsProduct;
|
import com.yuanchu.mom.pojo.InsSample;
|
import com.yuanchu.mom.vo.InsOrderPlanTaskSwitchVo;
|
import com.yuanchu.mom.vo.InsOrderPlanVO;
|
import com.yuanchu.mom.vo.SampleVo;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author Administrator
|
* @description 针对表【ins_sample(检验样品)】的数据库操作Mapper
|
* @createDate 2024-03-14 17:14:57
|
* @Entity com.yuanchu.mom.pojo.InsSample
|
*/
|
public interface InsSampleMapper extends BaseMapper<InsSample> {
|
|
IPage<InsOrderPlanVO> findInsSampleAndOrder(Page page, @Param("ew") QueryWrapper<InsOrderPlanDTO> ew, @Param("userName") String userName, @Param("sonLaboratory") String sonLaboratory, @Param("laboratory") String laboratory);
|
|
IPage<InsOrderPlanTaskSwitchVo> inspectionOrderDetailsTaskSwitching(Page page, @Param("ew") QueryWrapper<InsOrderPlanDTO> ew, @Param("userId") Integer userId, @Param("sonLaboratory") String sonLaboratory, @Param("laboratory") String laboratory);
|
|
SampleProductDto selectSampleProductListByOrderId(Integer id);
|
|
List<SampleProductDto> selectSampleProductListByOrderId2(Integer id);
|
List<SampleProductDto> selectSampleProductListByOrder2Id2(Integer id);
|
|
List<SampleProductDto3> selectSampleProductListByOrderId3(List<Integer> ids);
|
|
SampleProductDto getInsOrderAndSample(Integer sampleId, String laboratory);
|
SampleProductDto getInsOrderAndSample2(Integer sampleId, String laboratory);
|
|
String getSampleEn(String sample);
|
|
List<InsProduct> getInsProduct1(@Param("id") Integer id, @Param("laboratory") String laboratory);
|
List<InsProduct> getIns2Product1(@Param("id") Integer id, @Param("laboratory") String laboratory);
|
List<InsProduct> get2InsProduct1(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("num") Integer num);
|
|
List<Map<String, Object>> getReportModel(@Param("orderId") Integer orderId, @Param("id") Integer id, @Param("laboratory") String laboratory);
|
|
SampleVo getDetailById(Integer sampleId);
|
|
String selMethodById(Integer sampleId);
|
|
List<Map<String, String>> selectSampleList(Integer orderId);
|
|
//过滤掉没有检验项目的样品
|
List<InsSample> selectSampleListByOrderId(Integer orderId);
|
|
List<InsSample> selectInsSample(@Param("ids") List<Integer> ids);
|
|
//查询且过滤出有电路试验的样品
|
List<InsSample> selectSample(Integer insOrderId);
|
|
}
|
