VoteItUtil.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2013 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.voteit;
 
import java.util.Collection;
import java.util.Date;
import java.util.List;
import org.amic.util.date.CheckDate;
import org.turro.string.Strings;
import org.turro.contacts.Contact;
import org.turro.contacts.VoteIt;
import org.turro.contacts.db.ContactsPU;
import org.turro.entities.Entities;
import org.turro.jpa.Dao;
import org.turro.log.SystemLogType;
import org.turro.log.SystemLogger;
import org.turro.plugin.contacts.IContact;
 
public class VoteItUtil {
 
  public static void addVote(Object entity, int vote, IContact contact) {
    String path = Entities.getController(entity).getPath();
    if(path != null) {
      addVote(path, vote, contact);
    }
  }
  
  public static void addVote(String path, int vote, IContact contact) {
    if(!Strings.isBlank(path) && contact != null && contact.isValid()) {
      Dao dao = new ContactsPU();
      if(((Long) dao.getSingleResult(
            " select count(*) from VoteIt " +
            " where path = ? " +
            " and creator = ?",
            new Object[] { path, contact.getContact() }
            )) == 0) {
        VoteIt voteIt = new VoteIt();
        voteIt.setCreator((Contact) contact.getContact());
        voteIt.setDateCreation(new Date());
        voteIt.setVote(vote);
        voteIt.setPath(path);
        dao.saveObject(voteIt);
        SystemLogger.getInstance().doLog(SystemLogType.LOG_INFO, contact, path, "vote-it", vote + "");
      } else {
        changeVote(path, vote, contact);
      }
    }
  }
 
  public static void removeVote(Object entity, IContact contact) {
    String path = Entities.getController(entity).getPath();
    if(path != null) {
      removeVote(path, contact);
    }
  }
  
  public static void removeVote(String path, IContact contact) {
    if(!Strings.isBlank(path) && contact != null && contact.isValid()) {
      Dao dao = new ContactsPU();
      dao.executeUpdate(
              " delete from VoteIt " +
              " where path = ? " +
              " and creator = ?",
              new Object[] { path, contact.getContact() }
              );
      SystemLogger.getInstance().doLog(SystemLogType.LOG_INFO, contact, path, "vote-it", "deleted");
    }
  }
 
  public static void changeVote(Object entity, int newVote, IContact contact) {
    String path = Entities.getController(entity).getPath();
    if(path != null) {
      changeVote(path, newVote, contact);
    }
  }
  
  public static void changeVote(String path, int newVote, IContact contact) {
    if(!Strings.isBlank(path) && contact != null && contact.isValid()) {
      Dao dao = new ContactsPU();
      dao.executeUpdate(
              " update VoteIt " +
              " set vote = ? " +
              " where path = ? " +
              " and creator = ?",
              new Object[] { newVote, path, contact.getContact() }
              );
      SystemLogger.getInstance().doLog(SystemLogType.LOG_INFO, contact, path, "vote-it", newVote + "");
    }
  }
 
  public static VoteItInfo info(Object entity, IContact contact) {
    return info(entity, null, contact);
  }
  
  public static VoteItInfo info(Object entity, String allowed, IContact contact) {
    String path = Entities.getController(entity).getPath();
    if(path != null) {
      return info(path, allowed, contact);
    }
    return null;
  }
  
  public static VoteItInfo info(String path, IContact contact) {
    return info(path, null, contact);
  }
  
  public static VoteItInfo info(String path, String allowed, IContact contact) {
    VoteItInfo vi = new VoteItInfo();
    Dao dao = new ContactsPU();
    vi.setPositive((Long) dao.getSingleResult(
            " select count(vote) from VoteIt " +
            " where path = ? and vote > 0 " + 
            getAllowedString(allowed),
            new Object[] { path }
            ));
    vi.setNocare((Long) dao.getSingleResult(
            " select count(vote) from VoteIt " +
            " where path = ? and vote = 0 " + 
            getAllowedString(allowed),
            new Object[] { path }
            ));
    vi.setNegative((Long) dao.getSingleResult(
            " select count(vote) from VoteIt " +
            " where path = ? and vote < 0 " + 
            getAllowedString(allowed),
            new Object[] { path }
            ));
    if(contact != null) {
      vi.setMyVote(myVote(dao, path, contact));
    }
    return vi;
  }
  
  public static MyVote myVote(String path, IContact contact) {
    Dao dao = new ContactsPU();
    if(!Strings.isBlank(path) && contact != null && contact.isValid()) {
      VoteIt vi = (VoteIt) dao.getSingleResultOrNull(
              " select vi from VoteIt as vi " +
              " where path = ? and creator = ?",
              new Object[] { path, contact.getContact() }
              );
      if(vi != null) {
        return new MyVote(contact, vi.getVote());
      }
    }
    return null;
  }
 
  public static MyVote myVote(Dao dao, String path, IContact contact) {
    if(!Strings.isBlank(path) && contact != null && contact.isValid()) {
      VoteIt vi = (VoteIt) dao.getSingleResultOrNull(
              " select vi from VoteIt as vi " +
              " where path = ? and creator = ?",
              new Object[] { path, contact.getContact() }
              );
      if(vi != null) {
        return new MyVote(contact, vi.getVote());
      }
    }
    return null;
  }
 
  public static List<VoteIt> allVotes(String path) {
    Dao dao = new ContactsPU();
    return dao.getResultList(
            " select vi from VoteIt as vi " +
            " where vi.path = ?",
            new Object[] { path }
            );
  }
 
  public static String getAllowedString(String allowed) {
    if(allowed == null) {
      return "";
    } else {
      if(Strings.isBlank(allowed)) {
        return " and 1 = 2 ";
      } else {
        return " and creator.id in (" + allowed + ")";
      }
    }
  }
  
  public static Collection<String> paths(String path, int fromDays) {
    Dao dao = new ContactsPU();
    return dao.getResultList(
            " select g.path from VoteIt g " +
            " where g.path like ? " +
            " and g.dateCreation >= ?",
            new Object[] { path + "/%", new CheckDate().addDays(-fromDays).getDate() }
            );
  }
 
  private VoteItUtil() {
  }
 
}