Grouped.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2014 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.contacts;
 
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Collection;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.ManyToOne;
import org.turro.string.Strings;
import org.turro.contacts.db.ContactsPU;
import org.turro.elephant.db.WhereClause;
import org.turro.entities.Entities;
import org.turro.jpa.Dao;
 
@Entity
@org.hibernate.annotations.GenericGenerator(name = "hibernate-uuid", strategy = "uuid")
public class Grouped implements Serializable {
 
  @Id
  @GeneratedValue(generator = "hibernate-uuid")
  @Column(name="IDENTIFIER")
  private String id;
 
  @ManyToOne
  private GroupIt parent;
 
  @Column(name="GROUPED_PATH")
  private String path;
 
  public String getId() {
    return id;
  }
 
  public void setId(String id) {
    this.id = id;
  }
 
  public GroupIt getParent() {
    return parent;
  }
 
  public void setParent(GroupIt parent) {
    this.parent = parent;
  }
 
  public String getPath() {
    return path;
  }
 
  public void setPath(String path) {
    this.path = path;
  }
  
  /* Helpers */
  
  private transient String category;
 
  public String getCategory() {
    if(category == null && parent != null) {
      category = parent.getCategory();
    }
    return category;
  }
 
  public void setCategory(String category) {
    this.category = category;
  }
  
  public boolean isValid() {
    return parent != null &&
           !Strings.isBlank(path);
  }
  
  public static Collection<Grouped> groups(Object entity, String category) {
    String path = Entities.getController(entity).getPath();
    if(path != null) {
      return groups(path, category);
    }
    return new ArrayList<>();
  }
 
  public static Collection<Grouped> groups(String path, String category) {
    Dao dao = new ContactsPU();
    return dao.getResultList(
            " select g from Grouped g " +
            " where g.parent.category = ? " +
            " and g.path = ? " +
            " order by g.parent.category, g.parent.name ",
            new Object[] { category, path }
            );
  }
  
  public static Collection<Grouped> groups(Object entity) {
    String path = Entities.getController(entity).getPath();
    if(path != null) {
      return groups(path);
    }
    return new ArrayList<>();
  }
 
  public static Collection<Grouped> groups(String path) {
    Dao dao = new ContactsPU();
    return dao.getResultList(
            " select g from Grouped g " +
            " where g.path = ? " +
            " order by g.parent.category, g.parent.name ",
            new Object[] { path }
            );
  }
  
  public static Collection<String> paths(String path, String selectedGroup, String selectedCategory, boolean exact) {
    Dao dao = new ContactsPU();
    WhereClause wc = new WhereClause();
    wc.addClause("select g.path from Grouped g");
    wc.addClause("where g.path like :path");
    wc.addNamedValue("path", path + "/%");
    if(Strings.isBlank(selectedGroup)) {
      selectedGroup = "";
    }
    if(exact) {
      wc.addClause("and g.parent.pathName = :pathName01");
      wc.addNamedValue("pathName01", selectedGroup);
    } else {
      wc.addClause("and (g.parent.pathName = :pathName01 or g.parent.pathName like :pathName02)");
      wc.addNamedValue("pathName01", selectedGroup);
      wc.addNamedValue("pathName02", selectedGroup + "%");
    }
    wc.addClause("and g.parent.category = :category");
    wc.addNamedValue("category", selectedCategory);
    return dao.getResultList(wc);
  }
  
  public static Collection<String> pathsFromCategory(String path, String category) {
    Dao dao = new ContactsPU();
    return dao.getResultList(
            " select g.path from Grouped g " +
            " where g.path like ? " +
            " and g.parent.category = ?",
            new Object[] { path + "/%", category }
            );
  }
  
}