| /* |
| * 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.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 |
| |
| productId =parameters.productId |
| custRequestList=[] |
| backlogList=[] |
| custRequestList = from("CustRequestItem").where("productId", productId).queryList() |
| custRequestList.each { custRequestListMap -> |
| custRequestId=custRequestListMap.custRequestId |
| exprBldr = [] |
| exprBldr.add(EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "CRQ_REOPENED")) |
| exprBldr.add(EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "CRQ_REVIEWED")) |
| andExprs = [] |
| andExprs.add(EntityCondition.makeCondition("custRequestId", EntityOperator.EQUALS, custRequestId)) |
| andExprs.add(EntityCondition.makeCondition(exprBldr, EntityOperator.OR)) |
| custRequestTypeCond = EntityCondition.makeCondition(andExprs, EntityOperator.AND) |
| orderBy = ["custRequestTypeId"] |
| productBacklogList = from("CustRequest").where(andExprs).orderBy("custRequestTypeId").queryList() |
| productBacklogList.each { productBacklogMap -> |
| productBackId = productBacklogMap.custRequestId |
| taskBacklogList = from("CustRequestWorkEffort").where("custRequestId", productBackId).queryList() |
| int countImplTask=0, countImplTaskComplete=0, countInstallTask=0, countInstallTaskComplete=0, countErrTask=0, countErrTaskComplete=0, countTestTask=0 |
| taskBacklogList.each { taskBacklogMap -> |
| taskId = taskBacklogMap.workEffortId |
| |
| task = from("WorkEffort").where("workEffortId", taskId).queryOne() |
| if (task.workEffortTypeId == "SCRUM_TASK_IMPL") { |
| countImplTask+=1 |
| if ( task.currentStatusId == "STS_COMPLETED" || task.currentStatusId == "STS_CANCELLED") { |
| countImplTaskComplete+=1 |
| } |
| } |
| else if (task.workEffortTypeId == "SCRUM_TASK_INST") { |
| countInstallTask+=1 |
| if ( task.currentStatusId == "STS_COMPLETED" || task.currentStatusId == "STS_CANCELLED") { |
| countInstallTaskComplete+=1 |
| } |
| } |
| else if (task.workEffortTypeId == "SCRUM_TASK_ERROR") { |
| countErrTask+=1 |
| if ( task.currentStatusId == "STS_COMPLETED" || task.currentStatusId == "STS_CANCELLED") { |
| countErrTaskComplete+=1 |
| } |
| } |
| else if (task.workEffortTypeId == "SCRUM_TASK_TEST" || task.currentStatusId == "STS_CANCELLED") { |
| countTestTask+=1 |
| } |
| } |
| if ((countImplTask > 0 || countErrTask > 0 || countInstallTask > 0) && countImplTask == countImplTaskComplete |
| && countInstallTask == countInstallTaskComplete && countErrTask == countErrTaskComplete && countTestTask > 0) { |
| productBacklogMap = productBacklogMap.getAllFields() |
| backlogList.add(productBacklogMap) |
| } |
| } |
| } |
| if (backlogList) { |
| backlogList = UtilMisc.sortMaps(backlogList, ["-custRequestName"]) |
| context.backlogList = backlogList |
| } |
| |