package org.jeecg.modules.activiti.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.common.base.entity.ActNode;
import org.jeecg.common.base.entity.Department;
import org.jeecg.common.base.entity.Role;
import org.jeecg.common.system.vo.LoginUser;

import java.util.List;

/**
 * @Description: 流程节点扩展表
 * @Author: jeecg-boot
 * @Date:   2020-03-30
 * @Version: V1.0
 */
public interface ActNodeMapper extends BaseMapper<ActNode> {

    List<LoginUser> findUserByNodeId(@Param("nodeId") String nodeId,@Param("procDefId") String procDefId);

    List<Role> findRoleByNodeId(@Param("nodeId") String nodeId, @Param("procDefId") String procDefId);

    List<Department> findDepartmentByNodeId(@Param("nodeId") String nodeId, @Param("procDefId") String procDefId);

    List<Department> findDepartmentManageByNodeId(@Param("nodeId") String nodeId,@Param("procDefId") String procDefId);

    List<String> findFormVariableByNodeId(@Param("nodeId") String nodeId,@Param("procDefId") String procDefId);

    @Select("select role_code from sys_role where id in (select role_id from sys_user_role where user_id = (select id from sys_user where username=#{username}))")
    List<String> getRoleByUserName(@Param("username") String username);
    @Select("select * from sys_user")
    List<LoginUser> queryAllUser();
    @Select("select * from sys_user where id in (select user_id from sys_user_role where role_id = #{id})")
    List<LoginUser> findUserByRoleId(@Param("id") String id);
    @Select("select * from sys_user where id in (select user_id from sys_user_depart where dep_id = #{id})")
    List<LoginUser> findUserDepartmentId(@Param("id") String id);
    @Select("select * from sys_user where FIND_IN_SET(#{id},depart_ids)")
    List<LoginUser> findUserDepartmentManageId(@Param("id") String id);
    @Select("select * from act_z_node where node_id = #{nodeId}")
    List<ActNode> findByNodeId(@Param("nodeId") String nodeId);

}