AttachHeadlessResults.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 org.turro.attach.db.AttachPU;
import org.turro.attach.entity.Attachment;
import org.turro.elephant.db.SQLHelper;
import org.turro.elephant.db.WhereClause;
import org.turro.jpa.Dao;
import org.zkoss.lang.Strings;
 
public class AttachHeadlessResults {
 
  private boolean ckNonValidated = false, ckExactPath;
  private String attachValue = "*", attachPath;
 
  public AttachHeadlessResults() {
  }
 
  public void markAll() {
    attachValue = "*";
    ckNonValidated = false;
  }
 
  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), true);
  }
 
  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, true);
  }
 
  public void addCriteria(WhereClause wc) {
 
    if(Strings.isEmpty(attachValue)) {
      return;
    }
 
    wc = SQLHelper.getWhereClause(wc, new String[] {
              "attachment.fileName"
              }, (attachValue == null ? "" : attachValue.replaceAll("\\*", "%")));
 
    if(ckNonValidated) {
      wc.addClause("and attachment.validated = false");
    }
 
    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 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 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 + "/%'");
  }
  
}