GrantMatchCriteria.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.entity;
 
import java.io.Serializable;
import java.util.Collections;
import java.util.List;
import javax.persistence.Embeddable;
import org.turro.dossier.db.DossierPU;
import org.turro.elephant.db.WhereClause;
import org.turro.entities.Entities;
import org.turro.entities.EntityListAdapter;
import org.turro.entities.IElephantEntity;
import org.turro.path.Path;
import org.turro.tags.Tags;
 
@Embeddable
public class GrantMatchCriteria implements Serializable {
  
  private boolean hiring, idi, investment, startUp, formation;
 
  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 isFormation() {
    return formation;
  }
 
  public void setFormation(boolean formation) {
    this.formation = formation;
  }
  
  /* Helpers */
  
  public boolean isEmpty() {
    return !(hiring | idi | investment | startUp);
  }
  
  public List<IElephantEntity> getMatchingsFor(Object entity) {
    if(isEmpty()) return Collections.EMPTY_LIST;
    return getMatchingsFor(Entities.getController(entity).getPath());
  }
  
  public List<IElephantEntity> getMatchingsFor(String entityPath) {
    if(isEmpty()) return Collections.EMPTY_LIST;
    Path path = Path.pathFrom(entityPath);
    if("dossier".equals(path.getRoot())) {
      return getMatchingsForDossier(path.getNodeAs(1, Long.class));
    } else if("project-grant".equals(path.getRoot())) {
      return getMatchingsForProjectGrant(path.getNodeAs(1, Long.class));
    }
    return Collections.EMPTY_LIST;
  }
 
  public List<IElephantEntity> getMatchingsForDossier(Long dossierId) {
    WhereClause wc = new WhereClause();
    wc.addClause("select e from ProjectGrant e");
    wc.addClause("where (e.recurrent = TRUE or (e.endDate is null or e.endDate > now()))");
    addMatchCheck(wc);
    addEmptyCheck(wc);
    addTagIds(wc, "e.id", "/dossier/" + dossierId, "project-grant");
    return new EntityListAdapter(new DossierPU().getResultList(wc));
  }
 
  public List<IElephantEntity> getMatchingsForProjectGrant(Long projectGrantId) {
    WhereClause wc = new WhereClause();
    wc.addClause("select d from Dossier d");
    wc.addClause("join d.project e");
    wc.addClause("where 1=1");
    addMatchCheck(wc);
    addEmptyCheck(wc);
    addTagIds(wc, "d.id", "/project-grant/" + projectGrantId, "dossier");
    return new EntityListAdapter(new DossierPU().getResultList(wc));
  }
 
  private void addMatchCheck(WhereClause wc) {
    if(isEmpty()) {
      wc.addClause("and 1=2");
      return;
    }
    wc.addClause("and (");
    String sep = "";
    if(hiring) {
      wc.addClause(sep);
      wc.addClause("e.matchCriteria.hiring = :hiring");
      wc.addNamedValue("hiring", hiring);
      sep = "or";
    }
    if(idi) {
      wc.addClause(sep);
      wc.addClause("e.matchCriteria.idi = :idi");
      wc.addNamedValue("idi", idi);
      sep = "or";
    }
    if(investment) {
      wc.addClause(sep);
      wc.addClause("e.matchCriteria.investment = :investment");
      wc.addNamedValue("investment", investment);
      sep = "or";
    }
    if(startUp) {
      wc.addClause(sep);
      wc.addClause("e.matchCriteria.startUp = :startUp");
      wc.addNamedValue("startUp", startUp);
      sep = "or";
    }
    if(startUp) {
      wc.addClause(sep);
      wc.addClause("e.matchCriteria.formation = :formation");
      wc.addNamedValue("formation", formation);
      sep = "or";
    }
    wc.addClause(")");
  }
 
  private void addEmptyCheck(WhereClause wc) {
    wc.addClause("and (e.matchCriteria.hiring = TRUE");
    wc.addClause("or e.matchCriteria.idi = TRUE");
    wc.addClause("or e.matchCriteria.investment = TRUE");
    wc.addClause("or e.matchCriteria.startUp = TRUE");
    wc.addClause("or e.matchCriteria.formation = TRUE)");
  }
 
  private void addTagIds(WhereClause wc, String field, String source, String rootTarget) {
    List<Long> ids = Tags.getCommonLongIdentifiers(source, rootTarget);
    if(ids != null && !ids.isEmpty()) {
      wc.addIn("and", field, ids);
    }
  }
  
}