WorksheetUtil.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2015 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.dossier.util;
 
import java.util.ArrayList;
import java.util.Collection;
import java.util.Iterator;
import java.util.List;
import java.util.Objects;
import org.turro.string.Strings;
import org.turro.dossier.db.DossierPU;
import org.turro.dossier.entity.Issue;
import org.turro.dossier.entity.IssueParticipantRole;
import org.turro.dossier.entity.IssueStatus;
import org.turro.dossier.entity.Worksheet;
import org.turro.dossier.issue.IssueWrapper;
import org.turro.dossier.search.IssueResults;
import org.turro.jpa.Dao;
import org.turro.plugin.contacts.IContact;
 
public class WorksheetUtil {
  
  public static Collection<Worksheet> getWorksheet(String idContact) {
    Dao dao = new DossierPU();
    return dao.getResultList(
            "select w from Worksheet as w " +
            "where w.idContact = ? " +
            "order by w.sheetOrder",
            new Object[] { idContact });
  }
 
  public static Collection<Issue> getIssues(String idContact, String searchValue) {
    Dao dao = new DossierPU();
    if(!Strings.isBlank(searchValue)) {
      return dao.getResultList(
              "select w.issue from Worksheet as w " +
              "where w.idContact = ? " +
              "and w.issue.description like ? " +
              "order by w.sheetOrder",
              new Object[] { idContact, "%" + searchValue + "%" });
    } else {
      return dao.getResultList(
              "select w.issue from Worksheet as w " +
              "where w.idContact = ? " +
              "order by w.sheetOrder",
              new Object[] { idContact });
    }
  }
 
  public static List<IssueWrapper> getIssueWrappersForNow(IContact contact, String searchValue) {
    ArrayList<IssueWrapper> list = new ArrayList<>();
    for(Issue issue : getIssues(contact.getId(), searchValue)) {
      IssueWrapper iw = new IssueWrapper(issue, contact);
      list.add(iw);
    }
    return list;
  }
 
  public static List<IssueWrapper> getIssueWrappers(IContact contact, String searchValue) {
    ArrayList<IssueWrapper> list = new ArrayList<>();
    for(Issue issue : getIssues(contact.getId(), searchValue)) {
      IssueWrapper iw = new IssueWrapper(issue, contact);
      list.add(iw);
    }
    return list;
  }
 
  public static Collection<IssueWrapper> getNotIn(IContact contact, Collection<IssueWrapper> listws) {
    ArrayList<IssueWrapper> list = new ArrayList<>();
    if(contact.isValid()) {
      IssueResults results = new IssueResults();
      results.setByParticipant(contact);
      results.setDossierId(0L);
      for(IssueWrapper iw : results.getIssueList()) {
        if(iw.getRelevanceOrderByContact() == 1) {
          boolean exists = false;
          for(IssueWrapper liw : listws) {
            if(Objects.equals(liw.getIssue().getId(), iw.getIssue().getId())) {
              exists = true;
              break;
            }
          }
          if(!exists) {
            list.add(iw);
          }
        }
      }
    }
    return list;
  }
  
  public static void removeWorksheet(String idContact) {
    Dao dao = new DossierPU();
    dao.executeUpdate(
            "delete from Worksheet " +
            "where idContact = ? ",
            new Object[] { idContact });
  }
 
  public static void removeWorksheet(Long idIssue) {
    Dao dao = new DossierPU();
    dao.executeUpdate(
            "delete from Worksheet " +
            "where issue.id = ? ",
            new Object[] { idIssue });
  }
 
  public static Collection<String> getResponsibles() {
    Dao dao = new DossierPU();
    return dao.getResultList(
            "select p.idContact from IssueParticipant as p " +
            "where p.role = ? " +
            "and p.issue.status <> ?",
            new Object[] { IssueParticipantRole.ISSUE_RESPONSIBLE, IssueStatus.STATUS_CLOSED });
  }
 
  public static boolean cleared(Worksheet worksheet, IContact contact) {
    Dao dao = new DossierPU();
    if(isDone(worksheet, contact)) {
      dao.deleteObject(worksheet);
      return true;
    }
    return false;
  }
 
  public static void clearDone(List<Worksheet> list, IContact contact) {
    Dao dao = new DossierPU();
    Iterator<Worksheet> it = list.iterator();
    while(it.hasNext()) {
      Worksheet worksheet = it.next();
      if(isDone(worksheet, contact)) {
        dao.deleteObject(worksheet);
        it.remove();
      }
    }
  }
 
  private static boolean isDone(Worksheet worksheet, IContact contact) {
    IssueWrapper iw = new IssueWrapper(worksheet.getIssue(), contact);
    return iw.getRelevanceOrderByContact() != 1;
  }
 
  private WorksheetUtil() {
  }
 
}