use of mom.trd.opentheso.bdd.helper.nodes.NodeNT in project opentheso by miledrousset.
the class SelectedTerme method delSpe.
// ancien code qui ne marche pas
/*
if(termeGenerique.size() == 1) { // Le concept devient orphelin
new ConceptHelper().deleteConceptFromTable(connect.getPoolConnexion(), idC, idTheso);
new OrphanHelper().addNewOrphan(connect.getPoolConnexion(), idC, idTheso);
if(new GroupHelper().isIdOfGroup(connect.getPoolConnexion(), id, idTheso)) {
new RelationsHelper().setRelationTopConcept(connect.getPoolConnexion(), idC, idTheso, id, false);
} else {
new RelationsHelper().deleteRelationBT(connect.getPoolConnexion(), idC, idTheso, id);
}
termeGenerique = new ArrayList<>();
} else {
// On supprime l'ancien domaines si besoin
ArrayList<String> groupBT;
if(type == 2) {
groupBT = new ArrayList<>();
groupBT.add(id);
} else {
groupBT = new ConceptHelper().getListGroupIdOfConcept(connect.getPoolConnexion(), id, idTheso);
}
ArrayList<String> groupCurrent = new ConceptHelper().getListGroupIdOfConcept(connect.getPoolConnexion(), idC, idTheso);
ArrayList<String> delGroup = new ArrayList<>();
for(String s : groupBT) {
if(groupCurrent.contains(s)) {
delGroup.add(s);
}
}
delBranchGroup(delGroup, idC);
if(new GroupHelper().isIdOfGroup(connect.getPoolConnexion(), id, idTheso)) {
new RelationsHelper().setRelationTopConcept(connect.getPoolConnexion(), idC, idTheso, id, false);
} else {
new RelationsHelper().deleteRelationBT(connect.getPoolConnexion(), idC, idTheso, id);
}
termeGenerique = new ArrayList<>();
majTGen();
}
vue.setAddTGen(false);
}*/
/**
* Supprime les relations qui lient le concept au Concept père
*
* @param id l'identifiant du fils
* @return true or false
*/
public boolean delSpe(String id) {
// On regarde si le fils devient orphelin
ArrayList<Entry<String, String>> sonFathers = new ArrayList<>();
// On ajoute le domaine
ArrayList<String> listIdGroup = new ConceptHelper().getListGroupParentIdOfConcept(connect.getPoolConnexion(), id, idTheso);
HashMap<String, String> tempMap1 = new HashMap<>();
for (String group : listIdGroup) {
tempMap1.put(group, new GroupHelper().getLexicalValueOfGroup(connect.getPoolConnexion(), group, idTheso, idlangue));
}
sonFathers.addAll(tempMap1.entrySet());
ArrayList<NodeBT> tempBT = new RelationsHelper().getListBT(connect.getPoolConnexion(), id, idTheso, idlangue);
HashMap<String, String> tempMap2 = new HashMap<>();
for (NodeBT nbt : tempBT) {
tempMap2.put(nbt.getIdConcept(), nbt.getTitle());
}
sonFathers.addAll(tempMap2.entrySet());
if (sonFathers.size() <= 1) {
try {
Connection conn = connect.getPoolConnexion().getConnection();
conn.setAutoCommit(false);
if (!new ConceptHelper().deleteConceptFromTable(conn, id, idTheso, user.getUser().getId())) {
conn.rollback();
conn.close();
return false;
}
if (!new RelationsHelper().deleteRelationBT(conn, id, idTheso, idC, user.getUser().getId())) {
conn.rollback();
conn.close();
return false;
}
if (!new OrphanHelper().addNewOrphan(conn, id, idTheso)) {
conn.rollback();
conn.close();
return false;
}
conn.commit();
conn.close();
} catch (SQLException ex) {
Logger.getLogger(SelectedTerme.class.getName()).log(Level.SEVERE, null, ex);
return false;
}
} else {
try {
Connection conn = connect.getPoolConnexion().getConnection();
conn.setAutoCommit(false);
// On supprime l'ancien domaines si besoin
ArrayList<String> groupCurrent;
if (type == 1) {
groupCurrent = new ArrayList<>();
groupCurrent.add(idC);
} else {
groupCurrent = new ConceptHelper().getListGroupIdOfConcept(connect.getPoolConnexion(), idC, idTheso);
}
ArrayList<String> groupNT = new ConceptHelper().getListGroupIdOfConcept(connect.getPoolConnexion(), id, idTheso);
ArrayList<String> delGroup = new ArrayList<>();
for (String s : groupCurrent) {
if (groupNT.contains(s)) {
delGroup.add(s);
}
}
if (!delBranchGroup(delGroup, id)) {
conn.rollback();
conn.close();
return false;
}
if (type == 1) {
if (!new RelationsHelper().setRelationTopConcept(conn, id, idTheso, idC, false, user.getUser().getId())) {
conn.rollback();
conn.close();
return false;
}
} else if (!new RelationsHelper().deleteRelationBT(conn, id, idTheso, idC, user.getUser().getId())) {
conn.rollback();
conn.close();
return false;
}
conn.commit();
conn.close();
ArrayList<NodeNT> tempNT = new RelationsHelper().getListNT(connect.getPoolConnexion(), idC, idTheso, idlangue);
termesSpecifique = new ArrayList<>();
HashMap<String, String> tempMap3 = new HashMap<>();
for (NodeNT nnt : tempNT) {
tempMap3.put(nnt.getIdConcept(), nnt.getTitle() + " (" + nnt.getRole() + ")");
}
termesSpecifique.addAll(tempMap3.entrySet());
} catch (SQLException ex) {
Logger.getLogger(SelectedTerme.class.getName()).log(Level.SEVERE, null, ex);
return false;
}
}
return true;
}
use of mom.trd.opentheso.bdd.helper.nodes.NodeNT in project opentheso by miledrousset.
the class SelectedTerme method majTSpeConceptOrder.
public void majTSpeConceptOrder() {
termesSpecifique = new ArrayList<>();
ArrayList<NodeNT> tempNT = new RelationsHelper().getListNTOrderByDate(connect.getPoolConnexion(), idC, idTheso, idlangue);
writeTermesSpecifique(tempNT);
}
use of mom.trd.opentheso.bdd.helper.nodes.NodeNT in project opentheso by miledrousset.
the class SelectedTerme method majTSpeConcept.
private void majTSpeConcept() {
termesSpecifique = new ArrayList<>();
ArrayList<NodeNT> tempNT = new RelationsHelper().getListNT(connect.getPoolConnexion(), idC, idTheso, idlangue);
writeTermesSpecifique(tempNT);
}
use of mom.trd.opentheso.bdd.helper.nodes.NodeNT in project opentheso by miledrousset.
the class SelectedTerme method creerSpecialTermeSpe.
/**
* relation special type NTG NTP NTI ...
*
* @param selecedTerm
* @param BTname
* @param NTname
* @return
*/
public boolean creerSpecialTermeSpe(MyTreeNode selecedTerm, String BTname, String NTname) {
ConceptHelper instance = new ConceptHelper();
if (user.nodePreference == null)
return false;
instance.setNodePreference(user.getNodePreference());
Concept concept = new Concept();
concept.setIdGroup(selecedTerm.getIdCurrentGroup());
concept.setIdThesaurus(idTheso);
concept.setStatus("D");
concept.setNotation("");
Term terme = new Term();
terme.setId_thesaurus(idTheso);
terme.setLang(idlangue);
terme.setLexical_value(valueEdit);
terme.setSource("");
terme.setStatus("");
// String idTC = idTopConcept;
String idP = idC;
if (instance.addConceptSpecial(connect.getPoolConnexion(), idP, concept, terme, BTname, NTname, user.getUser().getId()) == null) {
FacesContext.getCurrentInstance().addMessage(null, new FacesMessage(FacesMessage.SEVERITY_ERROR, langueBean.getMsg("error") + " :", instance.getMessage()));
return false;
}
// instance.insertID_grouptoPermuted(connect.getPoolConnexion(), concept.getIdThesaurus(), concept.getIdConcept());
concept.getUserName();
ArrayList<NodeNT> tempNT = new RelationsHelper().getListNT(connect.getPoolConnexion(), idC, idTheso, idlangue);
termesSpecifique = new ArrayList<>();
HashMap<String, String> tempMap = new HashMap<>();
for (NodeNT nnt : tempNT) {
tempMap.put(nnt.getIdConcept(), nnt.getTitle() + " (" + nnt.getRole() + ")");
}
termesSpecifique.addAll(tempMap.entrySet());
vue.setAddTSpe(false);
valueEdit = "";
return true;
}
use of mom.trd.opentheso.bdd.helper.nodes.NodeNT in project opentheso by miledrousset.
the class SelectedTerme method addBranchGroup.
/**
* Cette fonction permet d'ajouter un groupe à une branche
*
* @param newGroup
* @param idConcept
* @return
*/
public boolean addBranchGroup(ArrayList<String> newGroup, String idConcept) {
try {
Connection conn = connect.getPoolConnexion().getConnection();
conn.setAutoCommit(false);
if (new ConceptHelper().haveChildren(connect.getPoolConnexion(), idTheso, idConcept)) {
List<NodeNT> children = new RelationsHelper().getListNT(connect.getPoolConnexion(), idConcept, idTheso, "");
for (NodeNT nnt : children) {
if (!addBranchGroup(newGroup, nnt.getIdConcept())) {
conn.rollback();
conn.close();
return false;
}
}
}
for (String s : newGroup) {
if (!new ConceptHelper().haveThisGroup(connect.getPoolConnexion(), idConcept, s, idTheso)) {
Concept c = new Concept();
c.setIdConcept(idConcept);
c.setIdGroup(s);
c.setIdThesaurus(idTheso);
c.setTopConcept(false);
c.setStatus("D");
if (!new GroupHelper().addConceptGroupConcept(conn, s, idConcept, idTheso)) {
// !new ConceptHelper().addNewGroupOfConcept(conn, c, user.getUser().getId())) {
conn.rollback();
conn.close();
return false;
}
}
}
conn.commit();
conn.close();
return true;
} catch (SQLException ex) {
Logger.getLogger(SelectedTerme.class.getName()).log(Level.SEVERE, null, ex);
}
return false;
}
Aggregations