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);
|
|
}
|
