PublicationResults.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.publication.zul.www;
 
import java.util.List;
import org.turro.string.Strings;
import org.turro.elephant.db.WhereClause;
import org.turro.publication.db.PublicationPU;
import org.turro.publication.entity.Publication;
 
public class PublicationResults {
 
  private PublicationOrdering ordering;
  private String author;
  private List<String> pathList;
  private long group, category;
 
  public String getAuthor() {
    return author;
  }
 
  public void setAuthor(String author) {
    this.author = author;
  }
 
  public long getCategory() {
    return category;
  }
 
  public void setCategory(long category) {
    this.category = category;
  }
 
  public long getGroup() {
    return group;
  }
 
  public void setGroup(long group) {
    this.group = group;
  }
 
  public PublicationOrdering getOrdering() {
    return ordering;
  }
 
  public void setOrdering(PublicationOrdering ordering) {
    this.ordering = ordering;
  }
 
  public List<String> getPathList() {
    return pathList;
  }
 
  public void setPathList(List<String> pathList) {
    this.pathList = pathList;
  }
 
  public List<Publication> getPublications(int max) {
    WhereClause wc = new WhereClause();
    wc.addClause("select publication from Publication publication");
    wc.addClause("where publication.accepted = true");
    wc.addClause("and publication.publicationGroup.publishable = true");
    wc.addClause("and publication.publicationCategory.publishable = true");
    if(group != 0) {
      wc.addClause("and publication.publicationGroup.id = :group");
      wc.addNamedValue("group", group);
    }
    if(category != 0) {
      wc.addClause("and publication.publicationCategory.id = :category");
      wc.addNamedValue("category", category);
    }
    if(!Strings.isBlank(author)) {
      wc.addClause("and publication.author = :author");
      wc.addNamedValue("author", author);
    }
    if(pathList != null && !pathList.isEmpty()) {
      wc.addClause("and publication.id in (" + convertToIn(pathList) + ")");
    }
    wc.addClause(ordering.getOrderStr());
    return new PublicationPU().getResultList(wc, max);
  }
 
  public String convertToIn(List<String> paths) {
    String result = null;
    for(String s : paths) {
      result = (String) ((result == null) ? s.substring(13) : (result + "," + s.substring(13))); // "/publication/n"
    }
    return result;
  }
  
}