ViewSets.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2011 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.financials.view;
 
import java.util.HashSet;
import java.util.Set;
import org.turro.financials.entity.RegisterView;
import org.turro.financials.model.register.ViewWrapper;
import org.turro.util.PhraseBuilder;
 
public class ViewSets {
 
  private Set<RegisterView> groupA, groupB;
 
  public ViewSets() {
    groupA = new HashSet<RegisterView>();
    groupB = new HashSet<RegisterView>();
    groupA.add(ViewWrapper.getFormalView());
  }
 
  public Set<RegisterView> getGroupA() {
    return groupA;
  }
 
  public void setGroupA(Set<RegisterView> groupA) {
    this.groupA.clear();
    this.groupA.addAll(groupA);
  }
 
  public Set<RegisterView> getGroupB() {
    return groupB;
  }
 
  public void setGroupB(Set<RegisterView> groupB) {
    this.groupB.clear();
    this.groupB.addAll(groupB);
  }
 
  public String getStringFilter() {
    PhraseBuilder pb = new PhraseBuilder();
    for(RegisterView v : groupA) {
      pb.addWord(v.getName());
      pb.addPendingSeparator(",");
    }
    if(!groupB.isEmpty()) {
      pb.cancelSeparator();
      pb.addWord("[vs.]");
      for(RegisterView v : groupB) {
        pb.addWord(v.getName());
        pb.addPendingSeparator(",");
      }
    }
    return pb.toString();
  }
 
  public String getSqlWhereAB(String field) {
    PhraseBuilder pb = new PhraseBuilder();
    if(!groupA.isEmpty()) {
      pb.addWord("and (" + field + " in (");
      for(RegisterView rv : groupA) {
        pb.addPendingSeparator(",");
        pb.addWord(rv.getId() + "");
      }
      pb.cancelSeparator();
      pb.addWord(")");
      if(!groupB.isEmpty()) {
        pb.addWord("or " + field + " in (");
        for(RegisterView rv : groupB) {
          pb.addPendingSeparator(",");
          pb.addWord(rv.getId() + "");
        }
        pb.cancelSeparator();
        pb.addWord(")");
      }
      pb.addWord(")");
    }
    return pb.toString();
  }
 
  public String getSqlWhereA(String field) {
    PhraseBuilder pb = new PhraseBuilder();
    if(!groupA.isEmpty()) {
      pb.addWord("and " + field + " in (");
      for(RegisterView rv : groupA) {
        pb.addPendingSeparator(",");
        pb.addWord(rv.getId() + "");
      }
      pb.cancelSeparator();
      pb.addWord(")");
    } else {
      pb.addWord("and 1=2");
    }
    return pb.toString();
  }
 
  public String getSqlWhereB(String field) {
    PhraseBuilder pb = new PhraseBuilder();
    if(!groupB.isEmpty()) {
      pb.addWord("and " + field + " in (");
      for(RegisterView rv : groupB) {
        pb.addPendingSeparator(",");
        pb.addWord(rv.getId() + "");
      }
      pb.cancelSeparator();
      pb.addWord(")");
    } else {
      pb.addWord("and 1=2");
    }
    return pb.toString();
  }
 
}