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/InsOrderMapper.java |  147 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 147 insertions(+), 0 deletions(-)

diff --git a/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderMapper.java b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderMapper.java
new file mode 100644
index 0000000..7c91fc1
--- /dev/null
+++ b/inspect-server/src/main/java/com/ruoyi/inspect/mapper/InsOrderMapper.java
@@ -0,0 +1,147 @@
+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.basic.pojo.StructureTestObject;
+import com.ruoyi.inspect.dto.SampleOrderDto;
+import com.ruoyi.inspect.dto.SampleProductDto2;
+import com.ruoyi.inspect.dto.SampleProductExportDto;
+import com.ruoyi.inspect.pojo.InsOrder;
+import com.ruoyi.inspect.vo.InsOrderPrintingVo;
+import com.ruoyi.inspect.vo.SampleDefectsFatherVo;
+import org.apache.ibatis.annotations.Param;
+
+import java.util.List;
+import java.util.Map;
+import java.util.Set;
+
+/**
+ * @author gaoaoy
+ * @description 閽堝琛ㄣ�恑ns_order(妫�楠屼笅鍗�)銆戠殑鏁版嵁搴撴搷浣淢apper
+ * @createDate 2024-03-12 16:17:55
+ * @Entity com.yuanchu.mom.pojo.InsOrder
+ */
+public interface InsOrderMapper extends BaseMapper<InsOrder> {
+
+    //鑾峰彇妫�楠屼笅鍗曟暟鎹�
+    IPage<SampleOrderDto> selectInsOrderPage(@Param("page") IPage<InsOrder> page, @Param("ew") QueryWrapper<SampleOrderDto> ew, @Param("laboratory") String laboratory, @Param("isOrderAll") String isOrderAll);
+
+
+    String getLaboratoryCode(@Param("name") String name);
+
+    IPage<SampleProductDto2> selectSampleAndProductByOrderId(@Param("page") IPage<SampleProductDto2> page, @Param("ew") QueryWrapper<SampleProductDto2> ew, @Param("id") Integer id);
+
+    List<Map<String, String>> selectDeviceList(@Param("managementNumbers") Set<String> managementNumbers);
+    List<SampleDefectsFatherVo> selectSampleDefects(Page page, @Param("inspectionItems") String inspectionItems, @Param("orderNumber") String orderNumber);
+
+    String getStandardMethodCode(@Param("id") Integer id);
+
+    int updateStatus(@Param("id") Integer id);
+
+    String selLaboratoryCode(@Param("laboratory") String laboratory);
+
+    List<Map<Integer, Object>> selectReportModelByOrderId(@Param("id") Integer id, @Param("laboratory") String laboratory);
+
+    String seldepLimsId(@Param("depLimsId") Integer depLimsId);
+
+    /**
+     * 鏌ヨ妫�楠岀粨鏋�
+     * @param ids
+     * @return
+     */
+    List<SampleProductExportDto> selectSampleBySampleId(@Param("ids") List<Integer> ids);
+
+    /**
+     * 鑾峰彇鎵归噺妫�楠岀殑鎬绘暟
+     * @param id
+     * @return
+     */
+    int selectSampleMax(@Param("id") Integer id);
+
+    /**
+     * 鑾峰彇绾胯姱棰滆壊
+     * @param id
+     * @return
+     */
+    List<String> selectSampleCableTag(@Param("id") Integer id);
+
+    /**
+     *
+     * @param orderId
+     * @return
+     */
+    int selectSampleItemS(@Param("orderId") Integer orderId);
+
+    /**
+     * 鍙煡璇㈤粯璁ょ涓�涓殑浜у搧
+     * @param id
+     * @return
+     */
+    List<SampleProductExportDto> selectSampleBySampleIdOne(@Param("id") Integer id);
+
+    /**
+     * 鏌ヨ鏃ュ巻鍥�
+     * @param
+     * @return
+     */
+    List<Map<String, Object>> selectCalendarWorkByWeek(@Param("day") Integer day);
+
+    /**
+     *
+     * @param partNo
+     * @return
+     */
+    StructureTestObject selectProductByPartNo(@Param("partNo") String partNo);
+
+    /**
+     *
+     * @param partNo
+     * @return
+     */
+    StructureTestObject selectByPartNo(@Param("partNo") String partNo);
+
+    /**
+     * 鎴愬搧鏍囩鎵撳嵃
+     * @param ids
+     * @return
+     */
+    List<InsOrderPrintingVo> labelOrderPrinting(@Param("ids") List<Integer> ids);
+
+    /**
+     * 鏌ヨ瀵煎嚭淇℃伅
+     * @return
+     */
+    List<SampleOrderDto> rawAllInsOrderExport(@Param("ew") QueryWrapper<SampleOrderDto> ew, @Param("laboratory") String laboratory, @Param("isOrderAll") String isOrderAll);
+
+    /**
+     * 鏍规嵁璁㈠崟鏌ヨ璇曢獙瀹�
+     * @param insOrderId
+     * @return
+     */
+    String selectLaboratoryByOrderId(@Param("insOrderId") Integer insOrderId);
+
+    /**
+     * 鏌ヨ璁㈠崟淇℃伅
+     * @param insSampleId
+     * @return
+     */
+    InsOrder selectFirstSubmit(@Param("insSampleId") Integer insSampleId);
+
+    /**
+     * 鏍规嵁璁㈠崟id鏌ヨ璁㈠崟瀵煎嚭淇℃伅
+     * @param orderIds
+     * @return
+     */
+    List<SampleOrderDto> getInsOrderExportByIds(@Param("orderIds") List<String> orderIds);
+
+    /**
+     * 鏌ヨ褰撳墠鏃堕棿鏄惁鏈夎妫�娴嬮」鐨勬娊鏍疯鍒掕鍗�
+     * @param itmeId    鏍峰搧Id
+     * @param startTime 寮�濮嬫椂闂�
+     * @param endTime   缁撴潫鏃堕棿
+     * @return
+     */
+    Integer selectNotSpotCheckOrder(@Param("itmeId") Integer itmeId, @Param("startTime") String startTime, @Param("endTime") String endTime);
+}

--
Gitblit v1.9.3