1 25 package org.ofbiz.workeffort.project; 26 27 import java.util.ArrayList ; 28 import java.util.Collection ; 29 import java.util.Iterator ; 30 31 import javax.servlet.jsp.PageContext ; 32 33 import org.ofbiz.base.util.Debug; 34 import org.ofbiz.base.util.UtilMisc; 35 import org.ofbiz.entity.GenericDelegator; 36 import org.ofbiz.entity.GenericEntityException; 37 import org.ofbiz.entity.GenericValue; 38 import org.ofbiz.entity.condition.EntityExpr; 39 import org.ofbiz.entity.condition.EntityOperator; 40 41 48 public class ProjectWorker { 49 50 public static final String module = ProjectWorker.class.getName(); 51 52 public static void getAssignedProjects(PageContext pageContext, String projectsAttrName) { 53 GenericDelegator delegator = (GenericDelegator) pageContext.getRequest().getAttribute("delegator"); 54 GenericValue userLogin = (GenericValue) pageContext.getSession().getAttribute("userLogin"); 55 56 Collection validWorkEfforts = null; 57 58 if (userLogin != null && userLogin.get("partyId") != null) { 59 try { 60 validWorkEfforts = delegator.findByAnd("WorkEffortAndPartyAssign", 61 UtilMisc.toList(new EntityExpr("partyId", EntityOperator.EQUALS, userLogin.get("partyId")), 62 new EntityExpr("currentStatusId", EntityOperator.NOT_EQUAL, "WF_COMPLETED"), 63 new EntityExpr("currentStatusId", EntityOperator.NOT_EQUAL, "WF_TERMINATED"), 64 new EntityExpr("currentStatusId", EntityOperator.NOT_EQUAL, "WF_ABORTED"), 65 new EntityExpr("workEffortTypeId", EntityOperator.EQUALS, "TASK"), 66 new EntityExpr("workEffortPurposeTypeId", EntityOperator.EQUALS, "WEPT_PROJECT")), 67 UtilMisc.toList("priority")); 68 } catch (GenericEntityException e) { 69 Debug.logWarning(e, module); 70 } 71 } 72 if (validWorkEfforts == null || validWorkEfforts.size() <= 0) 73 return; 74 75 pageContext.setAttribute(projectsAttrName, validWorkEfforts); 76 } 77 78 public static void getAllAssignedProjects(PageContext pageContext, String projectsAttrName) { 79 GenericDelegator delegator = (GenericDelegator) pageContext.getRequest().getAttribute("delegator"); 80 GenericValue userLogin = (GenericValue) pageContext.getSession().getAttribute("userLogin"); 81 82 Collection validWorkEfforts = null; 83 84 if (userLogin != null && userLogin.get("partyId") != null) { 85 try { 86 validWorkEfforts = delegator.findByAnd("WorkEffortAndPartyAssign", 87 UtilMisc.toList(new EntityExpr("partyId", EntityOperator.EQUALS, userLogin.get("partyId")), 88 new EntityExpr("workEffortTypeId", EntityOperator.EQUALS, "TASK"), 89 new EntityExpr("workEffortPurposeTypeId", EntityOperator.EQUALS, "WEPT_PROJECT")), 90 UtilMisc.toList("priority")); 91 } catch (GenericEntityException e) { 92 Debug.logWarning(e, module); 93 } 94 } 95 if (validWorkEfforts == null || validWorkEfforts.size() <= 0) 96 return; 97 98 pageContext.setAttribute(projectsAttrName, validWorkEfforts); 99 } 100 101 public static void getAllProjectPhases(PageContext pageContext, String phasesAttrName) { 102 GenericDelegator delegator = (GenericDelegator) pageContext.getRequest().getAttribute("delegator"); 103 GenericValue userLogin = (GenericValue) pageContext.getSession().getAttribute("userLogin"); 104 105 String projectWorkEffortId = pageContext.getRequest().getParameter("projectWorkEffortId"); 106 107 if (projectWorkEffortId == null) 109 projectWorkEffortId = (String ) pageContext.getRequest().getAttribute("projectWorkEffortId"); 110 111 Collection relatedWorkEfforts = null; 112 113 if (userLogin != null && userLogin.get("partyId") != null) { 114 try { 115 relatedWorkEfforts = delegator.findByAnd("WorkEffortAssoc", 116 UtilMisc.toList(new EntityExpr("workEffortIdFrom", EntityOperator.EQUALS, projectWorkEffortId), 117 new EntityExpr("workEffortAssocTypeId", EntityOperator.EQUALS, "WORK_EFF_BREAKDOWN"))); 118 } catch (GenericEntityException e) { 119 Debug.logWarning(e, module); 120 } 121 } 122 123 Collection validWorkEfforts = new ArrayList (); 124 125 if (relatedWorkEfforts != null) { 126 Iterator relatedWorkEffortsIter = relatedWorkEfforts.iterator(); 127 128 try { 129 while (relatedWorkEffortsIter.hasNext()) { 130 GenericValue workEffortAssoc = (GenericValue) relatedWorkEffortsIter.next(); 131 GenericValue workEffort = workEffortAssoc.getRelatedOne("ToWorkEffort"); 132 133 if ("TASK".equals(workEffort.getString("workEffortTypeId")) && 135 ("WEPT_PHASE".equals(workEffort.getString("workEffortPurposeTypeId")))) { 136 validWorkEfforts.add(workEffort); 137 } 138 } 139 } catch (GenericEntityException e) { 140 Debug.logWarning(e, module); 141 } 142 } 143 if (validWorkEfforts == null || validWorkEfforts.size() <= 0) 144 return; 145 146 pageContext.setAttribute(phasesAttrName, validWorkEfforts); 147 } 148 149 public static void getAllPhaseTasks(PageContext pageContext, String tasksAttrName) { 150 GenericDelegator delegator = (GenericDelegator) pageContext.getRequest().getAttribute("delegator"); 151 GenericValue userLogin = (GenericValue) pageContext.getSession().getAttribute("userLogin"); 152 153 String phaseWorkEffortId = pageContext.getRequest().getParameter("phaseWorkEffortId"); 154 155 if (phaseWorkEffortId == null) 157 phaseWorkEffortId = (String ) pageContext.getRequest().getAttribute("phaseWorkEffortId"); 158 159 Collection relatedWorkEfforts = null; 160 161 if (userLogin != null && userLogin.get("partyId") != null) { 162 try { 163 relatedWorkEfforts = delegator.findByAnd("WorkEffortAssoc", 164 UtilMisc.toList(new EntityExpr("workEffortIdFrom", EntityOperator.EQUALS, phaseWorkEffortId), 165 new EntityExpr("workEffortAssocTypeId", EntityOperator.EQUALS, "WORK_EFF_BREAKDOWN"))); 166 } catch (GenericEntityException e) { 167 Debug.logWarning(e, module); 168 } 169 } 170 171 Collection validWorkEfforts = new ArrayList (); 172 173 if (relatedWorkEfforts != null) { 174 Iterator relatedWorkEffortsIter = relatedWorkEfforts.iterator(); 175 176 try { 177 while (relatedWorkEffortsIter.hasNext()) { 178 GenericValue workEffortAssoc = (GenericValue) relatedWorkEffortsIter.next(); 179 GenericValue workEffort = workEffortAssoc.getRelatedOne("ToWorkEffort"); 180 181 if ("TASK".equals(workEffort.getString("workEffortTypeId"))) { 183 validWorkEfforts.add(workEffort); 184 } 185 } 186 } catch (GenericEntityException e) { 187 Debug.logWarning(e, module); 188 } 189 } 190 if (validWorkEfforts == null || validWorkEfforts.size() <= 0) 191 return; 192 193 pageContext.setAttribute(tasksAttrName, validWorkEfforts); 194 } 195 196 public static void getTaskNotes(PageContext pageContext, String notesAttrName) { 197 GenericDelegator delegator = (GenericDelegator) pageContext.getRequest().getAttribute("delegator"); 198 GenericValue userLogin = (GenericValue) pageContext.getSession().getAttribute("userLogin"); 199 200 String workEffortId = pageContext.getRequest().getParameter("workEffortId"); 201 202 if (workEffortId == null) 204 workEffortId = (String ) pageContext.getRequest().getAttribute("workEffortId"); 205 206 Collection notes = null; 207 208 if (userLogin != null && userLogin.get("partyId") != null) { 209 try { 210 notes = delegator.findByAnd("WorkEffortNoteAndData", 211 UtilMisc.toList(new EntityExpr("workEffortId", EntityOperator.EQUALS, workEffortId)), 212 UtilMisc.toList("noteDateTime")); 213 } catch (GenericEntityException e) { 214 Debug.logWarning(e, module); 215 } 216 } 217 if (notes == null || notes.size() <= 0) 218 return; 219 220 pageContext.setAttribute(notesAttrName, notes); 221 } 222 223 } 224 | Popular Tags |