PowerShellForGitHub

0.15.0

GitHubPullRequests.ps1

                                # Copyright (c) Microsoft Corporation. All rights reserved.

# Licensed under the MIT License.

@{

    GitHubPullRequestTypeName = 'GitHub.PullRequest'

 }.GetEnumerator() | ForEach-Object {

     Set-Variable -Scope Script -Option ReadOnly -Name $_.Key -Value $_.Value

 }

filter Get-GitHubPullRequest

{

<#

    .SYNOPSIS

        Retrieve the pull requests in the specified repository.

    .DESCRIPTION

        Retrieve the pull requests in the specified repository.

        The Git repo for this module can be found here: http://aka.ms/PowerShellForGitHub

    .PARAMETER OwnerName

        Owner of the repository.

        If not supplied here, the DefaultOwnerName configuration property value will be used.

    .PARAMETER RepositoryName

        Name of the repository.

        If not supplied here, the DefaultRepositoryName configuration property value will be used.

    .PARAMETER Uri

        Uri for the repository.

        The OwnerName and RepositoryName will be extracted from here instead of needing to provide

        them individually.

    .PARAMETER PullRequest

        The specific pull request id to return back.  If not supplied, will return back all

        pull requests for the specified Repository.

    .PARAMETER State

        The state of the pull requests that should be returned back.

    .PARAMETER Head

        Filter pulls by head user and branch name in the format of 'user:ref-name'

    .PARAMETER Base

        Base branch name to filter the pulls by.

    .PARAMETER Sort

        What to sort the results by.

        * created

        * updated

        * popularity (comment count)

        * long-running (age, filtering by pulls updated in the last month)

    .PARAMETER Direction

        The direction to be used for Sort.

    .PARAMETER AccessToken

        If provided, this will be used as the AccessToken for authentication with the

        REST Api.  Otherwise, will attempt to use the configured value or will run unauthenticated.

    .INPUTS

        GitHub.Branch

        GitHub.Content

        GitHub.Event

        GitHub.Issue

        GitHub.IssueComment

        GitHub.Label

        GitHub.Milestone

        GitHub.PullRequest

        GitHub.Project

        GitHub.ProjectCard

        GitHub.ProjectColumn

        GitHub.Reaction

        GitHub.Release

        GitHub.ReleaseAsset

        GitHub.Repository

    .OUTPUTS

        GitHub.PulLRequest

    .EXAMPLE

        $pullRequests = Get-GitHubPullRequest -Uri 'https://github.com/PowerShell/PowerShellForGitHub'

    .EXAMPLE

        $pullRequests = Get-GitHubPullRequest -OwnerName microsoft -RepositoryName PowerShellForGitHub -State Closed

#>

    [CmdletBinding(DefaultParameterSetName = 'Elements')]

    param(

        [Parameter(ParameterSetName='Elements')]

        [string] $OwnerName,

        [Parameter(ParameterSetName='Elements')]

        [string] $RepositoryName,

        [Parameter(

            Mandatory,

            ValueFromPipelineByPropertyName,

            ParameterSetName='Uri')]

        [Alias('RepositoryUrl')]

        [string] $Uri,

        [Parameter(

            ValueFromPipeline,

            ValueFromPipelineByPropertyName)]

        [Alias('PullRequestNumber')]

        [int64] $PullRequest,

        [ValidateSet('Open', 'Closed', 'All')]

        [string] $State = 'Open',

        [string] $Head,

        [string] $Base,

        [ValidateSet('Created', 'Updated', 'Popularity', 'LongRunning')]

        [string] $Sort = 'Created',

        [ValidateSet('Ascending', 'Descending')]

        [string] $Direction = 'Descending',

        [string] $AccessToken

    )

    Write-InvocationLog

    $elements = Resolve-RepositoryElements

    $OwnerName = $elements.ownerName

    $RepositoryName = $elements.repositoryName

    $telemetryProperties = @{

        'OwnerName' = (Get-PiiSafeString -PlainText $OwnerName)

        'RepositoryName' = (Get-PiiSafeString -PlainText $RepositoryName)

        'ProvidedPullRequest' = $PSBoundParameters.ContainsKey('PullRequest')

    }

    $uriFragment = "/repos/$OwnerName/$RepositoryName/pulls"

    $description = "Getting pull requests for $RepositoryName"

    if ($PSBoundParameters.ContainsKey('PullRequest'))

    {

        $uriFragment = $uriFragment + "/$PullRequest"

        $description = "Getting pull request $PullRequest for $RepositoryName"

    }

    $sortConverter = @{

        'Created' = 'created'

        'Updated' = 'updated'

        'Popularity' = 'popularity'

        'LongRunning' = 'long-running'

    }

    $directionConverter = @{

        'Ascending' = 'asc'

        'Descending' = 'desc'

    }

    $getParams = @(

        "state=$($State.ToLower())",

        "sort=$($sortConverter[$Sort])",

        "direction=$($directionConverter[$Direction])"

    )

    if ($PSBoundParameters.ContainsKey('Head'))

    {

        $getParams += "head=$Head"

    }

    if ($PSBoundParameters.ContainsKey('Base'))

    {

        $getParams += "base=$Base"

    }

    $params = @{

        'UriFragment' = $uriFragment + '?' +  ($getParams -join '&')

        'Description' = $description

        'AcceptHeader' = $script:symmetraAcceptHeader

        'AccessToken' = $AccessToken

        'TelemetryEventName' = $MyInvocation.MyCommand.Name

        'TelemetryProperties' = $telemetryProperties

    }

    return (Invoke-GHRestMethodMultipleResult @params | Add-GitHubPullRequestAdditionalProperties)

}

filter New-GitHubPullRequest

{

    <#

    .SYNOPSIS

        Create a new pull request in the specified repository.

    .DESCRIPTION

        Opens a new pull request from the given branch into the given branch

        in the specified repository.

        The Git repo for this module can be found here: http://aka.ms/PowerShellForGitHub

    .PARAMETER OwnerName

        Owner of the repository.

        If not supplied here, the DefaultOwnerName configuration property value will be used.

    .PARAMETER RepositoryName

        Name of the repository.

        If not supplied here, the DefaultRepositoryName configuration property value will be used.

    .PARAMETER Uri

        Uri for the repository.

        The OwnerName and RepositoryName will be extracted from here instead of needing to provide

        them individually.

    .PARAMETER Title

        The title of the pull request to be created.

    .PARAMETER Body

        The text description of the pull request.

    .PARAMETER Issue

        The GitHub issue number to open the pull request to address.

    .PARAMETER Head

        The name of the head branch (the branch containing the changes to be merged).

        May also include the name of the owner fork, in the form "${fork}:${branch}".

    .PARAMETER Base

        The name of the target branch of the pull request

        (where the changes in the head will be merged to).

    .PARAMETER HeadOwner

        The name of fork that the change is coming from.

        Used as the prefix of $Head parameter in the form "${HeadOwner}:${Head}".

        If unspecified, the unprefixed branch name is used,

        creating a pull request from the $OwnerName fork of the repository.

    .PARAMETER MaintainerCanModify

        If set, allows repository maintainers to commit changes to the

        head branch of this pull request.

    .PARAMETER Draft

        If set, opens the pull request as a draft.

    .PARAMETER AccessToken

        If provided, this will be used as the AccessToken for authentication with the

        REST Api.  Otherwise, will attempt to use the configured value or will run unauthenticated.

    .INPUTS

        GitHub.Branch

        GitHub.Content

        GitHub.Event

        GitHub.Issue

        GitHub.IssueComment

        GitHub.Label

        GitHub.Milestone

        GitHub.PullRequest

        GitHub.Project

        GitHub.ProjectCard

        GitHub.ProjectColumn

        GitHub.Reaction

        GitHub.Release

        GitHub.ReleaseAsset

        GitHub.Repository

    .OUTPUTS

        GitHub.PullRequest

    .EXAMPLE

        $prParams = @{

            OwnerName = 'Microsoft'

            Repository = 'PowerShellForGitHub'

            Title = 'Add simple file to root'

            Head = 'octocat:simple-file'

            Base = 'master'

            Body = "Adds a simple text file to the repository root.`n`nThis is an automated PR!"

            MaintainerCanModify = $true

        }

        $pr = New-GitHubPullRequest @prParams

    .EXAMPLE

        New-GitHubPullRequest -Uri 'https://github.com/PowerShell/PSScriptAnalyzer' -Title 'Add test' -Head simple-test -HeadOwner octocat -Base development -Draft -MaintainerCanModify

    .EXAMPLE

        New-GitHubPullRequest -Uri 'https://github.com/PowerShell/PSScriptAnalyzer' -Issue 642 -Head simple-test -HeadOwner octocat -Base development -Draft

    #>

    [CmdletBinding(

        SupportsShouldProcess,

        DefaultParameterSetName='Elements_Title')]

    param(

        [Parameter(ParameterSetName='Elements_Title')]

        [Parameter(ParameterSetName='Elements_Issue')]

        [string] $OwnerName,

        [Parameter(ParameterSetName='Elements_Title')]

        [Parameter(ParameterSetName='Elements_Issue')]

        [string] $RepositoryName,

        [Parameter(

            Mandatory,

            ValueFromPipelineByPropertyName,

            ParameterSetName='Uri_Title')]

        [Parameter(

            Mandatory,

            ValueFromPipelineByPropertyName,

            ParameterSetName='Uri_Issue')]

        [Alias('RepositoryUrl')]

        [string] $Uri,

        [Parameter(

            Mandatory,

            ParameterSetName='Elements_Title')]

        [Parameter(

            Mandatory,

            ParameterSetName='Uri_Title')]

        [ValidateNotNullOrEmpty()]

        [string] $Title,

        [Parameter(ParameterSetName='Elements_Title')]

        [Parameter(ParameterSetName='Uri_Title')]

        [string] $Body,

        [Parameter(

            Mandatory,

            ValueFromPipelineByPropertyName,

            ParameterSetName='Elements_Issue')]

        [Parameter(

            Mandatory,

            ValueFromPipelineByPropertyName,

            ParameterSetName='Uri_Issue')]

        [Alias('IssueNumber')]

        [int64] $Issue,

        [Parameter(Mandatory)]

        [string] $Head,

        [Parameter(Mandatory)]

        [string] $Base,

        [string] $HeadOwner,

        [switch] $MaintainerCanModify,

        [switch] $Draft,

        [string] $AccessToken

    )

    Write-InvocationLog

    if (-not [string]::IsNullOrWhiteSpace($HeadOwner))

    {

        if ($Head.Contains(':'))

        {

            $message = "`$Head ('$Head') was specified with an owner prefix, but `$HeadOwner ('$HeadOwner') was also specified." +

                " Either specify `$Head in '<owner>:<branch>' format, or set `$Head = '<branch>' and `$HeadOwner = '<owner>'."

            Write-Log -Message $message -Level Error

            throw $message

        }

        # $Head does not contain ':' - add the owner fork prefix

        $Head = "${HeadOwner}:${Head}"

    }

    $elements = Resolve-RepositoryElements

    $OwnerName = $elements.ownerName

    $RepositoryName = $elements.repositoryName

    $telemetryProperties = @{

        'OwnerName' = (Get-PiiSafeString -PlainText $OwnerName)

        'RepositoryName' = (Get-PiiSafeString -PlainText $RepositoryName)

    }

    $uriFragment = "/repos/$OwnerName/$RepositoryName/pulls"

    $postBody = @{

        'head' = $Head

        'base' = $Base

    }

    if ($PSBoundParameters.ContainsKey('Title'))

    {

        $description = "Creating pull request $Title in $RepositoryName"

        $shouldProcessAction = "Create GitHub Pull Request: $Title"

        $postBody['title'] = $Title

        # Body may be whitespace, although this might not be useful

        if ($Body)

        {

            $postBody['body'] = $Body

        }

    }

    else

    {

        $description = "Creating pull request for issue $Issue in $RepositoryName"

        $shouldProcessAction = "Create GitHub Pull Request for Issue $Issue"

        $postBody['issue'] = $Issue

    }

    if ($MaintainerCanModify)

    {

        $postBody['maintainer_can_modify'] = $true

    }

    if ($Draft)

    {

        $postBody['draft'] = $true

        $acceptHeader = 'application/vnd.github.shadow-cat-preview+json'

    }

    if (-not $PSCmdlet.ShouldProcess($RepositoryName, $shouldProcessAction))

    {

        return

    }

    $restParams = @{

        'UriFragment' = $uriFragment

        'Method' = 'Post'

        'Description' = $description

        'Body' = ConvertTo-Json -InputObject $postBody -Compress

        'AccessToken' = $AccessToken

        'TelemetryEventName' = $MyInvocation.MyCommand.Name

        'TelemetryProperties' = $telemetryProperties

    }

    if ($acceptHeader)

    {

        $restParams['AcceptHeader'] = $acceptHeader

    }

    return (Invoke-GHRestMethod @restParams | Add-GitHubPullRequestAdditionalProperties)

}

filter Add-GitHubPullRequestAdditionalProperties

{

<#

    .SYNOPSIS

        Adds type name and additional properties to ease pipelining to GitHub Repository objects.

    .PARAMETER InputObject

        The GitHub object to add additional properties to.

    .PARAMETER TypeName

        The type that should be assigned to the object.

#>

    [CmdletBinding()]

    [Diagnostics.CodeAnalysis.SuppressMessageAttribute("PSUseSingularNouns", "", Justification="Internal helper that is definitely adding more than one property.")]

    param(

        [Parameter(

            Mandatory,

            ValueFromPipeline)]

        [AllowNull()]

        [AllowEmptyCollection()]

        [PSCustomObject[]] $InputObject,

        [ValidateNotNullOrEmpty()]

        [string] $TypeName = $script:GitHubPullRequestTypeName

    )

    foreach ($item in $InputObject)

    {

        $item.PSObject.TypeNames.Insert(0, $TypeName)

        if (-not (Get-GitHubConfiguration -Name DisablePipelineSupport))

        {

            $elements = Split-GitHubUri -Uri $item.html_url

            $repositoryUrl = Join-GitHubUri @elements

            Add-Member -InputObject $item -Name 'RepositoryUrl' -Value $repositoryUrl -MemberType NoteProperty -Force

            Add-Member -InputObject $item -Name 'PullRequestId' -Value $item.id -MemberType NoteProperty -Force

            Add-Member -InputObject $item -Name 'PullRequestNumber' -Value $item.number -MemberType NoteProperty -Force

            @('assignee', 'assignees', 'requested_reviewers', 'merged_by', 'user') |

                ForEach-Object {

                    if ($null -ne $item.$_)

                    {

                        $null = Add-GitHubUserAdditionalProperties -InputObject $item.$_

                    }

                }

            if ($null -ne $item.labels)

            {

                $null = Add-GitHubLabelAdditionalProperties -InputObject $item.labels

            }

            if ($null -ne $item.milestone)

            {

                $null = Add-GitHubMilestoneAdditionalProperties -InputObject $item.milestone

            }

            if ($null -ne $item.requested_teams)

            {

                $null = Add-GitHubTeamAdditionalProperties -InputObject $item.requested_teams

            }

            # TODO: What type are item.head and item.base?

        }

        Write-Output $item

    }

}

# SIG # Begin signature block

# MIIjkgYJKoZIhvcNAQcCoIIjgzCCI38CAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCD4CPafwA8DRxVx

# T73QDBJGM321c5RgiQp8rs03EacFdKCCDYEwggX/MIID56ADAgECAhMzAAABh3IX

# chVZQMcJAAAAAAGHMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD

# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p

# bmcgUENBIDIwMTEwHhcNMjAwMzA0MTgzOTQ3WhcNMjEwMzAzMTgzOTQ3WjB0MQsw

# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u

# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy

# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB

# AQDOt8kLc7P3T7MKIhouYHewMFmnq8Ayu7FOhZCQabVwBp2VS4WyB2Qe4TQBT8aB

# znANDEPjHKNdPT8Xz5cNali6XHefS8i/WXtF0vSsP8NEv6mBHuA2p1fw2wB/F0dH

# sJ3GfZ5c0sPJjklsiYqPw59xJ54kM91IOgiO2OUzjNAljPibjCWfH7UzQ1TPHc4d

# weils8GEIrbBRb7IWwiObL12jWT4Yh71NQgvJ9Fn6+UhD9x2uk3dLj84vwt1NuFQ

# itKJxIV0fVsRNR3abQVOLqpDugbr0SzNL6o8xzOHL5OXiGGwg6ekiXA1/2XXY7yV

# Fc39tledDtZjSjNbex1zzwSXAgMBAAGjggF+MIIBejAfBgNVHSUEGDAWBgorBgEE

# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQUhov4ZyO96axkJdMjpzu2zVXOJcsw

# UAYDVR0RBEkwR6RFMEMxKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVyYXRpb25zIFB1

# ZXJ0byBSaWNvMRYwFAYDVQQFEw0yMzAwMTIrNDU4Mzg1MB8GA1UdIwQYMBaAFEhu

# ZOVQBdOCqhc3NyK1bajKdQKVMFQGA1UdHwRNMEswSaBHoEWGQ2h0dHA6Ly93d3cu

# bWljcm9zb2Z0LmNvbS9wa2lvcHMvY3JsL01pY0NvZFNpZ1BDQTIwMTFfMjAxMS0w

# Ny0wOC5jcmwwYQYIKwYBBQUHAQEEVTBTMFEGCCsGAQUFBzAChkVodHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01pY0NvZFNpZ1BDQTIwMTFfMjAx

# MS0wNy0wOC5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAgEAixmy

# S6E6vprWD9KFNIB9G5zyMuIjZAOuUJ1EK/Vlg6Fb3ZHXjjUwATKIcXbFuFC6Wr4K

# NrU4DY/sBVqmab5AC/je3bpUpjtxpEyqUqtPc30wEg/rO9vmKmqKoLPT37svc2NV

# BmGNl+85qO4fV/w7Cx7J0Bbqk19KcRNdjt6eKoTnTPHBHlVHQIHZpMxacbFOAkJr

# qAVkYZdz7ikNXTxV+GRb36tC4ByMNxE2DF7vFdvaiZP0CVZ5ByJ2gAhXMdK9+usx

# zVk913qKde1OAuWdv+rndqkAIm8fUlRnr4saSCg7cIbUwCCf116wUJ7EuJDg0vHe

# yhnCeHnBbyH3RZkHEi2ofmfgnFISJZDdMAeVZGVOh20Jp50XBzqokpPzeZ6zc1/g

# yILNyiVgE+RPkjnUQshd1f1PMgn3tns2Cz7bJiVUaqEO3n9qRFgy5JuLae6UweGf

# AeOo3dgLZxikKzYs3hDMaEtJq8IP71cX7QXe6lnMmXU/Hdfz2p897Zd+kU+vZvKI

# 3cwLfuVQgK2RZ2z+Kc3K3dRPz2rXycK5XCuRZmvGab/WbrZiC7wJQapgBodltMI5

# GMdFrBg9IeF7/rP4EqVQXeKtevTlZXjpuNhhjuR+2DMt/dWufjXpiW91bo3aH6Ea

# jOALXmoxgltCp1K7hrS6gmsvj94cLRf50QQ4U8Qwggd6MIIFYqADAgECAgphDpDS

# 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/BvW1taslScxMNelDNMYIVZzCCFWMCAQEwgZUwfjELMAkG

# A1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQx

# HjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9z

# b2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAxMQITMwAAAYdyF3IVWUDHCQAAAAABhzAN

# BglghkgBZQMEAgEFAKCBrjAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgor

# BgEEAYI3AgELMQ4wDAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgzlP+fJaq

# oOPyaDKsSPbikNa/YrsjwYD6+Sq6YJqaUNQwQgYKKwYBBAGCNwIBDDE0MDKgFIAS

# AE0AaQBjAHIAbwBzAG8AZgB0oRqAGGh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbTAN

# BgkqhkiG9w0BAQEFAASCAQDIkk+jANMehQN3z3r+Rsx9xBX2mfYm8ar5t+RIFA1a

# uOBL3zBSkL0DgpEu3vI6LFWvP2miCXAHLwWFRmsvj3Vyfcy8GWdpFhhclhPnThG2

# GD0pKlfxT0Y2GHQEY3AfmGzOqQQrQVdmMyQgij8hJvpOm+QCRxW4eWoupJ6/oSS5

# kduM81jkCcj/ycpE1n7HpBYlaayPuRYcmIHzkm7+QV4Ix7cSs6W83GHORBSg9sVz

# ECUrvhfLOGoH8ADKpo2b2m3MBhRzB3BUrlM/ooh9CHBa8/Bneq6YxhRjN0vUAbti

# 830dLn77Z5Ci/zvwSep6abjUfR+uIV9796JXDGAHxaq7oYIS8TCCEu0GCisGAQQB

# gjcDAwExghLdMIIS2QYJKoZIhvcNAQcCoIISyjCCEsYCAQMxDzANBglghkgBZQME

# AgEFADCCAVUGCyqGSIb3DQEJEAEEoIIBRASCAUAwggE8AgEBBgorBgEEAYRZCgMB

# MDEwDQYJYIZIAWUDBAIBBQAEIGHx2P/F0gYAMh8A0d1YKDwkUnY//6VSIx5AqEnI

# ZBG+AgZfFxEtm0wYEzIwMjAwODE4MDMxNDI5LjgwOFowBIACAfSggdSkgdEwgc4x

# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt

# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1p

# Y3Jvc29mdCBPcGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMg

# VFNTIEVTTjpDNEJELUUzN0YtNUZGQzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUt

# U3RhbXAgU2VydmljZaCCDkQwggT1MIID3aADAgECAhMzAAABIziw5K3YWpCdAAAA

# AAEjMA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNo

# aW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29y

# cG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEw

# MB4XDTE5MTIxOTAxMTQ1NloXDTIxMDMxNzAxMTQ1Nlowgc4xCzAJBgNVBAYTAlVT

# MRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQK

# ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jvc29mdCBPcGVy

# YXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpDNEJE

# LUUzN0YtNUZGQzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vydmlj

# ZTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAJ280MmwZKXcAS7x2ZvA

# 4TOOCzw+63Xs9ULGWtdZDN3Vl+aGQEsMwErIkgzQi0fTO0sOD9N3hO1HaTWHoS80

# N/Qb6oLR2WCZkv/VM4WFnThOv3yA5zSt+vuKNwrjEHFC0jlMDCJqaU7St6WJbl/k

# AP5sgM0qtpEEQhxtVaf8IoV5lq8vgMJNr30O4rqLYEi/YZWQZYwQHAiVMunCYpJi

# ccnNONRRdg2D3Tyu22eEJwPQP6DkeEioMy9ehMmBrkjADVOgQV+T4mir+hAJeINy

# sps6wgRO5qjuV5+jvczNQa1Wm7jxsqBv04GClIp5NHvrXQmZ9mpZdj3rjxFuZbKj

# d3ECAwEAAaOCARswggEXMB0GA1UdDgQWBBSB1GwUgNONG/kRwrBo3hkV+AyeHjAf

# BgNVHSMEGDAWgBTVYzpcijGQ80N7fEYbxTNoWoVtVTBWBgNVHR8ETzBNMEugSaBH

# hkVodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNU

# aW1TdGFQQ0FfMjAxMC0wNy0wMS5jcmwwWgYIKwYBBQUHAQEETjBMMEoGCCsGAQUF

# BzAChj5odHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY1RpbVN0

# YVBDQV8yMDEwLTA3LTAxLmNydDAMBgNVHRMBAf8EAjAAMBMGA1UdJQQMMAoGCCsG

# AQUFBwMIMA0GCSqGSIb3DQEBCwUAA4IBAQBb5QG3qlfoW6r1V4lT+kO8LUzF32S3

# fUfgn/S1QQBPzORs/6ujj09ytHWNDfOewwkSya1f8S9e+BbnXknH5l3R6nS2BkRT

# ANtTmXxvMLTCyveYe/JQIfos+Z3iJ0b1qHDSnEj6Qmdf1MymrPAk5jxhxhiiXlwI

# LUjvH56y7rLHxK0wnsH12EO9MnkaSNXJNCmSmfgUEkDNzu53C39l6XNRAPauz2/W

# slIUZcX3NDCMgv5hZi2nhd99HxyaJJscn1f8hZXA++f1HNbq8bdkh3OYgRnNr7Qd

# nO+Guvtu3dyGqYdQMMGPnAt4L7Ew9ykjy0Uoz64/r0SbQIRYty5eM9M3MIIGcTCC

# BFmgAwIBAgIKYQmBKgAAAAAAAjANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJv

# b3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5IDIwMTAwHhcNMTAwNzAxMjEzNjU1WhcN

# MjUwNzAxMjE0NjU1WjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3Rv

# bjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0

# aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDCCASIw

# DQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAKkdDbx3EYo6IOz8E5f1+n9plGt0

# VBDVpQoAgoX77XxoSyxfxcPlYcJ2tz5mK1vwFVMnBDEfQRsalR3OCROOfGEwWbEw

# RA/xYIiEVEMM1024OAizQt2TrNZzMFcmgqNFDdDq9UeBzb8kYDJYYEbyWEeGMoQe

# dGFnkV+BVLHPk0ySwcSmXdFhE24oxhr5hoC732H8RsEnHSRnEnIaIYqvS2SJUGKx

# Xf13Hz3wV3WsvYpCTUBR0Q+cBj5nf/VmwAOWRH7v0Ev9buWayrGo8noqCjHw2k4G

# kbaICDXoeByw6ZnNPOcvRLqn9NxkvaQBwSAJk3jN/LzAyURdXhacAQVPIk0CAwEA

# AaOCAeYwggHiMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBTVYzpcijGQ80N7

# fEYbxTNoWoVtVTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTALBgNVHQ8EBAMC

# AYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBTV9lbLj+iiXGJo0T2UkFvX

# zpoYxDBWBgNVHR8ETzBNMEugSaBHhkVodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20v

# cGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcmwwWgYI

# KwYBBQUHAQEETjBMMEoGCCsGAQUFBzAChj5odHRwOi8vd3d3Lm1pY3Jvc29mdC5j

# b20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIzLmNydDCBoAYDVR0g

# AQH/BIGVMIGSMIGPBgkrBgEEAYI3LgMwgYEwPQYIKwYBBQUHAgEWMWh0dHA6Ly93

# d3cubWljcm9zb2Z0LmNvbS9QS0kvZG9jcy9DUFMvZGVmYXVsdC5odG0wQAYIKwYB

# BQUHAgIwNB4yIB0ATABlAGcAYQBsAF8AUABvAGwAaQBjAHkAXwBTAHQAYQB0AGUA

# bQBlAG4AdAAuIB0wDQYJKoZIhvcNAQELBQADggIBAAfmiFEN4sbgmD+BcQM9naOh

# IW+z66bM9TG+zwXiqf76V20ZMLPCxWbJat/15/B4vceoniXj+bzta1RXCCtRgkQS

# +7lTjMz0YBKKdsxAQEGb3FwX/1z5Xhc1mCRWS3TvQhDIr79/xn/yN31aPxzymXlK

# kVIArzgPF/UveYFl2am1a+THzvbKegBvSzBEJCI8z+0DpZaPWSm8tv0E4XCfMkon

# /VWvL/625Y4zu2JfmttXQOnxzplmkIz/amJ/3cVKC5Em4jnsGUpxY517IW3DnKOi

# PPp/fZZqkHimbdLhnPkd/DjYlPTGpQqWhqS9nhquBEKDuLWAmyI4ILUl5WTs9/S/

# fmNZJQ96LjlXdqJxqgaKD4kWumGnEcua2A5HmoDF0M2n0O99g/DhO3EJ3110mCII

# YdqwUB5vvfHhAN/nMQekkzr3ZUd46PioSKv33nJ+YWtvd6mBy6cJrDm77MbL2IK0

# cs0d9LiFAR6A+xuJKlQ5slvayA1VmXqHczsI5pgt6o3gMy4SKfXAL1QnIffIrE7a

# KLixqduWsqdCosnPGUFN4Ib5KpqjEWYw07t0MkvfY3v1mYovG8chr1m1rtxEPJdQ

# cdeh0sVV42neV8HR3jDA/czmTfsNv11P6Z0eGTgvvM9YBS7vDaBQNdrvCScc1bN+

# NR4Iuto229Nfj950iEkSoYIC0jCCAjsCAQEwgfyhgdSkgdEwgc4xCzAJBgNVBAYT

# AlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYD

# VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKTAnBgNVBAsTIE1pY3Jvc29mdCBP

# cGVyYXRpb25zIFB1ZXJ0byBSaWNvMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpD

# NEJELUUzN0YtNUZGQzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vy

# dmljZaIjCgEBMAcGBSsOAwIaAxUAuhdmjeDinhfC7gw1KBCeM/v7V4GggYMwgYCk

# fjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH

# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD

# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIF

# AOLlJyowIhgPMjAyMDA4MTcxOTU2MjZaGA8yMDIwMDgxODE5NTYyNlowdzA9Bgor

# BgEEAYRZCgQBMS8wLTAKAgUA4uUnKgIBADAKAgEAAgIecAIB/zAHAgEAAgISATAK

# AgUA4uZ4qgIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIB

# AAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAIpJDZWTB9tNmfwC

# aGJtiL1/avo/jOu9T455aDdlA4JmK4t3pk8dfw+R+wHcXVKu4TwmRcjzIcubfy5S

# Cs4XYiGnDRNbGoAIv0qWiaFobSCdHNcTdOnDNafmptkbEaGNewGKStZFZ517K45W

# jAooyk1nwuwAnhSUPNM/6XRgvhltMYIDDTCCAwkCAQEwgZMwfDELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp

# bWUtU3RhbXAgUENBIDIwMTACEzMAAAEjOLDkrdhakJ0AAAAAASMwDQYJYIZIAWUD

# BAIBBQCgggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0B

# CQQxIgQgmIKS3ZUwgAI7pnm43RzVvd4RI7L8YZKl5nq1qXeEgXQwgfoGCyqGSIb3

# DQEJEAIvMYHqMIHnMIHkMIG9BCARmjODP/tEzMQNo6OsxKQADL8pwKJkM5YnXKrq

# +xWBszCBmDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u

# MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp

# b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAAB

# Iziw5K3YWpCdAAAAAAEjMCIEIBxustGluyregUHmA1kIUVNdps/cVsWhx/B2unuf

# Xb2LMA0GCSqGSIb3DQEBCwUABIIBAANy5kJv0rkI3yFbP2RjJDWdKkHDDuwNgXhs

# 9emKvKG0qF30WCPwW/ZomhrxKJ+2dttMvLCsdvK+yGOocRRygQpw78qbNUWdMvwU

# ElUmA91gS3xa/pwZ93iQOWXFRq5XeKr+3nlq0x5uf5V4RxxwFTyp+/OwBif3KG5q

# 4vHo1Rnlff0AnkrxUTxdIttHX07l/7KsL8Ea8WGEpyuBaPmOjI0m92fDpEhgoeqd

# p53Fp/5Om7LdHGREdKaOkEL7oCLcIGeTrV0Uol95BPsanCoH9hcyrpO2jO2JtIYn

# 0f2evT0Fa1TF6ytoducDo4oXE/BWM6T/EdaEIZdDcClKZDJf0/c=

# SIG # End signature block