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