IssueDetailSet.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.issue;
 
import java.util.TreeSet;
import org.turro.attach.db.AttachPU;
import org.turro.attach.entity.Attachment;
import org.turro.commentit.CommentItUtil;
import org.turro.dossier.db.DossierPU;
import org.turro.dossier.entity.Issue;
import org.turro.dossier.entity.IssueComment;
import org.turro.dossier.entity.IssuePredecessor;
import org.turro.jpa.Dao;
import org.turro.sql.SqlClause;
import org.turro.starit.StarItUtil;
import org.turro.voteit.VoteItUtil;
 
public class IssueDetailSet extends TreeSet {
 
  public IssueDetailSet(Issue issue) {
    super(new IssueDetailComparator());
    addDetail(issue);
  }
 
  private void addDetail(Issue issue) {
    String path = DossierPU.getObjectPath(issue);
    Dao dao = new DossierPU();
    addAll(SqlClause.select("c").from("IssueComment c")
            .where().equal("c.issue", issue)
            .dao(dao).resultList(IssueComment.class));
    addAll(SqlClause.select("p").from("IssuePredecessor p")
            .where().notEqual("creation", null)
            .and().group()
            .equal("p.source", issue)
            .or().equal("p.target", issue)
            .endGroup()
            .dao(dao).resultList(IssuePredecessor.class));
    addAll(SqlClause.select("a").from("Attachment a")
            .where().equal("a.path", path)
            .dao(new AttachPU()).resultList(Attachment.class));
    addAll(CommentItUtil.allComments(path));
    addAll(VoteItUtil.allVotes(path));
    addAll(StarItUtil.allStars(path));
  }
 
}