/* * 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 org.apache.ofbiz.entity.condition.* import org.apache.ofbiz.base.util.* import org.apache.ofbiz.entity.util.EntityUtil roleTypeId = null paramCond = [] products = [] productId = parameters.productId internalName = parameters.internalName statusId = parameters.statusId if ("Any".equals(statusId)) { statusId = null } partyId = parameters.partyId if(!security.hasEntityPermission("SCRUM", "_ADMIN", session)){ if(security.hasEntityPermission("SCRUM_PRODUCT", "_ADMIN", session)){ roleTypeId = "PRODUCT_OWNER" } } if (userLogin) { if(UtilValidate.isNotEmpty(partyId)){ paramCond.add(EntityCondition.makeCondition("partyId", EntityOperator.EQUALS, partyId)) } if(UtilValidate.isNotEmpty(productId)){ paramCond.add(EntityCondition.makeCondition("productId", EntityOperator.LIKE, productId + "%")) } if(UtilValidate.isNotEmpty(internalName)){ paramCond.add(EntityCondition.makeCondition("internalName", EntityOperator.LIKE, "%" + internalName + "%")) } if(UtilValidate.isNotEmpty(statusId)){ if ("PRODUCT_ACTIVE".equals(statusId)) { paramCond.add(EntityCondition.makeCondition("supportDiscontinuationDate", EntityOperator.EQUALS, null)) } else { paramCond.add(EntityCondition.makeCondition("supportDiscontinuationDate", EntityOperator.NOT_EQUAL, null)) } } paramCond.add(EntityCondition.makeCondition("productTypeId", EntityOperator.EQUALS, "SCRUM_ITEM")) paramCond.add(EntityCondition.makeCondition("roleTypeId", EntityOperator.EQUALS, "PRODUCT_OWNER_COMP")) paramCond.add(EntityCondition.makeCondition("thruDate", EntityOperator.EQUALS, null)) allProducts = from("ProductAndRole").where(paramCond).orderBy("groupName", "internalName").queryList() partyAndSecurityGroupList = select("partyId", "groupId") .from("ScrumMemberUserLoginAndSecurityGroup").where(EntityCondition.makeCondition([ EntityCondition.makeCondition ("partyId", EntityOperator.EQUALS, userLogin.partyId), EntityCondition.makeCondition ("partyStatusId", EntityOperator.NOT_EQUAL, "PARTY_DISABLED"), EntityCondition.makeCondition ("thruDate", EntityOperator.EQUALS, null) ], EntityJoinOperator.AND)) .orderBy("partyId") .queryList() context.partyAndSecurityGroupList = partyAndSecurityGroupList boolean addAllProducts = false allProducts.each { product -> product = product.getAllFields() productMap = from("Product").where("productId", product.productId).queryOne() product.put("longDescription",productMap.longDescription) if(security.hasEntityPermission("SCRUM", "_ADMIN", session)){ addAllProducts = true }else{ ismember = false if (partyAndSecurityGroupList) { groupId = partyAndSecurityGroupList[0].groupId if ("SCRUM_PRODUCT_OWNER".equals(groupId)) { productAndRoleList = from("ProductRole").where("productId", product.productId, "partyId", userLogin.partyId, "thruDate", null).queryList() if (productAndRoleList) { productAndRoleList.each { productAndRoleMap -> productIdInner = productAndRoleMap.productId if (productIdInner.equals(product.productId)) { ismember = true } } } } else if ("SCRUM_STAKEHOLDER".equals(groupId)) { // check in company relationship. scrumRolesCond = EntityCondition.makeCondition([ EntityCondition.makeCondition ("partyId", EntityOperator.EQUALS, userLogin.partyId), EntityCondition.makeCondition ("roleTypeId", EntityOperator.EQUALS, "STAKEHOLDER"), EntityCondition.makeCondition ("partyStatusId", EntityOperator.NOT_EQUAL, "PARTY_DISABLED"), EntityCondition.makeCondition ("thruDate", EntityOperator.EQUALS, null) ], EntityJoinOperator.AND) scrumRolesPersonAndCompanyList = from("ScrumRolesPersonAndCompany").where(scrumRolesCond).queryList() productRoleList = from("ProductRole").where("partyId", scrumRolesPersonAndCompanyList[0].partyIdFrom, "roleTypeId", "PRODUCT_OWNER_COMP", "thruDate", null).queryList() if (productRoleList) { productRoleList.each { productRoleMap -> stakeholderProduct = productRoleMap.productId if (stakeholderProduct.equals(product.productId)) { ismember = true } } } //check in product. if (ismember == false) { productAndRoleList = from("ProductAndRole").where("productId" : product.productId, "partyId" : userLogin.partyId, "roleTypeId" : "STAKEHOLDER", "supportDiscontinuationDate" : null, "thruDate" : null).queryList() if (productAndRoleList) { ismember = true } } } else if ("SCRUM_MASTER".equals(groupId)) { //check in product. productRoleList = [] productRoleList = from("ProductAndRole").where("productId" : product.productId, "partyId" : userLogin.partyId, "roleTypeId" : "SCRUM_MASTER", "supportDiscontinuationDate" : null, "thruDate" : null).queryList() if (productRoleList) { ismember = true } //check in project. if (ismember == false) { projects = [] projects = from("WorkEffortAndProduct").where("productId", product.productId, "workEffortTypeId", "SCRUM_PROJECT", "currentStatusId", "SPJ_ACTIVE").queryList() if (projects) { projects.each { project -> projectPartyAssignment = from("WorkEffortPartyAssignment").where("partyId", userLogin.partyId, "workEffortId", project.workEffortId).queryList() if (projectPartyAssignment) { ismember = true } } } } //check in sprint. if (ismember == false) { projects.each { project -> allSprintList = [] allSprintList = from("WorkEffort").where("workEffortParentId", project.workEffortId, "currentStatusId", "SPRINT_ACTIVE").queryList() allSprintList.each { SprintListMap -> sprintId = SprintListMap.workEffortId workEffortPartyAssignment = from("WorkEffortPartyAssignment").where("partyId", userLogin.partyId, "workEffortId", sprintId).queryList() if (workEffortPartyAssignment) { ismember = true } } } } } else { projects = [] projects = from("WorkEffortAndProduct").where("productId", product.productId, "workEffortTypeId", "SCRUM_PROJECT", "currentStatusId", "SPJ_ACTIVE").queryList() if (projects) { projects.each { project -> allSprintList = [] allSprintList = from("WorkEffort").where("workEffortParentId", project.workEffortId, "currentStatusId", "SPRINT_ACTIVE").queryList() allSprintList.each { SprintListMap -> sprintId = SprintListMap.workEffortId workEffortPartyAssignment = from("WorkEffortPartyAssignment").where("partyId", userLogin.partyId, "workEffortId", sprintId).queryList() if (workEffortPartyAssignment) { ismember = true } } } } if (ismember == false) { exprBldr = [EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "CRQ_REVIEWED"), EntityCondition.makeCondition("statusId", EntityOperator.EQUALS, "CRQ_REOPENED")] andExprs = [EntityCondition.makeCondition("productId", EntityOperator.EQUALS, product.productId), EntityCondition.makeCondition("currentStatusId", EntityOperator.EQUALS, "STS_CREATED"), EntityCondition.makeCondition(exprBldr, EntityOperator.OR)] unplannedBacklogCond = EntityCondition.makeCondition(andExprs, EntityOperator.AND) unplannedBacklogList = from("UnPlannedBacklogsAndTasks").where(unplannedBacklogCond).queryList() if (unplannedBacklogList) { unplannedBacklogList.each { unplannedMap -> workEffortId = unplannedMap.workEffortId workEffortPartyAssignment = from("WorkEffortPartyAssignment").where("partyId", userLogin.partyId, "workEffortId", workEffortId).queryList() if (workEffortPartyAssignment) { ismember = true } } } } } if (ismember) { products.add(product) } } } if(addAllProducts) products.add(product) } } else { Debug.logError("Party ID missing =========>>> : null ", "") } if (products){ context.listIt = products }