ContactFilterField.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2013 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.filter;
 
import java.util.Date;
import java.util.List;
import org.turro.string.Strings;
import org.turro.contacts.db.ContactsPU;
import org.turro.elephant.db.SQLHelper;
import org.turro.elephant.db.WhereClause;
import org.turro.zkoss.filter.FilterField;
import org.turro.zkoss.filter.FilterFieldOperator;
 
public abstract class ContactFilterField extends FilterField {
 
  public ContactFilterField(String label, String value) {
    super(label, value);
  }
 
  public ContactFilterField(String label, Number value) {
    super(label, value);
  }
 
  public ContactFilterField(String label, Date value) {
    super(label, value);
  }
 
  public ContactFilterField(String label, Boolean value) {
    super(label, value);
  }
 
  public ContactFilterField(String label, Enum value) {
    super(label, value);
  }
 
  public ContactFilterField(String label) {
    super(label);
  }
 
  public ContactFilterField(String label, String value, FilterFieldOperator operator) {
    super(label, value, operator);
  }
 
  public ContactFilterField(String label, Number value, FilterFieldOperator operator) {
    super(label, value, operator);
  }
 
  public ContactFilterField(String label, Date value, FilterFieldOperator operator) {
    super(label, value, operator);
  }
 
  public ContactFilterField(String label, Boolean value, FilterFieldOperator operator) {
    super(label, value, operator);
  }
 
  public ContactFilterField(String label, Enum value, FilterFieldOperator operator) {
    super(label, value, operator);
  }
 
  public ContactFilterField(String label, FilterFieldOperator operator) {
    super(label, operator);
  }
 
  @Override
  public void addConstraint(WhereClause wc) {
    String inClause = getInClause();
    if(!Strings.isBlank(inClause)) {
      wc.addClause(getChain().getOpSQL() + " " + getContactField() + " in " + inClause);
    } else {
      wc.addClause(getChain().getOpSQL() + " 1 = 2");
    }
  }
  
  public abstract String getContactField();
  
  protected abstract String getInternalField();
 
  private String getInClause() {
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct contact.id from Contact as contact");
    wc.addClause("left join contact.addresses address");
    wc.addClause("left join contact.connectors connector");
    wc.addClause("left join contact.comments comment");
    wc.addClause("where 1=1");
    doAddConstraint(wc, getInternalField());
    List<String> list = new ContactsPU().getResultList(wc);
    String inClause = SQLHelper.convertToIn(list);
    if(!Strings.isBlank(inClause)) {
      return "(" + inClause + ")";
    }
    return null;
  }
 
}