org.turro.dossier.workload.WorkloadQuery Class Reference

Collaboration diagram for org.turro.dossier.workload.WorkloadQuery:

Public Member Functions
	WorkloadQuery ()
	WorkloadQuery (IContact contact)
void	setApplication (Application app)
void	markSelf ()
WorkloadSet	getResults ()
Set< IssueWrapper >	getResultSet ()
Category	getCategory ()
void	setCategory (Category category)
Set< IssueResolution >	getResolutions ()
void	setResolutions (Set< IssueResolution > resolutions)
Set< IssueParticipantRole >	getRoles ()
void	setRoles (Set< IssueParticipantRole > roles)
Set< IssueStatus >	getStatus ()
void	setStatus (Set< IssueStatus > status)
IContact	getSubject ()
void	setSubject (IContact subject)
Set< IssueType >	getTypes ()
void	setTypes (Set< IssueType > types)
void	setType (IssueType type)
WhereClause	createCriteria ()
Dossier	getDossier ()
void	setDossier (Dossier dossier)
Long	getDossierId ()
void	setDossierId (Long dossierId)
String	getSearchValue ()
void	setSearchValue (String searchValue)
IContact	getByParticipant ()
void	setByParticipant (IContact byParticipant)
void	setByParticipantId (String id)

Detailed Description

Author

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

Definition at line 51 of file WorkloadQuery.java.

Constructor & Destructor Documentation

WorkloadQuery() [1/2]

org.turro.dossier.workload.WorkloadQuery.WorkloadQuery

(

)

Definition at line 66 of file WorkloadQuery.java.

                         {
    resetToDefault();
  }

WorkloadQuery() [2/2]

org.turro.dossier.workload.WorkloadQuery.WorkloadQuery

(

IContact

contact

)

Definition at line 71 of file WorkloadQuery.java.

                                         {
    realParticipant = contact;
    app = null;
    resetToDefault();
  }

Member Function Documentation

createCriteria()

WhereClause org.turro.dossier.workload.WorkloadQuery.createCriteria

(

)

Definition at line 183 of file WorkloadQuery.java.

                                      {
    boolean canSeeAll = app != null && app.isInRole("issue:all");
 
    WhereClause wc = new WhereClause();
    wc.addClause("select distinct issue from Issue as issue");
    wc.addClause("left outer join issue.participants participant");
    wc.addClause("left outer join issue.sources source");
    if(!"*".equals(searchValue)) {
      wc.addClause("left outer join issue.comments comment");
    }
    wc.addClause("where 1=1");
    
    boolean asParticipant = 
            roles.contains(IssueParticipantRole.ISSUE_REPORTER) ||
            roles.contains(IssueParticipantRole.ISSUE_RESPONSIBLE) ||
            roles.contains(IssueParticipantRole.ISSUE_QA) ||
            roles.contains(IssueParticipantRole.ISSUE_ASSISTANT);
 
    if(Strings.isEmpty(searchValue) || (!asParticipant && !canSeeAll)) {
      return null;
    }
 
    if(byParticipant == null) {
      byParticipant = realParticipant;
    }
 
    long id = 0;
    
    try {
      if(searchValue.startsWith("#") && canSeeAll) {
        id = Long.valueOf(searchValue.substring(1));
        if(id > 0) {
          wc.addClause("and issue.id = :id");
          wc.addNamedValue("id", id);
          return wc;
        }
      }
      id = Long.valueOf(searchValue);
      if(id > 0) {
        wc.addClause("and ((issue.id = :id)");
        wc.addNamedValue("id", id);
        wc.setPrefix("or");
      }
    } catch(Exception ex) {}
 
    if(searchValue.startsWith("#") && searchValue.length() > 2 && canSeeAll) {
      wc.addLikeFields(new String[] {
                "issue.description",
                "comment.comment"
                }, searchValue.substring(1).replaceAll("\\*", "%"));
      return wc;
    }
    
    if(!"*".equals(searchValue)) {
      wc.addLikeFields(new String[] {
                "issue.description",
                "comment.comment"
                }, (searchValue == null ? "" : searchValue.replaceAll("\\*", "%")));
    }
 
    if(id > 0) {
      wc.addClause(")");
      wc.setPrefix(null);
    }
 
    if(asParticipant) {
      wc.addClause("and participant.idContact = :idContact");
      wc.addNamedValue("idContact", byParticipant.getId());
      if(!roles.containsAll(EnumSet.allOf(IssueParticipantRole.class))) {
        wc.addClause("and participant.role in (:roles)");
        wc.addNamedValue("roles", roles);
      }
    }
    
    if(!status.containsAll(EnumSet.allOf(IssueStatus.class))) {
      wc.addClause("and issue.status in (:status)");
      wc.addNamedValue("status", status);
    }
    
    if(!resolutions.containsAll(EnumSet.allOf(IssueResolution.class))) {
      wc.addClause("and issue.resolution in (:resolutions)");
      wc.addNamedValue("resolutions", resolutions);
    }
 
    if(!types.containsAll(EnumSet.allOf(IssueType.class))) {
      wc.addClause("and issue.type in (:types)");
      wc.addNamedValue("types", types);
    }
 
    if(subject != null) {
      wc.addClause("and exists ( select subject from Participant as subject");
      wc.addClause("where subject.dossier = issue.dossier");
      wc.addClause("and subject.idContact = :idSubject");
      wc.addNamedValue("idSubject", subject.getId());
      wc.addClause("and subject.role = :roleSubject )");
      wc.addNamedValue("roleSubject", ParticipantRole.PARTICIPANT_SUBJECT);
    }
 
    if(dossier != null) {
      wc.addClause("and issue.dossier = :dossier");
      wc.addNamedValue("dossier", dossier);
    } else if(dossierId != null && dossierId > 0) {
      wc.addClause("and issue.dossier.id = :dossierId");
      wc.addNamedValue("dossierId", dossierId);
    } else {
      wc.addClause("and issue.dossier.status = :dstatus");
      wc.addNamedValue("dstatus", DossierStatus.DOSSIER_OPENED);
    }
    
    if(category != null) {
      wc.addClause("and (");
      wc.addClause("issue.dossier.category.fullDescription = :fullCatDesc");
      wc.addClause("or issue.dossier.category.fullDescription like concat(:fullCatDesc, '" + Chars.backward().spaced() + "%')");
      wc.addNamedValue("fullCatDesc", category.getFullDescription());
      wc.addClause(")");
    }
    
    if(!realParticipant.getId().equals(byParticipant.getId()) && !canSeeAll) {
      wc.addClause("and (");
      // dossier
      wc.addClause("exists (");
      wc.addClause("select p from Participant as p");
      wc.addClause("where p.dossier = issue.dossier");
      wc.addClause("and p.idContact = :idObserver");
      wc.addClause("and p.showAllIssues = TRUE");
      wc.addClause(")");
      // categories
      wc.addClause("or exists (");
      wc.addClause("select cp from CategoryParticipant as cp");
      wc.addClause("where cp.idContact = :idObserver");
      wc.addClause("and cp.showAllIssues = TRUE");
      wc.addClause("and (");
      wc.addClause("cp.category.fullDescription = issue.dossier.category.fullDescription");
      wc.addClause("or issue.dossier.category.fullDescription like concat(cp.category.fullDescription, '" + Chars.backward().spaced() + "%')");
      wc.addClause("))");
      //
      wc.addClause(")");
      // parameter
      wc.addNamedValue("idObserver", realParticipant.getId());
    }
 
    return wc;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getByParticipant()

IContact org.turro.dossier.workload.WorkloadQuery.getByParticipant

(

)

Definition at line 351 of file WorkloadQuery.java.

                                     {
    return byParticipant;
  }

Here is the caller graph for this function:

getCategory()

Category org.turro.dossier.workload.WorkloadQuery.getCategory

(

)

Definition at line 131 of file WorkloadQuery.java.

                                {
    return category;
  }

Here is the caller graph for this function:

getDossier()

Dossier org.turro.dossier.workload.WorkloadQuery.getDossier

(

)

Definition at line 327 of file WorkloadQuery.java.

                              {
    return dossier;
  }

Here is the caller graph for this function:

getDossierId()

Long org.turro.dossier.workload.WorkloadQuery.getDossierId

(

)

Definition at line 335 of file WorkloadQuery.java.

                             {
    return dossierId;
  }

getResolutions()

Set<IssueResolution> org.turro.dossier.workload.WorkloadQuery.getResolutions

(

)

Definition at line 139 of file WorkloadQuery.java.

                                               {
    return resolutions;
  }

getResults()

WorkloadSet org.turro.dossier.workload.WorkloadQuery.getResults

(

)

Definition at line 99 of file WorkloadQuery.java.

                                  {
    if(byParticipant == null) {
      byParticipant = realParticipant;
    }
    WorkloadSet results = new WorkloadSet();
    if((Strings.isEmpty(searchValue) || "*".equals(searchValue)) &&
        category == null && dossier == null && (dossierId == null || dossierId == 0)) {
      for(Worksheet worksheet : WorksheetUtil.getWorksheet(byParticipant.getId())) {
        if(!WorksheetUtil.cleared(worksheet, byParticipant)) {
          results.add(new WorkloadItem(worksheet));
        }
      }
    }
    for(IssueWrapper iw : getResultSet()) {
      WorkloadItem wi = new WorkloadItem(iw);
      if(!results.inWorksheet(wi.getIssue().getId())) {
        results.add(wi);
      }
    }
    return results;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getResultSet()

Set<IssueWrapper> org.turro.dossier.workload.WorkloadQuery.getResultSet

(

)

Definition at line 121 of file WorkloadQuery.java.

                                          {
    Dao dao = new DossierPU();
    WhereClause wc = createCriteria();
    if(wc != null) {
      return new IssueSet(dao.getResultList(wc), false, byParticipant);
    } else {
      return Collections.EMPTY_SET;
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getRoles()

Set<IssueParticipantRole> org.turro.dossier.workload.WorkloadQuery.getRoles

(

)

Definition at line 147 of file WorkloadQuery.java.

                                              {
    return roles;
  }

getSearchValue()

String org.turro.dossier.workload.WorkloadQuery.getSearchValue

(

)

Definition at line 343 of file WorkloadQuery.java.

                                 {
    return searchValue;
  }

Here is the caller graph for this function:

getStatus()

Set<IssueStatus> org.turro.dossier.workload.WorkloadQuery.getStatus

(

)

Definition at line 155 of file WorkloadQuery.java.

                                      {
    return status;
  }

Here is the caller graph for this function:

getSubject()

IContact org.turro.dossier.workload.WorkloadQuery.getSubject

(

)

Definition at line 163 of file WorkloadQuery.java.

                               {
    return subject;
  }

getTypes()

Set<IssueType> org.turro.dossier.workload.WorkloadQuery.getTypes

(

)

Definition at line 171 of file WorkloadQuery.java.

                                   {
    return types;
  }

Here is the caller graph for this function:

markSelf()

void org.turro.dossier.workload.WorkloadQuery.markSelf

(

)

Definition at line 95 of file WorkloadQuery.java.

                         {
    resetToDefault();
  }

setApplication()

void org.turro.dossier.workload.WorkloadQuery.setApplication

(

Application

app

)

Definition at line 91 of file WorkloadQuery.java.

                                              {
    this.app = app;
  }

setByParticipant()

void org.turro.dossier.workload.WorkloadQuery.setByParticipant

(

IContact

byParticipant

)

Definition at line 355 of file WorkloadQuery.java.

                                                       {
    this.byParticipant = byParticipant;
  }

Here is the caller graph for this function:

setByParticipantId()

void org.turro.dossier.workload.WorkloadQuery.setByParticipantId

(

String

id

)

Definition at line 359 of file WorkloadQuery.java.

                                            {
    this.byParticipant = Contacts.getContactById(id);
  }

Here is the call graph for this function:

setCategory()

void org.turro.dossier.workload.WorkloadQuery.setCategory

(

Category

category

)

Definition at line 135 of file WorkloadQuery.java.

                                             {
    this.category = category;
  }

Here is the caller graph for this function:

setDossier()

void org.turro.dossier.workload.WorkloadQuery.setDossier

(

Dossier

dossier

)

Definition at line 331 of file WorkloadQuery.java.

                                          {
    this.dossier = dossier;
  }

Here is the caller graph for this function:

setDossierId()

void org.turro.dossier.workload.WorkloadQuery.setDossierId

(

Long

dossierId

)

Definition at line 339 of file WorkloadQuery.java.

                                           {
    this.dossierId = dossierId;
  }

setResolutions()

void org.turro.dossier.workload.WorkloadQuery.setResolutions

(

Set< IssueResolution >

resolutions

)

Definition at line 143 of file WorkloadQuery.java.

                                                               {
    this.resolutions = EnumSet.copyOf(resolutions);
  }

setRoles()

void org.turro.dossier.workload.WorkloadQuery.setRoles

(

Set< IssueParticipantRole >

roles

)

Definition at line 151 of file WorkloadQuery.java.

                                                        {
    this.roles = EnumSet.copyOf(roles);
  }

setSearchValue()

void org.turro.dossier.workload.WorkloadQuery.setSearchValue

(

String

searchValue

)

Definition at line 347 of file WorkloadQuery.java.

                                                 {
    this.searchValue = searchValue;
  }

Here is the caller graph for this function:

setStatus()

void org.turro.dossier.workload.WorkloadQuery.setStatus

(

Set< IssueStatus >

status

)

Definition at line 159 of file WorkloadQuery.java.

                                                 {
    this.status = EnumSet.copyOf(status);
  }

Here is the caller graph for this function:

setSubject()

void org.turro.dossier.workload.WorkloadQuery.setSubject

(

IContact

subject

)

Definition at line 167 of file WorkloadQuery.java.

                                           {
    this.subject = subject;
  }

setType()

void org.turro.dossier.workload.WorkloadQuery.setType

(

IssueType

type

)

Definition at line 179 of file WorkloadQuery.java.

                                      {
    this.types = EnumSet.of(type);
  }

setTypes()

void org.turro.dossier.workload.WorkloadQuery.setTypes

(

Set< IssueType >

types

)

Definition at line 175 of file WorkloadQuery.java.

                                             {
    this.types = EnumSet.copyOf(types);
  }

Here is the caller graph for this function:

---

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

• WorkloadQuery.java