Search in sources :

Example 26 with UserHelper2

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

the class UserHelperTest method addUser.

@Test
public void addUser() {
    UserHelper2 userHelper2 = new UserHelper2();
    ConnexionTest connexionTest = new ConnexionTest();
    HikariDataSource conn = connexionTest.getConnexionPool();
    int idUser = -1;
    boolean status = userHelper2.addUser(conn, "userName2dd", "mail2dd@mom.fr", "21232f297a57a5a743894a0e4a801fc3", true, true);
    if (status) {
        idUser = userHelper2.getIdUser(conn, "userName2dd", "21232f297a57a5a743894a0e4a801fc3");
        status = userHelper2.addUserRoleOnGroup(conn, idUser, 1, 1);
    }
    System.out.println("" + idUser);
}
Also used : HikariDataSource(com.zaxxer.hikari.HikariDataSource) ConnexionTest(connexion.ConnexionTest) UserHelper2(mom.trd.opentheso.bdd.helper.UserHelper2) ConnexionTest(connexion.ConnexionTest) Test(org.junit.Test)

Example 27 with UserHelper2

use of mom.trd.opentheso.bdd.helper.UserHelper2 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);
}
Also used : NodeUserRole(mom.trd.opentheso.bdd.helper.nodes.NodeUserRole) HikariDataSource(com.zaxxer.hikari.HikariDataSource) ConnexionTest(connexion.ConnexionTest) UserHelper2(mom.trd.opentheso.bdd.helper.UserHelper2) ConnexionTest(connexion.ConnexionTest) Test(org.junit.Test)

Example 28 with UserHelper2

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

the class EditionBean method supprimerTheso.

/**
 * Permet de supprimer le thésaurus
 * @param idTheso1
 * @return
 */
public boolean supprimerTheso(String idTheso1) {
    PreferencesHelper preferencesHelper = new PreferencesHelper();
    NodePreference nodePreference = preferencesHelper.getThesaurusPreferences(connect.getPoolConnexion(), idTheso1);
    if (nodePreference != null) {
        // suppression des Identifiants Handle
        ConceptHelper conceptHelper = new ConceptHelper();
        conceptHelper.setNodePreference(nodePreference);
        conceptHelper.deleteAllIdHandle(connect.getPoolConnexion(), idTheso1);
    }
    // suppression du thesaurus du group/projet
    UserHelper2 userHelper = new UserHelper2();
    try {
        Connection conn = connect.getPoolConnexion().getConnection();
        conn.setAutoCommit(false);
        if (!userHelper.deleteThesoFromGroup(conn, idTheso1)) {
            FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, langueBean.getMsg("info") + " :", "BDD problem !! "));
            conn.rollback();
            conn.commit();
            return false;
        }
        conn.commit();
        conn.close();
    } catch (SQLException ex) {
        Logger.getLogger(UserHelper2.class.getName()).log(Level.SEVERE, null, ex);
    }
    // suppression complète du thésaurus
    ThesaurusHelper th = new ThesaurusHelper();
    th.deleteThesaurus(connect.getPoolConnexion(), idTheso1);
    FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(FacesMessage.SEVERITY_INFO, langueBean.getMsg("info") + " :", langueBean.getMsg("edition.ThesoDeleted")));
    return true;
}
Also used : ConceptHelper(mom.trd.opentheso.bdd.helper.ConceptHelper) SQLException(java.sql.SQLException) ThesaurusHelper(mom.trd.opentheso.bdd.helper.ThesaurusHelper) AccessThesaurusHelper(mom.trd.opentheso.bdd.helper.AccessThesaurusHelper) Connection(java.sql.Connection) UserHelper2(mom.trd.opentheso.bdd.helper.UserHelper2) NodePreference(mom.trd.opentheso.bdd.helper.nodes.NodePreference) FacesMessage(javax.faces.application.FacesMessage) PreferencesHelper(mom.trd.opentheso.bdd.helper.PreferencesHelper)

Example 29 with UserHelper2

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

the class RoleOnThesoBean method setUserRoleGroup.

/**
 * permet de récuperer le role de l'utilisateur sur le group
 * applelé en cas où le group n'a aucun thésaurus pour que l'utilisateur
 * puisse créer des thésaurus et gérer les utilisateur pour le group
 * il faut être Admin
 */
private void setUserRoleGroup() {
    UserHelper2 userHelper = new UserHelper2();
    ArrayList<NodeUserRoleGroup> nodeUserRoleGroups = userHelper.getUserRoleGroup(connect.getPoolConnexion(), user.getUser().getIdUser());
    for (NodeUserRoleGroup nodeUserRoleGroup1 : nodeUserRoleGroups) {
        if (nodeUserRoleGroup1.isIsAdmin())
            setIsAdminOnThisTheso(true);
    }
}
Also used : NodeUserRoleGroup(mom.trd.opentheso.bdd.helper.nodes.NodeUserRoleGroup) UserHelper2(mom.trd.opentheso.bdd.helper.UserHelper2)

Example 30 with UserHelper2

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

the class RoleOnThesoBean method setUserRoleOnThisTheso.

/**
 * Permet de définir le role d'un utilisateur sur le thésaurus en cours
 * le groupe du thésaurus est trouvé automatiquement, si l'utilisateur est SuperAdmin, pas besoin du groupe
 *
 * #MR
 */
public void setUserRoleOnThisTheso() {
    if (user.getUser() == null) {
        nodeUserRoleGroup = null;
        return;
    }
    if (idTheso == null) {
        nodeUserRoleGroup = null;
        return;
    }
    initRoles();
    UserHelper2 userHelper = new UserHelper2();
    if (user.getUser().isIsSuperAdmin()) {
        // cas de superadmin, on a accès à tous les groupes
        nodeUserRoleGroup = user.getUserRoleOnThisGroup(-1);
    } else {
        int idGroup = userHelper.getGroupOfThisTheso(connect.getPoolConnexion(), idTheso);
        nodeUserRoleGroup = user.getUserRoleOnThisGroup(idGroup);
    }
    if (nodeUserRoleGroup == null)
        return;
    if (nodeUserRoleGroup.getIdRole() == 1)
        setIsSuperAdmin(true);
    if (nodeUserRoleGroup.getIdRole() == 2)
        setIsAdminOnThisTheso(true);
    if (nodeUserRoleGroup.getIdRole() == 3)
        setIsManagerOnThisTheso(true);
    if (nodeUserRoleGroup.getIdRole() == 4)
        setIsContributorOnThisTheso(true);
}
Also used : UserHelper2(mom.trd.opentheso.bdd.helper.UserHelper2)

Aggregations

UserHelper2 (mom.trd.opentheso.bdd.helper.UserHelper2)48 FacesMessage (javax.faces.application.FacesMessage)19 Connection (java.sql.Connection)9 SQLException (java.sql.SQLException)8 ThesaurusHelper (mom.trd.opentheso.bdd.helper.ThesaurusHelper)6 HikariDataSource (com.zaxxer.hikari.HikariDataSource)5 ConnexionTest (connexion.ConnexionTest)5 Thesaurus (mom.trd.opentheso.bdd.datas.Thesaurus)5 Test (org.junit.Test)5 AccessThesaurusHelper (mom.trd.opentheso.bdd.helper.AccessThesaurusHelper)3 PreferencesHelper (mom.trd.opentheso.bdd.helper.PreferencesHelper)3 LinkedHashMap (java.util.LinkedHashMap)2 CandidateHelper (mom.trd.opentheso.bdd.helper.CandidateHelper)2 NodePreference (mom.trd.opentheso.bdd.helper.nodes.NodePreference)2 NodeUserRoleGroup (mom.trd.opentheso.bdd.helper.nodes.NodeUserRoleGroup)2 PrimeFaces (org.primefaces.PrimeFaces)2 HashMap (java.util.HashMap)1 PostConstruct (javax.annotation.PostConstruct)1 ConceptHelper (mom.trd.opentheso.bdd.helper.ConceptHelper)1 NodeUser2 (mom.trd.opentheso.bdd.helper.nodes.NodeUser2)1