| /* |
| * 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 |
| |
| partyId = userLogin.partyId |
| taskUnplanList = [] |
| taskPlanList = [] |
| taskPartyList = [] |
| taskListDropdown = [] |
| |
| //${projectId} - ${projectName} - ${sprintName} - ${groovy:description.substring(0,Math.min(description.length(),30))}[${custRequestId}] - ${groovy:taskName.substring(0,Math.min(taskName.length(),20))}[${taskId}]"/> |
| |
| taskUnplanList = from("ProjectSprintBacklogTaskAndParty").where("partyId", partyId,"taskCurrentStatusId", "STS_CREATED","custRequestTypeId","RF_UNPLAN_BACKLOG").orderBy("taskTypeId").queryList() |
| taskUnplanList.each { taskUnplanMap -> |
| unplanMap=[:] |
| custRequestId = taskUnplanMap.custRequestId |
| productlist = from("CustRequestItem").where("custRequestId", custRequestId).orderBy("productId").queryList() |
| productlist.each { productMap -> |
| productId = productMap.productId |
| product = from("Product").where("productId", productId).queryOne() |
| productName = product.internalName |
| unplanMap.taskId = taskUnplanMap.taskId |
| unplanMap.taskName = taskUnplanMap.taskName |
| unplanMap.projectId = taskUnplanMap.projectId |
| unplanMap.projectName = taskUnplanMap.projectName |
| unplanMap.sprintId = taskUnplanMap.sprintId |
| unplanMap.sprintName = taskUnplanMap.sprintName |
| unplanMap.custRequestId = custRequestId |
| unplanMap.description = taskUnplanMap.description |
| unplanMap.productId = productId |
| unplanMap.productName = productName |
| |
| } |
| taskPartyList.add(taskUnplanMap) |
| taskListDropdown.add(unplanMap) |
| } |
| |
| exprBldr = [] |
| exprBldr.add(EntityCondition.makeCondition("custRequestTypeId", EntityOperator.EQUALS, "RF_PROD_BACKLOG")) |
| exprBldr.add(EntityCondition.makeCondition("custRequestTypeId", EntityOperator.EQUALS, "RF_SCRUM_MEETINGS")) |
| andExprs = [] |
| andExprs.add(EntityCondition.makeCondition("taskCurrentStatusId", EntityOperator.EQUALS, "STS_CREATED")) |
| andExprs.add(EntityCondition.makeCondition("partyId", EntityOperator.EQUALS, partyId)) |
| andExprs.add(EntityCondition.makeCondition(exprBldr, EntityOperator.OR)) |
| custRequestTypeCond = EntityCondition.makeCondition(andExprs, EntityOperator.AND) |
| |
| taskPlanList = from("ProjectSprintBacklogTaskAndParty").where(custRequestTypeCond).orderBy("taskTypeId","projectId","sprintId").queryList() |
| taskPlanList.each { taskPlanMap -> |
| planMap=[:] |
| if ("RF_SCRUM_MEETINGS".equals(taskPlanMap.custRequestTypeId)) { |
| workEffPartyAssignedList = from("WorkEffortPartyAssignment").where("partyId", partyId, "workEffortId", taskPlanMap.taskId).queryList() |
| workEffPartyAssignedMap = workEffPartyAssignedList[0] |
| if (!"SCAS_COMPLETED".equals(workEffPartyAssignedMap.statusId)) { |
| taskPartyList.add(taskPlanMap) |
| taskListDropdown.add(taskPlanMap) |
| } |
| } else { |
| if (taskPlanMap.projectId) { |
| taskPartyList.add(taskPlanMap) |
| taskListDropdown.add(taskPlanMap) |
| } else { |
| custRequestId = taskPlanMap.custRequestId |
| productlist = from("CustRequestItem").where("custRequestId", custRequestId).orderBy("productId").queryList() |
| product = from("Product").where("productId", productlist[0].productId).queryOne() |
| productName = product.internalName |
| planMap.taskId = taskPlanMap.taskId |
| planMap.taskTypeId = taskPlanMap.taskTypeId |
| planMap.taskName = taskPlanMap.taskName |
| planMap.projectId = taskPlanMap.projectId |
| planMap.projectName = taskPlanMap.projectName |
| planMap.sprintId = taskPlanMap.sprintId |
| planMap.sprintName = taskPlanMap.sprintName |
| planMap.custRequestId = custRequestId |
| planMap.description = taskPlanMap.description |
| planMap.productId = productlist[0].productId |
| planMap.productName = productName |
| taskPartyList.add(planMap) |
| taskListDropdown.add(planMap) |
| } |
| |
| } |
| } |
| if (taskPartyList){ |
| context.taskPartyList = taskPartyList |
| } |
| if (taskListDropdown){ |
| context.taskListDropdown = taskListDropdown |
| } |
| |
| |