AzSKStaging.ADO

1.16.0

Framework/BugLog/AzSKADOAutoBugLogging.ps1

                                using namespace System.Management.Automation

Set-StrictMode -Version Latest 

class AzSKADOAutoBugLogging : CommandBase

{    

    [string] $OrgName

    [string] $BugLogProjectName

    $ScanResult = @();

    $ScanResultToCloseBug = @();

    hidden [InvocationInfo] $InvocationContext;

    hidden [bool] $IsLAFile = $false;

    $ResourceControlJson = @();

    $BugTemplate = $null;

    $STMappingFilePath = $null;

    $BugDescription = $null;

    [int] $MaxBugsToLog;

    AzSKADOAutoBugLogging([string] $organizationName, $BugLogProject, $AutoBugLog, $ResourceTypeName, $ControlIds, $scanResultData, $BugTemplate, [InvocationInfo] $invocationContext, $isLAFile, $stMappingFilePath, $BugDescription, $MaxBugLog): 

        Base($organizationName, $invocationContext) 

    { 

        $this.OrgName = $organizationName;

        $this.BugLogProjectName = $BugLogProject;

        $this.IsLAFile = $isLAFile;

        $this.BugTemplate = $BugTemplate;

        $this.STMappingFilePath = $stMappingFilePath;

        $this.BugDescription = $BugDescription;

        $this.MaxBugsToLog = $MaxBugLog

        #Can remove later if not needed.

        $resourcetypes = @()

        if($ResourceTypeName -ne [ResourceTypeName]::All)

        {

            $resourcetypes += ([SVTMapping]::AzSKADOResourceMapping |

                    Where-Object { $_.ResourceTypeName -eq $ResourceTypeName } | Select-Object JsonFileName, ResourceTypeName)

        }

        else

        {

            $resourcetypes += ([SVTMapping]::AzSKADOResourceMapping | Sort-Object ResourceTypeName | Select-Object JsonFileName, ResourceTypeName)

        }

        $resourcetypes = $resourcetypes | Sort-Object -Property JsonFileName -Unique

        foreach ($item in $resourcetypes) {

            $this.ResourceControlJson += [ConfigurationManager]::LoadServerConfigFile("$($item.JsonFileName)").Controls;

        }

        $this.GetAndFilterScanResultData($AutoBugLog, $ResourceTypeName, $ControlIds, $scanResultData, $isLAFile, $false);

    }

    AzSKADOAutoBugLogging([string] $organizationName, $BugLogProject, $ResourceTypeName, $ControlIds, $scanResultData, [InvocationInfo] $invocationContext, $isLAFile, $MaxBugLog): 

        Base($organizationName, $invocationContext) 

    { 

        $this.OrgName = $organizationName;

        $this.BugLogProjectName = $BugLogProject;

        $this.IsLAFile = $isLAFile;

        $this.MaxBugsToLog = $MaxBugLog

        #Can remove later if not needed.

        $resourcetypes = @()

        if($ResourceTypeName -ne [ResourceTypeName]::All)

        {

            $resourcetypes += ([SVTMapping]::AzSKADOResourceMapping |

                    Where-Object { $_.ResourceTypeName -eq $ResourceTypeName } | Select-Object JsonFileName, ResourceTypeName)

        }

        else

        {

            $resourcetypes += ([SVTMapping]::AzSKADOResourceMapping | Sort-Object ResourceTypeName | Select-Object JsonFileName, ResourceTypeName)

        }

        $resourcetypes = $resourcetypes | Sort-Object -Property JsonFileName -Unique

        foreach ($item in $resourcetypes) {

            $this.ResourceControlJson += [ConfigurationManager]::LoadServerConfigFile("$($item.JsonFileName)").Controls;

        }

        $this.GetAndFilterScanResultData($null, $ResourceTypeName, $ControlIds, $scanResultData, $isLAFile, $true);

    }

    [SVTEventContext[]] StartBugLogging()

    {

        return $this.InitiateBugLogging($false);

    }

    [SVTEventContext[]] ClosingLoggedBugs()

    {

        return $this.InitiateBugLogging($true);

    }

    hidden [SVTEventContext[]] InitiateBugLogging($isCloseBug) {  

        [ResourceContext] $ResourceContext = $null;

        [SVTEventContext[]] $ResourceContextControlResult = $null;

        $resourcesToLogBugs = @($this.ScanResult | Group-Object -Property ResourceId);

        if ($isCloseBug) {

            $this.PublishCustomMessage("`nNumber of resources for which bug clossing will be evaluated: $($resourcesToLogBugs.count)",[MessageType]::Info);

        }

        else {

            $this.PublishCustomMessage("`nNumber of resources for which bug logging will be evaluated: $($resourcesToLogBugs.count)",[MessageType]::Info);

        }

        foreach ($controlResult in $resourcesToLogBugs) {

            if ($this.IsLAFile) {

                $ResourceContext = [ResourceContext]@{

                    ResourceGroupName = $controlResult.Group[0].ResourceGroup;

                    ResourceName = $controlResult.Group[0].ResourceName_s;

                    ResourceType = "ADO."+$controlResult.Group[0].FeatureName_s;

                    ResourceTypeName = $controlResult.Group[0].FeatureName_s;

                    ResourceId = $controlResult.Group[0].ResourceId

                    ResourceDetails = @{ResourceLink = $controlResult.Group[0].ResourceLink_s}

                };    

            }

            else {

                $ResourceContext = [ResourceContext]@{

                    ResourceGroupName = $controlResult.Group[0].ResourceGroupName;

                    ResourceName = $controlResult.Group[0].ResourceName;

                    ResourceType = "ADO."+$controlResult.Group[0].FeatureName;

                    ResourceTypeName = $controlResult.Group[0].FeatureName;

                    ResourceId = $controlResult.Group[0].ResourceId

                    ResourceDetails = @{ResourceLink = $controlResult.Group[0].ResourceLink}

                };

            }

            $ResourceContextControlResult += $this.CreateResultContextObject($ResourceContext, $controlResult.Group);

        }

        return $this.BugLoggingEvaluation($ResourceContextControlResult, $isCloseBug);

    }

    #function to call AutoBugLog class for performing bug logging

    hidden [SVTEventContext []] BugLoggingEvaluation([SVTEventContext []] $ControlResults, $isCloseBug)

    {

        $AutoBugLog = $null;

        if (!$isCloseBug) {

            $AutoBugLog = [AutoBugLog]::AutoBugInstance

            if (!$AutoBugLog) {

                [BugLogPathManager]::checkValidPathFlag = $true;

                $BugLogParameterValue = $this.InvocationContext.BoundParameters["AutoBugLog"];

                $AutoBugLog = [AutoBugLog]::GetInstance($this.OrgName, $this.InvocationContext, $null, $BugLogParameterValue);

            }

            $resourcename = "";

            $resourceid = "";

            $assignee = "";

            #$ControlResults = $ControlResults | sort-object -property @{e={$_.ResourceContext.ResourceName}}

            foreach ($controlResult in $ControlResults) {

                #if different resource then only display message.

                if ($resourceid -ne $controlResult.ResourceContext.ResourceId ) {

                    $this.PublishCustomMessage([Constants]::DoubleDashLine, [MessageType]::Info);

                    $this.PublishCustomMessage("Running bug logging: [FeatureName: $($controlResult.FeatureName)] [ParentGroupName: $($controlResult.ResourceContext.ResourceGroupName)] [ResourceName: $($controlResult.ResourceContext.ResourceName)]", [MessageType]::Info);                

                }

                $resourcename = $controlResult.ResourceContext.ResourceName

                #if different resource then black assignee as for different resource assigneed need to evaluate again.

                if($resourceid -ne $controlResult.ResourceContext.ResourceId){

                    $assignee = "";

                }

                #if resource alredy ran bug logging for control and servicetree info is not find, then dont run bug logging for next control.

                if (($resourceid -ne $controlResult.ResourceContext.ResourceId -or $assignee)) {

                    $assignee = $AutoBugLog.LogBugsInADOFromCSV($controlResult, $this.BugLogProjectName, $this.BugTemplate, $this.STMappingFilePath, $this.BugDescription, $assignee)  

                }

                $resourceid = $controlResult.ResourceContext.ResourceId

            }

        }

        else {

            $this.PublishCustomMessage([Constants]::DoubleDashLine, [MessageType]::Info);

            $this.PublishCustomMessage("Closing bugs in bulk mode...", [MessageType]::Info);

            #$AutoClose = [AutoCloseBugManager]::new($this.OrganizationContext.OrganizationName);

            #$AutoClose.AutoCloseBugCSV($ControlResults)

        }

        $this.PublishCustomMessage([Constants]::DoubleDashLine, [MessageType]::Info);

        $this.PublishCustomMessage("Bug logging has been completed.", [MessageType]::Info);

        $this.PublishCustomMessage([Constants]::DoubleDashLine, [MessageType]::Info);

        return $ControlResults;

    }

    hidden [bool] GetAndFilterScanResultData($AutoBugLog, $ResourceTypeName, $ControlIds, $scanResultData, $isLAFile, $AutoCloseBug)

    {

        try {

            $this.PublishCustomMessage("`nFiltering scan result data.....",[MessageType]::Info);

            if (!$isLAFile) {

                if ($ResourceTypeName) {

                    $scanResultData = $scanResultData | Where { $_.FeatureName -eq $ResourceTypeName }

                }

                if ($AutoBugLog -eq "BaseLineControls" -and $scanResultData) {

                    $scanResultData = $scanResultData | Where { $_.IsBaselineControl -eq "Yes" }

                }

                if ($ControlIds -and $scanResultData) {

                    $cids = $this.ConvertToStringArray($ControlIds);

                    $scanResultData = $scanResultData | Where { $_.ControlId -In $cids }

                }

                if ($scanResultData -and $AutoBugLog -ne $null) {

                    $scanResultData = $scanResultData | Where {$_.Status -eq "Failed" -or $_.Status -eq "Varify"} 

                }

                if ($AutoCloseBug) {

                    $scanResultData = $scanResultData | Where {$_.Status -eq "Passed"} 

                }

                if ($scanResultData -and $this.MaxBugsToLog -and ($scanResultData.count -gt $this.MaxBugsToLog)) {

                    $scanResultData = $scanResultData[0..($this.MaxBugsToLog - 1)];

                }

                $this.ScanResult += $scanResultData;   

            }

            else {

                if ($ResourceTypeName) {

                    $scanResultData = $scanResultData | Where { $_.FeatureName_s -eq $ResourceTypeName }

                }

                if ($AutoBugLog -eq "BaseLineControls" -and $scanResultData) {

                    $scanResultData = $scanResultData | Where { $_.IsBaselineControl_b -eq "TRUE" }

                    Write-Host 'Can not read IsBaselineControl_b data from csv.' -ForegroundColor Yellow

                }

                if ($ControlIds -and $scanResultData) {

                    $cids = $this.ConvertToStringArray($ControlIds);

                    $scanResultData = $scanResultData | Where { $_.ControlId_s -In $cids }

                }

                if ($scanResultData -and $AutoBugLog -ne $null) {

                    $scanResultData = $scanResultData | Where {$_.ControlStatus_s -eq "Failed" -or $_.ControlStatus_s -eq "Verify"}

                }

                if ($AutoCloseBug) {

                    $scanResultData = $scanResultData | Where {$_.ControlStatus_s -eq "Passed"}

                }

                if ($scanResultData -and $this.MaxBugsToLog -and ($scanResultData.count -gt $this.MaxBugsToLog)) {

                    $scanResultData = $scanResultData[0..($this.MaxBugsToLog - 1)];

                }

                $this.ScanResult += $scanResultData;

            }

            return $true;   

        }

        catch {

            return $false;

        }

    }

    hidden [SVTEventContext[]] CreateResultContextObject($ResourceContext, $controlResult)

    {

        [SVTEventContext[]] $ResourceContextControlResult = @();

        [ControlResult[]] $controlResults = @();

        [ControlItem[]] $controlResults = @();

        foreach ($item in $controlResult) {

            $CtrlItm = [ControlItem]::new();

            if ($this.IsLAFile) 

            {

                $currentControlJson = $this.ResourceControlJson | Where {$_.ControlId -eq $item.ControlID_s}

                $CtrlItm.ID = $currentControlJson.ID

                $CtrlItm.ControlID = $item.ControlID_s

                $CtrlItm.ControlSeverity = $item.ControlSeverity_s

                #$CtrlItm.IsBaselineControl = $item.IsBaselineControl

                $CtrlItm.Description = $currentControlJson.Description 

                $CtrlItm.Recommendation = $currentControlJson.Recommendation

                $CtrlItm.Rationale = $currentControlJson.Rationale

                $CtrlResult = [ControlResult]::new();

                $CtrlResult.VerificationResult = $item.ControlStatus_s

                #$CtrlResult.ActualVerificationResult = $item.ActualVerificationResult_s

                $CtrlResult.AdditionalInfoInCSV = $item.AdditionalInfo_s

            }

            else {

                $currentControlJson = $this.ResourceControlJson | Where {$_.ControlId -eq $item.ControlID}

                $CtrlItm.ID = $currentControlJson.ID

                $CtrlItm.ControlID = $item.ControlID

                $CtrlItm.ControlSeverity = $item.ControlSeverity

                $CtrlItm.IsBaselineControl = $item.IsBaselineControl

                $CtrlItm.Description = $item.Description

                $CtrlItm.Recommendation = $item.Recommendation

                $CtrlItm.Rationale = $item.Rationale

                $CtrlResult = [ControlResult]::new();

                $CtrlResult.VerificationResult = $item.Status

                #$CtrlResult.ActualVerificationResult = $item.ActualStatus

                $CtrlResult.AdditionalInfoInCSV = $item.AdditionalInfo

            }

            $svtControlResult = [SVTEventContext]@{

                FeatureName = $ResourceContext[0].ResourceTypeName 

                Metadata = [Metadata]@{

                    Reference = "";

                };

                OrganizationContext = $this.OrganizationContext;

                ResourceContext = $ResourceContext;

                ControlResults = $CtrlResult;

                ControlItem = $CtrlItm;

            };

            $ResourceContextControlResult += $svtControlResult;

        }

        return $ResourceContextControlResult;

    }

}

# SIG # Begin signature block

# MIInvAYJKoZIhvcNAQcCoIInrTCCJ6kCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCAV2Es4ykNUZtk0

# XabVmCOKKYputYoglGKC+imIEB/qY6CCDYEwggX/MIID56ADAgECAhMzAAACUosz

# qviV8znbAAAAAAJSMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjEwOTAyMTgzMjU5WhcNMjIwOTAxMTgzMjU5WjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDQ5M+Ps/X7BNuv5B/0I6uoDwj0NJOo1KrVQqO7ggRXccklyTrWL4xMShjIou2I

# sbYnF67wXzVAq5Om4oe+LfzSDOzjcb6ms00gBo0OQaqwQ1BijyJ7NvDf80I1fW9O

# L76Kt0Wpc2zrGhzcHdb7upPrvxvSNNUvxK3sgw7YTt31410vpEp8yfBEl/hd8ZzA

# v47DCgJ5j1zm295s1RVZHNp6MoiQFVOECm4AwK2l28i+YER1JO4IplTH44uvzX9o

# RnJHaMvWzZEpozPy4jNO2DDqbcNs4zh7AWMhE1PWFVA+CHI/En5nASvCvLmuR/t8

# q4bc8XR8QIZJQSp+2U6m2ldNAgMBAAGjggF+MIIBejAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUNZJaEUGL2Guwt7ZOAu4efEYXedEw

# UAYDVR0RBEkwR6RFMEMxKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1

# ZXJ0byBSaWNvMRYwFAYDVQQFEw0yMzAwMTIrNDY3NTk3MB8GA1UdIwQYMBaAFEhu

# ZOVQBdOCqhc3NyK1bajKdQKVMFQGA1UdHwRNMEswSaBHoEWGQ2h0dHA6Ly93d3cu

# bWljcm9zb2Z0LmNvbS9wa2lvcHMvY3JsL01pY0NvZFNpZ1BDQTIwMTFfMjAxMS0w

# Ny0wOC5jcmwwYQYIKwYBBQUHAQEEVTBTMFEGCCsGAQUFBzAChkVodHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY0NvZFNpZ1BDQTIwMTFfMjAx

# MS0wNy0wOC5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAgEAFkk3

# uSxkTEBh1NtAl7BivIEsAWdgX1qZ+EdZMYbQKasY6IhSLXRMxF1B3OKdR9K/kccp

# kvNcGl8D7YyYS4mhCUMBR+VLrg3f8PUj38A9V5aiY2/Jok7WZFOAmjPRNNGnyeg7

# l0lTiThFqE+2aOs6+heegqAdelGgNJKRHLWRuhGKuLIw5lkgx9Ky+QvZrn/Ddi8u

# TIgWKp+MGG8xY6PBvvjgt9jQShlnPrZ3UY8Bvwy6rynhXBaV0V0TTL0gEx7eh/K1

# o8Miaru6s/7FyqOLeUS4vTHh9TgBL5DtxCYurXbSBVtL1Fj44+Od/6cmC9mmvrti

# yG709Y3Rd3YdJj2f3GJq7Y7KdWq0QYhatKhBeg4fxjhg0yut2g6aM1mxjNPrE48z

# 6HWCNGu9gMK5ZudldRw4a45Z06Aoktof0CqOyTErvq0YjoE4Xpa0+87T/PVUXNqf

# 7Y+qSU7+9LtLQuMYR4w3cSPjuNusvLf9gBnch5RqM7kaDtYWDgLyB42EfsxeMqwK

# WwA+TVi0HrWRqfSx2olbE56hJcEkMjOSKz3sRuupFCX3UroyYf52L+2iVTrda8XW

# esPG62Mnn3T8AuLfzeJFuAbfOSERx7IFZO92UPoXE1uEjL5skl1yTZB3MubgOA4F

# 8KoRNhviFAEST+nG8c8uIsbZeb08SeYQMqjVEmkwggd6MIIFYqADAgECAgphDpDS

# AAAAAAADMA0GCSqGSIb3DQEBCwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UECBMK

# V2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0

# IENvcnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0

# ZSBBdXRob3JpdHkgMjAxMTAeFw0xMTA3MDgyMDU5MDlaFw0yNjA3MDgyMTA5MDla

# MH4xCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdS

# ZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMT

# H01pY3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMTEwggIiMA0GCSqGSIb3DQEB

# AQUAA4ICDwAwggIKAoICAQCr8PpyEBwurdhuqoIQTTS68rZYIZ9CGypr6VpQqrgG

# OBoESbp/wwwe3TdrxhLYC/A4wpkGsMg51QEUMULTiQ15ZId+lGAkbK+eSZzpaF7S

# 35tTsgosw6/ZqSuuegmv15ZZymAaBelmdugyUiYSL+erCFDPs0S3XdjELgN1q2jz

# y23zOlyhFvRGuuA4ZKxuZDV4pqBjDy3TQJP4494HDdVceaVJKecNvqATd76UPe/7

# 4ytaEB9NViiienLgEjq3SV7Y7e1DkYPZe7J7hhvZPrGMXeiJT4Qa8qEvWeSQOy2u

# M1jFtz7+MtOzAz2xsq+SOH7SnYAs9U5WkSE1JcM5bmR/U7qcD60ZI4TL9LoDho33

# X/DQUr+MlIe8wCF0JV8YKLbMJyg4JZg5SjbPfLGSrhwjp6lm7GEfauEoSZ1fiOIl

# XdMhSz5SxLVXPyQD8NF6Wy/VI+NwXQ9RRnez+ADhvKwCgl/bwBWzvRvUVUvnOaEP

# 6SNJvBi4RHxF5MHDcnrgcuck379GmcXvwhxX24ON7E1JMKerjt/sW5+v/N2wZuLB

# l4F77dbtS+dJKacTKKanfWeA5opieF+yL4TXV5xcv3coKPHtbcMojyyPQDdPweGF

# RInECUzF1KVDL3SV9274eCBYLBNdYJWaPk8zhNqwiBfenk70lrC8RqBsmNLg1oiM

# CwIDAQABo4IB7TCCAekwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFEhuZOVQ

# BdOCqhc3NyK1bajKdQKVMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMAsGA1Ud

# DwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFHItOgIxkEO5FAVO

# 4eqnxzHRI4k0MFoGA1UdHwRTMFEwT6BNoEuGSWh0dHA6Ly9jcmwubWljcm9zb2Z0

# LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dDIwMTFfMjAxMV8wM18y

# Mi5jcmwwXgYIKwYBBQUHAQEEUjBQME4GCCsGAQUFBzAChkJodHRwOi8vd3d3Lm1p

# Y3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dDIwMTFfMjAxMV8wM18y

# Mi5jcnQwgZ8GA1UdIASBlzCBlDCBkQYJKwYBBAGCNy4DMIGDMD8GCCsGAQUFBwIB

# FjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2RvY3MvcHJpbWFyeWNw

# cy5odG0wQAYIKwYBBQUHAgIwNB4yIB0ATABlAGcAYQBsAF8AcABvAGwAaQBjAHkA

# XwBzAHQAYQB0AGUAbQBlAG4AdAAuIB0wDQYJKoZIhvcNAQELBQADggIBAGfyhqWY

# 4FR5Gi7T2HRnIpsLlhHhY5KZQpZ90nkMkMFlXy4sPvjDctFtg/6+P+gKyju/R6mj

# 82nbY78iNaWXXWWEkH2LRlBV2AySfNIaSxzzPEKLUtCw/WvjPgcuKZvmPRul1LUd

# d5Q54ulkyUQ9eHoj8xN9ppB0g430yyYCRirCihC7pKkFDJvtaPpoLpWgKj8qa1hJ

# Yx8JaW5amJbkg/TAj/NGK978O9C9Ne9uJa7lryft0N3zDq+ZKJeYTQ49C/IIidYf

# wzIY4vDFLc5bnrRJOQrGCsLGra7lstnbFYhRRVg4MnEnGn+x9Cf43iw6IGmYslmJ

# aG5vp7d0w0AFBqYBKig+gj8TTWYLwLNN9eGPfxxvFX1Fp3blQCplo8NdUmKGwx1j

# NpeG39rz+PIWoZon4c2ll9DuXWNB41sHnIc+BncG0QaxdR8UvmFhtfDcxhsEvt9B

# xw4o7t5lL+yX9qFcltgA1qFGvVnzl6UJS0gQmYAf0AApxbGbpT9Fdx41xtKiop96

# eiL6SJUfq/tHI4D1nvi/a7dLl+LrdXga7Oo3mXkYS//WsyNodeav+vyL6wuA6mk7

# r/ww7QRMjt/fdW1jkT3RnVZOT7+AVyKheBEyIXrvQQqxP/uozKRdwaGIm1dxVk5I

# RcBCyZt2WwqASGv9eZ/BvW1taslScxMNelDNMYIZkTCCGY0CAQEwgZUwfjELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9z

# b2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAxMQITMwAAAlKLM6r4lfM52wAAAAACUjAN

# BglghkgBZQMEAgEFAKCBsDAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgor

# BgEEAYI3AgELMQ4wDAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgqEfMCxga

# m4uyOuYLbzxA5j8UYmf7tqk+rY7grLnuD+gwRAYKKwYBBAGCNwIBDDE2MDSgFIAS

# AE0AaQBjAHIAbwBzAG8AZgB0oRyAGmh0dHBzOi8vd3d3Lm1pY3Jvc29mdC5jb20g

# MA0GCSqGSIb3DQEBAQUABIIBADdzHDvSwPtNAyw/e9mJIoyo9o5CPp65u51lNUWm

# qha8Gx9/sGPuKRSEQowCX1BBrY3ilqkEWZIeRXxmtjtSNhieHRzhe5vowT9PG4de

# z0Ta0Sbra7N8/6MqSzSx7NgLpuhXMugCfJLdSwc1OGlb+0dgXLAI8jfWHgIXI8lZ

# 5dqG7eak9fGZZDc6JKmEVKggcvCSiP3OMqXU4wIExid+KR+b2gBLptTaz2XY2vcJ

# EtxKliiVhWMU6IiH2FGY6hStr9o25zirkCZKL0TJNwqJqRyP1DG8Lj9+a2rya591

# pel7DqrNySf8ilaKw3NJBch/Ot+v35BJJSipSSTxca3kzsahghcZMIIXFQYKKwYB

# BAGCNwMDATGCFwUwghcBBgkqhkiG9w0BBwKgghbyMIIW7gIBAzEPMA0GCWCGSAFl

# AwQCAQUAMIIBWQYLKoZIhvcNAQkQAQSgggFIBIIBRDCCAUACAQEGCisGAQQBhFkK

# AwEwMTANBglghkgBZQMEAgEFAAQgdriM60XCB0aY7rjaCZtlz6cZlwArNm21TZnw

# X52BWUECBmHzKOjeBBgTMjAyMjAyMDMxMDI0MDAuMDI1WjAEgAIB9KCB2KSB1TCB

# 0jELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1Jl

# ZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMk

# TWljcm9zb2Z0IElyZWxhbmQgT3BlcmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1U

# aGFsZXMgVFNTIEVTTjo4RDQxLTRCRjctQjNCNzElMCMGA1UEAxMcTWljcm9zb2Z0

# IFRpbWUtU3RhbXAgU2VydmljZaCCEWgwggcUMIIE/KADAgECAhMzAAABiC7NxoFB

# 4bwqAAEAAAGIMA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQI

# EwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3Nv

# ZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBD

# QSAyMDEwMB4XDTIxMTAyODE5Mjc0MFoXDTIzMDEyNjE5Mjc0MFowgdIxCzAJBgNV

# BAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4w

# HAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xLTArBgNVBAsTJE1pY3Jvc29m

# dCBJcmVsYW5kIE9wZXJhdGlvbnMgTGltaXRlZDEmMCQGA1UECxMdVGhhbGVzIFRT

# UyBFU046OEQ0MS00QkY3LUIzQjcxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0

# YW1wIFNlcnZpY2UwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQCa5xAI

# BCaRxcfIOtXhLzxV4mDZcao0pxamytqlEoVZyGGMux/8z1c31uDOcs3jwFc8C06X

# Ch50HaQ3htl08/cp1E1tirW00VSHxSeaMIKv4KMuWuKAdyZLRH6uw3aAExeUsRmH

# Zb8I64P1U4uxvY/aMOnjfdXitQABRbzYzuuDzV3c5xy077VdbWHcS1tC1LpASTDo

# Ngi699fsDDyNcdmewy6A/xkDWi2mulM1SH/NFYLsInIHPKZAgNIJ1aFV8PiyHF75

# GzrVrF/bttODkf9X9KQ132HMzo2r/LY6MMqsu2432FLnfnr26FM1B4CEBUN94ekT

# OUy+1c7JfoxOZ7eOcd0c+PoYtP0AxEisB/3qE9g6I8QG8e2uDoymIjf6Xo2VtI6z

# Xr8VN6WNPX6x2xYa0VNm95r2kCpXVoHv3loOSZnqxGbmO12dVrN+hasd3e8N6Hfl

# ZXTy9bhOU58RxXb4ptqKs/FoWQnj62Wwn4x+xU6JOv9mcOBoxoefPOiB6UjcCh8N

# T0hNsyRO1PGss/KBNtF21um2ucvMGfaPNHhMl+RCj6HNa5oy7k60xmIpXYjkw7Sb

# WYq5QCCir7jjYvDwJC6P0QLYXydNslvY1xQOD7vh2AmKz8/wFr86uXFb5OuBzpM8

# bEI61Pvf1Sp6yW9YPqs1DpQQ71/u9YOSF3a+2wIDAQABo4IBNjCCATIwHQYDVR0O

# BBYEFGR5tVDEo7vOu736jbsaM+WMyUpKMB8GA1UdIwQYMBaAFJ+nFV0AXmJdg/Tl

# 0mWnG1M1GelyMF8GA1UdHwRYMFYwVKBSoFCGTmh0dHA6Ly93d3cubWljcm9zb2Z0

# LmNvbS9wa2lvcHMvY3JsL01pY3Jvc29mdCUyMFRpbWUtU3RhbXAlMjBQQ0ElMjAy

# MDEwKDEpLmNybDBsBggrBgEFBQcBAQRgMF4wXAYIKwYBBQUHMAKGUGh0dHA6Ly93

# d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvY2VydHMvTWljcm9zb2Z0JTIwVGltZS1T

# dGFtcCUyMFBDQSUyMDIwMTAoMSkuY3J0MAwGA1UdEwEB/wQCMAAwEwYDVR0lBAww

# CgYIKwYBBQUHAwgwDQYJKoZIhvcNAQELBQADggIBAEAQWtv7WAgmy/8YotLbNq+b

# Z6TXvuaTjK7oG5LpWIi4vR7bRg3Z11d6JSER2GTcVG2j8YP3eTlIjI0npf6ny5Aw

# 7Ejbdg5J3ITMsnCHv5+27Qh/zLfHoAnRLV3XY5nt+xiqWMdR5xyd5L0NaqKkeTy4

# zybZlsGFGdQ3wziKqDiugkaZkpn0VzxntkcmAz3uLt8jID2EkfTXvPblasMmXFqk

# Pl2YzI3LPN8BWpoHJ6YKgGfhWREIY0hLHTFGVxv3dboQ2EkXU0GMyXdwpUQdbh3x

# jQ1mGl1cO14uT0eBsnJ4IjZ830YGsJLUHVqT7X3g8aJkovz6C0rs2isCgAxC8WRi

# CsetYJh+NXo+i4Lc34DrA4GtyRU4dP09QgMrkAMIfhmtpCJ15L0sP+KYoczcjiJr

# M+ShwdwUcH3Kjl32Uwln6mcABaCVBCMxaFSqcT+WUD4SqNs7SUDGWZS1WKhVSzCF

# PekroOMVFcz8tTHBO225/PXMGMQuREhny4LLViQzF8EXASiz9AUiUNoVK9SfgiJZ

# kDdUt8ASPLnWInAraNIgfD7VuMIj4UEdwJNEfak/f6HkOVDkBn929x82sBM/XDDP

# bkivwqAo5sdEIhgfhUjZWuY5uhIcUbv0lsd2Q9VKN8vFO5OyiHkXOhTW3m6sbSvC

# 6WhlkVnFOSvF/JOSG+aMMIIHcTCCBVmgAwIBAgITMwAAABXF52ueAptJmQAAAAAA

# FTANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hp

# bmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jw

# b3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNhdGUgQXV0

# aG9yaXR5IDIwMTAwHhcNMjEwOTMwMTgyMjI1WhcNMzAwOTMwMTgzMjI1WjB8MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNy

# b3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDCCAiIwDQYJKoZIhvcNAQEBBQADggIP

# ADCCAgoCggIBAOThpkzntHIhC3miy9ckeb0O1YLT/e6cBwfSqWxOdcjKNVf2AX9s

# SuDivbk+F2Az/1xPx2b3lVNxWuJ+Slr+uDZnhUYjDLWNE893MsAQGOhgfWpSg0S3

# po5GawcU88V29YZQ3MFEyHFcUTE3oAo4bo3t1w/YJlN8OWECesSq/XJprx2rrPY2

# vjUmZNqYO7oaezOtgFt+jBAcnVL+tuhiJdxqD89d9P6OU8/W7IVWTe/dvI2k45GP

# sjksUZzpcGkNyjYtcI4xyDUoveO0hyTD4MmPfrVUj9z6BVWYbWg7mka97aSueik3

# rMvrg0XnRm7KMtXAhjBcTyziYrLNueKNiOSWrAFKu75xqRdbZ2De+JKRHh09/SDP

# c31BmkZ1zcRfNN0Sidb9pSB9fvzZnkXftnIv231fgLrbqn427DZM9ituqBJR6L8F

# A6PRc6ZNN3SUHDSCD/AQ8rdHGO2n6Jl8P0zbr17C89XYcz1DTsEzOUyOArxCaC4Q

# 6oRRRuLRvWoYWmEBc8pnol7XKHYC4jMYctenIPDC+hIK12NvDMk2ZItboKaDIV1f

# MHSRlJTYuVD5C4lh8zYGNRiER9vcG9H9stQcxWv2XFJRXRLbJbqvUAV6bMURHXLv

# jflSxIUXk8A8FdsaN8cIFRg/eKtFtvUeh17aj54WcmnGrnu3tz5q4i6tAgMBAAGj

# ggHdMIIB2TASBgkrBgEEAYI3FQEEBQIDAQABMCMGCSsGAQQBgjcVAgQWBBQqp1L+

# ZMSavoKRPEY1Kc8Q/y8E7jAdBgNVHQ4EFgQUn6cVXQBeYl2D9OXSZacbUzUZ6XIw

# XAYDVR0gBFUwUzBRBgwrBgEEAYI3TIN9AQEwQTA/BggrBgEFBQcCARYzaHR0cDov

# L3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9Eb2NzL1JlcG9zaXRvcnkuaHRtMBMG

# A1UdJQQMMAoGCCsGAQUFBwMIMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMAsG

# A1UdDwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFNX2VsuP6KJc

# YmjRPZSQW9fOmhjEMFYGA1UdHwRPME0wS6BJoEeGRWh0dHA6Ly9jcmwubWljcm9z

# b2Z0LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIz

# LmNybDBaBggrBgEFBQcBAQROMEwwSgYIKwYBBQUHMAKGPmh0dHA6Ly93d3cubWlj

# cm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3J0

# MA0GCSqGSIb3DQEBCwUAA4ICAQCdVX38Kq3hLB9nATEkW+Geckv8qW/qXBS2Pk5H

# ZHixBpOXPTEztTnXwnE2P9pkbHzQdTltuw8x5MKP+2zRoZQYIu7pZmc6U03dmLq2

# HnjYNi6cqYJWAAOwBb6J6Gngugnue99qb74py27YP0h1AdkY3m2CDPVtI1TkeFN1

# JFe53Z/zjj3G82jfZfakVqr3lbYoVSfQJL1AoL8ZthISEV09J+BAljis9/kpicO8

# F7BUhUKz/AyeixmJ5/ALaoHCgRlCGVJ1ijbCHcNhcy4sa3tuPywJeBTpkbKpW99J

# o3QMvOyRgNI95ko+ZjtPu4b6MhrZlvSP9pEB9s7GdP32THJvEKt1MMU0sHrYUP4K

# WN1APMdUbZ1jdEgssU5HLcEUBHG/ZPkkvnNtyo4JvbMBV0lUZNlz138eW0QBjloZ

# kWsNn6Qo3GcZKCS6OEuabvshVGtqRRFHqfG3rsjoiV5PndLQTHa1V1QJsWkBRH58

# oWFsc/4Ku+xBZj1p/cvBQUl+fpO+y/g75LcVv7TOPqUxUYS8vwLBgqJ7Fx0ViY1w

# /ue10CgaiQuPNtq6TPmb/wrpNPgkNWcr4A245oyZ1uEi6vAnQj0llOZ0dFtq0Z4+

# 7X6gMTN9vMvpe784cETRkPHIqzqKOghif9lwY1NNje6CbaUFEMFxBmoQtB1VM1iz

# oXBm8qGCAtcwggJAAgEBMIIBAKGB2KSB1TCB0jELMAkGA1UEBhMCVVMxEzARBgNV

# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv

# c29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxhbmQgT3Bl

# cmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjo4RDQxLTRC

# RjctQjNCNzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZaIj

# CgEBMAcGBSsOAwIaAxUA4TyKzHwgF5U9LB4PzTmXlB16DkKggYMwgYCkfjB8MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNy

# b3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIFAOWlkBsw

# IhgPMjAyMjAyMDMwNzE5NTVaGA8yMDIyMDIwNDA3MTk1NVowdzA9BgorBgEEAYRZ

# CgQBMS8wLTAKAgUA5aWQGwIBADAKAgEAAgIKHQIB/zAHAgEAAgIRYjAKAgUA5abh

# mwIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIBAAIDB6Eg

# oQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBADSFGgE09YCLmjeGbjHj2UO7

# KpH1SNaJ/0XPMxl8jXrq6KIcw339ue0fA+ew6GIQYtl6Kc+uvhiODFZm977/paok

# bKSPdKlOAcKmlgTsop1ExGCr2aupWF2DzFhCe71vhoFadrQVLtEp9vvAn5O56aPW

# FTeNrM8YGE2HuDn4XqIOMYIEDTCCBAkCAQEwgZMwfDELMAkGA1UEBhMCVVMxEzAR

# BgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1p

# Y3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3Rh

# bXAgUENBIDIwMTACEzMAAAGILs3GgUHhvCoAAQAAAYgwDQYJYIZIAWUDBAIBBQCg

# ggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0BCQQxIgQg

# PKhBoHqU6hdCt15gEmDtUEzHu/zmAOM54lZuqP1xNCwwgfoGCyqGSIb3DQEJEAIv

# MYHqMIHnMIHkMIG9BCBm6d7trAY3RoSC+M/snI7c0qXuGy1fwKGGsqZe0klApTCB

# mDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYD

# VQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAk

# BgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAABiC7NxoFB

# 4bwqAAEAAAGIMCIEIGau1oYRDSdr0Oy7OJe0AQoQzS2dT+19Qsr4ro4L3kUVMA0G

# CSqGSIb3DQEBCwUABIICAFdICoJ2/KoxtbEtnZkHBYqsAXJFuPGbsiKrgB+N4O34

# VHLO7PKj6LSm0HcZMxoBaMv5W49TIWw/qnLBQxHHtaMYNrZMnqQt5uCyefAtuoSr

# HJsCKEKVUCWYE/o+Mwdf205L1sC7jvvTOQ3n1sBMm9PC5IdwnqZ8PY3+b82r3Tqh

# L1fZKdCt5+YeD7zVi75BRl5lTaLyngsd3XUVVXaUTHJuvrHEikZmID9S83o9sBcy

# HSFNcDcqMEzR7ewVmczv8ZfimVILQjrXCxR2Ogn0i4qdgd1G/3bnoyHwFRmnUFbU

# XdFy1DGOLI/Q3LbemSDnL1m9LhgB+JqhZrq+CH7qvPXNbfNjXAUPPGkMDjSxoWri

# axSFyI41StsGbIUD3fGViNBxPzlIQ79/Xrl+rm0bF9zER60PunTVtmKCisNuIylG

# KDQ0qsASipFHyQ4Phx7jy4ytNN5RRdIvSrT+mjprGMcmuWhX4AzGpWY8Egfs97Hm

# /8RpGike6+Ip/OP98AlfZTr4fUn1aaVeH9n+/MY/xWy9zVKSWWNd358aGcEU9PhZ

# x8/Vkh5iLObARnwBQp0ojajTH9D80z+g8EPqzmhi9W6Uaul4hskoz4DENsHCybBF

# 7c+qwQ+jwd5dYI5PFCwCODfujhKfls8yutVHHkdRSM+2s0/kitEpcZt/69X1bLKr

# SIG # End signature block