IssueResults.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.dossier.search;
 
import java.util.*;
import org.turro.action.Contacts;
import org.turro.auth.Authentication;
import org.turro.dossier.db.DossierPU;
import org.turro.dossier.entity.*;
import org.turro.dossier.issue.IssueSet;
import org.turro.dossier.issue.IssueWrapper;
import org.turro.elephant.context.Application;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
import org.turro.plugin.contacts.IContact;
import org.turro.util.Chars;
import org.zkoss.lang.Strings;
 
public class IssueResults {
 
  private Application app = Application.getApplication();
 
  private String issueValue = "*";
  private boolean 
          ckStartPosible = false,
          ckOthers = false;
  private IContact byParticipant, byResponsible, byReporter, byQA;
  private Long dossierId;
  private Dossier dossier;
  private Set<IssueParticipantRole> roles = new HashSet<IssueParticipantRole>();
  private Set<IssueStatus> status = new HashSet<IssueStatus>();
  private Set<IssueResolution> resolutions = new HashSet<IssueResolution>();
  private Set<IssueType> types = new HashSet<IssueType>();
  private Category category;
  private IContact subject;
 
  public IssueResults() {
    roles.addAll(Arrays.asList(IssueParticipantRole.values()));
    types.addAll(Arrays.asList(IssueType.values()));
    status.addAll(Arrays.asList(IssueStatus.values()));
    status.remove(IssueStatus.STATUS_CLOSED);
    resolutions.addAll(Arrays.asList(IssueResolution.values()));
  }
 
  public void setApplication(Application app) {
    this.app = app;
  }
 
  public void markAll() {
    ckStartPosible = true;
 
    ckOthers = app.isInRole("issue:all");
 
    roles.addAll(Arrays.asList(IssueParticipantRole.values()));
    types.addAll(Arrays.asList(IssueType.values()));
    status.addAll(Arrays.asList(IssueStatus.values()));
    resolutions.addAll(Arrays.asList(IssueResolution.values()));
  }
  
  public long getIssueCount() {
    Dao dao = new DossierPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select count(distinct issue) from Issue as issue");
    wc.addClause("left outer join issue.participants participant");
    wc.addClause("left outer join issue.comments comment");
    wc.addClause("where 1=1");
    addCriteria(wc);
    return (Long) dao.getSingleResult(wc);
  }
 
  public java.util.List<IssueWrapper> getIssueList() {
    Dao dao = new DossierPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct issue from Issue as issue");
    wc.addClause("left outer join issue.participants participant");
    wc.addClause("left outer join issue.comments comment");
    wc.addClause("where 1=1");
    addCriteria(wc);
    addClause(wc);
    return new ArrayList(new IssueSet(dao.getResultList(wc), ckStartPosible, byParticipant));
  }
 
  public Category getCategory() {
    return category;
  }
 
  public void setCategory(Category category) {
    this.category = category;
  }
 
  public Set<IssueResolution> getResolutions() {
    return resolutions;
  }
 
  public void setResolutions(Set<IssueResolution> resolutions) {
    this.resolutions = resolutions;
  }
 
  public Set<IssueParticipantRole> getRoles() {
    return roles;
  }
 
  public void setRoles(Set<IssueParticipantRole> roles) {
    this.roles = roles;
  }
 
  public Set<IssueStatus> getStatus() {
    return status;
  }
 
  public void setStatus(Set<IssueStatus> status) {
    this.status = status;
  }
 
  public IContact getSubject() {
    return subject;
  }
 
  public void setSubject(IContact subject) {
    this.subject = subject;
  }
 
  public Set<IssueType> getTypes() {
    return types;
  }
 
  public void setTypes(Set<IssueType> types) {
    this.types = types;
  }
 
  public void setType(IssueType type) {
    this.types = EnumSet.of(type);
  }
 
  public void addCriteria(WhereClause wc) {
    boolean asParticipant = 
            roles.contains(IssueParticipantRole.ISSUE_REPORTER) ||
            roles.contains(IssueParticipantRole.ISSUE_RESPONSIBLE) ||
            roles.contains(IssueParticipantRole.ISSUE_QA) ||
            roles.contains(IssueParticipantRole.ISSUE_ASSISTANT);
 
    if(Strings.isEmpty(issueValue) || (!asParticipant && !app.isInRole("issue:all"))) {
      wc.addClause("and 1=0");
      return;
    }
 
    if(byParticipant == null) {
      byParticipant = Authentication.getIContact();
    }
 
    long id = 0;
    try {
      id = Long.valueOf(issueValue);
      if(id > 0) {
        wc.addClause("and ((issue.id = :id)");
        wc.addNamedValue("id", id);
        wc.setPrefix("or");
      }
    } catch(Exception ex) {}
 
    wc.addLikeFields(new String[] {
              "issue.description",
              "comment.comment"
              }, (issueValue == null ? "" : issueValue.replaceAll("\\*", "%")));
 
    if(id > 0) {
      wc.addClause(")");
      wc.setPrefix(null);
    }
 
    if(ckStartPosible) {
      wc.addClause("and (issue.startDate >= :startDate or issue.startDate is null)");
      wc.addNamedValue("startDate", new Date());
    }
    
    if(asParticipant && !(ckOthers && app.isInRole("issue:all"))) {
      String sep = "";
      wc.addClause("and (");
      for(IssueParticipantRole ii : IssueParticipantRole.values()) {
        if(roles.contains(ii)) {
          wc.addClause(sep);
          sep = "or";
          wc.addClause("(");
          wc.addClause("participant.idContact = :idContact");
          wc.addNamedValue("idContact", byParticipant.getId());
          wc.addClause("and participant.role = :" + ii.toString());
          wc.addNamedValue(ii.toString(), ii);
          wc.addClause(")");
        }
      }
      wc.addClause(")");
    }
    
    if(byResponsible != null && byResponsible.getId() != null) {
      wc.addClause("and (");
      wc.addClause("participant.idContact = :idRes");
      wc.addNamedValue("idRes", byResponsible.getId());
      wc.addClause("and participant.role = :byRes");
      wc.addNamedValue("byRes", IssueParticipantRole.ISSUE_RESPONSIBLE);
      wc.addClause(")");
    }
 
    if(byReporter != null && byReporter.getId() != null) {
      wc.addClause("and (");
      wc.addClause("participant.idContact = :idInf");
      wc.addNamedValue("idInf", byReporter.getId());
      wc.addClause("and participant.role = :byInf");
      wc.addNamedValue("byInf", IssueParticipantRole.ISSUE_REPORTER);
      wc.addClause(")");
    }
 
    if(byQA != null && byQA.getId() != null) {
      wc.addClause("and (");
      wc.addClause("participant.idContact = :idQA");
      wc.addNamedValue("idQA", byQA.getId());
      wc.addClause("and participant.role = :byQA");
      wc.addNamedValue("byQA", IssueParticipantRole.ISSUE_QA);
      wc.addClause(")");
    }
 
    String sep = "";
    wc.addClause("and (");
    for(IssueStatus ii : IssueStatus.values()) {
      if(status.contains(ii)) {
        wc.addClause(sep);
        sep = "or";
        wc.addClause("issue.status = :" + ii.toString());
        wc.addNamedValue(ii.toString(), ii);
      }
    }
    wc.addClause(")");
    
    sep = "";
    wc.addClause("and (");
    for(IssueResolution ii : IssueResolution.values()) {
      if(resolutions.contains(ii)) {
        wc.addClause(sep);
        sep = "or";
        wc.addClause("issue.resolution = :" + ii.toString());
        wc.addNamedValue(ii.toString(), ii);
      }
    }
    wc.addClause(")");
 
    sep = "";
    wc.addClause("and (");
    for(IssueType ii : IssueType.values()) {
      if(types.contains(ii)) {
        wc.addClause(sep);
        sep = "or";
        wc.addClause("issue.type = :" + ii.toString());
        wc.addNamedValue(ii.toString(), ii);
      }
    }
    wc.addClause(")");
 
    if(subject != null) {
      wc.addClause("and exists ( select subject from Participant as subject");
      wc.addClause("where subject.dossier = issue.dossier");
      wc.addClause("and subject.idContact = :idSubject");
      wc.addNamedValue("idSubject", subject.getId());
      wc.addClause("and subject.role = :roleSubject )");
      wc.addNamedValue("roleSubject", ParticipantRole.PARTICIPANT_SUBJECT);
    }
 
    if(dossier != null) {
      wc.addClause("and issue.dossier = :dossier");
      wc.addNamedValue("dossier", dossier);
    } else if(dossierId != null && dossierId > 0) {
      wc.addClause("and issue.dossier.id = :dossierId");
      wc.addNamedValue("dossierId", dossierId);
    } else {
      wc.addClause("and issue.dossier.status = :dstatus");
      wc.addNamedValue("dstatus", DossierStatus.DOSSIER_OPENED);
    }
    
    if(category != null) {
      wc.addClause("and (issue.dossier.category.fullDescription = :decat");
      wc.addNamedValue("decat", category.getFullDescription());
      wc.addClause("or issue.dossier.category.fullDescription like :dlcat)");
      wc.addNamedValue("dlcat", category.getFullDescription() + Chars.backward().spaced() + "%");
      //DossierResults.addExistsCategoryAffiliance(wc, category, "issue.dossier");
    }
 
  }
 
  public boolean isCkOthers() {
    return ckOthers;
  }
 
  public void setCkOthers(boolean ckOthers) {
    this.ckOthers = ckOthers;
  }
 
  public boolean isCkStartPosible() {
    return ckStartPosible;
  }
 
  public void setCkStartPosible(boolean ckStartPosible) {
    this.ckStartPosible = ckStartPosible;
  }
 
  public Dossier getDossier() {
    return dossier;
  }
 
  public void setDossier(Dossier dossier) {
    this.dossier = dossier;
  }
 
  public Long getDossierId() {
    return dossierId;
  }
 
  public void setDossierId(Long dossierId) {
    this.dossierId = dossierId;
  }
 
  public String getIssueValue() {
    return issueValue;
  }
 
  public void setIssueValue(String issueValue) {
    this.issueValue = issueValue;
  }
 
  public IContact getByQA() {
    return byQA;
  }
 
  public void setByQA(IContact byQA) {
    this.byQA = byQA;
  }
 
  public IContact getByResponsible() {
    return byResponsible;
  }
 
  public void setByResponsible(IContact byResponsible) {
    this.byResponsible = byResponsible;
  }
 
  public IContact getByReporter() {
    return byReporter;
  }
 
  public void setByReporter(IContact byReporter) {
    this.byReporter = byReporter;
  }
 
  public IContact getByParticipant() {
    return byParticipant;
  }
 
  public void setByParticipant(IContact byParticipant) {
    this.byParticipant = byParticipant;
  }
 
  public void setByParticipantId(String id) {
    this.byParticipant = Contacts.getContactById(id);
  }
 
  protected void addClause(WhereClause wc) {
    // Do nothing
  }
  
}