RegistryResults.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.Date;
import org.turro.contacts.Contact;
import org.turro.dossier.db.DossierPU;
import org.turro.dossier.entity.Dossier;
import org.turro.dossier.entity.ParticipantRole;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
 
public class RegistryResults {
 
  private boolean ckRegistered = false;
  private Contact subject;
  private Dossier dossier;
  private Date fromDate = new Date(new Date().getTime() - (90L * 24L * 60L * 60L * 1000L));
  
  public RegistryResults() {
  }
  
  public java.util.List getRegistryList() {
    Dao dao = new DossierPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct comment from IssueComment as comment");
    wc.addClause("left join comment.issue.dossier.participants participant");
    wc.addClause("where (comment.expenses <> 0 or comment.hours <> 0 or comment.price <> 0)");
    addCriteria(wc);
    wc.addClause("order by comment.modification");
    return dao.getResultList(wc);
  }
 
  public void addCriteria(WhereClause wc) {
    if(subject == null && dossier == null) {
      wc.addClause("and 1=0");
      return;
    }
 
    wc.addClause("and comment.processed = :processed");
    wc.addNamedValue("processed", ckRegistered);
    
    if(fromDate != null) {
      wc.addClause("and comment.modification >= :modification");
      wc.addNamedValue("modification", fromDate);
    }
    
    if(subject != null) {
      wc.addClause("and (");
      wc.addClause("participant.idContact = :idContact");
      wc.addNamedValue("idContact", subject.getId());
      wc.addClause("and participant.role = :role");
      wc.addNamedValue("role", ParticipantRole.PARTICIPANT_SUBJECT);
      wc.addClause(")");
    } else if(dossier != null) {
      wc.addClause("and comment.issue.dossier = :dossier");
      wc.addNamedValue("dossier", dossier);
    }
  }
 
  public boolean isCkRegistered() {
    return ckRegistered;
  }
 
  public void setCkRegistered(boolean ckRegistered) {
    this.ckRegistered = ckRegistered;
  }
 
  public Dossier getDossier() {
    return dossier;
  }
 
  public void setDossier(Dossier dossier) {
    this.dossier = dossier;
  }
 
  public Date getFromDate() {
    return fromDate;
  }
 
  public void setFromDate(Date fromDate) {
    this.fromDate = fromDate;
  }
 
  public Contact getSubject() {
    return subject;
  }
 
  public void setSubject(Contact subject) {
    this.subject = subject;
  }
 
}