| /* |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| */ |
| |
| import org.apache.ofbiz.entity.condition.EntityCondition |
| import org.apache.ofbiz.entity.condition.EntityOperator |
| |
| taskId = parameters.taskId |
| taskName = parameters.taskName |
| sprintId = parameters.sprintId |
| sprintName = parameters.sprintName |
| taskTypeId = parameters.taskTypeId |
| projectId = parameters.projectId |
| projectName = parameters.projectName |
| backlogTypeId = parameters.unplannedFlag |
| statusId = parameters.statusId |
| partyId = parameters.partyId |
| |
| unplannedTaskList = [] |
| plannedTaskList = [] |
| resultList=[] |
| taskList=[] |
| implementTaskList=[] |
| testTaskList=[] |
| errorTaskList = [] |
| installTaskList = [] |
| |
| // get Unplaned task list |
| if ((taskId != null)||(taskName != null)||(taskTypeId != null)||(sprintId != null)||(sprintName != null) |
| ||(projectId != null)||(projectName != null)||(backlogTypeId != null)||(statusId != null) |
| ||(partyId != null)||(viewIndex_1 > 0)||(viewIndex_2 > 0)||(viewIndex_3 > 0)||(viewIndex_4 > 0) |
| ||(viewIndexNo_1 > 0)||(viewIndexNo_2 > 0)||(viewIndexNo_3 > 0)||(viewIndexNo_4 > 0)){ |
| if ((taskId != null)||(taskName != null)||(taskTypeId != null)){ |
| exprBldr = [] |
| if (taskId) { |
| exprBldr.add(EntityCondition.makeCondition("workEffortId", EntityOperator.EQUALS, taskId)) |
| } |
| if (taskName){ |
| exprBldr.add(EntityCondition.makeCondition("workEffortName", EntityOperator.LIKE, "%"+taskName+"%")) |
| } |
| if (taskTypeId){ |
| exprBldr.add(EntityCondition.makeCondition("workEffortTypeId", EntityOperator.EQUALS, taskTypeId)) |
| } |
| if (statusId){ |
| exprBldr.add(EntityCondition.makeCondition("currentStatusId", EntityOperator.EQUALS, statusId)) |
| } |
| unplannedTaskList = from("UnPlannedBacklogsAndTasks").where(exprBldr).orderBy("-createdDate").queryList() |
| } |
| else{ |
| unplannedTaskList = from("UnPlannedBacklogsAndTasks").orderBy("-createdDate").queryList() |
| } |
| |
| exprBldr2 = [] |
| if (taskId) { |
| exprBldr2.add(EntityCondition.makeCondition("taskId", EntityOperator.EQUALS, taskId)) |
| } |
| if (taskName){ |
| exprBldr2.add(EntityCondition.makeCondition("taskName", EntityOperator.LIKE, "%"+taskName+"%")) |
| } |
| if (taskTypeId){ |
| exprBldr2.add(EntityCondition.makeCondition("taskTypeId", EntityOperator.EQUALS, taskTypeId)) |
| } |
| if (statusId){ |
| exprBldr2.add(EntityCondition.makeCondition("taskCurrentStatusId", EntityOperator.EQUALS, statusId)) |
| } |
| if (sprintId){ |
| exprBldr2.add(EntityCondition.makeCondition("sprintId", EntityOperator.EQUALS, sprintId)) |
| } |
| if (sprintName){ |
| exprBldr2.add(EntityCondition.makeCondition("sprintName", EntityOperator.LIKE, "%"+sprintName+"%")) |
| } |
| if (projectId){ |
| exprBldr2.add(EntityCondition.makeCondition("projectId", EntityOperator.EQUALS, projectId)) |
| } |
| if (projectName){ |
| exprBldr2.add(EntityCondition.makeCondition("projectName", EntityOperator.LIKE, "%"+projectName+"%")) |
| } |
| exprBldr2.add(EntityCondition.makeCondition("sprintTypeId", EntityOperator.EQUALS, "SCRUM_SPRINT")) |
| plannedTaskList = from("ProjectSprintBacklogAndTask").where(exprBldr2).orderBy("-taskCreatedDate").queryList() |
| |
| unplannedTaskList.each{ unplannedTaskMap -> |
| unplannedMap = [:] |
| unplannedMap.taskId = unplannedTaskMap.workEffortId |
| unplannedMap.sprintId = null |
| unplannedMap.projectId = null |
| unplannedMap.productId = unplannedTaskMap.productId |
| unplannedMap.taskName = unplannedTaskMap.workEffortName |
| unplannedMap.taskTypeId = unplannedTaskMap.workEffortTypeId |
| unplannedMap.taskCurrentStatusId = unplannedTaskMap.currentStatusId |
| unplannedMap.taskEstimatedMilliSeconds = unplannedTaskMap.estimatedMilliSeconds |
| unplannedMap.taskCreatedDate = unplannedTaskMap.createdDate |
| unplannedMap.custRequestId = unplannedTaskMap.custRequestId |
| unplannedMap.description = unplannedTaskMap.description |
| unplannedMap.custRequestTypeId = unplannedTaskMap.custRequestTypeId |
| unplannedMap.taskActualMilliSeconds = unplannedTaskMap.actualMilliSeconds |
| unplannedMap.taskEstimatedStartDate = unplannedTaskMap.estimatedStartDate |
| taskList.add(unplannedMap) |
| } |
| |
| plannedTaskList.each{ plannedTaskMap -> |
| plannedMap = [:] |
| plannedMap.taskId = plannedTaskMap.taskId |
| plannedMap.taskName = plannedTaskMap.taskName |
| plannedMap.taskTypeId = plannedTaskMap.taskTypeId |
| plannedMap.taskCurrentStatusId = plannedTaskMap.taskCurrentStatusId |
| plannedMap.taskEstimatedMilliSeconds = plannedTaskMap.taskEstimatedMilliSeconds |
| plannedMap.taskCreatedDate = plannedTaskMap.taskCreatedDate |
| plannedMap.sprintId = plannedTaskMap.sprintId |
| plannedMap.sprintName = plannedTaskMap.sprintName |
| plannedMap.projectId = plannedTaskMap.projectId |
| plannedMap.projectName = plannedTaskMap.projectName |
| plannedMap.custRequestId = plannedTaskMap.custRequestId |
| plannedMap.description = plannedTaskMap.description |
| plannedMap.custRequestTypeId = plannedTaskMap.custRequestTypeId |
| plannedMap.taskActualMilliSeconds = plannedTaskMap.taskActualMilliSeconds |
| plannedMap.taskEstimatedStartDate = plannedTaskMap.taskEstimatedStartDate |
| taskList.add(plannedMap) |
| } |
| //Check the backlog |
| if (backlogTypeId){ |
| if (backlogTypeId=="Y"){ |
| taskList.each{taskMap -> |
| if(taskMap.custRequestTypeId=="RF_UNPLAN_BACKLOG"){ |
| resultList.add(taskMap) |
| } |
| } |
| } |
| if (backlogTypeId=="N"){ |
| taskList.each{taskMap -> |
| if(taskMap.custRequestTypeId=="RF_PROD_BACKLOG"){ |
| resultList.add(taskMap) |
| } |
| } |
| } |
| } else { |
| taskList.each { taskMap -> |
| resultList.add(taskMap) |
| } |
| } |
| // Check party assigned |
| if (partyId){ |
| assignedList = resultList |
| resultList = [] |
| assignedList.each { assignedMap -> |
| workEffortId = assignedMap.taskId |
| assignToList = from("WorkEffortPartyAssignment").where("workEffortId", workEffortId, "partyId", partyId).queryList() |
| if (assignToList) { |
| assignedMap.partyId = assignToList[0].partyId |
| resultList.add(assignedMap) |
| } |
| } |
| } else { |
| assignedList = resultList |
| resultList = [] |
| assignedList.each { assignedMap -> |
| workEffortId = assignedMap.taskId |
| assignToList = from("WorkEffortPartyAssignment").where("workEffortId", workEffortId).queryList() |
| if (assignToList) { |
| assignedMap.partyId = assignToList[0].partyId |
| resultList.add(assignedMap) |
| } else { |
| resultList.add(assignedMap) |
| } |
| } |
| } |
| |
| resultList.each{resultMap -> |
| if (resultMap.taskTypeId=="SCRUM_TASK_IMPL"){ |
| implementTaskList.add(resultMap) |
| } |
| if (resultMap.taskTypeId=="SCRUM_TASK_INST"){ |
| installTaskList.add(resultMap) |
| } |
| if (resultMap.taskTypeId=="SCRUM_TASK_TEST"){ |
| testTaskList.add(resultMap) |
| } |
| if (resultMap.taskTypeId=="SCRUM_TASK_ERROR"){ |
| errorTaskList.add(resultMap) |
| } |
| } |
| |
| if (implementTaskList){ |
| context.implementTaskList = implementTaskList |
| } |
| if (installTaskList){ |
| context.installTaskList = installTaskList |
| } |
| if (testTaskList){ |
| context.testTaskList = testTaskList |
| } |
| if (errorTaskList){ |
| context.errorTaskList = errorTaskList |
| } |
| } |