BcContainerHelper

6.1.16-preview2594144

Saas/Publish-PerTenantExtensionApps.ps1

                                <# 

 .Synopsis

  Function for publishing PTE apps to an online tenant

 .Description

  Function for publishing PTE apps to an online tenant

  Please consult the CI/CD Workshop document at http://aka.ms/cicdhol to learn more about this function

 .Parameter clientId

  ClientID of Azure AD App for authenticating to Business Central (SecureString or String)

 .Parameter clientSecret

  ClientSecret of Azure AD App for authenticating to Business Central (SecureString or String)

 .Parameter tenantId

  TenantId of tenant in which you want to publish the Per Tenant Extension Apps

 .Parameter environment

  Name of the environment inside the tenant in which you want to publish the Per Tenant Extension Apps

 .Parameter companyName

  Company Name in which the Azure AD App is registered

 .Parameter appFiles

  Array or comma separated string of apps or .zip files containing apps, which needs to be published

  The apps will be sorted by dependencies and published+installed

 .Parameter useNewLine

  Add this switch to add a newline to progress indicating periods during wait.

  Azure DevOps doesn't update logs until a newline is added.

 .Parameter hideInstalledExtensionsOutput

  Add this parameter to hide the output that lists installed extensions on the specified environment before and after installation of new and updated PTE extensions.

 .Parameter unpublishPreviousVersions

  Add this switch to unpublish previous versions of apps after upgrading to a new version.

#>

function Publish-PerTenantExtensionApps {

    [CmdletBinding(DefaultParameterSetName="AC")]

    Param(

        [Parameter(Mandatory=$true, ParameterSetName="CC")]

        $clientId,

        [Parameter(Mandatory=$true, ParameterSetName="CC")]

        $clientSecret,

        [Parameter(Mandatory=$true, ParameterSetName="CC")]

        [string] $tenantId,

        [Parameter(Mandatory=$true, ParameterSetName="AC")]

        [Hashtable] $bcAuthContext,

        [Parameter(Mandatory=$true)]

        [string] $environment,

        [Parameter(Mandatory=$false)]

        [string] $companyName,

        [Parameter(Mandatory=$true)]

        $appFiles,

        [ValidateSet('Add','Force')]

        [string] $schemaSyncMode = 'Add',

        [ValidateSet('','Current version','Next minor version','Next major version')]

        [string] $schedule = '',

        [switch] $useNewLine,

        [switch] $hideInstalledExtensionsOutput,

        [switch] $unpublishPreviousVersions

    )

$telemetryScope = InitTelemetryScope -name $MyInvocation.InvocationName -parameterValues $PSBoundParameters -includeParameters @()

try {

    function GetAuthHeaders {

        $script:authContext = Renew-BcAuthContext -bcAuthContext $script:authContext

        return @{ "Authorization" = "Bearer $($script:authContext.AccessToken)" }

    }

    $newLine = @{}

    if (!$useNewLine) {

        $newLine = @{ "NoNewLine" = $true }

    }

    if ($PsCmdlet.ParameterSetName -eq "CC") {

        if ($clientId -is [SecureString]) { $clientID = [System.Runtime.InteropServices.Marshal]::PtrToStringBSTR([System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($clientID)) }

        if ($clientId -isnot [String]) { throw "ClientID needs to be a SecureString or a String" }

        if ($clientSecret -is [String]) { $clientSecret = ConvertTo-SecureString -String $clientSecret -AsPlainText -Force }

        if ($clientSecret -isnot [SecureString]) { throw "ClientSecret needs to be a SecureString or a String" }

        $script:authContext = New-BcAuthContext `

            -clientID $clientID `

            -clientSecret $clientSecret `

            -tenantID $tenantId `

            -scopes "https://api.businesscentral.dynamics.com/.default"

        if (-not ($script:AuthContext)) {

            throw "Authentication failed"

        }

    }

    else {

        $script:authContext = Renew-BcAuthContext -bcAuthContext $bcAuthContext

    }

    $appFolder = Join-Path ([System.IO.Path]::GetTempPath()) ([guid]::NewGuid().ToString())

    try {

        $appFiles = CopyAppFilesToFolder -appFiles $appFiles -folder $appFolder

        $automationApiUrl = "$($bcContainerHelperConfig.apiBaseUrl.TrimEnd('/'))/v2.0/$environment/api/microsoft/automation/v2.0"

        Write-Host "$automationApiUrl/companies"

        $companies = Invoke-RestMethod -Headers (GetAuthHeaders) -Method Get -Uri "$automationApiUrl/companies" -UseBasicParsing

        $company = $companies.value | Where-Object { ($companyName -eq "") -or ($_.name -eq $companyName) } | Select-Object -First 1

        if (!($company)) {

            throw "No company $companyName"

        }

        $companyId = $company.id

        if ($companyName -eq "") {

            $companyName = $company.name

        }

        Write-Host "Company '$companyName' has id $companyId"

        Write-Host "$automationApiUrl/companies($companyId)/extensions"

        $getExtensions = Invoke-WebRequest -Headers (GetAuthHeaders) -Method Get -Uri "$automationApiUrl/companies($companyId)/extensions" -UseBasicParsing

        $extensions = (ConvertFrom-Json $getExtensions.Content).value | Sort-Object -Property DisplayName

        if(!$hideInstalledExtensionsOutput) {

            Write-Host "Extensions before:"

            $extensions | ForEach-Object { Write-Host " - $($_.DisplayName), Version $($_.versionMajor).$($_.versionMinor).$($_.versionBuild).$($_.versionRevision), Installed=$($_.isInstalled)" }

            Write-Host

        }

        $body = @{"schedule" = "Current Version"}

        $appDep = $extensions | Where-Object { $_.DisplayName -eq 'Application' }

        $appDepVer = [System.Version]"$($appDep.versionMajor).$($appDep.versionMinor).$($appDep.versionBuild).$($appDep.versionRevision)"

        if ($appDepVer -ge [System.Version]"21.2.0.0") {

            if ($schemaSyncMode -eq 'Force') {

                $body."SchemaSyncMode" = "Force Sync"

            }

            else {

                $body."SchemaSyncMode" = "Add"

            }

        }

        else {

            if ($schemaSyncMode -eq 'Force') {

                throw 'SchemaSyncMode Force is not supported before version 21.2'

            }

        }

        if($schedule) {

            $body."schedule" = $schedule

        }

        $ifMatchHeader = @{ "If-Match" = '*'}

        $jsonHeader = @{ "Content-Type" = 'application/json'}

        $streamHeader = @{ "Content-Type" = 'application/octet-stream'}

        try {

            Sort-AppFilesByDependencies -appFiles $appFiles -excludeRuntimePackages | ForEach-Object {

                $appFile = $_

                Write-Host @newline "$([System.IO.Path]::GetFileName($appFile)) - "

                $appJson = Get-AppJsonFromAppFile -appFile $appFile

                $previousApp = $null

                $existingApp = $extensions | Where-Object { $_.id -eq $appJson.id -and $_.isInstalled }

                if ($existingApp) {

                    if ($existingApp.isInstalled) {

                        $existingVersion = [System.Version]"$($existingApp.versionMajor).$($existingApp.versionMinor).$($existingApp.versionBuild).$($existingApp.versionRevision)"

                        if ($existingVersion -ge $appJson.version) {

                            Write-Host "already installed"

                        }

                        else {

                            Write-Host @newLine "upgrading"

                            $previousApp = $existingApp

                            $existingApp = $null

                        }

                    }

                    else {

                        Write-Host @newLine "installing"

                        $existingApp = $null

                    }

                }

                else {

                    Write-Host @newLine "publishing and installing"

                }

                if (!$existingApp) {

                    $extensionUpload = (Invoke-RestMethod -Method Get -Uri "$automationApiUrl/companies($companyId)/extensionUpload" -Headers (GetAuthHeaders)).value

                    Write-Host @newLine "."

                    if ($extensionUpload -and $extensionUpload.systemId) {

                        $extensionUpload = Invoke-RestMethod `

                            -Method Patch `

                            -Uri "$automationApiUrl/companies($companyId)/extensionUpload($($extensionUpload.systemId))" `

                            -Headers ((GetAuthHeaders) + $ifMatchHeader + $jsonHeader) `

                            -Body ($body | ConvertTo-Json -Compress)

                    }

                    else {

                        $ExtensionUpload = Invoke-RestMethod `

                            -Method Post `

                            -Uri "$automationApiUrl/companies($companyId)/extensionUpload" `

                            -Headers ((GetAuthHeaders) + $jsonHeader) `

                            -Body ($body | ConvertTo-Json -Compress)

                    }

                    Write-Host @newLine "."

                    if ($null -eq $extensionUpload.systemId) {

                        throw "Unable to upload extension"

                    }

                    # Use stream instead of reading the entire file into memory

                    $fileStream = [System.IO.File]::OpenRead($appFile)

                    Invoke-RestMethod `

                        -Method Patch `

                        -Uri $extensionUpload.'extensionContent@odata.mediaEditLink' `

                        -Headers ((GetAuthHeaders) + $ifMatchHeader + $streamHeader) `

                        -Body $fileStream | Out-Null

                    $fileStream.Close()

                    Write-Host @newLine "."

                    Invoke-RestMethod `

                        -Method Post `

                        -Uri "$automationApiUrl/companies($companyId)/extensionUpload($($extensionUpload.systemId))/Microsoft.NAV.upload" `

                        -Headers ((GetAuthHeaders) + $ifMatchHeader) `

                        -ErrorAction SilentlyContinue | Out-Null

                    Write-Host @newLine "."    

                    $completed = $false

                    $errCount = 0

                    $sleepSeconds = 30

                    $lastStatus = ''

                    while (!$completed)

                    {

                        Start-Sleep -Seconds $sleepSeconds

                        try {

                            $extensionDeploymentStatusResponse = Invoke-WebRequest -Headers (GetAuthHeaders) -Method Get -Uri "$automationApiUrl/companies($companyId)/extensionDeploymentStatus" -UseBasicParsing

                            $extensionDeploymentStatuses = (ConvertFrom-Json $extensionDeploymentStatusResponse.Content).value

                            $thisExtension = $extensionDeploymentStatuses | Where-Object { $_.publisher -eq $appJson.publisher -and $_.name -eq $appJson.name -and $_.appVersion -eq $appJson.version }

                            if ($null -eq $thisExtension) {

                                throw "Unable to find extension deployment status"

                            } 

                            $thisExtension | ForEach-Object {

                                if ($_.status -ne $lastStatus) {

                                    if (!$useNewLine) { Write-Host }

                                    Write-Host @newLine $_.status

                                    $lastStatus = $_.status

                                }

                                if ($_.status -eq "InProgress") {

                                    $errCount = 0

                                    $sleepSeconds = 5

                                    Write-Host @newLine "."

                                }

                                elseif ($_.Status -eq "Unknown") {

                                    throw "Unknown Error"

                                }

                                elseif ($_.Status -eq "Completed") {

                                    if (!$useNewLine) { Write-Host }

                                    $completed = $true

                                }

                                else {

                                    $errCount = 5

                                    throw $_.status

                                }

                            }

                        }

                        catch {

                            if (!$useNewLine) { Write-Host }

                            if ($errCount++ -gt 4) {

                                Write-Host $_.Exception.Message

                                throw "Unable to publish app. Please open the Extension Deployment Status Details page in Business Central to see the detailed error message."

                            }

                            $sleepSeconds += $sleepSeconds

                            Write-Host "Error: $($_.Exception.Message). Retrying in $sleepSeconds seconds"

                        }

                    }

                    if ($unpublishPreviousVersions -and $previousApp -and ($appDepVer -ge [System.Version]"25.4.0.0")) { # New unpublish API available from 25.4

                        Write-Host @newLine "Unpublishing previous version"

                        Invoke-RestMethod `

                            -Method Post `

                            -Uri "$automationApiUrl/companies($companyId)/extensions($($previousApp.packageId))/Microsoft.NAV.unpublish" `

                            -Headers (GetAuthHeaders) | Out-Null

                    }

                }

            }

        }

        catch [System.Net.WebException],[System.Net.Http.HttpRequestException] {

            if (!$useNewLine) { Write-Host }

            Write-Host "ERROR $($_.Exception.Message)"

            Write-Host $_.ScriptStackTrace

            throw (GetExtendedErrorMessage $_)

        }

        catch {

            if (!$useNewLine) { Write-Host }

            Write-Host "ERROR: $($_.Exception.Message) [$($_.Exception.GetType().FullName)]"

            throw

        }

        finally {

            $getExtensions = Invoke-WebRequest -Headers (GetAuthHeaders) -Method Get -Uri "$automationApiUrl/companies($companyId)/extensions" -UseBasicParsing

            $extensions = (ConvertFrom-Json $getExtensions.Content).value | Sort-Object -Property DisplayName

            if (!$hideInstalledExtensionsOutput) {

                Write-Host

                Write-Host "Extensions after:"

                $extensions | ForEach-Object { Write-Host " - $($_.DisplayName), Version $($_.versionMajor).$($_.versionMinor).$($_.versionBuild).$($_.versionRevision), Installed=$($_.isInstalled)" }

            }

        }

    }

    catch [System.Net.WebException],[System.Net.Http.HttpRequestException] {

        Write-Host "ERROR $($_.Exception.Message)"

        throw (GetExtendedErrorMessage $_)

    }

    finally {

        if (Test-Path $appFolder) {

            Remove-Item $appFolder -Recurse -Force -ErrorAction SilentlyContinue

        }

    }

}

catch {

    TrackException -telemetryScope $telemetryScope -errorRecord $_

    throw

}

finally {

    $script:authContext = $null

    TrackTrace -telemetryScope $telemetryScope

}

}

Export-ModuleMember -Function Publish-PerTenantExtensionApps

# SIG # Begin signature block

# MIInSQYJKoZIhvcNAQcCoIInOjCCJzYCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCBWCWINe1jT9ccY

# kzwzQ4QQ9o29ZgLDb1zQSw9D7Xym/KCCDLowggX1MIID3aADAgECAhMzAAACHU0Z

# yE7XD1dIAAAAAAIdMA0GCSqGSIb3DQEBCwUAMFcxCzAJBgNVBAYTAlVTMR4wHAYD

# VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBD

# b2RlIFNpZ25pbmcgUENBIDIwMjQwHhcNMjYwNDE2MTg1OTQzWhcNMjcwNDE1MTg1

# OTQzWjB0MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE

# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYD

# VQQDExVNaWNyb3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IB

# DwAwggEKAoIBAQDQvewXxx9gZZFC6Ys1WBay8BJ8kGA4JQnH5CMafqOASlTpK9H8

# o5ZXTXt0caVQTNMUPt445wXYD+dFtaKWTwDn1I52oUSrC9vJin1Gsqt+zyKJL5Dg

# 3eQXbQNR61DmMy20GLTIO3SFed9Rfi/ophgCLGFLDR3r0KvHjwMb/jYWS0celV/4

# Lz27LfAekm8v9E5IXaeiXbAUYZKK090n4CVl3JBtbN+9DtI9SNu/yjvozW52/u7R

# X/Ttpa/KDlpuokZ+Zcbvmtd9ur9gFLvZzh41o9MsE/clQtdaFWGvuo6Jua/ntpgk

# ey3E5/vBFe+MJPG6phdnuo6r57ZudCudiI1bAgMBAAGjggGbMIIBlzAOBgNVHQ8B

# Af8EBAMCB4AwHwYDVR0lBBgwFgYKKwYBBAGCN0wIAQYIKwYBBQUHAwMwHQYDVR0O

# BBYEFH6QuMwqcPG0hQlQ6c5jCtTTLrVeMEUGA1UdEQQ+MDykOjA4MR4wHAYDVQQL

# ExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xFjAUBgNVBAUTDTIzMDAxMis1MDc1NTkw

# HwYDVR0jBBgwFoAUf1k/VCHarU/vBeXmo9ctBpQSCDEwYAYDVR0fBFkwVzBVoFOg

# UYZPaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9jcmwvTWljcm9zb2Z0

# JTIwQ29kZSUyMFNpZ25pbmclMjBQQ0ElMjAyMDI0LmNybDBtBggrBgEFBQcBAQRh

# MF8wXQYIKwYBBQUHMAKGUWh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMv

# Y2VydHMvTWljcm9zb2Z0JTIwQ29kZSUyMFNpZ25pbmclMjBQQ0ElMjAyMDI0LmNy

# dDAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBCwUAA4ICAQBKTbYOjzwTG/DXGaz9

# s6+fQeaTtDcFmMY+5UyVFCyj7Pv+5i37qfX8lSL/tBIfYQfWsMuBQlfZurJD6r4H

# VJ2CeH+1fgiq8dcHdVKoZ3Sa2qXoX3cq9iS8cVb06B7+5/XJ7I0OxHH9fDsvJ3T3

# w5V/ZtAIFmLrl+P0CtG+92uzRsn0nTbdFjOkLMLWPLAU3THohKRlSEMgFJpPkm5n

# 5UAZ35xX6FWCrDLsSKb555bTifwa8mJBwdlof0bmfYidH+dxZ1FdDxvLnNl9zeKs

# A4kejaaIqqIPguhwAti5Ql7BlTNoJNwxCvBmqW2MQLnCkYN/VVUsR3V2x/rcTNzo

# Bf/Z/SpROvdaA2ZOOd1uioXJt3tdLQ7vHpqpib0KfWr/FWXW10q38VxfCnRQBqzb

# SuztR7nEMuzX7Ck+B/XaPDXd1qh72+QYyB0Z2VzWmO9zsnb9Uq/dwu8LGeQqnyu6

# 7SDGACvnXii2fb9+US492VTnXSnFKyqwgzUyFMtZK1/sHYTv6bG4TtQUygQxTN+Z

# V+aJIlKO2MqZ7bKrAnOzS9m6NgoTdWOq11bTOZwKlIEV/EhV9SWkDmdpR/hPPT2v

# 6TEj4F8PT/zHjRezIU5c/DGlt/VhY/pK0XkJtEyMmmS1BMtjU/rqBZVMIm3dnxQs

# /TBByr+Cf8Z1r7aifQVQ+WSqzjCCBr0wggSloAMCAQICEzMAAAA5O7Y3Gb8GHWcA

# AAAAADkwDQYJKoZIhvcNAQEMBQAwgYgxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpX

# YXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQg

# Q29ycG9yYXRpb24xMjAwBgNVBAMTKU1pY3Jvc29mdCBSb290IENlcnRpZmljYXRl

# IEF1dGhvcml0eSAyMDExMB4XDTI0MDgwODIwNTQxOFoXDTM2MDMyMjIyMTMwNFow

# VzELMAkGA1UEBhMCVVMxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEo

# MCYGA1UEAxMfTWljcm9zb2Z0IENvZGUgU2lnbmluZyBQQ0EgMjAyNDCCAiIwDQYJ

# KoZIhvcNAQEBBQADggIPADCCAgoCggIBANgBnB7jOMeqlRYHNa265v4IY9fH8TKh

# emHfPINe1gpLaV3dhg324WwH06LcHbpnsBukCDNitryo0dtS/EW6I/yEL/bLSY8h

# KpbfQuWusBPr9qazYcDxCW/qnjb5JsI1s8bNOg3bVATvQVL4tcf03aTycsz8QeCd

# M0l/yHRObJ9QqazM1r6VPEOJ7LL+uEEb73w6QCuhs89a1uv1zerOYMnsneRRwCbp

# yW11IcggU0cRKDDq1pjVJzIbIF6+oiXXbReOsgeI8zu1FyQfK0fVkaya8SmVHQ/t

# Of23mZ4W9k0Ri22QW9p3UgSC5OUDktKxxcCmGL6tXLfOGSWHIIV4YrTJTT6PNty5

# REojHJuZHArkF9VnHTERWoTjAzfI3kP+5b4alUdhgAZ7ttOu1bVnXfHaqPYl2rPs

# 20ji03LOVWsh/radgE17es5hL+t6lV0eVHrVhsssROWJuz2MXMCt7iw7lFPG9LXK

# Gjsmonn2gotGdHIuEg5JnJMJVmixd5LRlkmgYRZKzhxSCwyoGIq0PhaA7Y+VPct5

# pCHkijcIIDm0nlkK+0KyepolcqGm0T/GYQRMhHJlGOOmVQop36wUVUYklUy++vDW

# eEgEo4s7hxN6mIbf2MSIQ/iIfMZgJxC69oukMUXCrOC3SkE/xIkgpfl22MM1itkZ

# 35nNXkMolU1lAgMBAAGjggFOMIIBSjAOBgNVHQ8BAf8EBAMCAYYwEAYJKwYBBAGC

# NxUBBAMCAQAwHQYDVR0OBBYEFH9ZP1Qh2q1P7wXl5qPXLQaUEggxMBkGCSsGAQQB

# gjcUAgQMHgoAUwB1AGIAQwBBMA8GA1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU

# ci06AjGQQ7kUBU7h6qfHMdEjiTQwWgYDVR0fBFMwUTBPoE2gS4ZJaHR0cDovL2Ny

# bC5taWNyb3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMvTWljUm9vQ2VyQXV0MjAx

# MV8yMDExXzAzXzIyLmNybDBeBggrBgEFBQcBAQRSMFAwTgYIKwYBBQUHMAKGQmh0

# dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljUm9vQ2VyQXV0MjAx

# MV8yMDExXzAzXzIyLmNydDANBgkqhkiG9w0BAQwFAAOCAgEAFJQfOChP7onn6fLI

# MKrSlN1WYKwDFgAddymOUO3FrM8d7B/W/iQ6DxXsDn7D5W4wMwYeLystcEqfkjz4

# NURRgazyMu5yRzQh4LqjA4tStTcJh1opExo7nn5PuPBYnbu0+THSuVHTe0VTTPVh

# ily/piFrDo3axQ9P4C+Ol5yet+2gTfekICS5xS+cYfSIvgn0JksVBVMYVI5QFu/q

# hnLhsEFEUzG8fvv0hjgkO+lkpV9ty6GkN4vdnd7ya6Q6aR9y34aiM1qmxaxBi6OU

# nyNl6fkuun/diTFnYDLTppOkr/mg5WSfCiDVMNCxtj4wPKC5OmHm1DQIt/MNokbb

# H3UGsFP1QbzsLocuSqLCvH09Io3fDPTmscR9Y75G4qX7RTX8AdBPo0I6OEojf39z

# uFZt0qOHm65YWQE69cZM2ueE1MB05dNNgHK9gTE7zKvK/fg8B2qjW88MT/WF5V5u

# vZGtqa9FSL2RazArA+rDPuf6JGYz4HpgMZHB4S6szWSKYBv0VisCzfxgeU+dquXW

# 9bd0auYlOB58DPcOYKdc3Se94g+xL4pcEhbB54JOgAkwYTu/9dLeH2pDqeJZAABV

# DWRQCaXfO5LgyKwKCLYXpigrZYCjUSBcr+Ve8PFWMhVTQl0v4q8J/AUmQN5W4n10

# 1cY2L4A7GTQG1h32HHAvfQESWP0xghnlMIIZ4QIBATBuMFcxCzAJBgNVBAYTAlVT

# MR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jv

# c29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMjQCEzMAAAIdTRnITtcPV0gAAAAAAh0w

# DQYJYIZIAWUDBAIBBQCgga4wGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYK

# KwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIKGLS97D

# xXlqnllIizEG8KwVVjw22qCB947a33fWbGngMEIGCisGAQQBgjcCAQwxNDAyoBSA

# EgBNAGkAYwByAG8AcwBvAGYAdKEagBhodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20w

# DQYJKoZIhvcNAQEBBQAEggEAYXvf6+nf2IDEEDnBwU0Q5WTT3s9G91q9XhK/FGMY

# 5xfKDRyl0FZYO1o1wpoyip+AL4zQQnzaZrTYZ9tquZQz90dOYqljXJkjyjy/HAMf

# 9XYHtrwFEneETZ/WjGY+SVICkkClOnDximOQ0nypNvIoVQhgxJ2cHgib3mgeuruJ

# yKPBkuQnaaWWubfuEjaubHDa0clsu7Nq9o8S982tWMiwscgip797crHZtR0q1F0H

# kk/Cbs3H2cBepLf9hw2zYtArF1lC/oiZT9VDDAnN3XzCW7vKSUYFH+MxBoQj09zT

# eFW3X0ZUPvvOicSAhr66eRsCd5umRXmOqvPcYbLwsGvvBKGCF5cwgheTBgorBgEE

# AYI3AwMBMYIXgzCCF38GCSqGSIb3DQEHAqCCF3AwghdsAgEDMQ8wDQYJYIZIAWUD

# BAIBBQAwggFSBgsqhkiG9w0BCRABBKCCAUEEggE9MIIBOQIBAQYKKwYBBAGEWQoD

# ATAxMA0GCWCGSAFlAwQCAQUABCBe8+sB4G32gqOhB540hMbwkO8fUgNKZNEgc4pR

# Og4PqwIGal/5BtoxGBMyMDI2MDcyMzExNTMzMy4xNjRaMASAAgH0oIHRpIHOMIHL

# MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVk

# bW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxN

# aWNyb3NvZnQgQW1lcmljYSBPcGVyYXRpb25zMScwJQYDVQQLEx5uU2hpZWxkIFRT

# UyBFU046N0YwMC0wNUUwLUQ5NDcxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0

# YW1wIFNlcnZpY2WgghHtMIIHIDCCBQigAwIBAgITMwAAAh6jrKRuOW98SQABAAAC

# HjANBgkqhkiG9w0BAQsFADB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGlu

# Z3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBv

# cmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDAe

# Fw0yNjAyMTkxOTM5NDlaFw0yNzA1MTcxOTM5NDlaMIHLMQswCQYDVQQGEwJVUzET

# MBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMV

# TWljcm9zb2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxNaWNyb3NvZnQgQW1lcmlj

# YSBPcGVyYXRpb25zMScwJQYDVQQLEx5uU2hpZWxkIFRTUyBFU046N0YwMC0wNUUw

# LUQ5NDcxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0YW1wIFNlcnZpY2UwggIi

# MA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQCl0TjtbDwsR7Fe8ac6ol5s1zht

# Tqd2AWpchQhLp9G5mmSM23N5fyQGCQ1D06rOA3PgXKF+76vXvOCs2VsLv1owj4mH

# EyEqiq8GJ5yC+/QNYRpZPA8e7OgekzDO6S/4vy/jTMYbp3rhuFiKKCzTWOQtdFcF

# +D0k369I7pm/E07SyNMGkuNd5lj5SJ91UqFuZfjMB6cQ2wh77mtiRUVdj53yjdNq

# j+GQl+Yaz29Bjrzn7U1ln+JpLlnb0xdGmZoIPKZbwBVcWtyL4uyhML7SSTmiOfWX

# U+g+yNl0CdoLGL8LtWHEi8FsuTPeSdSqmeMrvLaEmibTVTS4vQQY8NPnb6uI5y6i

# NV9vBFcm8LU/lDTjGTqPa7UBT4gdf5Jm3wYrfCFZ4P/j5MoqT0JONca50jt4TGI9

# 0SihXaDEYqk23S0IJZ3UkUpukDRTjK713BIykffxyBqMeQqfO0zvWfUx7BrmUpug

# Qcw99+DxLl2gf+uQEpRmnlbrVJ9dvW9ds4fqEPN2jG0QwF1PBSglNcV1SpqZKitQ

# gBGSwu/82AKztoCHwYRHRNwzwTVe/1KNTvmqAd4Uges4ywOH02haagT8wYY8OdWd

# jKn3k052w+kmc0UC0F+iVXTGZIMxvo9iBZQoXehzRtWJ/VOtKvCyS3csKzN7rStW

# JwjSWz6dtOf0l+ytLQIDAQABo4IBSTCCAUUwHQYDVR0OBBYEFOYKFprqBB0JZmJc

# FC4cPPmeF4JkMB8GA1UdIwQYMBaAFJ+nFV0AXmJdg/Tl0mWnG1M1GelyMF8GA1Ud

# HwRYMFYwVKBSoFCGTmh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvY3Js

# L01pY3Jvc29mdCUyMFRpbWUtU3RhbXAlMjBQQ0ElMjAyMDEwKDEpLmNybDBsBggr

# BgEFBQcBAQRgMF4wXAYIKwYBBQUHMAKGUGh0dHA6Ly93d3cubWljcm9zb2Z0LmNv

# bS9wa2lvcHMvY2VydHMvTWljcm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIw

# MTAoMSkuY3J0MAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUHAwgw

# DgYDVR0PAQH/BAQDAgeAMA0GCSqGSIb3DQEBCwUAA4ICAQCkoZB5NnJVFb5wKejR

# onk518a2TBNYpKcBMtfL6BS0ARaABOMGYLlPNuhI1HwmelP9hX3oq3TaEm/cDkkz

# NQAzDedPgoRI2R7+8poNSWvHXEAs7SZODm9x7KqlBkNZM9ex4XY1yNmVOAmWDjRr

# 7jKjaiQbntf7EC4GNikxGGaVWOjfYt3Q9X0r/Ks8KBlbzDR9zjA/TCctR4co1WpU

# 1ZRLFrB9bl8dRxsbnyT2qQ41E7dT12R30eIGUziEs5GN+26V/ovXOi20dJiM13hY

# Wvy1NNJAhkKOlLB1ONund6ffhPdUcHWsu8V+lR0aakMV64HqDbLumZrCNwUofVx3

# xMk8F4tCYJtQxLTywc30sZAD1S2sC1959x6KixA+p41FLUl8g64oHy3bfYnH5xd4

# JOBgQoaqndGjcctxr+8EknjhKyrgAzrTcKLJbUezgoye8brCLJ+y6PAoEjpXRkSY

# AU8wfQ3YWRck6ALwoV7Uin8+rpGQSbXhF6c1dTFakXmChClud4IADY/t6JRkJ+06

# FzL+jDd8KLV8Qj77JfiuTiPIG5G/xlnGoZFcX+yyBtDvzZE48d+Y+HYUd/cvhH1F

# Kl7AH+5AyotqJSFmvM/BuYRx2B20asVXilV2k2JbNO3LGCz3Q+dpElzwsfJrka1N

# /getma7fWpowsNvoIaEQvjad8TCCB3EwggVZoAMCAQICEzMAAAAVxedrngKbSZkA

# AAAAABUwDQYJKoZIhvcNAQELBQAwgYgxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpX

# YXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQg

# Q29ycG9yYXRpb24xMjAwBgNVBAMTKU1pY3Jvc29mdCBSb290IENlcnRpZmljYXRl

# IEF1dGhvcml0eSAyMDEwMB4XDTIxMDkzMDE4MjIyNVoXDTMwMDkzMDE4MzIyNVow

# fDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1Jl

# ZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMd

# TWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwggIiMA0GCSqGSIb3DQEBAQUA

# A4ICDwAwggIKAoICAQDk4aZM57RyIQt5osvXJHm9DtWC0/3unAcH0qlsTnXIyjVX

# 9gF/bErg4r25PhdgM/9cT8dm95VTcVrifkpa/rg2Z4VGIwy1jRPPdzLAEBjoYH1q

# UoNEt6aORmsHFPPFdvWGUNzBRMhxXFExN6AKOG6N7dcP2CZTfDlhAnrEqv1yaa8d

# q6z2Nr41JmTamDu6GnszrYBbfowQHJ1S/rboYiXcag/PXfT+jlPP1uyFVk3v3byN

# pOORj7I5LFGc6XBpDco2LXCOMcg1KL3jtIckw+DJj361VI/c+gVVmG1oO5pGve2k

# rnopN6zL64NF50ZuyjLVwIYwXE8s4mKyzbnijYjklqwBSru+cakXW2dg3viSkR4d

# Pf0gz3N9QZpGdc3EXzTdEonW/aUgfX782Z5F37ZyL9t9X4C626p+Nuw2TPYrbqgS

# Uei/BQOj0XOmTTd0lBw0gg/wEPK3Rxjtp+iZfD9M269ewvPV2HM9Q07BMzlMjgK8

# QmguEOqEUUbi0b1qGFphAXPKZ6Je1yh2AuIzGHLXpyDwwvoSCtdjbwzJNmSLW6Cm

# gyFdXzB0kZSU2LlQ+QuJYfM2BjUYhEfb3BvR/bLUHMVr9lxSUV0S2yW6r1AFemzF

# ER1y7435UsSFF5PAPBXbGjfHCBUYP3irRbb1Hode2o+eFnJpxq57t7c+auIurQID

# AQABo4IB3TCCAdkwEgYJKwYBBAGCNxUBBAUCAwEAATAjBgkrBgEEAYI3FQIEFgQU

# KqdS/mTEmr6CkTxGNSnPEP8vBO4wHQYDVR0OBBYEFJ+nFV0AXmJdg/Tl0mWnG1M1

# GelyMFwGA1UdIARVMFMwUQYMKwYBBAGCN0yDfQEBMEEwPwYIKwYBBQUHAgEWM2h0

# dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvRG9jcy9SZXBvc2l0b3J5Lmh0

# bTATBgNVHSUEDDAKBggrBgEFBQcDCDAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMA

# QTALBgNVHQ8EBAMCAYYwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBTV9lbL

# j+iiXGJo0T2UkFvXzpoYxDBWBgNVHR8ETzBNMEugSaBHhkVodHRwOi8vY3JsLm1p

# Y3Jvc29mdC5jb20vcGtpL2NybC9wcm9kdWN0cy9NaWNSb29DZXJBdXRfMjAxMC0w

# Ni0yMy5jcmwwWgYIKwYBBQUHAQEETjBMMEoGCCsGAQUFBzAChj5odHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20vcGtpL2NlcnRzL01pY1Jvb0NlckF1dF8yMDEwLTA2LTIz

# LmNydDANBgkqhkiG9w0BAQsFAAOCAgEAnVV9/Cqt4SwfZwExJFvhnnJL/Klv6lwU

# tj5OR2R4sQaTlz0xM7U518JxNj/aZGx80HU5bbsPMeTCj/ts0aGUGCLu6WZnOlNN

# 3Zi6th542DYunKmCVgADsAW+iehp4LoJ7nvfam++Kctu2D9IdQHZGN5tggz1bSNU

# 5HhTdSRXud2f8449xvNo32X2pFaq95W2KFUn0CS9QKC/GbYSEhFdPSfgQJY4rPf5

# KYnDvBewVIVCs/wMnosZiefwC2qBwoEZQhlSdYo2wh3DYXMuLGt7bj8sCXgU6ZGy

# qVvfSaN0DLzskYDSPeZKPmY7T7uG+jIa2Zb0j/aRAfbOxnT99kxybxCrdTDFNLB6

# 2FD+CljdQDzHVG2dY3RILLFORy3BFARxv2T5JL5zbcqOCb2zAVdJVGTZc9d/HltE

# AY5aGZFrDZ+kKNxnGSgkujhLmm77IVRrakURR6nxt67I6IleT53S0Ex2tVdUCbFp

# AUR+fKFhbHP+CrvsQWY9af3LwUFJfn6Tvsv4O+S3Fb+0zj6lMVGEvL8CwYKiexcd

# FYmNcP7ntdAoGokLjzbaukz5m/8K6TT4JDVnK+ANuOaMmdbhIurwJ0I9JZTmdHRb

# atGePu1+oDEzfbzL6Xu/OHBE0ZDxyKs6ijoIYn/ZcGNTTY3ugm2lBRDBcQZqELQd

# VTNYs6FwZvKhggNQMIICOAIBATCB+aGB0aSBzjCByzELMAkGA1UEBhMCVVMxEzAR

# BgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1p

# Y3Jvc29mdCBDb3Jwb3JhdGlvbjElMCMGA1UECxMcTWljcm9zb2Z0IEFtZXJpY2Eg

# T3BlcmF0aW9uczEnMCUGA1UECxMeblNoaWVsZCBUU1MgRVNOOjdGMDAtMDVFMC1E

# OTQ3MSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBTZXJ2aWNloiMKAQEw

# BwYFKw4DAhoDFQCD/QNkKDIW4VIF7j3oi2qbrR0a/6CBgzCBgKR+MHwxCzAJBgNV

# BAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4w

# HAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29m

# dCBUaW1lLVN0YW1wIFBDQSAyMDEwMA0GCSqGSIb3DQEBCwUAAgUA7gxxhzAiGA8y

# MDI2MDcyMzEwNTUwM1oYDzIwMjYwNzI0MTA1NTAzWjB3MD0GCisGAQQBhFkKBAEx

# LzAtMAoCBQDuDHGHAgEAMAoCAQACAhLCAgH/MAcCAQACAhLpMAoCBQDuDcMHAgEA

# MDYGCisGAQQBhFkKBAIxKDAmMAwGCisGAQQBhFkKAwKgCjAIAgEAAgMHoSChCjAI

# AgEAAgMBhqAwDQYJKoZIhvcNAQELBQADggEBABSsFAhmEB9+szY1vgmDaldieVKb

# GWKS5Yn5Q96PQ6ht+HIeB25W6lEt8mwTOEGKeFAPWi4k4MK3SqskiKqfNFI20/R4

# OqX2RQNyzXyJJS49DQcj6hqsYWjy4CI/TqEZyW+YlfynidvJ3zcLkAJTSnr1Mp6o

# 5vHgyEa7bbqrJrqhMsFt4AUTA+qd3+OSb0xPU2VC9Bqs8sZxCUuAwTib+VwM9kSe

# Z/ixQA/x6T5pkXJ3nVU5A9SA7mwp0MNy7FM4D9oSvriMaSxOqH1Lz1lk/X0z2QXP

# PzNbinqthZsBLE9JvXdZ7TDip4u2+lF1wDLONbQjXIMi84nVJE7qL4Qfz1MxggQN

# MIIECQIBATCBkzB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQ

# MA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9u

# MSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMAITMwAAAh6j

# rKRuOW98SQABAAACHjANBglghkgBZQMEAgEFAKCCAUowGgYJKoZIhvcNAQkDMQ0G

# CyqGSIb3DQEJEAEEMC8GCSqGSIb3DQEJBDEiBCDB1ObYQBqyfYiRPiWA1w3kdYsQ

# +QD/vBrpD2IMmb0QgjCB+gYLKoZIhvcNAQkQAi8xgeowgecwgeQwgb0EIC+BXWrz

# 9geMgM8Bvn8bqxHjhHXJ29EBizITIw0B9vOCMIGYMIGApH4wfDELMAkGA1UEBhMC

# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV

# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp

# bWUtU3RhbXAgUENBIDIwMTACEzMAAAIeo6ykbjlvfEkAAQAAAh4wIgQghDtYu13+

# V+kHsZJbbK4pm0jw9RVtOLrfRkwGEV222howDQYJKoZIhvcNAQELBQAEggIAZ9UV

# D6m2JZJwd1oZtCWkAGwO8oH8VkiaZnPcvuOlW3XQ/sCryC58EndEAl6lJENsST+Z

# O7xdHM9RQvu5tKVDwNxDG7YagpXcoVwoMHYjQWwdtqVzEEuKLNnmxnrchcWjMZsd

# Vpxdpxh2Ezm3LvU5DogZgz4U21VtmGBIs2dunme9jIkT+XplM+JuhE0BX8UhWAep

# CNaqTVgwhcZcWGD7VzMtviyMxNlU4Bs5/lqbG2VezPd3WL/JN4CsfNzG+lFEYX6W

# RobZFaJDgd6m1hCKguhuxqO/m+7hJXjHFcH7EmhcXw7A8C+uPVuEPE4b2VWnpmMQ

# Y3aXzpbJz5QE+UhkBTNMmq3nezd4Yfl1lu2QcfU2Es8/zSDu7b1i33Yfm1iljonU

# ZaL9sP4Glky6PaJQTUfwC6L7gU3rdIhykVL42apEWltb5Sn4bHxfBEYi1WwyB4bS

# QJDO3Is5sxTprZSHrEY/x4hiNbMMya5ANWb1XLpujwnJM2z2p84h2uZsvj825rLT

# vfAzWbJAgpt8G/L26LNpyN4q3RYKBJd30YGhqN0Md2912FuKQwL/vJEpumnzYzRP

# mM+HMHyB/od4aQZ88R3PiI+79ZSun7SqW0rO/BQiDz3s46infRpOx+mjkMwb2DIN

# hIsziooUv87wwU9ceHw0xmd+TnTU1w7n5iqepQ4=

# SIG # End signature block