org.turro.dossier.util.WorksheetUtil Class Reference

Static Public Member Functions
static Collection< Worksheet >	getWorksheet (String idContact)
static Collection< Issue >	getIssues (String idContact, String searchValue)
static List< IssueWrapper >	getIssueWrappersForNow (IContact contact, String searchValue)
static List< IssueWrapper >	getIssueWrappers (IContact contact, String searchValue)
static Collection< IssueWrapper >	getNotIn (IContact contact, Collection< IssueWrapper > listws)
static void	removeWorksheet (String idContact)
static void	removeWorksheet (Long idIssue)
static Collection< String >	getResponsibles ()
static boolean	cleared (Worksheet worksheet, IContact contact)
static void	clearDone (List< Worksheet > list, IContact contact)

Detailed Description

Author

Lluis Turró Cutiller lluis.nosp@m.@tur.nosp@m.ro.or.nosp@m.g

Definition at line 41 of file WorksheetUtil.java.

Member Function Documentation

clearDone()

static void org.turro.dossier.util.WorksheetUtil.clearDone ( List< Worksheet >  list, IContact  contact  )

static

Definition at line 146 of file WorksheetUtil.java.

                                                                       {
    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();
      }
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

cleared()

static boolean org.turro.dossier.util.WorksheetUtil.cleared ( Worksheet  worksheet, IContact  contact  )

static

Definition at line 137 of file WorksheetUtil.java.

                                                                       {
    Dao dao = new DossierPU();
    if(isDone(worksheet, contact)) {
      dao.deleteObject(worksheet);
      return true;
    }
    return false;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getIssues()

static Collection<Issue> org.turro.dossier.util.WorksheetUtil.getIssues ( String  idContact, String  searchValue  )

static

Definition at line 52 of file WorksheetUtil.java.

                                                                                  {
    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 });
    }
  }

Here is the caller graph for this function:

getIssueWrappers()

static List<IssueWrapper> org.turro.dossier.util.WorksheetUtil.getIssueWrappers ( IContact  contact, String  searchValue  )

static

Definition at line 79 of file WorksheetUtil.java.

                                                                                          {
    ArrayList<IssueWrapper> list = new ArrayList<>();
    for(Issue issue : getIssues(contact.getId(), searchValue)) {
      IssueWrapper iw = new IssueWrapper(issue, contact);
      list.add(iw);
    }
    return list;
  }

Here is the call graph for this function:

getIssueWrappersForNow()

static List<IssueWrapper> org.turro.dossier.util.WorksheetUtil.getIssueWrappersForNow ( IContact  contact, String  searchValue  )

static

Definition at line 70 of file WorksheetUtil.java.

                                                                                                {
    ArrayList<IssueWrapper> list = new ArrayList<>();
    for(Issue issue : getIssues(contact.getId(), searchValue)) {
      IssueWrapper iw = new IssueWrapper(issue, contact);
      list.add(iw);
    }
    return list;
  }

Here is the call graph for this function:

getNotIn()

static Collection<IssueWrapper> org.turro.dossier.util.WorksheetUtil.getNotIn ( IContact  contact, Collection< IssueWrapper >  listws  )

static

Definition at line 88 of file WorksheetUtil.java.

                                                                                                     {
    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;
  }

Here is the call graph for this function:

getResponsibles()

static Collection<String> org.turro.dossier.util.WorksheetUtil.getResponsibles ( )

static

Definition at line 128 of file WorksheetUtil.java.

                                                     {
    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 });
  }

getWorksheet()

static Collection<Worksheet> org.turro.dossier.util.WorksheetUtil.getWorksheet ( String  idContact )

static

Definition at line 43 of file WorksheetUtil.java.

                                                                     {
    Dao dao = new DossierPU();
    return dao.getResultList(
            "select w from Worksheet as w " +
            "where w.idContact = ? " +
            "order by w.sheetOrder",
            new Object[] { idContact });
  }

Here is the caller graph for this function:

removeWorksheet() [1/2]

static void org.turro.dossier.util.WorksheetUtil.removeWorksheet ( Long  idIssue )

static

Definition at line 120 of file WorksheetUtil.java.

                                                   {
    Dao dao = new DossierPU();
    dao.executeUpdate(
            "delete from Worksheet " +
            "where issue.id = ? ",
            new Object[] { idIssue });
  }

Here is the call graph for this function:

removeWorksheet() [2/2]

static void org.turro.dossier.util.WorksheetUtil.removeWorksheet ( String  idContact )

static

Definition at line 112 of file WorksheetUtil.java.

                                                       {
    Dao dao = new DossierPU();
    dao.executeUpdate(
            "delete from Worksheet " +
            "where idContact = ? ",
            new Object[] { idContact });
  }

Here is the call graph for this function:

Here is the caller graph for this function:

---

The documentation for this class was generated from the following file:

• WorksheetUtil.java