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);
|
|
/**
|
* 一组id递归所有子节点
|
*/
|
List<String> recursionChildrenByList(@Param("productionIds") List<String> productionIds);
|
|
/**
|
* 根据用户id和车间id获取用户拥有的车间id
|
* @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);
|
}
|
