AzSKStaging.ADO

1.14.3

Framework/BugLog/AutoCloseBugManager.ps1

                                Set-StrictMode -Version Latest

class AutoCloseBugManager {

    hidden [string] $OrganizationName;

    hidden [PSObject] $ControlSettings;

    hidden [string] $ScanSource;

    hidden [bool] $UseAzureStorageAccount = $false;

    hidden [BugLogHelper] $BugLogHelperObj;

    static [SVTEventContext []] $ClosedBugs=$null;

    AutoCloseBugManager([string] $orgName) {

        $this.OrganizationName = $orgName;

        $this.ControlSettings = [ConfigurationManager]::LoadServerConfigFile("ControlSettings.json");

        $this.ScanSource = [AzSKSettings]::GetInstance().GetScanSource();

        if ([Helpers]::CheckMember($this.ControlSettings.BugLogging, "UseAzureStorageAccount", $null)) {

            $this.UseAzureStorageAccount = $this.ControlSettings.BugLogging.UseAzureStorageAccount;

            if ($this.UseAzureStorageAccount) {

                $this.BugLogHelperObj = [BugLogHelper]::BugLogHelperInstance

                if (!$this.BugLogHelperObj) {

                    $this.BugLogHelperObj = [BugLogHelper]::GetInstance($this.OrganizationName);

                }

            }

        }

    }

    #function to auto close resolved bugs

    hidden [void] AutoCloseBug([SVTEventContext []] $ControlResults) {

        #tags that need to be searched

        $TagSearchKeyword = ""

        #flag to check number of current keywords in the tag

        $QueryKeyWordCount = 0;

        #maximum no of keywords that need to be checked per batch

        $MaxKeyWordsToQuery=0;    

        #all passing control results go here

        $PassedControlResults = @();

        $autoCloseOrgBugFlag=$true

        $autoCloseProjBugFlag=$true;

        [AutoCloseBugManager]::ClosedBugs=$null

        try {

            $MaxKeyWordsToQuery = $this.ControlSettings.BugLogging.MaxKeyWordsToQueryForBugClose;

            $autoCloseOrgBugFlag=$this.ControlSettings.BugLogging.AutoCloseOrgBug

            $autoCloseProjBugFlag=$this.ControlSettings.BugLogging.AutoCloseProjectBug

        }

        catch {

            $MaxKeyWordsToQuery=30

            $autoCloseOrgBugFlag=$true

            $autoCloseProjBugFlag=$true;

        }

        #collect all passed control results

        $ControlResults | ForEach-Object {

            if ($_.ControlResults[0].VerificationResult -eq "Passed") {

                #to check if org level bugs should be auto closed based on control settings

                if($_.FeatureName -eq "Organization"){

                    if($autoCloseOrgBugFlag -eq $true){

                        $PassedControlResults += $_

                    }

                }

                #to check if proj level bugs should be auto closed based on control settings

                elseif($_.FeatureName -eq "Project"){

                    if($autoCloseProjBugFlag -eq $true){

                        $PassedControlResults += $_

                    }

                }

                else {

                    $PassedControlResults += $_

                }

            }

        }

        #number of passed controls

        $PassedControlResultsLength = ($PassedControlResults | Measure-Object).Count

        #This Hash map is used to map an ADOScan hashtag value to a control. 

        $hashToControlIDMap=@{}

        #the following loop will call api for bug closing in batches of size as defined in control settings,

        #first check if passed controls length is less than the batch size, if yes then we have to combine all tags in one go

        #and call the api

        #if length is more divide the control results in chunks of batch size, after a particular batch is made call the api

        #reinitialize the variables for the next batch

        $PassedControlResults | ForEach-Object {

            $control = $_;

            #if control results are less than the maximum no of tags per batch

            #ToDo add common method for both if and else condition

            if ($PassedControlResultsLength -lt $MaxKeyWordsToQuery) {

                #check for number of tags in current query

                $QueryKeyWordCount++;

                if ($this.UseAzureStorageAccount -and $this.ScanSource -eq "CA")

                {

                    $tagHash=$this.GetHashedTag($control.ControlItem.Id, $control.ResourceContext.ResourceId)

                    $hashToControlIDMap.add($tagHash,$control);

                    #complete the query

                    $TagSearchKeyword += "(ADOScannerHashId eq '" + $tagHash + "') or "

                    #if the query count equals the passing control results, search for bugs for this batch

                    if ($QueryKeyWordCount -eq $PassedControlResultsLength) {

                        #to remove OR from the last tag keyword. Ex: Tags: Tag1 OR Tags: Tag2 OR. Remove the last OR from this keyword

                        $TagSearchKeyword = $TagSearchKeyword.Substring(0, $TagSearchKeyword.length - 3)

                        $closedBugsResponse = $this.BugLogHelperObj.GetTableEntityAndCloseBug($TagSearchKeyword)

                        if ($closedBugsResponse){

                            $this.closedBugInfoCollect($closedBugsResponse, $hashToControlIDMap)

                        }

                    }

                }

                else {

                    $tagHash=$this.GetHashedTag($control.ControlItem.Id, $control.ResourceContext.ResourceId)

                    $hashToControlIDMap.add($tagHash,$control);

                    $TagSearchKeyword += "Tags: " + $tagHash + " OR "

                    #if the query count equals the passing control results, search for bugs for this batch

                    if ($QueryKeyWordCount -eq $PassedControlResultsLength) {

                        #to remove OR from the last tag keyword. Ex: Tags: Tag1 OR Tags: Tag2 OR. Remove the last OR from this keyword

                        $TagSearchKeyword = $TagSearchKeyword.Substring(0, $TagSearchKeyword.length - 3)

                        $response = $this.GetWorkItemByHash($TagSearchKeyword,$MaxKeyWordsToQuery)

                        #if bug was present

                        if ($response[0].results.count -gt 0) {

                            $ids = @();

                            $ids += $response.results.fields."system.id";

                            $closedBugsResponse = $this.CloseBugsInBulk($ids);

                            #$response.results | ForEach-Object {

                            #    #close the bug

                            #    $id = $_.fields."system.id"

                            #    $Project = $_.project.name

                            #    $this.CloseBug($id, $Project)

                            #}

                            if ($closedBugsResponse){

                                $this.closedBugInfoCollect($closedBugsResponse, $hashToControlIDMap)

                            }

                        }

                    }

                }

            }

                #if the number of control results was more than batch size

                else {

                    $QueryKeyWordCount++;

                    if ($this.UseAzureStorageAccount -and $this.ScanSource -eq "CA")

                    {

                        $tagHash=$this.GetHashedTag($control.ControlItem.Id, $control.ResourceContext.ResourceId)

                        $hashToControlIDMap.add($tagHash,$control);

                        $TagSearchKeyword += "(ADOScannerHashId eq '" + $tagHash + "') or "

                        #if number of tags reaches batch limit

                        if ($QueryKeyWordCount -eq $MaxKeyWordsToQuery) {

                            #query for all these tags and their bugs

                            $TagSearchKeyword = $TagSearchKeyword.Substring(0, $TagSearchKeyword.length - 3)

                            $closedBugsResponse = $this.BugLogHelperObj.GetTableEntityAndCloseBug($TagSearchKeyword);

                            if ($closedBugsResponse){

                                $this.closedBugInfoCollect($closedBugsResponse, $hashToControlIDMap)

                            }

                            #Reinitialize for the next batch

                            $QueryKeyWordCount = 0;

                            $TagSearchKeyword = "";

                            $PassedControlResultsLength -= $MaxKeyWordsToQuery

                            $hashToControlIDMap.Clear();

                        }

                    }

                    else

                    {

                        $tagHash=$this.GetHashedTag($control.ControlItem.Id, $control.ResourceContext.ResourceId) 

                        $hashToControlIDMap.add($tagHash,$control);

                        $TagSearchKeyword += "Tags: " + $tagHash + " OR "

                        #if number of tags reaches batch limit

                        if ($QueryKeyWordCount -eq $MaxKeyWordsToQuery) {

                        #query for all these tags and their bugs

                        $TagSearchKeyword = $TagSearchKeyword.Substring(0, $TagSearchKeyword.length - 3)

                        $response = $this.GetWorkItemByHash($TagSearchKeyword,$MaxKeyWordsToQuery)

                        if ($response[0].results.count -gt 0) {

                            $ids = @();

                            $ids += $response.results.fields."system.id";

                            $closedBugsResponse = $this.CloseBugsInBulk($ids);

                            #$response.results | ForEach-Object {

                            #    $id = $_.fields."system.id"

                            #    $Project = $_.project.name

                            #    $this.CloseBug($id, $Project)

                            #}

                            if ($closedBugsResponse){

                                $this.closedBugInfoCollect($closedBugsResponse, $hashToControlIDMap)

                            }

                        }

                        #Reinitialize for the next batch

                        $QueryKeyWordCount = 0;

                        $TagSearchKeyword = "";

                        $PassedControlResultsLength -= $MaxKeyWordsToQuery

                        $hashToControlIDMap.Clear();

                        }

                    }

                }

            }

        $hashToControlIDMap.Clear();

        $hashToControlIDMap=$null

        Remove-Variable hashToControlIDMap;    

    }

    #function to close an active bug

    hidden [void] CloseBug([string] $id, [string] $Project) {

        $url = "https://dev.azure.com/{0}/{1}/_apis/wit/workitems/{2}?api-version=6.0" -f $this.OrganizationName, $Project, $id

        #load the closed bug template

        $BugTemplate = [ConfigurationManager]::LoadServerConfigFile("TemplateForClosedBug.Json")

        $BugTemplate = $BugTemplate | ConvertTo-Json -Depth 10

        $header = [WebRequestHelper]::GetAuthHeaderFromUriPatch($url)

        try {

            $responseObj = Invoke-RestMethod -Uri $url -Method Patch  -ContentType "application/json-patch+json ; charset=utf-8" -Headers $header -Body $BugTemplate

        }

        catch {

            Write-Host "Could not close the bug" -ForegroundColor Red

        }

    }

    #function to close an active bugs in bulk

    hidden [object] CloseBugsInBulk([string[]] $ids) 

    {

        try {

            $closeBugTemplate = @();

            foreach ($id in $ids) {

                $closeBugTemplate += [PSCustomObject] @{ method = 'PATCH'; uri = "/_apis/wit/workitems/$($id)?api-version=4.1"; headers = @{"Content-Type" = 'application/json-patch+json'};

                body = @(@{op = "add"; "path"= "/fields/System.State"; "value"= "Closed"}; @{op = "add"; "path"= "/fields/Microsoft.VSTS.Common.ResolvedReason"; "value"= ""})

                }

            }

            if ($closeBugTemplate.count -gt 0) {

                $body = $null;

                if ($closeBugTemplate.count -eq 1) {

                    $body = "[$($closeBugTemplate | ConvertTo-Json -depth 10)]"

                }

                else {

                    $body = $closeBugTemplate | ConvertTo-Json -depth 10  

                }

                $uri = 'https://{0}.visualstudio.com/_apis/wit/$batch?api-version=4.1' -f $this.OrganizationName

                $header = [WebRequestHelper]::GetAuthHeaderFromUriPatch($uri)

                $adoResult = Invoke-RestMethod -Uri $uri -Method Patch -ContentType "application/json" -Headers $header -Body $body

                if ($adoResult -and $adoResult.count -gt 0) {

                    return $adoResult.value;

                }

            }

            return $false;

        }

        catch {

            Write-Host $_

            Write-Host "Could not close the bug." -ForegroundColor Red

            return $false

        }

    }

    hidden [void] closedBugInfoCollect([object] $closedBugsResponse, [hashtable] $hashToControlIDMap){

        # Hash map checks for duplicate work items

        $hashClosedBugs=@{}

        $closedBugsResponse| ForEach-Object{

            #Store closed bug details

            $bug=$_.body |ConvertFrom-Json

            $controlHashValue=$null

            #Fetch hash From storage account CA response

            if($this.UseAzureStorageAccount -and $this.ScanSource -eq "CA"){

                $controlHashValue=$bug.ADOScannerHashID

            }

            #Fetch hash for regular scan

            else{

                $controlHashValue=$bug.fields.'System.Tags'

            }

            if ($hashToControlIDMap.ContainsKey($controlHashValue) -and $bug.fields.'System.State' -eq 'Closed')

            {

                $id=$bug.id

                $project=$bug.fields.'System.TeamProject'

                $urlClose= "https://dev.azure.com/{0}/{1}/_workitems/edit/{2}" -f $this.OrganizationName, $project , $id;

                $hashToControlIDMap[$controlHashValue].ControlResults.AddMessage("Closed Bug",$urlClose);

                # duplicate work items do not populate static variable $ClosedBugs multiple times

                if(!$hashClosedBugs.ContainsKey($controlHashValue)){

                    [AutoCloseBugManager]::ClosedBugs+=$hashToControlIDMap[$controlHashValue]

                    $hashClosedBugs.add($controlHashValue,$true)

                }

            }

        }

        $hashClosedBugs.Clear()

    } 

    #function to retrieve all new/active/resolved bugs 

    hidden [object] GetWorkItemByHash([string] $hash,[int] $MaxKeyWordsToQuery) 

    {

        $url = "https://almsearch.dev.azure.com/{0}/_apis/search/workitemsearchresults?api-version=6.0-preview.1" -f $this.OrganizationName

        #take results have been doubled, as their might be chances for a bug to be logged more than once, if the tag id is copied.

        #in this case we want all the instances of this bug to be closed

        $body = '{"searchText": "{0}","$skip": 0,"$top": 60,"filters": {"System.TeamProject": [],"System.WorkItemType": ["Bug"],"System.State": ["New","Active","Resolved"]}}'| ConvertFrom-Json

        $body.searchText = $hash

        $response = [WebRequestHelper]:: InvokePostWebRequest($url, $body)

        return  $response

    }

    #function to create hash for bug tag

    hidden [string] GetHashedTag([string] $ControlId, [string] $ResourceId) {

        $hashedTag = $null

        $stringToHash = "$ResourceId#$ControlId";

        #return the bug tag

        if ($this.UseAzureStorageAccount -and $this.ScanSource -eq "CA") 

        {

            return [AutoBugLog]::ComputeHashX($stringToHash);

        }

        else {

            return "ADOScanID: " + [AutoBugLog]::ComputeHashX($stringToHash)

        }

    }

}

# SIG # Begin signature block

# MIIjlAYJKoZIhvcNAQcCoIIjhTCCI4ECAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCCF9LeRTHzhrnWY

# HNEQYJt2H87kxBAUiwSCKTlFD2fXSKCCDYEwggX/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/BvW1taslScxMNelDNMYIVaTCCFWUCAQEwgZUwfjELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9z

# b2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAxMQITMwAAAlKLM6r4lfM52wAAAAACUjAN

# BglghkgBZQMEAgEFAKCBsDAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgor

# BgEEAYI3AgELMQ4wDAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgAquVRB5x

# /0dLSBqNGzC3MM6cBLgBX/PZySw5HmqQ9AwwRAYKKwYBBAGCNwIBDDE2MDSgFIAS

# AE0AaQBjAHIAbwBzAG8AZgB0oRyAGmh0dHBzOi8vd3d3Lm1pY3Jvc29mdC5jb20g

# MA0GCSqGSIb3DQEBAQUABIIBAGYGwhWpmBWMOr1q9DKJOuWkFAHb7kL31TKuMqGb

# DdYx0+4DMG4PMMtPid9Nrn+0fzRlqV8lWYErsfeetaSp1Uq4yrqcRcwfsUyfEtqh

# TWAN0dWjaBFmmO9/gnCVtLathMhdG6sr07TqvtlB0Y1LGwPDN9LuNhSsXAhuoeFN

# zxPMttqa9M0UreuiukxCGzpGuKn7OSpJpS7bu3t+Ntb74CIdCaSRndTjAL0VzbEh

# xLRVft4/NHRJ9RGnRE/n67uCzL2CHmvyBWDak7CVe/B4+84i8KQsz/tDYr/kBxYa

# lBVcH+BetgYNHVGqMVCkNpOpu3Ein6kmHZEpM1s695NISNGhghLxMIIS7QYKKwYB

# BAGCNwMDATGCEt0wghLZBgkqhkiG9w0BBwKgghLKMIISxgIBAzEPMA0GCWCGSAFl

# AwQCAQUAMIIBVQYLKoZIhvcNAQkQAQSgggFEBIIBQDCCATwCAQEGCisGAQQBhFkK

# AwEwMTANBglghkgBZQMEAgEFAAQgodZbIXyt5Cuc8tHQ+EVSlxjGlPwlsvfNSo7q

# A411IIUCBmGT78ruUhgTMjAyMTEyMDMwNzA4NDUuMzIzWjAEgAIB9KCB1KSB0TCB

# zjELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1Jl

# ZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEpMCcGA1UECxMg

# TWljcm9zb2Z0IE9wZXJhdGlvbnMgUHVlcnRvIFJpY28xJjAkBgNVBAsTHVRoYWxl

# cyBUU1MgRVNOOkM0QkQtRTM3Ri01RkZDMSUwIwYDVQQDExxNaWNyb3NvZnQgVGlt

# ZS1TdGFtcCBTZXJ2aWNloIIORDCCBPUwggPdoAMCAQICEzMAAAFXRAdi3G/ovioA

# AAAAAVcwDQYJKoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldh

# c2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBD

# b3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIw

# MTAwHhcNMjEwMTE0MTkwMjEzWhcNMjIwNDExMTkwMjEzWjCBzjELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEpMCcGA1UECxMgTWljcm9zb2Z0IE9w

# ZXJhdGlvbnMgUHVlcnRvIFJpY28xJjAkBgNVBAsTHVRoYWxlcyBUU1MgRVNOOkM0

# QkQtRTM3Ri01RkZDMSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBTZXJ2

# aWNlMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA3m0Dp1Rm+efAv2pC

# 1dzA8A2EHh7P7kJCt4+n9nxMfg0Gvm8B8YyjSVX+WJ0Fq0pOAcSs64ofXXFUB8F6

# Ecm8f1P86E5zzcImz1vMOGuV3Ql3Ld4nILTIF3FV65xL7ZrZkF3nTAGD/n/ZiNDb

# KV8PR3Eorq1AvF04NO5p1Axt1rTmU8adYbBneeJKAgpVGCqoJWWEfPA21GHUAf5n

# Ft9J7u3zPegQoB1MDLtKw/zKSG3eyuN2HQHKQ8V2loCCrBYIkkmYaTSACtK8cLz6

# 9e0ajcwmFZBF7km3N0PmR1oof25z2CdKGxfIMSEZmPHf5vxy6oQ7xse/RY9f0xER

# +t/G+QIDAQABo4IBGzCCARcwHQYDVR0OBBYEFF0xe7voOCGdT+Q9Mwp0WRH2gKnZ

# MB8GA1UdIwQYMBaAFNVjOlyKMZDzQ3t8RhvFM2hahW1VMFYGA1UdHwRPME0wS6BJ

# oEeGRWh0dHA6Ly9jcmwubWljcm9zb2Z0LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01p

# Y1RpbVN0YVBDQV8yMDEwLTA3LTAxLmNybDBaBggrBgEFBQcBAQROMEwwSgYIKwYB

# BQUHMAKGPmh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljVGlt

# U3RhUENBXzIwMTAtMDctMDEuY3J0MAwGA1UdEwEB/wQCMAAwEwYDVR0lBAwwCgYI

# KwYBBQUHAwgwDQYJKoZIhvcNAQELBQADggEBACV3eQCAbpdaJnK92JstGZavvJvp

# FLJyNUODy1wKK1LTWxNWnhPwB3ZB5h8lZ8roMwSTtBEF8qB03ugTx1e2ZBUv4lzE

# uPSlS7Lg0HlFyFy14Pl1GdN8qVGLy+ApRrENygUjM0RTPUQemil5qANvj+4j1SPm

# 0i7CWKT+qu/+wcDDuQziAQss06B16/1n/vGjUkjB97R6hAzfDFwIUu5/xL06dy21

# oUBYe0QRHwi+BECAsn9aeW4XPrz6GsN9HJf+qpZI8gTS+gTqoXHXPxS8vAqmbrlA

# 3I0NEyn9WYKmpFmvEHWjRFjs/6fiNI0a9uTZtHvSQq392iAUVEEdVW5TF/4wggZx

# MIIEWaADAgECAgphCYEqAAAAAAACMA0GCSqGSIb3DQEBCwUAMIGIMQswCQYDVQQG

# EwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG

# A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQg

# Um9vdCBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkgMjAxMDAeFw0xMDA3MDEyMTM2NTVa

# Fw0yNTA3MDEyMTQ2NTVaMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5n

# dG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9y

# YXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwMIIB

# IjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAqR0NvHcRijog7PwTl/X6f2mU

# a3RUENWlCgCChfvtfGhLLF/Fw+Vhwna3PmYrW/AVUycEMR9BGxqVHc4JE458YTBZ

# sTBED/FgiIRUQwzXTbg4CLNC3ZOs1nMwVyaCo0UN0Or1R4HNvyRgMlhgRvJYR4Yy

# hB50YWeRX4FUsc+TTJLBxKZd0WETbijGGvmGgLvfYfxGwScdJGcSchohiq9LZIlQ

# YrFd/XcfPfBXday9ikJNQFHRD5wGPmd/9WbAA5ZEfu/QS/1u5ZrKsajyeioKMfDa

# TgaRtogINeh4HLDpmc085y9Euqf03GS9pAHBIAmTeM38vMDJRF1eFpwBBU8iTQID

# AQABo4IB5jCCAeIwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFNVjOlyKMZDz

# Q3t8RhvFM2hahW1VMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMAsGA1UdDwQE

# AwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFNX2VsuP6KJcYmjRPZSQ

# W9fOmhjEMFYGA1UdHwRPME0wS6BJoEeGRWh0dHA6Ly9jcmwubWljcm9zb2Z0LmNv

# bS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIzLmNybDBa

# BggrBgEFBQcBAQROMEwwSgYIKwYBBQUHMAKGPmh0dHA6Ly93d3cubWljcm9zb2Z0

# LmNvbS9wa2kvY2VydHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3J0MIGgBgNV

# HSABAf8EgZUwgZIwgY8GCSsGAQQBgjcuAzCBgTA9BggrBgEFBQcCARYxaHR0cDov

# L3d3dy5taWNyb3NvZnQuY29tL1BLSS9kb2NzL0NQUy9kZWZhdWx0Lmh0bTBABggr

# BgEFBQcCAjA0HjIgHQBMAGUAZwBhAGwAXwBQAG8AbABpAGMAeQBfAFMAdABhAHQA

# ZQBtAGUAbgB0AC4gHTANBgkqhkiG9w0BAQsFAAOCAgEAB+aIUQ3ixuCYP4FxAz2d

# o6Ehb7Prpsz1Mb7PBeKp/vpXbRkws8LFZslq3/Xn8Hi9x6ieJeP5vO1rVFcIK1GC

# RBL7uVOMzPRgEop2zEBAQZvcXBf/XPleFzWYJFZLdO9CEMivv3/Gf/I3fVo/HPKZ

# eUqRUgCvOA8X9S95gWXZqbVr5MfO9sp6AG9LMEQkIjzP7QOllo9ZKby2/QThcJ8y

# Sif9Va8v/rbljjO7Yl+a21dA6fHOmWaQjP9qYn/dxUoLkSbiOewZSnFjnXshbcOc

# o6I8+n99lmqQeKZt0uGc+R38ONiU9MalCpaGpL2eGq4EQoO4tYCbIjggtSXlZOz3

# 9L9+Y1klD3ouOVd2onGqBooPiRa6YacRy5rYDkeagMXQzafQ732D8OE7cQnfXXSY

# Ighh2rBQHm+98eEA3+cxB6STOvdlR3jo+KhIq/fecn5ha293qYHLpwmsObvsxsvY

# grRyzR30uIUBHoD7G4kqVDmyW9rIDVWZeodzOwjmmC3qjeAzLhIp9cAvVCch98is

# TtoouLGp25ayp0Kiyc8ZQU3ghvkqmqMRZjDTu3QyS99je/WZii8bxyGvWbWu3EQ8

# l1Bx16HSxVXjad5XwdHeMMD9zOZN+w2/XU/pnR4ZOC+8z1gFLu8NoFA12u8JJxzV

# s341Hgi62jbb01+P3nSISRKhggLSMIICOwIBATCB/KGB1KSB0TCBzjELMAkGA1UE

# BhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAc

# BgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEpMCcGA1UECxMgTWljcm9zb2Z0

# IE9wZXJhdGlvbnMgUHVlcnRvIFJpY28xJjAkBgNVBAsTHVRoYWxlcyBUU1MgRVNO

# OkM0QkQtRTM3Ri01RkZDMSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBT

# ZXJ2aWNloiMKAQEwBwYFKw4DAhoDFQARLfhJYnsN9tIb+BshDBOvOBnw8qCBgzCB

# gKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQH

# EwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNV

# BAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwMA0GCSqGSIb3DQEBBQUA

# AgUA5VQulzAiGA8yMDIxMTIwMzA5NTAxNVoYDzIwMjExMjA0MDk1MDE1WjB3MD0G

# CisGAQQBhFkKBAExLzAtMAoCBQDlVC6XAgEAMAoCAQACAhekAgH/MAcCAQACAhEo

# MAoCBQDlVYAXAgEAMDYGCisGAQQBhFkKBAIxKDAmMAwGCisGAQQBhFkKAwKgCjAI

# AgEAAgMHoSChCjAIAgEAAgMBhqAwDQYJKoZIhvcNAQEFBQADgYEAC+/O3/QmF5nv

# G1/zolf+rLCDzIR6Hc+rZz2phEVTwcObYc1nZBhaS5O3PCIkpH3haNCI+nRnt51X

# d7o5m/chIzW+YlgArb8qri8UA1I3Th8J1Em1Hxz2qbgBDDJ2V3Li6wpHagBsqjJZ

# ijGya1x9O76pbsPlVCP/rTP59XcGYBsxggMNMIIDCQIBATCBkzB8MQswCQYDVQQG

# EwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG

# A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQg

# VGltZS1TdGFtcCBQQ0EgMjAxMAITMwAAAVdEB2Lcb+i+KgAAAAABVzANBglghkgB

# ZQMEAgEFAKCCAUowGgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMC8GCSqGSIb3

# DQEJBDEiBCC3CPvr9/i8SC4MPqp564EEHn/iAHpn+4tYFm1JYVdITzCB+gYLKoZI

# hvcNAQkQAi8xgeowgecwgeQwgb0EICxajQ1Dq/O666lSxkQxInhSxGO1DDZ0XFla

# Qe2pHKATMIGYMIGApH4wfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0

# b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3Jh

# dGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTACEzMA

# AAFXRAdi3G/ovioAAAAAAVcwIgQggp5LKxZsaKcUbomKnv2iJlkAHpy2ufOlb1UJ

# dnlII6swDQYJKoZIhvcNAQELBQAEggEAVfioO4342VCjSDKdYbhQOKps7khIenI1

# OEhMqIrRIXJuNA0E5T9Grn32y4JwITTgO7I7BCnhbjPOrmJRuoqcq+M8vpvYfZKX

# qo3efPmfVoHsetr9xeSYUNuU43Z4XaQ4UNAKvS7pBTx31Jk6WJlWtrFGTjBzlNX5

# +CYx5HVPpL8tcuAO69ybRXZUa0kFnlZ11Q83P5zEUs/yM2gvXqpwLhtZ6slpQQka

# GUh5K6t/viM4rkxIkJc5KSCUyTxyw2p9/zI2XePLpeAF5k6BmPj7KT2YHQY3bZy8

# j6WvJK6xZVGaH5wvsM2AGbooX59LNA+zxjZj6Hqbys2qWADykFIAdA==

# SIG # End signature block