ProjectGrantCriteria.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.dossier.grant;
 
import org.turro.elephant.db.WhereClause;
 
public class ProjectGrantCriteria {
 
  private String searchValue;
  private boolean minimis, nominimis;
  private boolean subvention, loan, combination;
  private boolean collaboration, individual;
  private boolean hiring, idi, investment, startUp;
  private boolean micro, small, medium, big;
  private boolean active, ended, recurrent;
  
  public String getSearchValue() {
    return searchValue;
  }
 
  public void setSearchValue(String searchValue) {
    this.searchValue = searchValue;
  }
 
  public void clearMinimis() {
    this.minimis = false;
    this.nominimis = false;
  }
  
  public boolean isMinimis() {
    return minimis;
  }
 
  public void setMinimis(boolean minimis) {
    this.minimis = minimis;
    this.nominimis = false;
  }
 
  public boolean isNominimis() {
    return nominimis;
  }
 
  public void setNominimis(boolean nominimis) {
    this.nominimis = nominimis;
    this.minimis = false;
  }
 
  public void clearGrant() {
    this.subvention = false;
    this.loan = false;
    this.combination = false;
  }
  
  public boolean isSubvention() {
    return subvention;
  }
 
  public void setSubvention(boolean subvention) {
    this.subvention = subvention;
    this.loan = false;
    this.combination = false;
  }
 
  public boolean isLoan() {
    return loan;
  }
 
  public void setLoan(boolean loan) {
    this.loan = loan;
    this.subvention = false;
    this.combination = false;
  }
 
  public boolean isCombination() {
    return combination;
  }
 
  public void setCombination(boolean combination) {
    this.combination = combination;
    this.subvention = false;
    this.loan = false;
  }
 
  public void clearCollaboration() {
    this.collaboration = false;
    this.individual = false;
  }
  
  public boolean isCollaboration() {
    return collaboration;
  }
 
  public void setCollaboration(boolean collaboration) {
    this.collaboration = collaboration;
    this.individual = false;
  }
 
  public boolean isIndividual() {
    return individual;
  }
 
  public void setIndividual(boolean individual) {
    this.individual = individual;
    this.collaboration = false;
  }
 
  public void clearType() {
    this.hiring = false;
    this.idi = false;
    this.investment = false;
    this.startUp = false;
  }
  
  public boolean isHiring() {
    return hiring;
  }
 
  public void setHiring(boolean hiring) {
    this.hiring = hiring;
  }
 
  public boolean isIdi() {
    return idi;
  }
 
  public void setIdi(boolean idi) {
    this.idi = idi;
  }
 
  public boolean isInvestment() {
    return investment;
  }
 
  public void setInvestment(boolean investment) {
    this.investment = investment;
  }
 
  public boolean isStartUp() {
    return startUp;
  }
 
  public void setStartUp(boolean startUp) {
    this.startUp = startUp;
  }
 
  public boolean isMicro() {
    return micro;
  }
 
  public void setMicro(boolean micro) {
    this.micro = micro;
  }
 
  public boolean isSmall() {
    return small;
  }
 
  public void setSmall(boolean small) {
    this.small = small;
  }
 
  public boolean isMedium() {
    return medium;
  }
 
  public void setMedium(boolean medium) {
    this.medium = medium;
  }
 
  public boolean isBig() {
    return big;
  }
 
  public void setBig(boolean big) {
    this.big = big;
  }
 
  public void clearDeadline() {
    this.active = false;
    this.ended = false;
    this.recurrent = false;
  }
  
  public boolean isActive() {
    return active;
  }
 
  public void setActive(boolean active) {
    this.active = active;
    this.ended = false;
    this.recurrent = false;
  }
 
  public boolean isEnded() {
    return ended;
  }
 
  public void setEnded(boolean ended) {
    this.ended = ended;
    this.active = false;
    this.recurrent = false;
  }
 
  public boolean isRecurrent() {
    return recurrent;
  }
 
  public void setRecurrent(boolean recurrent) {
    this.recurrent = recurrent;
    this.active = false;
    this.ended = false;
  }
 
  public WhereClause create() {
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct g from ProjectGrant g");
    addCriteria(wc);
    return wc;
  }
  
  public WhereClause createCount() {
    WhereClause wc = new WhereClause();
    wc.addClause("select count(distinct g) from ProjectGrant g");
    addCriteria(wc);
    return wc;
  }
  
  public WhereClause createAx() {
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct g from AxProjectGrant g");
    addCriteriaAx(wc);
    return wc;
  }
  
  public WhereClause createCountAx() {
    WhereClause wc = new WhereClause();
    wc.addClause("select count(distinct g) from AxProjectGrant g");
    addCriteriaAx(wc);
    return wc;
  }
  
  private void addCriteria(WhereClause wc) {
    wc.addClause("where 1=1");
    wc.addLikeFields(new String[] { "g.title", "g.goal.text", "g.beneficiaries.text", 
      "g.elegible.text", "g.features.text" }, searchValue);
    if(minimis) {
      wc.addClause("and g.minimis = TRUE");
    }
    if(nominimis) {
      wc.addClause("and g.minimis = FALSE");
    }
    if(combination) {
      wc.addClause("and subvention = TRUE");
      wc.addClause("and loan = TRUE");
    }
    if(subvention) {
      wc.addClause("and subvention = TRUE");
      wc.addClause("and loan = FALSE");
    }
    if(loan) {
      wc.addClause("and loan = TRUE");
      wc.addClause("and subvention = FALSE");
    }
    if(collaboration) {
      wc.addClause("and g.collaboration = TRUE");
    }
    if(individual) {
      wc.addClause("and g.collaboration = FALSE");
    }
    if(hiring) {
      wc.addClause("and g.matchCriteria.hiring = TRUE");
    }
    if(idi) {
      wc.addClause("and g.matchCriteria.idi = TRUE");
    }
    if(investment) {
      wc.addClause("and g.matchCriteria.investment = TRUE");
    }
    if(startUp) {
      wc.addClause("and g.matchCriteria.startUp = TRUE");
    }
    if(micro | small | medium | big) {
      String sep = "";
      wc.addClause("and (");
      if(micro) {
        wc.addClause(sep + "g.micro = TRUE");
        sep = "or ";
      }
      if(small) {
        wc.addClause(sep + "g.small = TRUE");
        sep = "or ";
      }
      if(medium) {
        wc.addClause(sep + "g.medium = TRUE");
        sep = "or ";
      }
      if(big) {
        wc.addClause(sep + "g.big = TRUE");
        sep = "or ";
      }
      wc.addClause(")");
    }
    if(active) {
      wc.addClause("and (g.endDate is null or g.endDate > now())");
    }
    if(ended) {
      wc.addClause("and g.endDate < now()");
    }
    if(recurrent) {
      wc.addClause("and g.recurrent = TRUE");
    }
  }
  
  private void addCriteriaAx(WhereClause wc) {
    wc.addClause("where 1=1");
    wc.addLikeFields(new String[] { "g.goal.text", "g.beneficiaries.text", 
      "g.elegible.text", "g.features.text" }, searchValue);
    if(minimis) {
      wc.addClause("and g.minimis = TRUE");
    }
    if(nominimis) {
      wc.addClause("and g.minimis = FALSE");
    }
    if(combination) {
      wc.addClause("and subvention = TRUE");
      wc.addClause("and loan = TRUE");
    }
    if(subvention) {
      wc.addClause("and subvention = TRUE");
      wc.addClause("and loan = FALSE");
    }
    if(loan) {
      wc.addClause("and loan = TRUE");
      wc.addClause("and subvention = FALSE");
    }
    if(collaboration) {
      wc.addClause("and g.collaboration = TRUE");
    }
    if(individual) {
      wc.addClause("and g.collaboration = FALSE");
    }
    if(hiring) {
      wc.addClause("and g.hiring = TRUE");
    }
    if(idi) {
      wc.addClause("and g.idi = TRUE");
    }
    if(investment) {
      wc.addClause("and g.investment = TRUE");
    }
    if(startUp) {
      wc.addClause("and g.startUp = TRUE");
    }
    if(micro | small | medium | big) {
      String sep = "";
      wc.addClause("and (");
      if(micro) {
        wc.addClause(sep + "g.micro = TRUE");
        sep = "or ";
      }
      if(small) {
        wc.addClause(sep + "g.small = TRUE");
        sep = "or ";
      }
      if(medium) {
        wc.addClause(sep + "g.medium = TRUE");
        sep = "or ";
      }
      if(big) {
        wc.addClause(sep + "g.big = TRUE");
        sep = "or ";
      }
      wc.addClause(")");
    }
    if(active) {
      wc.addClause("and (g.endDate is null or g.endDate > now())");
    }
    if(ended) {
      wc.addClause("and g.endDate < now()");
    }
    if(recurrent) {
      wc.addClause("and g.recurrent = TRUE");
    }
  }
  
}