specialpurpose/scrum/groovyScripts/AddProductBacklogItem.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.sql.*
import java.sql.Timestamp
import java.util.Calendar
import net.fortuna.ical4j.model.DateTime
import org.apache.ofbiz.base.util.*
import org.apache.ofbiz.entity.condition.*
import sun.util.calendar.LocalGregorianCalendar.Date

def module = "AddProductBacklogItem.groovy"

// find cust request and items
def inputFields = [:]

if(parameters.statusId == null){
    parameters.statusId = ""
}else if("Any".equals(parameters.statusId)){
    parameters.statusId = ""
}
inputFields.putAll(parameters)
inputFields.custRequestTypeId = "RF_PROD_BACKLOG"
def performFindResults = runService('performFind', ["entityName": "CustRequestAndCustRequestItem", "inputFields": inputFields, "orderBy": "custSequenceNum"])
def custRequestAndItems = performFindResults.listIt.getCompleteList()
performFindResults.listIt.close()

// prepare cust request item list [cust request and item Map]
def countSequence = 1
def custRequestAndCustRequestItems = []
custRequestAndItems.each() { custRequestAndItem ->
    def tempCustRequestAndItem = [:]
    tempCustRequestAndItem.putAll(custRequestAndItem)
    tempCustRequestAndItem.custSequenceNum = countSequence
    tempCustRequestAndItem.realSequenceNum = custRequestAndItem.custSequenceNum
    // if custRequest has task then get Actual Hours
    custWorkEffortList = from("CustRequestWorkEffort").where("custRequestId", custRequestAndItem.custRequestId).queryList()
    if (custWorkEffortList) {
        actualHours = 0.00
        custWorkEffortList.each() { custWorkEffortMap ->
            result = runService('getScrumActualHour', ["taskId" : custWorkEffortMap.workEffortId,"partyId" : null, "userLogin" : userLogin])
            actualHours += result.actualHours
        }
        if(actualHours) {
            tempCustRequestAndItem.actualHours = actualHours
        } else {
            tempCustRequestAndItem.actualHours = null
        }
    } else {
        tempCustRequestAndItem.actualHours = null
    }
    custRequestAndCustRequestItems.add(tempCustRequestAndItem)
    countSequence ++
}

if ("N".equals(parameters.sequence)) { // re-order category list item
    custRequestAndCustRequestItems = UtilMisc.sortMaps(custRequestAndCustRequestItems, ["parentCustRequestId"])
}
//set status back for display in Find screen
if("".equals(parameters.statusId)){
    parameters.statusId = "Any"
}
context.custRequestAndCustRequestItems = custRequestAndCustRequestItems

// unplanned backlog item list

productId = parameters.productId

conditionList = []
orConditionList = []
mainConditionList = []

conditionList.add(EntityCondition.makeCondition("custRequestTypeId", EntityOperator.EQUALS, "RF_UNPLAN_BACKLOG"))
conditionList.add(EntityCondition.makeCondition("productId", EntityOperator.EQUALS, parameters.productId))

orConditionList.add(EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "CRQ_ACCEPTED"))
orConditionList.add(EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "CRQ_REOPENED"))

orConditions = EntityCondition.makeCondition(orConditionList, EntityOperator.OR)
conditions = EntityCondition.makeCondition(conditionList, EntityOperator.AND)

mainConditionList.add(orConditions)
mainConditionList.add(conditions)

unplannedList = select("custRequestId", "custSequenceNum", "statusId", "description", "custEstimatedMilliSeconds", "custRequestName", "parentCustRequestId").from("CustRequestAndCustRequestItem").where(mainConditionList).orderBy("custSequenceNum").queryList()

def countSequenceUnplanned = 1
def unplanBacklogItems = []
unplannedList.each() { unplannedItem ->
    def tempUnplanned = [:]
    tempUnplanned.putAll(unplannedItem)
    tempUnplanned.custSequenceNum = countSequenceUnplanned
    tempUnplanned.realSequenceNum = unplannedItem.custSequenceNum
    // if custRequest has task then get Actual Hours
    unplanCustWorkEffortList = from("CustRequestWorkEffort").where("custRequestId", unplannedItem.custRequestId).queryList()
    if (unplanCustWorkEffortList) {
        actualHours = 0.00
        unplanCustWorkEffortList.each() { custWorkEffortMap ->
            result = runService('getScrumActualHour', ["taskId" : custWorkEffortMap.workEffortId,"partyId" : null, "userLogin" : userLogin])
            actualHours += result.actualHours
        }
        if(actualHours) {
            tempUnplanned.actualHours = actualHours
        } else {
            tempUnplanned.actualHours = null
        }
    } else {
        tempUnplanned.actualHours = null
    }
    unplanBacklogItems.add(tempUnplanned)
    countSequenceUnplanned ++
}
if ("N".equals(parameters.UnplannedSequence)) { // re-order category list item
    unplanBacklogItems = UtilMisc.sortMaps(unplanBacklogItems, ["parentCustRequestId"])
}
context.unplanBacklogItems = unplanBacklogItems