AttachResults.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.attach.search;
 
import java.util.ArrayList;
import org.turro.attach.db.AttachPU;
import org.turro.attach.entity.Attachment;
import org.turro.attach.version.AttachVersionMap;
import org.turro.attach.version.AttachVersionSet;
import org.turro.auth.Authentication;
import org.turro.elephant.context.Application;
import org.turro.elephant.db.SQLHelper;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
import org.turro.plugin.contacts.IContact;
import org.zkoss.lang.Strings;
 
public class AttachResults {
 
  private final Application app = Application.getApplication();
 
  private boolean ckOthers, ckNonValidated = false, ckExactPath, publicOnly = false;
  private String attachValue = "*", attachPath;
  private IContact byParticipant;
 
  public AttachResults() {
  }
 
  public void markAll() {
    attachValue = "*";
    ckOthers = app != null && app.isInRole("attach-show:all");
    ckNonValidated = false;
  }
 
  public boolean isPublicOnly() {
    return publicOnly;
  }
 
  public void setPublicOnly(boolean publicOnly) {
    this.publicOnly = publicOnly;
  }
 
  public java.util.List<Attachment> getAttachmentList() {
    Dao dao = new AttachPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct attachment from Attachment as attachment");
    wc.addClause("where 1=1");
    addCriteria(wc);
    wc.addClause("order by attachment.fileName, attachment.modification DESC");
    return new AttachmentList(dao.getResultList(wc), ckOthers && app!= null && app.isInRole("attach-show:all"));
  }
 
  public java.util.List<Attachment> getVersionedAttachmentList() {
    AttachVersionMap avm = new AttachVersionMap();
    for(Attachment a : getAttachmentList()) {
      avm.addAttachment(a);
    }
    ArrayList<Attachment> list = new ArrayList<>();
    for(AttachVersionSet avs : avm.values()) {
      list.add(avs.first());
    }
    return list;
  }
 
  public java.util.Set<String> getPathList(String currPath) {
    Dao dao = new AttachPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct attachment.path from Attachment as attachment");
    wc.addClause("where 1=1");
    addCriteria(wc);
    wc.addClause("order by attachment.path");
      return new PathSet(dao.getResultList(wc), currPath, ckOthers && app!= null && app.isInRole("attach-show:all"));
  }
 
  public void addCriteria(WhereClause wc) {
 
    if(Strings.isEmpty(attachValue) || (ckOthers && app!= null && !app.isInRole("attach-show:all"))) {
      return;
    }
 
    if(byParticipant == null) {
      byParticipant = Authentication.getIContact();
    }
 
    wc = SQLHelper.getWhereClause(wc, new String[] {
              "attachment.fileName"
              }, (attachValue == null ? "" : attachValue.replaceAll("\\*", "%")));
 
    if(!(ckOthers && app!= null && app.isInRole("attach-show:all")) && byParticipant != null) {
      wc.addClause("and (");
 
      wc.addClause("attachment.onlyOwner = false");
 
      wc.addClause("or");
 
      wc.addClause("(attachment.onlyOwner = true and attachment.owner = :idOwner)");
      wc.addNamedValue("idOwner", byParticipant.getId());
 
      wc.addClause(")");
    }
 
    if(ckNonValidated) {
      wc.addClause("and attachment.validated = false");
    }
    
    if(publicOnly) {
      wc.addClause("and attachment.publishable = true");
    }
 
    if(attachPath != null) {
      wc.addClause("and UCASE(attachment.path) " +
              (ckExactPath ? "=" : "like") +
              " UCASE(:path)");
      wc.addNamedValue("path", attachPath);
    }
  }
 
  public String getAttachPath() {
    return attachPath;
  }
 
  public void setAttachPath(String attachPath) {
    this.attachPath = attachPath;
  }
 
  public String getAttachValue() {
    return attachValue;
  }
 
  public void setAttachValue(String attachValue) {
    this.attachValue = attachValue;
  }
 
  public IContact getByParticipant() {
    return byParticipant;
  }
 
  public void setByParticipant(IContact byParticipant) {
    this.byParticipant = byParticipant;
  }
 
  public boolean isCkExactPath() {
    return ckExactPath;
  }
 
  public void setCkExactPath(boolean ckExactPath) {
    this.ckExactPath = ckExactPath;
  }
 
  public boolean isCkNonValidated() {
    return ckNonValidated;
  }
 
  public void setCkNonValidated(boolean ckNonValidated) {
    this.ckNonValidated = ckNonValidated;
  }
 
  public boolean isCkOthers() {
    return ckOthers;
  }
 
  public void setCkOthers(boolean ckOthers) {
    this.ckOthers = ckOthers;
  }
 
  public static long getCountAttachments(String root) {
    Dao dao = new AttachPU();
    return (Long) dao.getSingleResult(
              " select count(attachment) " +
              " from Attachment as attachment" +
              " where attachment.path like '" + root + "/%'");
  }
}