From 4f3a98f19143865cdc1de4791e8a95d96bd40c65 Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期五, 01 八月 2025 13:27:59 +0800
Subject: [PATCH] yys 密码已重置

---
 inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsSampleMapper.java |  137 +++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 137 insertions(+), 0 deletions(-)

diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsSampleMapper.java b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsSampleMapper.java
new file mode 100644
index 0000000..0b1fb82
--- /dev/null
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsSampleMapper.java
@@ -0,0 +1,137 @@
+package com.ruoyi.inspect.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.ruoyi.inspect.dto.InsOrderPlanDTO;
+import com.ruoyi.inspect.dto.SampleProductDto;
+import com.ruoyi.inspect.pojo.InsProduct;
+import com.ruoyi.inspect.pojo.InsSample;
+import com.ruoyi.inspect.vo.InsOrderPlanTaskSwitchVo;
+import com.ruoyi.inspect.vo.InsOrderPlanVO;
+import com.ruoyi.inspect.vo.SampleVo;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+import java.util.Map;
+
+/**
+* @author Administrator
+* @description 閽堝琛ㄣ�恑ns_sample(妫�楠屾牱鍝�)銆戠殑鏁版嵁搴撴搷浣淢apper
+* @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("userId") Integer userId,
+                                                @Param("sonLaboratory") String sonLaboratory,
+                                                @Param("laboratory") String laboratory,
+                                                @Param("isCheck") Integer isCheck);
+
+    IPage<InsOrderPlanTaskSwitchVo> inspectionOrderDetailsTaskSwitching(Page page, @Param("ew") QueryWrapper<InsOrderPlanDTO> ew, @Param("userId") Integer userId, @Param("sonLaboratory") String sonLaboratory, @Param("laboratory") String laboratory);
+
+    List<SampleProductDto> selectSampleProductListByOrderId(@Param("id") Integer id);
+
+    List<SampleProductDto> selectSampleProductListByOrderId2(@Param("id") Integer id);
+
+    Map<String,Object> selectInsOrder(@Param("id") Integer id);
+
+    List<SampleProductDto> getInsOrderAndSample(@Param("id") Integer id, @Param("laboratory") String laboratory);
+
+    String getSampleEn(@Param("sample") String sample);
+
+    /**
+     * 鍙兘娌℃湁浜у搧鐩存帴灏辨槸瀵硅薄
+     * @param sample
+     * @return
+     */
+    String getSampleEnByObject(@Param("sample") String sample);
+
+    /**
+     * 鏍峰搧
+     * @param id
+     * @param laboratory
+     * @return
+     */
+    List<InsProduct> getInsProduct1(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("cableTag") String cableTag, @Param("repetitionTag") String repetitionTag);
+
+
+    /**
+     * 鍘熸潗鏂�
+     * @param id
+     * @param laboratory
+     * @param rawMaterialTag
+     * @return
+     */
+    List<InsProduct> getInsProduct6(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("rawMaterialTag") String rawMaterialTag);
+
+    SampleVo getDetailById(@Param("sampleId") Integer sampleId);
+
+    String selMethodById(@Param("sampleId") Integer sampleId);
+
+    /**
+     * 鐢电紗閰嶇疆鏌ョ湅閰嶇疆鏍囪瘑
+     * @param id
+     * @param laboratory
+     * @return
+     */
+    List<Map<String, Object>> getCableTag(@Param("id") Integer id, @Param("laboratory") String laboratory);
+
+    /**
+     * 鍘熸潗鏂欐煡鐪嬮厤缃爣璇�
+     * @param id
+     * @param laboratory
+     * @return
+     */
+    List<Map<String, Object>> getRawMaterialTag(@Param("id") Integer id, @Param("laboratory") String laboratory);
+
+    /**
+     * 鏌ョ湅閲嶅鏍囪瘑
+     * @param id
+     * @param laboratory
+     * @return
+     */
+    List<Map<String, Object>> getRepetitionTag(@Param("id") Integer id, @Param("laboratory") String laboratory, @Param("cableTag") String cableTag);
+
+
+    List<SampleProductDto> selectExemptionByOrderId(@Param("id") Integer id);
+
+    /**
+     * 鏌ヨ鍘傚瀵嗗害(鏈夊瀷鍙�)
+     * @param sample
+     * @param production
+     * @return
+     */
+    String selectSupplierDensityModel(@Param("sample") String sample, @Param("production") String production, @Param("model") String model);
+
+    /**
+     * 鏌ヨ鍘傚瀵嗗害(娌″瀷鍙�)
+     * @param sample
+     * @param production
+     * @return
+     */
+    String selectSupplierDensity(@Param("sample") String sample, @Param("production") String production);
+
+
+    /**
+     * 鏌ヨ妫�楠岄」妫�楠岀粨鏋�
+     * @param itemIds
+     * @return
+     */
+    List<InsProduct> selectProductResult(@Param("itemIds") List<Integer> itemIds);
+
+    /**
+     * 鏍规嵁璁㈠崟id鏌ヨ鏍峰搧
+     * @param insOrderId
+     * @return
+     */
+    List<InsSample> getSampleByOrderId(Integer insOrderId);
+}
+
+
+
+

--
Gitblit v1.9.3