org.turro.contacts.util.RelationUtil Class Reference

Static Public Member Functions
static void	addRelation (Contact business, Contact contact, String relation)
static void	addRelation (String business, String contact, String relation)
static void	addRelations (Collection< BusinessRelation > relations)
static void	killRelation (Contact business, Contact contact, String relation)
static void	killRelation (String business, String contact, String relation)
static void	killRelations (String like)
static void	setPreferentialRelation ()

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 36 of file RelationUtil.java.

Member Function Documentation

addRelation() [1/2]

static void org.turro.contacts.util.RelationUtil.addRelation ( Contact  business, Contact  contact, String  relation  )

static

Definition at line 38 of file RelationUtil.java.

                                                                                     {
    if(business != null && contact != null && !Strings.isBlank(relation)) {
      Dao dao = new ContactsPU();
      WhereClause wc = new WhereClause();
      wc.addClause("select r from BusinessRelation as r");
      wc.addClause("where r.contact = :c1");
      wc.addNamedValue("c1", contact);
      wc.addClause("and r.business = :c2");
      wc.addNamedValue("c2", business);
      wc.addClause("and r.relationType = :pr");
      wc.addNamedValue("pr", relation);
      List<BusinessRelation> relations = dao.getResultList(wc);
      if(relations.isEmpty()) {
        BusinessRelation r = new BusinessRelation();
        r.setContact(contact);
        r.setBusiness(business);
        r.setRelationType(relation);
        dao.saveObject(r);
      }
    }
  }

Here is the call graph for this function:

addRelation() [2/2]

static void org.turro.contacts.util.RelationUtil.addRelation ( String  business, String  contact, String  relation  )

static

Definition at line 60 of file RelationUtil.java.

                                                                                   {
    if(business != null && contact != null && !Strings.isBlank(relation)) {
      Dao dao = new ContactsPU();
      WhereClause wc = new WhereClause();
      wc.addClause("select r from BusinessRelation as r");
      wc.addClause("where r.contact.id = :c1");
      wc.addNamedValue("c1", contact);
      wc.addClause("and r.business.id = :c2");
      wc.addNamedValue("c2", business);
      wc.addClause("and r.relationType = :pr");
      wc.addNamedValue("pr", relation);
      List<BusinessRelation> relations = dao.getResultList(wc);
      if(relations.isEmpty()) {
        BusinessRelation r = new BusinessRelation();
        r.setContact(dao.find(Contact.class, contact));
        r.setBusiness(dao.find(Contact.class, business));
        r.setRelationType(relation);
        if(r.getContact() != null && r.getBusiness()!= null) {
          dao.saveObject(r);
        }
      }
    }
  }

Here is the call graph for this function:

addRelations()

static void org.turro.contacts.util.RelationUtil.addRelations ( Collection< BusinessRelation >  relations )

static

Definition at line 84 of file RelationUtil.java.

                                                                          {
    Dao dao = new ContactsPU();
    dao.saveCollection(relations);
  }

Here is the call graph for this function:

killRelation() [1/2]

static void org.turro.contacts.util.RelationUtil.killRelation ( Contact  business, Contact  contact, String  relation  )

static

Definition at line 89 of file RelationUtil.java.

                                                                                      {
    if(business != null && contact != null && !Strings.isBlank(relation)) {
      Dao dao = new ContactsPU();
      WhereClause wc = new WhereClause();
      wc.addClause("delete from BusinessRelation as r");
      wc.addClause("where r.contact = :c1");
      wc.addNamedValue("c1", contact);
      wc.addClause("and r.business = :c2");
      wc.addNamedValue("c2", business);
      wc.addClause("and r.relationType = :pr");
      wc.addNamedValue("pr", relation);
      dao.executeUpdate(wc);
    }
  }

Here is the call graph for this function:

killRelation() [2/2]

static void org.turro.contacts.util.RelationUtil.killRelation ( String  business, String  contact, String  relation  )

static

Definition at line 104 of file RelationUtil.java.

                                                                                    {
    if(business != null && contact != null && !Strings.isBlank(relation)) {
      Dao dao = new ContactsPU();
      WhereClause wc = new WhereClause();
      wc.addClause("delete from BusinessRelation as r");
      wc.addClause("where r.contact.id = :c1");
      wc.addNamedValue("c1", contact);
      wc.addClause("and r.business.id = :c2");
      wc.addNamedValue("c2", business);
      wc.addClause("and r.relationType = :pr");
      wc.addNamedValue("pr", relation);
      dao.executeUpdate(wc);
    }
  }

Here is the call graph for this function:

killRelations()

static void org.turro.contacts.util.RelationUtil.killRelations ( String  like )

static

Definition at line 119 of file RelationUtil.java.

                                                {
    if(!Strings.isBlank(like)) {
      Dao dao = new ContactsPU();
      WhereClause wc = new WhereClause();
      wc.addClause("delete from BusinessRelation as r");
      wc.addClause("where r.relationType like :pr");
      wc.addNamedValue("pr", like);
      dao.executeUpdate(wc);
    }
  }

Here is the call graph for this function:

setPreferentialRelation()

static void org.turro.contacts.util.RelationUtil.setPreferentialRelation ( )

static

Definition at line 130 of file RelationUtil.java.

                                               {
    try(Stream<Contact> contacts = new ContactsPU().stream(Contact.class, "select c from Contact c")) {
      contacts.forEach((contact) -> {
        if(contact.getBusiness() == null) {
          for(BusinessRelation relation : contact.getBusinessRelations()) {
            if(!Strings.isBlank(relation.getRelationType()) && relation.getRelationType().startsWith("$REL_")) {
              new ContactsPU().executeUpdate(
                      "update BusinessRelation set preferential = TRUE where identifier = ?", 
                      new Object[] { relation.getId() }
                      );
              break;
            }
          }
        }
      });
    }
  }

---

The documentation for this class was generated from the following file:

• RelationUtil.java