From 23855599412c4d61b38d78f0f3abd3430a48b5b1 Mon Sep 17 00:00:00 2001 From: zhangherong <571457620@qq.com> Date: 星期三, 25 六月 2025 11:51:38 +0800 Subject: [PATCH] Merge branch 'mdc_hyjs_master' --- lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/MdcProductionMapper.java | 68 ++++++++++++++++++++++++++++++++++ 1 files changed, 68 insertions(+), 0 deletions(-) diff --git a/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/MdcProductionMapper.java b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/MdcProductionMapper.java new file mode 100644 index 0000000..fe64c7a --- /dev/null +++ b/lxzn-module-system/lxzn-system-biz/src/main/java/org/jeecg/modules/system/mapper/MdcProductionMapper.java @@ -0,0 +1,68 @@ +package org.jeecg.modules.system.mapper; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; +import org.jeecg.modules.system.entity.MdcProduction; + +import java.util.List; + + +/** + * @Description: 浜х嚎琛� + * @Author: liuS + * @Date: 2023-03-23 + * @Version: V1.0 + */ +public interface MdcProductionMapper extends BaseMapper<MdcProduction> { + + /** + * 鏍规嵁id涓嬬骇浜х嚎 + */ + @Select("SELECT * FROM mdc_production where del_flag ='0' AND parent_id = #{parentId,jdbcType=VARCHAR}") + List<MdcProduction> queryProdByPid(@Param("parentId") String parentId); + + /** + * 閫掑綊鏌ヨ鎵�鏈夊瓙鑺傜偣 + */ + List<String> recursionChildren(@Param("productionId") String productionId); + + /** + * 涓�缁刬d閫掑綊鎵�鏈夊瓙鑺傜偣 + */ + List<String> recursionChildrenByList(@Param("productionIds") List<String> productionIds); + + /** + * 鏍规嵁鐢ㄦ埛id鍜岃溅闂磇d鑾峰彇鐢ㄦ埛鎷ユ湁鐨勮溅闂磇d + * @param userId + * @param productionId + * @return + */ + String findFirstProduction(@Param("userId") String userId, @Param("productionId") String productionId); + + /** + * 鏍规嵁鐢ㄦ埛id鏌ヨ鐢ㄦ埛宸ユ鏉冮檺 + * @param userId + * @return + */ + String findThreeProductionId(@Param("userId") String userId); + + /** + * 鏍规嵁鐢ㄦ埛id鏌ヨ鐢ㄦ埛鍏ㄩ儴杞﹂棿鏉冮檺 + * @param userId + * @return + */ + List<MdcProduction> findAllProductionId(@Param("userId") String userId); + + List<String> findChildren(@Param("mdcProductionIds") List<String> mdcProductionIds); + + List<MdcProduction> loadProductionOptions(@Param("userId") String userId, @Param("productionId") String productionId); + + List<String> findTeamValue(@Param("userId") String userId, @Param("productionList") List<String> productionList); + + List<String> findProIdsByUId(@Param("userId") String userId, @Param("allProductionIds") List<String> allProductionIds); + + List<String> findChildByProId(@Param("productionId") String productionId); + + String findProName(@Param("equipmentId") String equipmentId); +} -- Gitblit v1.9.3