| /* |
| * 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 java.util.*; |
| import java.lang.*; |
| import org.apache.tools.ant.taskdefs.Parallel.TaskList; |
| import org.apache.ofbiz.base.util.*; |
| import org.apache.ofbiz.entity.*; |
| import org.apache.ofbiz.base.util.UtilMisc; |
| import org.apache.ofbiz.base.util.UtilValidate; |
| import org.apache.ofbiz.base.util.UtilDateTime; |
| import org.apache.ofbiz.entity.util.*; |
| import org.apache.ofbiz.entity.condition.*; |
| import java.sql.Timestamp; |
| |
| 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; |
| } |
| } |
