Examples with NodeUserRole mom.trd.opentheso.bdd.helper.nodes.NodeUserRole used on opensource projects

Example 1 with NodeUserRole

use of mom.trd.opentheso.bdd.helper.nodes.NodeUserRole in project opentheso by miledrousset.

the class UserHelper2 method getListOfSuperAdmin.

/**
 * cette fonction permet de retourner les utilisateurs avec role SuperAdmin
 *
 * @param ds
 * @return
 */
public ArrayList<NodeUserRole> getListOfSuperAdmin(HikariDataSource ds) {
    ArrayList<NodeUserRole> nodeUserRoles = null;
    Connection conn;
    Statement stmt;
    ResultSet resultSet;
    try {
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "SELECT " + "  users.id_user," + "  users.username," + " users.active" + " FROM " + "  users" + " WHERE" + "  users.issuperadmin = true" + " ORDER BY" + "  LOWER(users.username)";
                resultSet = stmt.executeQuery(query);
                nodeUserRoles = new ArrayList<>();
                while (resultSet.next()) {
                    NodeUserRole nodeUserRole = new NodeUserRole();
                    nodeUserRole.setIdUser(resultSet.getInt("id_user"));
                    nodeUserRole.setUserName(resultSet.getString("username"));
                    nodeUserRole.setIdRole(1);
                    nodeUserRole.setRoleName("SuperAdmin");
                    nodeUserRole.setIsActive(resultSet.getBoolean("active"));
                    nodeUserRoles.add(nodeUserRole);
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException ex) {
        Logger.getLogger(UserHelper2.class.getName()).log(Level.SEVERE, null, ex);
    }
    return nodeUserRoles;
}

Example 2 with NodeUserRole

use of mom.trd.opentheso.bdd.helper.nodes.NodeUserRole in project opentheso by miledrousset.

the class UserHelper2 method getUsersRolesByGroup.

/**
 * cette fonction permet de retourner la liste des utilisateurs pour un
 * groupe avec un role égale ou inférieur au role de l'utilisateur en cours
 *
 * @param ds
 * @param idGroup
 * @param idRole
 * @return
 */
public ArrayList<NodeUserRole> getUsersRolesByGroup(HikariDataSource ds, int idGroup, int idRole) {
    ArrayList<NodeUserRole> listUser = new ArrayList<>();
    Connection conn;
    Statement stmt;
    ResultSet resultSet;
    try {
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "SELECT" + "  users.id_user," + "  users.username," + "  users.active," + "  roles.name," + "  roles.id" + " FROM " + "  user_role_group," + "  users," + "  roles" + " WHERE" + "  user_role_group.id_role = roles.id AND" + "  users.id_user = user_role_group.id_user AND" + "  user_role_group.id_group =" + idGroup + " and users.issuperadmin != " + true + " and user_role_group.id_role >= " + idRole + " ORDER BY LOWER(users.username)";
                resultSet = stmt.executeQuery(query);
                while (resultSet.next()) {
                    NodeUserRole nodeUserRole = new NodeUserRole();
                    nodeUserRole.setIdUser(resultSet.getInt("id_user"));
                    nodeUserRole.setUserName(resultSet.getString("username"));
                    nodeUserRole.setIsActive(resultSet.getBoolean("active"));
                    nodeUserRole.setIdRole(resultSet.getInt("id"));
                    nodeUserRole.setRoleName(resultSet.getString("name"));
                    listUser.add(nodeUserRole);
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException ex) {
        Logger.getLogger(UserHelper2.class.getName()).log(Level.SEVERE, null, ex);
    }
    return listUser;
}

Example 3 with NodeUserRole

use of mom.trd.opentheso.bdd.helper.nodes.NodeUserRole in project opentheso by miledrousset.

the class UserHelperTest method getUsersOfGroup.

@Test
public void getUsersOfGroup() {
    UserHelper2 userHelper2 = new UserHelper2();
    ConnexionTest connexionTest = new ConnexionTest();
    HikariDataSource conn = connexionTest.getConnexionPool();
    ArrayList<NodeUserRole> nodeUser2s = userHelper2.getUsersRolesByGroup(conn, 3, 2);
}

Example 4 with NodeUserRole

use of mom.trd.opentheso.bdd.helper.nodes.NodeUserRole in project opentheso by miledrousset.

the class UserHelper2 method getUsersWithoutGroup.

/**
 * cette fonction permet de retourner la liste des utilisateurs qui
 * n'appartiennent à aucun groupe donc aucun role défini
 *
 * @param ds
 * @return
 */
public ArrayList<NodeUserRole> getUsersWithoutGroup(HikariDataSource ds) {
    ArrayList<NodeUserRole> listUser = new ArrayList<>();
    Connection conn;
    Statement stmt;
    ResultSet resultSet;
    try {
        conn = ds.getConnection();
        try {
            stmt = conn.createStatement();
            try {
                String query = "SELECT users.id_user, users.username, users.active" + " FROM users where users.issuperadmin!=true and users.id_user not in " + "(select distinct id_user from user_role_group order by id_user)" + " ORDER BY LOWER(users.username)";
                resultSet = stmt.executeQuery(query);
                while (resultSet.next()) {
                    NodeUserRole nodeUserRole = new NodeUserRole();
                    nodeUserRole.setIdUser(resultSet.getInt("id_user"));
                    nodeUserRole.setUserName(resultSet.getString("username"));
                    nodeUserRole.setIsActive(resultSet.getBoolean("active"));
                    nodeUserRole.setIdRole(-1);
                    nodeUserRole.setRoleName("");
                    listUser.add(nodeUserRole);
                }
            } finally {
                stmt.close();
            }
        } finally {
            conn.close();
        }
    } catch (SQLException ex) {
        Logger.getLogger(UserHelper2.class.getName()).log(Level.SEVERE, null, ex);
    }
    return listUser;
}