package org.jeecg.modules.eam.base.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.eam.base.entity.EamBaseRepairDepart;

import java.util.List;

/**
 * @Author: Lius
 * @CreateTime: 2025-07-01
 * @Description:
 */
public interface EamBaseRepairDepartMapper extends BaseMapper<EamBaseRepairDepart> {

    /**
     * 根据id下级维修部门班组
     */
    @Select("SELECT * FROM sys_maintain_depart where del_flag ='0' AND parent_id = #{parentId,jdbcType=VARCHAR}")
    List<EamBaseRepairDepart> queryRepDepByPid(@Param("parentId") String parentId);

    /**
     * 递归查询所有子节点
     */
    List<String> recursionChildren(@Param("maintainId") String maintainId);

    /**
     * 根据用户id和车间id获取用户拥有的车间id
     *
     * @param userId
     * @param maintainId
     * @return
     */
    String findFirstMaintain(@Param("userId") String userId, @Param("maintainId") String maintainId);

    /**
     * 根据用户id查询用户维修部门班组权限
     *
     * @param userId
     * @return
     */
    String findThreeMaintainId(@Param("userId") String userId);

    EamBaseRepairDepart findMaintainList(@Param("equipmentId") String equipmentId);

}