ImporterEntry.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2023 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.importer;
 
import java.util.List;
import java.util.Map;
import java.util.Objects;
import org.turro.contacts.Contact;
import org.turro.contacts.ContactType;
import org.turro.contacts.db.ContactsPU;
import org.turro.contacts.organigram.RelationType;
import org.turro.jpa.Dao;
import org.turro.plugin.contacts.IContact;
import org.turro.sql.SqlClause;
import org.turro.util.Cached;
 
public class ImporterEntry {
  
  private final String email, name, relatedTo;
  private String position;
  private RelationType type;
  private Contact contact, possibleRelated;
  private boolean duplicated;
 
  public ImporterEntry(String email, String name, String relatedTo, String position) {
    this.email = email;
    this.name = name;
    this.relatedTo = relatedTo;
    this.position = position;
    type = RelationType.REL_STAFF;
    solve();
  }
 
  public String getEmail() {
    return email;
  }
 
  public String getName() {
    return name;
  }
 
  public String getRelatedTo() {
    return relatedTo;
  }
 
  public String getPosition() {
    return position;
  }
 
  public void setPosition(String position) {
    this.position = position;
  }
 
  public boolean isDuplicated() {
    return duplicated;
  }
 
  public RelationType getType() {
    return type;
  }
 
  public void setType(RelationType type) {
    this.type = type;
  }
 
  public Contact getContact() {
    return contact;
  }
 
  public void setContact(Contact contact) {
    this.contact = contact;
  }
 
  public Contact getPossibleRelated() {
    return possibleRelated;
  }
 
  public void setPossibleRelated(Contact possibleRelated) {
    this.possibleRelated = possibleRelated;
  }
  
  public String getFinalName() {
    return contact == null ? name : contact.getName();
  }
 
  /* Init */
  
  public void rebuild() {
    solve();
  }
  
  private void solve() {
    List<Contact> found = findEmail();
    if(found.size() > 1) {
      duplicated = true;
      return;
    } else if(found.size() == 1) {
      contact = found.get(0);
    }
    List<Contact> related = findRelated();
    if(!related.isEmpty()) {
      possibleRelated = related.get(0);
    }
  }
  
  private List<Contact> findEmail() {
    return SqlClause.select("c.contact").from("Connector c")
            .where().equal("c.value", email)
            .and().equal("c.description", IContact.CONNECTOR_EMAIL)
            .dao(dao.get())
            .resultList(Contact.class);
  }  
 
  private List<Contact> findRelated() {
    return SqlClause.select("c").from("Contact c")
            .where().equal("c.name", relatedTo)
            .and().in("c.type", List.of(
                    ContactType.CONTACT_COMPANY,
                    ContactType.CONTACT_LEARNINGCENTER))
            .dao(dao.get())
            .resultList(Contact.class);
  }  
 
  /* Dao */
  
  private final Cached<Dao> dao = Cached.instance(() -> new ContactsPU());
  
  /* Factory */
  
  public static ImporterEntry from(Map<String, String> values) {
    return new ImporterEntry(values.get("email"), values.get("name"), 
            values.get("relatedTo"), values.get("position"));
  }
  
  /* Utils */
 
  @Override
  public int hashCode() {
    int hash = 5;
    hash = 53 * hash + Objects.hashCode(this.email);
    return hash;
  }
 
  @Override
  public boolean equals(Object obj) {
    if (this == obj) {
      return true;
    }
    if (obj == null) {
      return false;
    }
    if (getClass() != obj.getClass()) {
      return false;
    }
    final ImporterEntry other = (ImporterEntry) obj;
    return Objects.equals(this.email, other.email);
  }
    
}