| /* |
| * 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.ofbiz.entity.condition.*; |
| import org.ofbiz.base.util.*; |
| |
| cond = EntityCondition.makeCondition([ |
| EntityCondition.makeCondition ("projectTypeId", EntityOperator.EQUALS, "SCRUM_PROJECT"), |
| EntityCondition.makeCondition ("projectStatusId", EntityOperator.NOT_EQUAL, "SPJ_CLOSED") |
| ], EntityJoinOperator.AND); |
| securityGroupCond = 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); |
| fields = new HashSet(["partyId", "groupId"]); |
| |
| allSprints = delegator.findList("ProjectSprint", cond, null, ["projectName", "-sprintActualStartDate"], null, false); |
| partyAndSecurityGroupList = delegator.findList("ScrumMemberUserLoginAndSecurityGroup", securityGroupCond, fields, ["partyId"], null, false); |
| oldProjectId = null; |
| newProjectId = null; |
| countSprint = 0; |
| sprints = []; |
| allSprints.each { sprint -> |
| newProjectId = sprint.projectId; |
| productAndRole = delegator.findByAnd("ProductAndRole", ["roleTypeId" : "PRODUCT_OWNER_COMP", "productId" : sprint.productId], null, false); |
| companyId = ""; |
| companyName = ""; |
| if (productAndRole.size() > 0) { |
| companyName = productAndRole.get(0).groupName; |
| companyId = productAndRole.get(0).partyId; |
| } |
| sprint = sprint.getAllFields(); |
| sprint.put("companyId", companyId) |
| sprint.put("companyName", companyName) |
| product = delegator.findOne("Product",["productId" : sprint.productId], false); |
| productName = ""; |
| if (product != null) productName = product.internalName; |
| sprint.put("productName", productName); |
| //sprint.add("companyName", companyName, "String") |
| if (oldProjectId != newProjectId) { |
| oldProjectId = newProjectId; |
| countSprint = 0; |
| ismember = false; |
| if (partyAndSecurityGroupList) { |
| groupId = partyAndSecurityGroupList[0].groupId; |
| if ("SCRUM_PRODUCT_OWNER".equals(groupId)) { |
| productAndRoleList = delegator.findByAnd("ProductRole", ["productId" : sprint.productId, "partyId" : partyAndSecurityGroupList.getAt(0).partyId, "thruDate" : null], null, false); |
| if (productAndRoleList) { |
| 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 = delegator.findList("ScrumRolesPersonAndCompany", scrumRolesCond, null, null, null, false); |
| productRoleList = delegator.findByAnd("ProductRole", ["partyId" : scrumRolesPersonAndCompanyList[0].partyIdFrom, "roleTypeId" : "PRODUCT_OWNER_COMP", "thruDate" : null], null, false); |
| if (productRoleList) { |
| productRoleList.each { productRoleMap -> |
| stakeholderProduct = productRoleMap.productId; |
| if (stakeholderProduct.equals(sprint.productId)) { |
| ismember = true; |
| } |
| } |
| } |
| //check in product. |
| if (ismember == false) { |
| productAndRoleList = delegator.findByAnd("ProductAndRole", ["productId" : sprint.productId, "partyId" : userLogin.partyId |
| , "roleTypeId" : "STAKEHOLDER", "supportDiscontinuationDate" : null, "thruDate" : null], null, false); |
| if (productAndRoleList) { |
| ismember = true; |
| } |
| } |
| } else if("SCRUM_MASTER".equals(groupId)) { |
| //check in product |
| productRoleList = []; |
| productRoleList = delegator.findByAnd("ProductAndRole", ["productId" : sprint.productId, "partyId" : userLogin.partyId |
| , "roleTypeId" : "SCRUM_MASTER", "supportDiscontinuationDate" : null, "thruDate" : null], null, false); |
| if (productRoleList) { |
| ismember = true; |
| } |
| //check in project. |
| if (ismember == false) { |
| projectPartyAssignment = delegator.findByAnd("WorkEffortPartyAssignment", ["workEffortId" : sprint.projectId, "partyId" : userLogin.partyId], null, false); |
| if (projectPartyAssignment) { |
| ismember = true; |
| } |
| } |
| //check in sprint. |
| if (ismember == false) { |
| allSprintList = []; |
| allSprintList = delegator.findByAnd("WorkEffort", ["workEffortParentId" : sprint.projectId], null, false); |
| allSprintList.each { SprintListMap -> |
| sprintId = SprintListMap.workEffortId; |
| workEffortPartyAssignment = delegator.findByAnd("WorkEffortPartyAssignment", ["workEffortId" : sprintId, "partyId" : userLogin.partyId], null, false); |
| if (workEffortPartyAssignment) { |
| ismember = true; |
| } |
| } |
| } |
| } else { |
| allSprintList = []; |
| allSprintList = delegator.findByAnd("WorkEffort", ["workEffortParentId" : sprint.projectId], null, false); |
| allSprintList.each { SprintListMap -> |
| sprintId = SprintListMap.workEffortId; |
| workEffortPartyAssignment = delegator.findByAnd("WorkEffortPartyAssignment", ["workEffortId" : sprintId, "partyId" : userLogin.partyId], null, false); |
| if (workEffortPartyAssignment) { |
| ismember = true; |
| } |
| } |
| } |
| } |
| if (security.hasEntityPermission("SCRUM", "_ADMIN", session) |
| || ((security.hasEntityPermission("SCRUM", "_ROLE_ADMIN", session) || security.hasEntityPermission("SCRUM", "_ROLE_VIEW", session) |
| || security.hasEntityPermission("SCRUM_PROJECT", "_ROLE_ADMIN", session) || security.hasEntityPermission("SCRUM_PROJECT", "_ROLE_VIEW", session) |
| || security.hasEntityPermission("SCRUM_PROJECT", "_VIEW", session)) && ismember)) { |
| sprints.add(sprint); |
| countSprint++; |
| } |
| } else { |
| if (countSprint < 4) { |
| ismember = false; |
| if (partyAndSecurityGroupList) { |
| groupId = partyAndSecurityGroupList[0].groupId; |
| if ("SCRUM_PRODUCT_OWNER".equals(groupId)) { |
| productAndRoleList = delegator.findByAnd("ProductRole", ["productId" : sprint.productId, "partyId" : partyAndSecurityGroupList.getAt(0).partyId, "thruDate" : null], null, false); |
| if (productAndRoleList) { |
| 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 = delegator.findList("ScrumRolesPersonAndCompany", scrumRolesCond, null, null, null, false); |
| productRoleList = delegator.findByAnd("ProductRole", ["partyId" : scrumRolesPersonAndCompanyList[0].partyIdFrom, "roleTypeId" : "PRODUCT_OWNER_COMP", "thruDate" : null], null, false); |
| if (productRoleList) { |
| productRoleList.each { productRoleMap -> |
| stakeholderProduct = productRoleMap.productId; |
| if (stakeholderProduct.equals(sprint.productId)) { |
| ismember = true; |
| } |
| } |
| } |
| //check in product. |
| if (ismember == false) { |
| productAndRoleList = delegator.findByAnd("ProductAndRole", ["productId" : sprint.productId, "partyId" : userLogin.partyId |
| , "roleTypeId" : "STAKEHOLDER", "supportDiscontinuationDate" : null, "thruDate" : null], null, false); |
| if (productAndRoleList) { |
| ismember = true; |
| } |
| } |
| } else if("SCRUM_MASTER".equals(groupId)) { |
| //check in product |
| productRoleList = []; |
| productRoleList = delegator.findByAnd("ProductAndRole", ["productId" : sprint.productId, "partyId" : userLogin.partyId |
| , "roleTypeId" : "SCRUM_MASTER", "supportDiscontinuationDate" : null, "thruDate" : null], null, false); |
| if (productRoleList) { |
| ismember = true; |
| } |
| //check in project. |
| if (ismember == false) { |
| projectPartyAssignment = delegator.findByAnd("WorkEffortPartyAssignment", ["workEffortId" : sprint.projectId, "partyId" : userLogin.partyId], null, false); |
| if (projectPartyAssignment) { |
| ismember = true; |
| } |
| } |
| //check in sprint. |
| if (ismember == false) { |
| allSprintList = []; |
| allSprintList = delegator.findByAnd("WorkEffort", ["workEffortParentId" : sprint.projectId], null, false); |
| allSprintList.each { SprintListMap -> |
| sprintId = SprintListMap.workEffortId; |
| workEffortPartyAssignment = delegator.findByAnd("WorkEffortPartyAssignment", ["workEffortId" : sprintId, "partyId" : userLogin.partyId], null, false); |
| if (workEffortPartyAssignment) { |
| ismember = true; |
| } |
| } |
| } |
| } else { |
| allSprintList = []; |
| allSprintList = delegator.findByAnd("WorkEffort", ["workEffortParentId" : sprint.projectId], null, false); |
| allSprintList.each { SprintListMap -> |
| sprintId = SprintListMap.workEffortId; |
| workEffortPartyAssignment = delegator.findByAnd("WorkEffortPartyAssignment", ["workEffortId" : sprintId, "partyId" : userLogin.partyId], null, false); |
| if (workEffortPartyAssignment) { |
| ismember = true; |
| } |
| } |
| } |
| } |
| if (security.hasEntityPermission("SCRUM", "_ADMIN", session) |
| || ((security.hasEntityPermission("SCRUM", "_ROLE_ADMIN", session) || security.hasEntityPermission("SCRUM", "_ROLE_VIEW", session) |
| || security.hasEntityPermission("SCRUM_PROJECT", "_ROLE_ADMIN", session) || security.hasEntityPermission("SCRUM_PROJECT", "_ROLE_VIEW", session) |
| || security.hasEntityPermission("SCRUM_PROJECT", "_VIEW", session)) && ismember)) { |
| sprints.add(sprint); |
| countSprint++; |
| } |
| } |
| } |
| } |
| if (sprints) { |
| sprints = UtilMisc.sortMaps(sprints, ["companyName", "projectName", "productName"]) |
| context.sprints = sprints; |
| } |