AzSKPreview.ADO

1.10.2

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

# MIIjjAYJKoZIhvcNAQcCoIIjfTCCI3kCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCCF9LeRTHzhrnWY

# HNEQYJt2H87kxBAUiwSCKTlFD2fXSKCCDYUwggYDMIID66ADAgECAhMzAAAB4HFz

# JMpcmPgZAAAAAAHgMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjAxMjE1MjEzMTQ2WhcNMjExMjAyMjEzMTQ2WjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDRXpc9eiGRI/2BlmU7OMiQPTKpNlluodjT2rltPO/Gk47bH4gBShPMD4BX/4sg

# NvvBun6ZOG2dxUW30myWoUJJ0iRbTAv2JFzjSpVQvPE+D5vtmdu6WlOR2ahF4leF

# 5Vvk4lPg2ZFrqg5LNwT9gjwuYgmih+G2KwT8NMWusBhO649F4Ku6B6QgA+vZld5S

# G2XWIdvS0pmpmn/HFrV4eYTsl9HYgjn/bPsAlfWolLlEXYTaCljK7q7bQHDBrzlR

# ukyyryFpPOR9Wx1cxFJ6KBqg2jlJpzxjN3udNJPOqarnQIVgB8DUm3I5g2v5xTHK

# Ovz9ucN21467cYcIxjPC4UkDAgMBAAGjggGCMIIBfjAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUVBWIZHrG4UIX3uX4142l+8GsPXAw

# VAYDVR0RBE0wS6RJMEcxLTArBgNVBAsTJE1pY3Jvc29mdCBJcmVsYW5kIE9wZXJh

# dGlvbnMgTGltaXRlZDEWMBQGA1UEBRMNMjMwMDEyKzQ2MzAxMDAfBgNVHSMEGDAW

# gBRIbmTlUAXTgqoXNzcitW2oynUClTBUBgNVHR8ETTBLMEmgR6BFhkNodHRwOi8v

# d3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNDb2RTaWdQQ0EyMDExXzIw

# MTEtMDctMDguY3JsMGEGCCsGAQUFBwEBBFUwUzBRBggrBgEFBQcwAoZFaHR0cDov

# L3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9jZXJ0cy9NaWNDb2RTaWdQQ0EyMDEx

# XzIwMTEtMDctMDguY3J0MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIB

# AE5msNzmYzYbNgpnhya6YsrM+CIC8CXDu10nwzZtkgQciPOOqAYmFcWJCwD5VZzs

# qFwad8XIOrfCylWf4hzn09mD87yuazpuCstLSqfDLNd3740+254vEZqdGxOglAGU

# ih2IiF8S0GDwucpLGzt/OLXPFr/d4MWxPuX0L+HB5lA3Y/CJE673dHGQW2DELdqt

# ohtkhp+oWFn1hNDDZ3LP++HEZvA7sI/o/981Sh4kaGayOp6oEiQuGeCXyfrIC9KX

# eew0UlYX/NHVDqr4ykKkqpHtzbUbuo7qovUHPbYKcRGWrrEtBS5SPLFPumqsRtzb

# LgU9HqfRAN36bMsd2qynGyWBVFOM7NMs2lTCGM85Z/Fdzv/8tnYT36Cmbue+IM+6

# kS86j6Ztmx0VIFWbOvNsASPT6yrmYiecJiP6H0TrYXQK5B3jE8s53l+t61ab0Eul

# 7DAxNWX3lAiUlzKs3qZYQEK1LFvgbdTXtBRnHgBdABALK3RPrieIYqPln9sAmg3/

# zJZi4C/c2cWGF6WwK/w1Nzw08pj7jaaZZVBpCeDe+y7oM26QIXxracot7zJ21/TL

# 70biK36YybSUDkjhQPP/uxT0yebLNBKk7g8V98Wna2MsHWwk0sgqpkjIp02TrkVz

# 26tcF2rml2THRSDrwpBa4x9c8rM8Qomiyeh2tEJnsx2LMIIHejCCBWKgAwIBAgIK

# YQ6Q0gAAAAAAAzANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNV

# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv

# c29mdCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlm

# aWNhdGUgQXV0aG9yaXR5IDIwMTEwHhcNMTEwNzA4MjA1OTA5WhcNMjYwNzA4MjEw

# OTA5WjB+MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE

# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSgwJgYD

# VQQDEx9NaWNyb3NvZnQgQ29kZSBTaWduaW5nIFBDQSAyMDExMIICIjANBgkqhkiG

# 9w0BAQEFAAOCAg8AMIICCgKCAgEAq/D6chAcLq3YbqqCEE00uvK2WCGfQhsqa+la

# UKq4BjgaBEm6f8MMHt03a8YS2AvwOMKZBrDIOdUBFDFC04kNeWSHfpRgJGyvnkmc

# 6Whe0t+bU7IKLMOv2akrrnoJr9eWWcpgGgXpZnboMlImEi/nqwhQz7NEt13YxC4D

# dato88tt8zpcoRb0RrrgOGSsbmQ1eKagYw8t00CT+OPeBw3VXHmlSSnnDb6gE3e+

# lD3v++MrWhAfTVYoonpy4BI6t0le2O3tQ5GD2Xuye4Yb2T6xjF3oiU+EGvKhL1nk

# kDstrjNYxbc+/jLTswM9sbKvkjh+0p2ALPVOVpEhNSXDOW5kf1O6nA+tGSOEy/S6

# A4aN91/w0FK/jJSHvMAhdCVfGCi2zCcoOCWYOUo2z3yxkq4cI6epZuxhH2rhKEmd

# X4jiJV3TIUs+UsS1Vz8kA/DRelsv1SPjcF0PUUZ3s/gA4bysAoJf28AVs70b1FVL

# 5zmhD+kjSbwYuER8ReTBw3J64HLnJN+/RpnF78IcV9uDjexNSTCnq47f7Fufr/zd

# sGbiwZeBe+3W7UvnSSmnEyimp31ngOaKYnhfsi+E11ecXL93KCjx7W3DKI8sj0A3

# T8HhhUSJxAlMxdSlQy90lfdu+HggWCwTXWCVmj5PM4TasIgX3p5O9JawvEagbJjS

# 4NaIjAsCAwEAAaOCAe0wggHpMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRI

# bmTlUAXTgqoXNzcitW2oynUClTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTAL

# BgNVHQ8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBRyLToCMZBD

# uRQFTuHqp8cx0SOJNDBaBgNVHR8EUzBRME+gTaBLhklodHRwOi8vY3JsLm1pY3Jv

# c29mdC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFf

# MDNfMjIuY3JsMF4GCCsGAQUFBwEBBFIwUDBOBggrBgEFBQcwAoZCaHR0cDovL3d3

# dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFf

# MDNfMjIuY3J0MIGfBgNVHSAEgZcwgZQwgZEGCSsGAQQBgjcuAzCBgzA/BggrBgEF

# BQcCARYzaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9kb2NzL3ByaW1h

# cnljcHMuaHRtMEAGCCsGAQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAHAAbwBsAGkA

# YwB5AF8AcwB0AGEAdABlAG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQBn

# 8oalmOBUeRou09h0ZyKbC5YR4WOSmUKWfdJ5DJDBZV8uLD74w3LRbYP+vj/oCso7

# v0epo/Np22O/IjWll11lhJB9i0ZQVdgMknzSGksc8zxCi1LQsP1r4z4HLimb5j0b

# pdS1HXeUOeLpZMlEPXh6I/MTfaaQdION9MsmAkYqwooQu6SpBQyb7Wj6aC6VoCo/

# KmtYSWMfCWluWpiW5IP0wI/zRive/DvQvTXvbiWu5a8n7dDd8w6vmSiXmE0OPQvy

# CInWH8MyGOLwxS3OW560STkKxgrCxq2u5bLZ2xWIUUVYODJxJxp/sfQn+N4sOiBp

# mLJZiWhub6e3dMNABQamASooPoI/E01mC8CzTfXhj38cbxV9Rad25UAqZaPDXVJi

# hsMdYzaXht/a8/jyFqGaJ+HNpZfQ7l1jQeNbB5yHPgZ3BtEGsXUfFL5hYbXw3MYb

# BL7fQccOKO7eZS/sl/ahXJbYANahRr1Z85elCUtIEJmAH9AAKcWxm6U/RXceNcbS

# oqKfenoi+kiVH6v7RyOA9Z74v2u3S5fi63V4GuzqN5l5GEv/1rMjaHXmr/r8i+sL

# gOppO6/8MO0ETI7f33VtY5E90Z1WTk+/gFcioXgRMiF670EKsT/7qMykXcGhiJtX

# cVZOSEXAQsmbdlsKgEhr/Xmfwb1tbWrJUnMTDXpQzTGCFV0wghVZAgEBMIGVMH4x

# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt

# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01p

# Y3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMTECEzMAAAHgcXMkylyY+BkAAAAA

# AeAwDQYJYIZIAWUDBAIBBQCggbAwGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQw

# HAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIAKr

# lUQecf9HS0gajRswtzDOnAS4AV/z2cksOR5qkPQMMEQGCisGAQQBgjcCAQwxNjA0

# oBSAEgBNAGkAYwByAG8AcwBvAGYAdKEcgBpodHRwczovL3d3dy5taWNyb3NvZnQu

# Y29tIDANBgkqhkiG9w0BAQEFAASCAQB38pLgQGi+LCmNMaV0+H7giRNLOY4IC6vh

# bKZmxH2SJelo7IftqqqbnFkkupIkwtQslHnIX85i3jKA7dp0Ywf5Jhf1C7BwdUNF

# 5bhpoTQMdpMQKcuzS1l1LlNBxkfnm92nBllsnKk6RnnK/dUues5aI/vEJRIi+AIJ

# /hUKG9W61xX16OHeupcI3/JkOlmbO5YXqU9fa5sZuANJJmXYCF/g8rjiMxyeN5px

# UNFqUaOEJ5l/0cIQxNDu0fT5wwa9tJVN6487jfqBa11q96Gsm/duJK1F+F4vkhc/

# r9nMpxHAnYeAQkOfWwU7UifqIc0E97NH/93x8f59GB2T6DkU5yyWoYIS5TCCEuEG

# CisGAQQBgjcDAwExghLRMIISzQYJKoZIhvcNAQcCoIISvjCCEroCAQMxDzANBglg

# hkgBZQMEAgEFADCCAVEGCyqGSIb3DQEJEAEEoIIBQASCATwwggE4AgEBBgorBgEE

# AYRZCgMBMDEwDQYJYIZIAWUDBAIBBQAEILFtgeqSgki0RpGiY90HWRKIQ2edW5fR

# pxiWxQd03U/qAgZg+Zqs9mEYEzIwMjEwODE2MDU1MzQzLjEzM1owBIACAfSggdCk

# gc0wgcoxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQH

# EwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJTAjBgNV

# BAsTHE1pY3Jvc29mdCBBbWVyaWNhIE9wZXJhdGlvbnMxJjAkBgNVBAsTHVRoYWxl

# cyBUU1MgRVNOOjEyQkMtRTNBRS03NEVCMSUwIwYDVQQDExxNaWNyb3NvZnQgVGlt

# ZS1TdGFtcCBTZXJ2aWNloIIOPDCCBPEwggPZoAMCAQICEzMAAAFT0oJyRWxX44sA

# AAAAAVMwDQYJKoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldh

# c2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBD

# b3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIw

# MTAwHhcNMjAxMTEyMTgyNjA1WhcNMjIwMjExMTgyNjA1WjCByjELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjElMCMGA1UECxMcTWljcm9zb2Z0IEFt

# ZXJpY2EgT3BlcmF0aW9uczEmMCQGA1UECxMdVGhhbGVzIFRTUyBFU046MTJCQy1F

# M0FFLTc0RUIxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0YW1wIFNlcnZpY2Uw

# ggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC167Z0B7Mb+bNCAuXC6EGJ

# sFvgVB6i30/jl4gmtUwoQG5z3WpxQHNJj+t2I4fpETQQLoxioHSiR+nbJFRnT3WC

# jc6UwbGBMnQJgzgzVXofVPHICimiYNEiHy86PvCEpWT8vb6jfFcaOVoMe+4wN2Nq

# blOWA4o6wmEQUFmrbpKZB+cRVJF7WE1L6NDfRiPE9XRfRk+zzZd+MJhs3eWRr7jV

# dG10vVElV3hq0YFzfho7guP3L0bMxikRy3pPe4W6g7Qwf5McxDpM0Aatz9CNkscA

# Pyh4jZOF0f7diL1BGET/c4vp8iQTlfKqEhCbt3Fi/Hq54cwXjE1aUxzQva5b/ebt

# AgMBAAGjggEbMIIBFzAdBgNVHQ4EFgQUxqKLc0gqqbMwGUC34HBtrDFWRHUwHwYD

# VR0jBBgwFoAU1WM6XIoxkPNDe3xGG8UzaFqFbVUwVgYDVR0fBE8wTTBLoEmgR4ZF

# aHR0cDovL2NybC5taWNyb3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMvTWljVGlt

# U3RhUENBXzIwMTAtMDctMDEuY3JsMFoGCCsGAQUFBwEBBE4wTDBKBggrBgEFBQcw

# AoY+aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNUaW1TdGFQ

# Q0FfMjAxMC0wNy0wMS5jcnQwDAYDVR0TAQH/BAIwADATBgNVHSUEDDAKBggrBgEF

# BQcDCDANBgkqhkiG9w0BAQsFAAOCAQEAlGi9eXz6IEQ+xwFzSaJR3JxHsaiegym9

# DsRXcpfd7frlTUZ/5iVkyFq8YXyKoEI+7bVOzJlTf3PF8UdYCy4ysWae6szI+bsz

# 29boYoRlwSaxdQOg9hwlX1MkfdMnhJ+Iiw35EVYp7rMVjdN9i6aZHldKP/PDQNu+

# uzEHobKNLpZsxe+LI/gdxuIiFJDO3O9eTun07xWHfhnIxJ2wS7y5PEHpdxZTQX2n

# vWR0bjdmt5r6hy5X0sND1XZiaU2apl1Wb9Ha2bnO4A8lre7wZjS+i8XBVVJaE4LX

# mcTFeQllZldvq8yBmvDo4wvjFOFVckqyBSpCMMJpRqzkodGDxJ06NDCCBnEwggRZ

# oAMCAQICCmEJgSoAAAAAAAIwDQYJKoZIhvcNAQELBQAwgYgxCzAJBgNVBAYTAlVT

# MRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQK

# ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xMjAwBgNVBAMTKU1pY3Jvc29mdCBSb290

# IENlcnRpZmljYXRlIEF1dGhvcml0eSAyMDEwMB4XDTEwMDcwMTIxMzY1NVoXDTI1

# MDcwMTIxNDY1NVowfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x

# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv

# bjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwggEiMA0G

# CSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCpHQ28dxGKOiDs/BOX9fp/aZRrdFQQ

# 1aUKAIKF++18aEssX8XD5WHCdrc+Zitb8BVTJwQxH0EbGpUdzgkTjnxhMFmxMEQP

# 8WCIhFRDDNdNuDgIs0Ldk6zWczBXJoKjRQ3Q6vVHgc2/JGAyWGBG8lhHhjKEHnRh

# Z5FfgVSxz5NMksHEpl3RYRNuKMYa+YaAu99h/EbBJx0kZxJyGiGKr0tkiVBisV39

# dx898Fd1rL2KQk1AUdEPnAY+Z3/1ZsADlkR+79BL/W7lmsqxqPJ6Kgox8NpOBpG2

# iAg16HgcsOmZzTznL0S6p/TcZL2kAcEgCZN4zfy8wMlEXV4WnAEFTyJNAgMBAAGj

# ggHmMIIB4jAQBgkrBgEEAYI3FQEEAwIBADAdBgNVHQ4EFgQU1WM6XIoxkPNDe3xG

# G8UzaFqFbVUwGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEwCwYDVR0PBAQDAgGG

# MA8GA1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU1fZWy4/oolxiaNE9lJBb186a

# GMQwVgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDovL2NybC5taWNyb3NvZnQuY29tL3Br

# aS9jcmwvcHJvZHVjdHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3JsMFoGCCsG

# AQUFBwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5taWNyb3NvZnQuY29t

# L3BraS9jZXJ0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcnQwgaAGA1UdIAEB

# /wSBlTCBkjCBjwYJKwYBBAGCNy4DMIGBMD0GCCsGAQUFBwIBFjFodHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20vUEtJL2RvY3MvQ1BTL2RlZmF1bHQuaHRtMEAGCCsGAQUF

# BwICMDQeMiAdAEwAZQBnAGEAbABfAFAAbwBsAGkAYwB5AF8AUwB0AGEAdABlAG0A

# ZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQAH5ohRDeLG4Jg/gXEDPZ2joSFv

# s+umzPUxvs8F4qn++ldtGTCzwsVmyWrf9efweL3HqJ4l4/m87WtUVwgrUYJEEvu5

# U4zM9GASinbMQEBBm9xcF/9c+V4XNZgkVkt070IQyK+/f8Z/8jd9Wj8c8pl5SpFS

# AK84Dxf1L3mBZdmptWvkx872ynoAb0swRCQiPM/tA6WWj1kpvLb9BOFwnzJKJ/1V

# ry/+tuWOM7tiX5rbV0Dp8c6ZZpCM/2pif93FSguRJuI57BlKcWOdeyFtw5yjojz6

# f32WapB4pm3S4Zz5Hfw42JT0xqUKloakvZ4argRCg7i1gJsiOCC1JeVk7Pf0v35j

# WSUPei45V3aicaoGig+JFrphpxHLmtgOR5qAxdDNp9DvfYPw4TtxCd9ddJgiCGHa

# sFAeb73x4QDf5zEHpJM692VHeOj4qEir995yfmFrb3epgcunCaw5u+zGy9iCtHLN

# HfS4hQEegPsbiSpUObJb2sgNVZl6h3M7COaYLeqN4DMuEin1wC9UJyH3yKxO2ii4

# sanblrKnQqLJzxlBTeCG+SqaoxFmMNO7dDJL32N79ZmKLxvHIa9Zta7cRDyXUHHX

# odLFVeNp3lfB0d4wwP3M5k37Db9dT+mdHhk4L7zPWAUu7w2gUDXa7wknHNWzfjUe

# CLraNtvTX4/edIhJEqGCAs4wggI3AgEBMIH4oYHQpIHNMIHKMQswCQYDVQQGEwJV

# UzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UE

# ChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxNaWNyb3NvZnQgQW1l

# cmljYSBPcGVyYXRpb25zMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjoxMkJDLUUz

# QUUtNzRFQjElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZaIj

# CgEBMAcGBSsOAwIaAxUAikpN7ccO1k9PKCGCvaQWKyJ50ZuggYMwgYCkfjB8MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNy

# b3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIFAOTEZRMw

# IhgPMjAyMTA4MTYxMjE2MTlaGA8yMDIxMDgxNzEyMTYxOVowdzA9BgorBgEEAYRZ

# CgQBMS8wLTAKAgUA5MRlEwIBADAKAgEAAgIPJwIB/zAHAgEAAgIRTDAKAgUA5MW2

# kwIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIBAAIDB6Eg

# oQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAJY06ClDxwu3Ps4V7beybDK4

# qGdn9iboj05nffDvFwb6vUlP/oxc+FxTQcRXk3NsWTTvS24YNneQvXVkwsvSPD4g

# jERhpGhaFKilgQ3hn0TqdDg8s3Kgd/pE/uUKQ02BpPTlRkPXf+Trr0ZeHRdxw3We

# K0TeOW/6z6OBu2ry27gfMYIDDTCCAwkCAQEwgZMwfDELMAkGA1UEBhMCVVMxEzAR

# BgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1p

# Y3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3Rh

# bXAgUENBIDIwMTACEzMAAAFT0oJyRWxX44sAAAAAAVMwDQYJYIZIAWUDBAIBBQCg

# ggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0BCQQxIgQg

# LYpFS9tu7FdaUAntRMc1LlCws7GhIQPu9i4QQuhxS+cwgfoGCyqGSIb3DQEJEAIv

# MYHqMIHnMIHkMIG9BCBQwQqPObQgCAn8l6GQQ6aaHSyDHG9sDh9qxAVojbWPADCB

# mDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYD

# VQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAk

# BgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAABU9KCckVs

# V+OLAAAAAAFTMCIEIBUs9Ji0tTgc1BSFyuqfpGWJUflYK1K4Rq6wPLoHFKCOMA0G

# CSqGSIb3DQEBCwUABIIBABSCoVxgAvMaGXmun2sj3ua8z/W0xAqyJaXBZ8dvXZgO

# K3qG21hnbzzqjrx6op2hGsySrW6qxEz0NlgMwpIGbOVsh+XAUBHNMGBvqjIP6+vC

# S4DT82ATsP1IqNtGqlG+DPHtOTN1NSvZSYIPQB26+3sBjX/SnHlHjlGpbgIkHJST

# 5nfPheEKwJxTtGnX5THRJ4Gf9Ax7p7KCm6L4hV1h593k9qhV2OmvOI4srpPZFs8w

# /ThJ48/3Savb6XqZT3GgkDm4Ir8krJiQ0SXV1LFq8QGkcc8Ymqp8Nv6xFgMGdgxj

# yNk31sPSQsyvpHNZCdg/+NGAesseRCqY4gI2ehhr3kE=

# SIG # End signature block