org.turro.dossier.kb.KnowledgeBaseQuery Class Reference

Public Member Functions
	KnowledgeBaseQuery ()
	KnowledgeBaseQuery (IContact contact)
KnowledgeBaseList	getResultList ()
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)
Set< IssueType >	getTypes ()
void	setTypes (Set< IssueType > types)
void	setType (IssueType type)
int	getMaxResults ()
void	setMaxResults (int maxResults)
WhereClause	createCriteria ()
Dossier	getDossier ()
void	setDossier (Dossier dossier)
Long	getDossierId ()
void	setDossierId (Long dossierId)
String	getSearchValue ()
void	setSearchValue (String searchValue)
boolean	isOnlyTitle ()
void	setOnlyTitle (boolean onlyTitle)
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 44 of file KnowledgeBaseQuery.java.

Constructor & Destructor Documentation

KnowledgeBaseQuery() [1/2]

org.turro.dossier.kb.KnowledgeBaseQuery.KnowledgeBaseQuery

(

)

Definition at line 59 of file KnowledgeBaseQuery.java.

                              {
    resetToDefault();
    realContact = Authentication.getIContact();
  }

Here is the call graph for this function:

KnowledgeBaseQuery() [2/2]

org.turro.dossier.kb.KnowledgeBaseQuery.KnowledgeBaseQuery

(

IContact

contact

)

Definition at line 64 of file KnowledgeBaseQuery.java.

                                              {
    resetToDefault();
    realContact = contact;
  }

Member Function Documentation

createCriteria()

WhereClause org.turro.dossier.kb.KnowledgeBaseQuery.createCriteria

(

)

Definition at line 138 of file KnowledgeBaseQuery.java.

                                      {
    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.comments comment");
    wc.addClause("where issue.publishable = TRUE");
    
    boolean asParticipant = false;
    
    if(byParticipant != null && byParticipant.isValid()) {
      asParticipant = roles.isEmpty() ||
            roles.contains(IssueParticipantRole.ISSUE_REPORTER) ||
            roles.contains(IssueParticipantRole.ISSUE_RESPONSIBLE) ||
            roles.contains(IssueParticipantRole.ISSUE_QA) ||
            roles.contains(IssueParticipantRole.ISSUE_ASSISTANT);
    }
 
    if(Strings.isEmpty(searchValue)) {
      return null;
    }
 
    try {
      long id = Long.valueOf(searchValue);
      if(id > 0) {
        wc.addClause("and issue.id = :id");
        wc.addNamedValue("id", id);
        return wc;
      }
    } catch(Exception ex) {}
 
    if(onlyTitle) {
      wc.addLikeFields(new String[] {
                "issue.description"
                }, (searchValue == null ? "" : searchValue.replaceAll("\\*", "%")));
    } else {
      wc.addLikeFields(new String[] {
                "issue.description",
                "comment.comment"
                }, (searchValue == null ? "" : searchValue.replaceAll("\\*", "%")));
    }
 
    if(asParticipant) {
      String sep = "";
      wc.addClause("and (");
      if(roles.isEmpty()) {
        wc.addClause("(");
        wc.addClause("participant.idContact = :idContact");
        wc.addNamedValue("idContact", byParticipant.getId());
        wc.addClause(")");
      } else {
        for(IssueParticipantRole ii : roles) {
          wc.addClause(sep);
          sep = "or";
          wc.addClause("(");
          wc.addClause("participant.idContact = :idContact");
          wc.addNamedValue("idContact", byParticipant.getId());
          wc.addClause("and participant.role = :" + ii.toString());
          wc.addNamedValue(ii.toString(), ii);
          wc.addClause(")");
        }
      }
      wc.addClause(")");
    }
    
    if(!status.isEmpty()) {
      String sep = "";
      wc.addClause("and (");
      for(IssueStatus ii : status) {
        wc.addClause(sep);
        sep = "or";
        wc.addClause("issue.status = :" + ii.toString());
        wc.addNamedValue(ii.toString(), ii);
      }
      wc.addClause(")");
    }
    
    if(!resolutions.isEmpty()) {
      String sep = "";
      wc.addClause("and (");
      for(IssueResolution ii : resolutions) {
        wc.addClause(sep);
        sep = "or";
        wc.addClause("issue.resolution = :" + ii.toString());
        wc.addNamedValue(ii.toString(), ii);
      }
      wc.addClause(")");
    }
 
    if(!types.isEmpty()) {
      String sep = "";
      wc.addClause("and (");
      for(IssueType ii : types) {
        wc.addClause(sep);
        sep = "or";
        wc.addClause("issue.type = :" + ii.toString());
        wc.addNamedValue(ii.toString(), ii);
      }
      wc.addClause(")");
    }
 
    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(")");
    }
    
    wc.addClause("order by issue.modification desc");
    
    return wc;
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getByParticipant()

IContact org.turro.dossier.kb.KnowledgeBaseQuery.getByParticipant

(

)

Definition at line 294 of file KnowledgeBaseQuery.java.

                                     {
    return byParticipant;
  }

Here is the caller graph for this function:

getCategory()

Category org.turro.dossier.kb.KnowledgeBaseQuery.getCategory

(

)

Definition at line 86 of file KnowledgeBaseQuery.java.

                                {
    return category;
  }

Here is the caller graph for this function:

getDossier()

Dossier org.turro.dossier.kb.KnowledgeBaseQuery.getDossier

(

)

Definition at line 262 of file KnowledgeBaseQuery.java.

                              {
    return dossier;
  }

Here is the caller graph for this function:

getDossierId()

Long org.turro.dossier.kb.KnowledgeBaseQuery.getDossierId

(

)

Definition at line 270 of file KnowledgeBaseQuery.java.

                             {
    return dossierId;
  }

Here is the caller graph for this function:

getMaxResults()

int org.turro.dossier.kb.KnowledgeBaseQuery.getMaxResults

(

)

Definition at line 130 of file KnowledgeBaseQuery.java.

                             {
    return maxResults;
  }

Here is the caller graph for this function:

getResolutions()

Set<IssueResolution> org.turro.dossier.kb.KnowledgeBaseQuery.getResolutions

(

)

Definition at line 94 of file KnowledgeBaseQuery.java.

                                               {
    return resolutions;
  }

Here is the caller graph for this function:

getResultList()

KnowledgeBaseList org.turro.dossier.kb.KnowledgeBaseQuery.getResultList

(

)

Definition at line 76 of file KnowledgeBaseQuery.java.

                                           {
    Dao dao = new DossierPU();
    WhereClause wc = createCriteria();
    if(wc != null) {
      return new KnowledgeBaseList(dao.getResultList(wc, maxResults), realContact);
    } else {
      return new KnowledgeBaseList(Collections.EMPTY_LIST, realContact);
    }
  }

Here is the call graph for this function:

Here is the caller graph for this function:

getRoles()

Set<IssueParticipantRole> org.turro.dossier.kb.KnowledgeBaseQuery.getRoles

(

)

Definition at line 102 of file KnowledgeBaseQuery.java.

                                              {
    return roles;
  }

getSearchValue()

String org.turro.dossier.kb.KnowledgeBaseQuery.getSearchValue

(

)

Definition at line 278 of file KnowledgeBaseQuery.java.

                                 {
    return searchValue;
  }

Here is the caller graph for this function:

getStatus()

Set<IssueStatus> org.turro.dossier.kb.KnowledgeBaseQuery.getStatus

(

)

Definition at line 110 of file KnowledgeBaseQuery.java.

                                      {
    return status;
  }

Here is the caller graph for this function:

getTypes()

Set<IssueType> org.turro.dossier.kb.KnowledgeBaseQuery.getTypes

(

)

Definition at line 118 of file KnowledgeBaseQuery.java.

                                   {
    return types;
  }

Here is the caller graph for this function:

isOnlyTitle()

boolean org.turro.dossier.kb.KnowledgeBaseQuery.isOnlyTitle

(

)

Definition at line 286 of file KnowledgeBaseQuery.java.

                               {
    return onlyTitle;
  }

Here is the caller graph for this function:

setByParticipant()

void org.turro.dossier.kb.KnowledgeBaseQuery.setByParticipant

(

IContact

byParticipant

)

Definition at line 298 of file KnowledgeBaseQuery.java.

                                                       {
    this.byParticipant = byParticipant;
  }

Here is the caller graph for this function:

setByParticipantId()

void org.turro.dossier.kb.KnowledgeBaseQuery.setByParticipantId

(

String

id

)

Definition at line 302 of file KnowledgeBaseQuery.java.

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

Here is the call graph for this function:

setCategory()

void org.turro.dossier.kb.KnowledgeBaseQuery.setCategory

(

Category

category

)

Definition at line 90 of file KnowledgeBaseQuery.java.

                                             {
    this.category = category;
  }

Here is the caller graph for this function:

setDossier()

void org.turro.dossier.kb.KnowledgeBaseQuery.setDossier

(

Dossier

dossier

)

Definition at line 266 of file KnowledgeBaseQuery.java.

                                          {
    this.dossier = dossier;
  }

Here is the caller graph for this function:

setDossierId()

void org.turro.dossier.kb.KnowledgeBaseQuery.setDossierId

(

Long

dossierId

)

Definition at line 274 of file KnowledgeBaseQuery.java.

                                           {
    this.dossierId = dossierId;
  }

Here is the caller graph for this function:

setMaxResults()

void org.turro.dossier.kb.KnowledgeBaseQuery.setMaxResults

(

int

maxResults

)

Definition at line 134 of file KnowledgeBaseQuery.java.

                                            {
    this.maxResults = maxResults;
  }

Here is the caller graph for this function:

setOnlyTitle()

void org.turro.dossier.kb.KnowledgeBaseQuery.setOnlyTitle

(

boolean

onlyTitle

)

Definition at line 290 of file KnowledgeBaseQuery.java.

                                              {
    this.onlyTitle = onlyTitle;
  }

Here is the caller graph for this function:

setResolutions()

void org.turro.dossier.kb.KnowledgeBaseQuery.setResolutions

(

Set< IssueResolution >

resolutions

)

Definition at line 98 of file KnowledgeBaseQuery.java.

                                                               {
    this.resolutions = resolutions.isEmpty() ? EnumSet.noneOf(IssueResolution.class) : EnumSet.copyOf(resolutions);
  }

Here is the caller graph for this function:

setRoles()

void org.turro.dossier.kb.KnowledgeBaseQuery.setRoles

(

Set< IssueParticipantRole >

roles

)

Definition at line 106 of file KnowledgeBaseQuery.java.

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

setSearchValue()

void org.turro.dossier.kb.KnowledgeBaseQuery.setSearchValue

(

String

searchValue

)

Definition at line 282 of file KnowledgeBaseQuery.java.

                                                 {
    this.searchValue = searchValue;
  }

Here is the caller graph for this function:

setStatus()

void org.turro.dossier.kb.KnowledgeBaseQuery.setStatus

(

Set< IssueStatus >

status

)

Definition at line 114 of file KnowledgeBaseQuery.java.

                                                 {
    this.status = status.isEmpty() ? EnumSet.noneOf(IssueStatus.class) : EnumSet.copyOf(status);
  }

Here is the caller graph for this function:

setType()

void org.turro.dossier.kb.KnowledgeBaseQuery.setType

(

IssueType

type

)

Definition at line 126 of file KnowledgeBaseQuery.java.

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

setTypes()

void org.turro.dossier.kb.KnowledgeBaseQuery.setTypes

(

Set< IssueType >

types

)

Definition at line 122 of file KnowledgeBaseQuery.java.

                                             {
    this.types = types.isEmpty() ? EnumSet.noneOf(IssueType.class) : EnumSet.copyOf(types);
  }

Here is the caller graph for this function:

---

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

• KnowledgeBaseQuery.java