DossierCounter.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2017 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.dossier;
 
import java.io.Serializable;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import org.turro.string.Strings;
import org.turro.dossier.db.DossierPU;
import org.turro.dossier.entity.Category;
import org.turro.dossier.entity.DossierStatus;
import org.turro.dossier.entity.DossierType;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
 
public class DossierCounter implements Serializable {
 
  private final String allowedCategories, types[], status[];
  private final HashMap<Integer, Long> phases = new HashMap<>();
  private final HashMap<String, Long> dossiers = new HashMap<>();
  private final ArrayList<String> categories = new ArrayList<>();
  private final boolean restricted;
 
  public DossierCounter(String allowedCategories, List<String> types, List<String> status, boolean restricted) {
    this.allowedCategories = allowedCategories;
    this.types = types != null ? types.toArray(new String[0]): new String[0];
    this.status = status != null ? status.toArray(new String[0]): new String[0];
    this.restricted = restricted;
  }
 
  public DossierCounter(String allowedCategories, String types[], String status[], boolean restricted) {
    this.allowedCategories = allowedCategories;
    this.types = types;
    this.status = status;
    this.restricted = restricted;
  }
 
  public Long getPhaseCount(int phase) {
    Long value = phases.get(phase);
    if(value == null) {
      value = phaseCount(phase);
      phases.put(phase, value);
    }
    return value;
  }
  
  public Long getDossierCount(String category) {
    Long value = dossiers.get(category);
    if(value == null) {
      value = dossierCount(category);
      dossiers.put(category, value);
    }
    return value;
  }
  
  private Long phaseCount(int phase) {
    Dao dao = new DossierPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select count(distinct d.dossierId) from DWDossier d where 1=1");
    addCriteria(wc, null, phase);
    return (Long) dao.getSingleResult(wc);
  }
  
  private Long dossierCount(String category) {
    Dao dao = new DossierPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select count(distinct d.dossierId) from DWDossier d where 1=1");
    addCriteria(wc, category, -1);
    return (Long) dao.getSingleResult(wc);
  }
 
  private void doCategories() {
    if(!Strings.isBlank(allowedCategories) && !"all".equals(allowedCategories) && categories.isEmpty()) {
      Dao dao = new DossierPU();
      String[] cats = allowedCategories.split(",");
      for(String cat : cats) {
        Category category = dao.find(Category.class, Long.valueOf(cat));
        if(category != null) {
          categories.add(category.getFullDescription());
        }
      }
    }
  }
 
  private void addCriteria(WhereClause wc, String category, int phase) {
    if(!Strings.isBlank(category) && !"all".equals(category)) {
      String par = "cat" + wc.getUniqueSuffix();
      wc.addClause("and d.categoryPath like :" + par);
      wc.addNamedValue(par, category + "%");
    }
    if(!"all".equals(allowedCategories)) {
      doCategories();
      wc.addClause("and (");
      String sep = "";
      for(String cat : categories) {
        String par = "cat" + wc.getUniqueSuffix();
        wc.addClause(sep + "d.categoryPath like :" + par);
        wc.addNamedValue(par, cat + "%");
        sep = "or ";
      }
      wc.addClause(")");
    }
    if(phase > -1) {
      wc.addClause("and d.phase = :phase");
      wc.addNamedValue("phase", phase);
    }
    if(!restricted) {
      wc.addClause("and d.publishable = TRUE");
    }
    if(types != null && types.length > 0) {
      wc.addClause("and (");
      String sep = "";
      for(String type : types) {
        DossierType dt = DossierType.valueOf(type);
        if(dt != null) {
          String par = "type" + wc.getUniqueSuffix();
          wc.addClause(sep + "d.type = :" + par);
          wc.addNamedValue(par, dt);
          sep = "or ";
        }
      }
      wc.addClause(")");
    }
    if(status != null && status.length > 0) {
      wc.addClause("and (");
      String sep = "";
      for(String stat : status) {
        DossierStatus ds = DossierStatus.valueOf(stat);
        if(ds != null) {
          String par = "status" + wc.getUniqueSuffix();
          wc.addClause(sep + "d.status = :" + par);
          wc.addNamedValue(par, ds);
          sep = "or ";
        }
      }
      wc.addClause(")");
    }
  }
 
}