FuzzyRelationTypes.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2021 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
 
package org.turro.contacts.relation;
 
import org.turro.contacts.BusinessRelation;
import org.turro.contacts.ContactType;
import org.turro.contacts.organigram.RelationType;
import org.turro.elephant.db.WhereClause;
 
public class FuzzyRelationTypes {
  
  public static boolean isWorker(BusinessRelation relation) {
    return isProfessional(relation) || isEducator(relation);
  }
  
  public static void isWorker(WhereClause wc, String separator, String relationField) {
    wc.addClause(separator + " (");
    isProfessional(wc, "", relationField);
    isEducator(wc, "or", relationField);
    wc.addClause(")");
  }
 
  public static boolean isProfessional(BusinessRelation relation) {
    return !relation.isEmpty() && ContactType.CONTACT_COMPANY.equals(relation.getBusiness().getType());
  }
  
  public static void isProfessional(WhereClause wc, String separator, String relationField) {
    wc.addClause(separator + " (");
    wc.addClause(relationField + ".business.type = :wtype");
    wc.addNamedValue("wtype", ContactType.CONTACT_COMPANY);
    wc.addClause(")");
  }
 
  public static boolean isEducator(BusinessRelation relation) {
    return !relation.isEmpty() && (
            (ContactType.CONTACT_LEARNINGCENTER.equals(relation.getBusiness().getType()) &&
            !RelationType.REL_STAFF.getRelationKey().equals(relation.getRelationType())));
  }
  
  public static void isEducator(WhereClause wc, String separator, String relationField) {
    wc.addClause(separator + " (");
    wc.addClause(relationField + ".business.type = :stype");
    wc.addNamedValue("stype", ContactType.CONTACT_LEARNINGCENTER);
    wc.addClause("and " + relationField +".relationType <> :brtype");
    wc.addNamedValue("brtype", RelationType.REL_STAFF.getRelationKey());
    wc.addClause(")");
  }
 
  public static boolean isStudent(BusinessRelation relation) {
    return !relation.isEmpty() && 
            ContactType.CONTACT_LEARNINGCENTER.equals(relation.getBusiness().getType()) &&
            RelationType.REL_STAFF.getRelationKey().equals(relation.getRelationType());
  }
  
  public static void isStudent(WhereClause wc, String separator, String relationField) {
    wc.addClause(separator + " (");
    wc.addClause(relationField + ".business.type = :stype");
    wc.addNamedValue("stype", ContactType.CONTACT_LEARNINGCENTER);
    wc.addClause("and " + relationField +".relationType = :brtype");
    wc.addNamedValue("brtype", RelationType.REL_STAFF.getRelationKey());
    wc.addClause(")");
  }
 
  public static boolean isStaff(BusinessRelation relation) {
    return !relation.isEmpty() && 
            (ContactType.CONTACT_COMPANY.equals(relation.getBusiness().getType()) ||
            ContactType.CONTACT_LEARNINGCENTER.equals(relation.getBusiness().getType())) &&
            RelationType.REL_STAFF.getRelationKey().equals(relation.getRelationType());
  }
  
  public static boolean isResponsible(BusinessRelation relation) {
    return !relation.isEmpty() && 
            (ContactType.CONTACT_COMPANY.equals(relation.getBusiness().getType()) ||
            ContactType.CONTACT_LEARNINGCENTER.equals(relation.getBusiness().getType())) &&
            !RelationType.REL_STAFF.getRelationKey().equals(relation.getRelationType());
  }
  
  public static boolean isHHRR(BusinessRelation relation) {
    return !relation.isEmpty() && 
            (ContactType.CONTACT_COMPANY.equals(relation.getBusiness().getType()) ||
            ContactType.CONTACT_LEARNINGCENTER.equals(relation.getBusiness().getType())) &&
            RelationType.REL_HHRR.getRelationKey().equals(relation.getRelationType());
  }
  
  public static void isHHRR(WhereClause wc, String separator, String relationField) {
    wc.addClause(separator + " ((");
    wc.addClause(relationField + ".business.type = :stype");
    wc.addNamedValue("stype", ContactType.CONTACT_LEARNINGCENTER);
    wc.addClause("or " + relationField + ".business.type = :ctype");
    wc.addNamedValue("stype", ContactType.CONTACT_COMPANY);
    wc.addClause(")");
    wc.addClause("and " + relationField +".relationType = :brtype");
    wc.addNamedValue("brtype", RelationType.REL_HHRR.getRelationKey());
    wc.addClause(")");
  }
 
  public static void isSingleton(WhereClause wc, String separator, String contactField, String relationField) {
    wc.addClause(separator + " (" + relationField + " is null");
    wc.addClause("and (" + contactField + ".type = :sgtype or " + contactField + ".type = :sitype))");
    wc.addNamedValue("sgtype", ContactType.CONTACT_USER);
    wc.addNamedValue("sitype", ContactType.CONTACT_INTERNAL);
  }
 
  public static void isTyped(WhereClause wc, String separator, String relationField) {
    wc.addClause(separator + " (");
    wc.addClause(relationField + ".contact.type = :wtype");
    wc.addNamedValue("wtype", ContactType.CONTACT_COMPANY);
    wc.addClause("or");
    wc.addClause(relationField + ".contact.type = :stype");
    wc.addNamedValue("stype", ContactType.CONTACT_LEARNINGCENTER);
    wc.addClause("or");
    wc.addClause(relationField + ".business.type = :wtype");
    wc.addClause("or");
    wc.addClause(relationField + ".business.type = :stype");
    wc.addClause(")");
  }
 
  public static void isJuridical(WhereClause wc, String separator, String relationField) {
    wc.addClause(separator + " (");
    wc.addClause(relationField + ".type = :wtype");
    wc.addNamedValue("wtype", ContactType.CONTACT_COMPANY);
    wc.addClause("or");
    wc.addClause(relationField + ".type = :stype");
    wc.addNamedValue("stype", ContactType.CONTACT_LEARNINGCENTER);
    wc.addClause(")");
  }
 
  public static void isNatural(WhereClause wc, String separator, String relationField) {
    wc.addClause(separator + " (");
    wc.addClause(relationField + ".business.type = :wtype");
    wc.addNamedValue("wtype", ContactType.CONTACT_COMPANY);
    wc.addClause("or");
    wc.addClause(relationField + ".business.type = :stype");
    wc.addNamedValue("stype", ContactType.CONTACT_LEARNINGCENTER);
    wc.addClause(")");
  }
 
}