ModelSearch.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.model;
 
import java.util.HashSet;
import java.util.Set;
import org.turro.string.Strings;
import org.turro.contacts.organigram.RelationType;
import org.turro.elephant.db.SQLHelper;
import org.turro.elephant.db.WhereClause;
 
public class ModelSearch {
 
  private String fieldContact, fieldRelation, fieldConnector, fieldAddress, fieldSyndication, fieldComment;
  private boolean useConnector, useAddress, useComment;
 
  public ModelSearch() {
    this.fieldContact = "contact";
    this.fieldRelation = "relation";
    this.fieldConnector = "connector";
    this.fieldAddress = "address";
    this.fieldSyndication = "syndication";
    this.fieldComment = "comment";
    this.useConnector = false;
    this.useAddress = false;
    this.useComment = false;
  }  
 
  public String getFieldContact() {
    return fieldContact;
  }
 
  public void setFieldContact(String fieldContact) {
    this.fieldContact = fieldContact;
  }
 
  public String getFieldRelation() {
    return fieldRelation;
  }
 
  public void setFieldRelation(String fieldRelation) {
    this.fieldRelation = fieldRelation;
  }
 
  public String getFieldConnector() {
    return fieldConnector;
  }
 
  public void setFieldConnector(String fieldConnector) {
    this.fieldConnector = fieldConnector;
  }
 
  public String getFieldAddress() {
    return fieldAddress;
  }
 
  public void setFieldAddress(String fieldAddress) {
    this.fieldAddress = fieldAddress;
  }
 
  public String getFieldSyndication() {
    return fieldSyndication;
  }
 
  public void setFieldSyndication(String fieldSyndication) {
    this.fieldSyndication = fieldSyndication;
  }
 
  public String getFieldComment() {
    return fieldComment;
  }
 
  public void setFieldComment(String fieldComment) {
    this.fieldComment = fieldComment;
  }
 
  public boolean isUseConnector() {
    return useConnector;
  }
 
  public void setUseConnector(boolean useConnector) {
    this.useConnector = useConnector;
  }
 
  public boolean isUseAddress() {
    return useAddress;
  }
 
  public void setUseAddress(boolean useAddress) {
    this.useAddress = useAddress;
  }
 
  public boolean isUseComment() {
    return useComment;
  }
 
  public void setUseComment(boolean useComment) {
    this.useComment = useComment;
  }
 
  public void apply(String operator, String value, WhereClause wc, boolean stopIfEmpty) {
    if(Strings.isBlank(value)) {
      wc.addClause(operator + (stopIfEmpty ? " 1=2" : " 1=1"));
    } else if(value.indexOf("=") > 0) {
      applyPair(operator, value, wc);
    } else {
      Set<String> fields = new HashSet<>();
      fields.add("contact.name");
      fields.add("contact.globalIdentifier");
      if(useConnector) fields.add("connector.value");
      if(useAddress) { 
        fields.add("address.city"); 
        fields.add("address.zipCode"); 
        fields.add("address.province"); 
        fields.add("address.state"); 
        fields.add("address.street"); 
      }
      if(useComment) fields.add("comment.comment");
      wc.setPrefix(operator);
      wc.addLikeFields(fields.toArray(new String[0]), value);
    }
  }
 
  private void applyPair(String operator, String value, WhereClause wc) {
    String[] v = value.split("\\s*=\\s*");
    if(v.length == 1) {
      wc.addClause(operator + " (");
      wc.addClause("connector.description = :variable");
      wc.addClause("or address.description = :variable");
      wc.addClause(")");
      wc.addNamedValue("variable", v[0]);
    } else {
      if("Grouping".equalsIgnoreCase(v[0])) {
        wc.addClause(operator + " contact.grouping like :value");
        wc.addNamedValue("value", SQLHelper.convertToPartialLike(v[1]));
      } else if("Activity".equalsIgnoreCase(v[0])) {
        wc.addClause(operator + " contact.idActivity like :value");
        wc.addNamedValue("value", SQLHelper.convertToPartialLike(v[1]));
      } else if("Relation".equalsIgnoreCase(v[0])) {
        wc.addClause(operator + " relation.relationType = :typevalue");
        wc.addNamedValue("typevalue", RelationType.getRelationPrefix() + v[1].toUpperCase());
      } else {
        wc.addClause(operator + " (");
        wc.addClause("(connector.description = :variable and connector.value like :value)");
        wc.addClause("or (address.description = :variable and (");
        wc.addClause("address.city like :value or address.zipCode like :value or address.province like :value or address.state like :value or address.street like :value))"); 
        wc.addClause(")");
        wc.addNamedValue("variable", v[0]);
        wc.addNamedValue("value", SQLHelper.convertToPartialLike(v[1]));
      }
    }
  }
  
}