plugins/scrum/groovyScripts/TaskList.groovy

/*
* 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
}