FieldItUtil.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.fieldit;
 
import java.util.Collection;
import java.util.Date;
import java.util.List;
import org.turro.string.Strings;
import org.turro.contacts.FieldIt;
import org.turro.contacts.ValueIt;
import org.turro.contacts.db.ContactsPU;
import org.turro.entities.Entities;
import org.turro.i18n.I_;
import org.turro.jpa.Dao;
import org.turro.path.Path;
 
public class FieldItUtil {
  
  public static FieldItSet fields(Object entity) {
    String path = Entities.getController(entity).getPath();
    if(path != null) {
      return fields(path);
    }
    return new FieldItSet();
  }
  
  public static FieldItSet fields(String path) {
    Dao dao = new ContactsPU();
    List l = dao.getResultList(
            " select v from FieldIt v " +
            " where path = ?",
            new Object[] { path }
            );
    FieldItSet fis = new FieldItSet();
    fis.addAll(l);
    return fis;
  }
 
  public static ValueItSet values(Object entity) {
    String path = Entities.getController(entity).getPath();
    if(path != null) {
      return values(path);
    }
    return new ValueItSet();
  }
  
  public static ValueItSet values(String path) {
    Dao dao = new ContactsPU();
    List l = dao.getResultList(
            " select v from ValueIt v " +
            " where path = ?",
            new Object[] { path }
            );
    ValueItSet vis = new ValueItSet();
    vis.addAll(l);
    return vis;
  }
  
  public static ValueIt value(FieldIt field, String path) {
    Dao dao = new ContactsPU();
    ValueIt vi = (ValueIt) dao.getSingleResultOrNull(
            " select v from ValueIt v " +
            " where path = ? and v.fieldIt = ? ",
            new Object[] { path, field }
            );
    if(vi == null) {
      vi = field.createValue();
      vi.setPath(path);
    }
    return vi;
  }
  
  public static ValueIt value(String field, String path) {
    Dao dao = new ContactsPU();
    ValueIt vi = (ValueIt) dao.getSingleResultOrNull(
            " select v from ValueIt v " +
            " where path = ? and v.fieldIt.name = ? ",
            new Object[] { path, field }
            );
    return vi;
  }
  
  public static String getLabel(Class javaClass) {
    if(String.class.equals(javaClass)) {
      return I_.get("String");
    } else if(Long.class.equals(javaClass)) {
      return I_.get("Long integer");
    } else if(Double.class.equals(javaClass)) {
      return I_.get("Double");
    } else if(Date.class.equals(javaClass)) {
      return I_.get("Date");
    } else if(Boolean.class.equals(javaClass)) {
      return I_.get("Boolean");
    } else if(StringList.class.equals(javaClass)) {
      return I_.get("String list");
    } else if(AutoFillList.class.equals(javaClass)) {
      return I_.get("Auto fill list");
    }
    return null;
  }
  
  public static void delete(FieldIt field) {
    Dao dao = new ContactsPU();
    dao.executeUpdate("delete from ValueIt where fieldIt = ?", new Object[] { field });
    dao.deleteObject(field);
  }
  
  public static void saveValues(Collection<ValueIt> values) {
    Dao dao = new ContactsPU();
    for(ValueIt v : values) {
      if(v.isValid()) {
        dao.saveObject(v);
      } else if(!Strings.isBlank(v.getId())) {
        dao.deleteObject(v);
      }
    }
  }
 
  //TODO: Related entities
  public static Collection<String> related(String path) {
    Path p = new Path(path);
    Dao dao = new ContactsPU();
    return dao.getResultList(
            " select v.path from ValueIt v " +
            " where path <> ? " +
            " and path like ? " +
            " and exists ( " +
            "   select v2 from  " +
            " )",
            new Object[] { path, p.getRoot() + "/" }
            );
  }
 
  //TODO: Search on entities
  public static Collection<String> search(String path, String value) {
    Path p = new Path(path);
    Dao dao = new ContactsPU();
    return dao.getResultList(
            " select v.path from ValueIt v " +
            " where path like ? " +
            " and v.value like ? ",
            new Object[] { p.getRoot() + "/", value }
            );
  }
 
  public static Object getFieldValue(String label, String entityPath) {
    ValueIt value = FieldItUtil.value(label, entityPath);
    if(value != null) {
      Object v = value.getObjectValue();
      return v == null ? "" : v;
    }
    return "";
  }
 
  private FieldItUtil() {
  }
}