Bricklead.BCDev.Tools

0.1.9471.35520

Saas/Update-BCDevEnvironment.ps1

                                Function Update-BCDevEnvironment {

    param (

        [Parameter(Mandatory = $true)]  [Hashtable]$bcAuthContext,

        [Parameter(Mandatory = $false)] $EnvironmentName,

        [Parameter(Mandatory = $false)] $ExtensionFilter = 'Primus',

        [Parameter(Mandatory = $false)] [switch]$Force

    )

    if ($null -eq $EnvironmentName) {

        Write-Host "Getting environments" -ForegroundColor Green

        $Environments = Get-BcEnvironments -bcAuthContext $bcAuthContext

        $EnvironmentList = $(foreach ($Environment in ($Environments | Where-Object { $_.Status -eq 'Active' })) { $Environment.Name }) | Sort-Object

        $EnvironmentName = Get-ToolFromList -Message "Please select the environment to update" -Values $EnvironmentList

    }

    if ($null -eq $EnvironmentName) {

        Write-Host "No environment selected." -ForegroundColor Red

        Return $false

    }

    # Get environment details

    $Environment = Get-BcEnvironments -bcAuthContext $bcAuthContext -environment $EnvironmentName

    # Define Nuget Source

    if ($Environment.type -eq 'Production' ) { $NugetSource = 'master' } else { $NugetSource = 'release-candidate' }

    if ($ExtensionFilter -eq 'Primus') { $NugetRepository = 'primus-soft' } else { $NugetRepository = 'bricklead' }

    $bcContainerHelperConfig.TrustedNuGetFeeds = @(

        [PSCustomObject]@{ "url"      = "$(Get-BCDevRef -type nuget -DevOpsSignature $NugetRepository -SourceApp $SourceApp)";

                            "token"    = "$(Get-BCDevRef -type nugetToken -DevOpsSignature $NugetRepository -SourceApp $AppSource)";

                            "patterns" = @("*")

        }

    )

    # Get extensions installed on the environment

    Write-Host

    Write-Host "Getting extensions on $($Environment.name) ($($Environment.type))" -ForegroundColor Green

    $InstalledExtensions = Get-BcEnvironmentInstalledExtensions -bcAuthContext $bcAuthContext -environment $Environment.name

    $InstalledExtensions = $InstalledExtensions | Where-Object { (($_.displayName -like "*$ExtensionFilter*") -or ($_.publisher -like "*$ExtensionFilter*")) -and ($_.isInstalled) -and ($_.publishedAs -like '*PTE*') }

    # Getting last version from Nuget and add details

    Write-Host

    Write-Host "Getting last version from $NugetSource Nuget" -ForegroundColor Green

    $InstalledExtensions = $InstalledExtensions | Select-Object *, @{Name = "currentVersion"; Expression = { [version]0.0.0.0 } }

    $InstalledExtensions = $InstalledExtensions | Select-Object *, @{Name = "latestVersion"; Expression = { [version]0.0.0.0 } }

    $InstalledExtensions = $InstalledExtensions | Select-Object *, @{Name = "latestVersionAppPath"; Expression = { '' } }

    $InstalledExtensions = $InstalledExtensions | Select-Object *, @{Name = "levelDependency"; Expression = { 0 } }

    $InstalledExtensions = $InstalledExtensions | Select-Object *, @{Name = "Comment"; Expression = { '' } }

    $WorkDirectory = Join-Path ([System.IO.Path]::GetTempPath()) "$([GUID]::NewGuid().ToString())"

    New-item $WorkDirectory -ItemType Directory -Force | Out-Null

    foreach ($Extension in $InstalledExtensions) {

        Write-Host $Extension.displayName -ForegroundColor Cyan

        $Extension.currentVersion = [Version] "$($Extension.versionMajor).$($Extension.versionMinor).$($Extension.versionBuild).$($Extension.versionRevision)"

        #Download Nuget version

        Download-BcNuGetPackageToFolder -packageName $Extension.id -downloadDependencies allButMicrosoft -folder $WorkDirectory | Out-Null

        $FileApp = Get-Item "$WorkDirectory\*$($Extension.Displayname)*.app"

        $Extension.latestVersion = [Version] $FileApp.Name.split('_')[2].TrimEnd('.app')

        $Extension.latestVersionAppPath = $FileApp.fullName

        $Extension.Comment = 'Up to Date'

        if ($Extension.currentVersion -lt $Extension.latestVersion) { $Extension.Comment = 'Action requiered' }

        if ($Extension.currentVersion -gt $Extension.latestVersion) { $Extension.Comment = 'Versions not consistent' }

    }

    # Delete old properties

    $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty versionMajor

    $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty versionMinor

    $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty versionBuild

    $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty versionRevision

    # Sorting extensions by dependencies

    $AppFiles = @()

    foreach ($Files in (Get-Item "$WorkDirectory\*.app")) {

        $AppFiles += $Files.FullName

    }

    Write-Host

    Write-Host "Sorting $($AppFiles.Length) extensions..." -ForegroundColor Green

    $AppFiles = Sort-AppFilesByDependencies -appFiles $AppFiles

    $i = -1

    $AppFiles | ForEach-Object { 

        $i += 1

        $Index = [Array]::IndexOf($InstalledExtensions.displayName, $_.split('\')[-1].Split('_')[1])

        $InstalledExtensions[$Index].levelDependency = $i

    }

    $InstalledExtensions = $InstalledExtensions | Sort-Object -Property levelDependency

    # Show result

    Write-Host

    Write-Host "Summary of $ExtensionFilter extensions deployed on $($Environment.name) ($($Environment.type)) comparing $NugetSource branch." -ForegroundColor Green -NoNewline

    $InstalledExtensions | Format-Table  -Property levelDependency, DisplayName, publishedAs, currentVersion, latestVersion, Comment | Out-Host

    # Check if update requiered

    if ([Array]::IndexOf($InstalledExtensions.Comment, 'Versions not consistent') -ne -1) {

        Write-Warning "Existing versions inconsistency."

    }

    if ([Array]::IndexOf($InstalledExtensions.Comment, 'Action requiered') -eq -1) {

        Write-host "No update to process." -ForegroundColor Green

        Remove-Item $WorkDirectory -Recurse -Force | Out-Null

        $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty '@odata.etag'

        $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty packageId

        $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty latestVersionAppPath

        Return $InstalledExtensions

    }

    else {

        Write-host "Update requiered." -ForegroundColor Red

        Write-host

    }

    if (! $Force.IsPresent) {

        if (! (Confirm-ToolYesOrNo -message "Do you want to proceed the update?")) {

            Write-host "Update cancel by user." -ForegroundColor Red

            Remove-Item $WorkDirectory -Recurse -Force | Out-Null

            Return $null

        }

    }

    # Update extensions

    Measure-Command { foreach ($Extension in ($InstalledExtensions | Where-Object { $_.currentVersion -lt $_.latestVersion })) {

            Write-Host

            Write-Host "Updating $($Extension.displayName)  $($Extension.currentVersion) --> $($Extension.latestVersion)" -ForegroundColor Green

            try {

                Publish-PerTenantExtensionApps -bcAuthContext $bcAuthContext `

                    -Environment $Environment.name `

                    -appFiles $Extension.latestVersionAppPath `

                    -schemaSyncMode Force `

                    -hideInstalledExtensionsOutput

                $Extension.currentVersion = $Extension.latestVersion

                $Extension.Comment = 'Up to Date'

            }

            catch {

                Write-Host "Error during update of $($Extension.displayName) $($_.Exception.Message)" -ForegroundColor Red

                $Extension.Comment = 'Error during update'

            }

        }

    } | ForEach-Object { Write-Host "Update tooks $($_.ToString('hh\:mm\:ss'))" -ForegroundColor Green }

    # Remove work directory

    Remove-Item $WorkDirectory -Recurse -Force | Out-Null

    $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty '@odata.etag'

    $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty packageId

    $InstalledExtensions = $InstalledExtensions | Select-Object * -ExcludeProperty latestVersionAppPath

    Return $InstalledExtensions

}

Export-ModuleMember -Function Update-BCDevEnvironment

# SIG # Begin signature block

# MIIn2wYJKoZIhvcNAQcCoIInzDCCJ8gCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCA0yuNGxnoConhN

# nyIG3ZqLSwRJiloKI0O1TQYDxPTCCqCCIOwwggWNMIIEdaADAgECAhAOmxiO+dAt

# 5+/bUOIIQBhaMA0GCSqGSIb3DQEBDAUAMGUxCzAJBgNVBAYTAlVTMRUwEwYDVQQK

# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAiBgNV

# BAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0yMjA4MDEwMDAwMDBa

# Fw0zMTExMDkyMzU5NTlaMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2Vy

# dCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNVBAMTGERpZ2lD

# ZXJ0IFRydXN0ZWQgUm9vdCBHNDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoC

# ggIBAL/mkHNo3rvkXUo8MCIwaTPswqclLskhPfKK2FnC4SmnPVirdprNrnsbhA3E

# MB/zG6Q4FutWxpdtHauyefLKEdLkX9YFPFIPUh/GnhWlfr6fqVcWWVVyr2iTcMKy

# unWZanMylNEQRBAu34LzB4TmdDttceItDBvuINXJIB1jKS3O7F5OyJP4IWGbNOsF

# xl7sWxq868nPzaw0QF+xembud8hIqGZXV59UWI4MK7dPpzDZVu7Ke13jrclPXuU1

# 5zHL2pNe3I6PgNq2kZhAkHnDeMe2scS1ahg4AxCN2NQ3pC4FfYj1gj4QkXCrVYJB

# MtfbBHMqbpEBfCFM1LyuGwN1XXhm2ToxRJozQL8I11pJpMLmqaBn3aQnvKFPObUR

# WBf3JFxGj2T3wWmIdph2PVldQnaHiZdpekjw4KISG2aadMreSx7nDmOu5tTvkpI6

# nj3cAORFJYm2mkQZK37AlLTSYW3rM9nF30sEAMx9HJXDj/chsrIRt7t/8tWMcCxB

# YKqxYxhElRp2Yn72gLD76GSmM9GJB+G9t+ZDpBi4pncB4Q+UDCEdslQpJYls5Q5S

# UUd0viastkF13nqsX40/ybzTQRESW+UQUOsxxcpyFiIJ33xMdT9j7CFfxCBRa2+x

# q4aLT8LWRV+dIPyhHsXAj6KxfgommfXkaS+YHS312amyHeUbAgMBAAGjggE6MIIB

# NjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBTs1+OC0nFdZEzfLmc/57qYrhwP

# TzAfBgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzAOBgNVHQ8BAf8EBAMC

# AYYweQYIKwYBBQUHAQEEbTBrMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdp

# Y2VydC5jb20wQwYIKwYBBQUHMAKGN2h0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNv

# bS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcnQwRQYDVR0fBD4wPDA6oDigNoY0

# aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENB

# LmNybDARBgNVHSAECjAIMAYGBFUdIAAwDQYJKoZIhvcNAQEMBQADggEBAHCgv0Nc

# Vec4X6CjdBs9thbX979XB72arKGHLOyFXqkauyL4hxppVCLtpIh3bb0aFPQTSnov

# Lbc47/T/gLn4offyct4kvFIDyE7QKt76LVbP+fT3rDB6mouyXtTP0UNEm0Mh65Zy

# oUi0mcudT6cGAxN3J0TU53/oWajwvy8LpunyNDzs9wPHh6jSTEAZNUZqaVSwuKFW

# juyk1T3osdz9HNj0d1pcVIxv76FQPfx2CWiEn2/K2yCNNWAcAgPLILCsWKAOQGPF

# mCLBsln1VWvPJ6tsds5vIy30fnFqI2si/xK4VC0nftg62fC2h5b9W9FcrBjDTZ9z

# twGpn1eqXijiuZQwgga0MIIEnKADAgECAhANx6xXBf8hmS5AQyIMOkmGMA0GCSqG

# SIb3DQEBCwUAMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMx

# GTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNVBAMTGERpZ2lDZXJ0IFRy

# dXN0ZWQgUm9vdCBHNDAeFw0yNTA1MDcwMDAwMDBaFw0zODAxMTQyMzU5NTlaMGkx

# CzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjFBMD8GA1UEAxM4

# RGlnaUNlcnQgVHJ1c3RlZCBHNCBUaW1lU3RhbXBpbmcgUlNBNDA5NiBTSEEyNTYg

# MjAyNSBDQTEwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC0eDHTCphB

# cr48RsAcrHXbo0ZodLRRF51NrY0NlLWZloMsVO1DahGPNRcybEKq+RuwOnPhof6p

# vF4uGjwjqNjfEvUi6wuim5bap+0lgloM2zX4kftn5B1IpYzTqpyFQ/4Bt0mAxAHe

# HYNnQxqXmRinvuNgxVBdJkf77S2uPoCj7GH8BLuxBG5AvftBdsOECS1UkxBvMgEd

# gkFiDNYiOTx4OtiFcMSkqTtF2hfQz3zQSku2Ws3IfDReb6e3mmdglTcaarps0wjU

# jsZvkgFkriK9tUKJm/s80FiocSk1VYLZlDwFt+cVFBURJg6zMUjZa/zbCclF83bR

# VFLeGkuAhHiGPMvSGmhgaTzVyhYn4p0+8y9oHRaQT/aofEnS5xLrfxnGpTXiUOeS

# LsJygoLPp66bkDX1ZlAeSpQl92QOMeRxykvq6gbylsXQskBBBnGy3tW/AMOMCZIV

# NSaz7BX8VtYGqLt9MmeOreGPRdtBx3yGOP+rx3rKWDEJlIqLXvJWnY0v5ydPpOjL

# 6s36czwzsucuoKs7Yk/ehb//Wx+5kMqIMRvUBDx6z1ev+7psNOdgJMoiwOrUG2Zd

# SoQbU2rMkpLiQ6bGRinZbI4OLu9BMIFm1UUl9VnePs6BaaeEWvjJSjNm2qA+sdFU

# eEY0qVjPKOWug/G6X5uAiynM7Bu2ayBjUwIDAQABo4IBXTCCAVkwEgYDVR0TAQH/

# BAgwBgEB/wIBADAdBgNVHQ4EFgQU729TSunkBnx6yuKQVvYv1Ensy04wHwYDVR0j

# BBgwFoAU7NfjgtJxXWRM3y5nP+e6mK4cD08wDgYDVR0PAQH/BAQDAgGGMBMGA1Ud

# JQQMMAoGCCsGAQUFBwMIMHcGCCsGAQUFBwEBBGswaTAkBggrBgEFBQcwAYYYaHR0

# cDovL29jc3AuZGlnaWNlcnQuY29tMEEGCCsGAQUFBzAChjVodHRwOi8vY2FjZXJ0

# cy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVzdGVkUm9vdEc0LmNydDBDBgNVHR8E

# PDA6MDigNqA0hjJodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVz

# dGVkUm9vdEc0LmNybDAgBgNVHSAEGTAXMAgGBmeBDAEEAjALBglghkgBhv1sBwEw

# DQYJKoZIhvcNAQELBQADggIBABfO+xaAHP4HPRF2cTC9vgvItTSmf83Qh8WIGjB/

# T8ObXAZz8OjuhUxjaaFdleMM0lBryPTQM2qEJPe36zwbSI/mS83afsl3YTj+IQhQ

# E7jU/kXjjytJgnn0hvrV6hqWGd3rLAUt6vJy9lMDPjTLxLgXf9r5nWMQwr8Myb9r

# EVKChHyfpzee5kH0F8HABBgr0UdqirZ7bowe9Vj2AIMD8liyrukZ2iA/wdG2th9y

# 1IsA0QF8dTXqvcnTmpfeQh35k5zOCPmSNq1UH410ANVko43+Cdmu4y81hjajV/gx

# dEkMx1NKU4uHQcKfZxAvBAKqMVuqte69M9J6A47OvgRaPs+2ykgcGV00TYr2Lr3t

# y9qIijanrUR3anzEwlvzZiiyfTPjLbnFRsjsYg39OlV8cipDoq7+qNNjqFzeGxcy

# tL5TTLL4ZaoBdqbhOhZ3ZRDUphPvSRmMThi0vw9vODRzW6AxnJll38F0cuJG7uEB

# YTptMSbhdhGQDpOXgpIUsWTjd6xpR6oaQf/DJbg3s6KCLPAlZ66RzIg9sC+NJpud

# /v4+7RWsWCiKi9EOLLHfMR2ZyJ/+xhCx9yHbxtl5TPau1j/1MIDpMPx0LckTetiS

# uEtQvLsNz3Qbp7wGWqbIiOWCnb5WqxL3/BAPvIXKUjPSxyZsq8WhbaM2tszWkPZP

# ubdcMIIGvzCCBKegAwIBAgIRAIFOQhehKX/tWszUF/iRrXUwDQYJKoZIhvcNAQEL

# BQAwUzELMAkGA1UEBhMCQkUxGTAXBgNVBAoTEEdsb2JhbFNpZ24gbnYtc2ExKTAn

# BgNVBAMTIEdsb2JhbFNpZ24gQ29kZSBTaWduaW5nIFJvb3QgUjQ1MB4XDTI0MDYx

# OTAzMjUxMVoXDTM4MDcyODAwMDAwMFowWTELMAkGA1UEBhMCQkUxGTAXBgNVBAoT

# EEdsb2JhbFNpZ24gbnYtc2ExLzAtBgNVBAMTJkdsb2JhbFNpZ24gR0NDIFI0NSBD

# b2RlU2lnbmluZyBDQSAyMDIwMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKC

# AgEA1kJN+eNPxiP0bB2BpjD3SD3P0OWN5SAilgdENV0Gzw8dcGDmJlT6UyNgAqhf

# AgL3jsluPal4Bb2O9U8ZJJl8zxEWmx97a9Kje2hld6vYsSw/03IGMlxbrFBnLCVN

# VgY2/MFiTH19hhaVml1UulDQsH+iRBnp1m5sPhPCnxHUXzRbUWgxYwr4W9Deullf

# Ma+JaDhAPgjoU2dOY7Yhju/djYVBVZ4cvDfclaDEcacfG6VJbgogWX6Jo1gVlwAl

# ad/ewmpQZU5T+2uhnxgeig5fVF694FvP8gwE0t4IoRAm97Lzei7CjpbBP86l2vRZ

# KIw3ZaExlguOpHZ3FUmEZoIl50MKd1KxmVFC/6Gy3ZzS3BjZwYapQB1Bl2KGvKj/

# osdjFwb9Zno2lAEgiXgfkPR7qVJOak9UBiqAr57HUEL6ZQrjAfSxbqwOqOOBGag4

# yJ4DKIakdKdHlX5yWip7FWocxGnmsL5AGZnL0n1VTiKcEOChW8OzLnqLxN7xSx+M

# KHkwRX9sE7Y9LP8tSooq7CgPLcrUnJiKSm1aNiwv37rL4kFKCHcYiK01YZQS86Ry

# 6+42nqdRJ5E896IazPyH5ZfhUYdp6SLMg8C3D0VsB+FDT9SMSs7PY7G1pBB6+Q0M

# KLBrNP4haCdv7Pj6JoRbdULNiSZ5WZ1rq2NxYpAlDQgg8f8CAwEAAaOCAYYwggGC

# MA4GA1UdDwEB/wQEAwIBhjATBgNVHSUEDDAKBggrBgEFBQcDAzASBgNVHRMBAf8E

# CDAGAQH/AgEAMB0GA1UdDgQWBBTas43AJJCja3fTDKBZ3SFnZHYLeDAfBgNVHSME

# GDAWgBQfAL9GgAr8eDm3pbRD2VZQu86WOzCBkwYIKwYBBQUHAQEEgYYwgYMwOQYI

# KwYBBQUHMAGGLWh0dHA6Ly9vY3NwLmdsb2JhbHNpZ24uY29tL2NvZGVzaWduaW5n

# cm9vdHI0NTBGBggrBgEFBQcwAoY6aHR0cDovL3NlY3VyZS5nbG9iYWxzaWduLmNv

# bS9jYWNlcnQvY29kZXNpZ25pbmdyb290cjQ1LmNydDBBBgNVHR8EOjA4MDagNKAy

# hjBodHRwOi8vY3JsLmdsb2JhbHNpZ24uY29tL2NvZGVzaWduaW5ncm9vdHI0NS5j

# cmwwLgYDVR0gBCcwJTAIBgZngQwBBAEwCwYJKwYBBAGgMgEyMAwGCisGAQQBoDIK

# BAIwDQYJKoZIhvcNAQELBQADggIBADIQ5LwXpYMQQJ3Tqf0nz0VyqcUfSzNZbywy

# MXlxhNY2Z9WrdPzU8gY6brXWy/FCg5a9fd6VLBrtauNBHKbIiTHCWWyJvCojA1lQ

# R0n9b1MOKijMSFTv8yMYW5I2TryjY9TD+wAPgNEgwsrllrrwmluqpCV6Gdv623tT

# T/m2o9lj1XVfAaUo27YYKRRleZzbtOuImBRTUGAxDGazUeNuySkmZPAU0XN4xISN

# PhSlklmreUFG6jTPgXZGOpF4GXO+/gb118GEOaBwTAo1AF7YKjAkHzJ3tuF837NG

# QeH6bY3j4wufL0DZpToNZMm+jNEayWUgOuIA+k56ITdBcJmdUB+Ze3WQdHNNRaVO

# WH/ddmqQWIlmk2Sj/lT3Tarr5SDuddeIsh0MPLyhkqBW5Ef8Zw/qeCnfj6PH2eMx

# eKcLKZRrHCddISeH4qPvyECQLlwXKCXTAUQXq4DafJSoWyP8IJ6bkaGQ/7MN5XJE

# LEcV89SRcib58gXjAWf3abXeBbb+KJCMf6EpO7cs2mQiaZbE9NNXDSqFxrtoaKyL

# 8VJLZG6quLfsTRQc+qgUOM7sJevkYt01+bh7B10bQ2cCCGs9vyUjg4GWcwfu/lha

# PDfaoNtf0pw6RpKcxCYcCTDaJeQOHZBz1B6HTmmEgZHNZX7nNfqDgGrTNB1Gp3gI

# pngyJWZ6MIIG6zCCBNOgAwIBAgIMNY0DQ6d8EhhRyrkRMA0GCSqGSIb3DQEBCwUA

# MFkxCzAJBgNVBAYTAkJFMRkwFwYDVQQKExBHbG9iYWxTaWduIG52LXNhMS8wLQYD

# VQQDEyZHbG9iYWxTaWduIEdDQyBSNDUgQ29kZVNpZ25pbmcgQ0EgMjAyMDAeFw0y

# NTEwMjIxMDQyMjlaFw0yODExMjYwODE1NTlaMFkxCzAJBgNVBAYTAkZSMREwDwYD

# VQQIEwhNb3JiaWhhbjEPMA0GA1UEBxMGVmFubmVzMRIwEAYDVQQKEwlCUklDS0xF

# QUQxEjAQBgNVBAMTCUJSSUNLTEVBRDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCC

# AgoCggIBANH89CNXVaQCYu+kwBql0qfG+mWCRiSqIDm3iUF0uI/stq3PhOE8raxs

# xH48emVu5EYVNAQ4UqjA7hCNw+qVChf0PQdJaHbyXNDroEihVT73VwMfL+8FcxjW

# 6sXDmtp4NJJtQHUD3CQpIz74FE/2MydGQ5ZyM+IzXZdqvCmSeoMI5PWnhJHUfHTM

# rI4t4xOwacRCP1sl6FtIZ0vT/hl7BO3lFonKuKb5RL+0uxAoKnjLxbisNK5uRqN4

# A6Gg5swExkG1wqeZBgw2Ay+C4g4J/m21YO7FWkfJposKvwnS+Im+qLljm3wwnu1G

# Bxo9i8bODiDQaG+xfda0huvffYGeSKm4t1y0Cgoy1PkxwxATGEQAvDERT0K1JmVn

# VQO4SaZ0nOR/AFydlCvzsHzWN5KfX3pn4S3+OyVEHyjS7u2FYLgeuw9Vkj3IimWn

# fp7CpZPO9Ild6DkeNcC/fABHHxJ5hSnt6c2D1ilpnAaTdUwnlEqydxQilOCQCY5V

# 54xF+5rV9M6bSnwVMqRUI24Dys8Q2brf+LMoqOkF2qDLTfjDaHEAc2fNMVwtEjyC

# oHninq8aEOwSjAdNYoM4N0e+FfBvhWDGG7eJ/BYap6i5m/+kX2uRGG/fDm16RP4A

# CO76ZrQWoAYuYSfBe31thpSQirSljx+KeyIw01PwZDBJtOA07G3tAgMBAAGjggGx

# MIIBrTAOBgNVHQ8BAf8EBAMCB4AwgZsGCCsGAQUFBwEBBIGOMIGLMEoGCCsGAQUF

# BzAChj5odHRwOi8vc2VjdXJlLmdsb2JhbHNpZ24uY29tL2NhY2VydC9nc2djY3I0

# NWNvZGVzaWduY2EyMDIwLmNydDA9BggrBgEFBQcwAYYxaHR0cDovL29jc3AuZ2xv

# YmFsc2lnbi5jb20vZ3NnY2NyNDVjb2Rlc2lnbmNhMjAyMDBWBgNVHSAETzBNMEEG

# CSsGAQQBoDIBMjA0MDIGCCsGAQUFBwIBFiZodHRwczovL3d3dy5nbG9iYWxzaWdu

# LmNvbS9yZXBvc2l0b3J5LzAIBgZngQwBBAEwCQYDVR0TBAIwADBFBgNVHR8EPjA8

# MDqgOKA2hjRodHRwOi8vY3JsLmdsb2JhbHNpZ24uY29tL2dzZ2NjcjQ1Y29kZXNp

# Z25jYTIwMjAuY3JsMBMGA1UdJQQMMAoGCCsGAQUFBwMDMB8GA1UdIwQYMBaAFNqz

# jcAkkKNrd9MMoFndIWdkdgt4MB0GA1UdDgQWBBScz5MAsOazFIMc9PQAOwyeYtJX

# XTANBgkqhkiG9w0BAQsFAAOCAgEAjxOP7JLAHE5dd+OgTzQY/k50WPn9XxxyIzMY

# 1OHJh7qC4CGHk+3N7f/Vp6hwFgNEjgK/EcAbL8BZILFyaRCskMT5yEPh4m+IF8/O

# 1WxUUrItXs7R0VRkh2L4fGaEKgH33W1C5Y9WgLn3Su7zXCyHEuYOFMsEReKheVVc

# sbSle4330aoKp6oiaifjdhr91uMu3Ta1FlG9prlrzVoz/d8EHJu3LAmZzLv53JQ0

# SrjPQrb53KXEOST7opxyCIDZZ090Ji3oThd7TNy+SID7BDkh+ea+HZJTjY/3FuLu

# yFhRxWtIJ6PCMx6a4UDgw2qGcKTlXb71hD7QJJspwWEYftG1hRjf0zMiJk8F4EYb

# 6Xn36uItedM6ETJ4YVisjt79HeYowJQkm/OajZyUrTYs8e9EWkKjO58cSrpFKMgi

# yess0dcvYEz0TZdWTKzhItNtV52r+qtkL7StsLV8JVx1pG/hiHghICrGfaNlYmPk

# a6aDJn/vwJfDvyAgCYCOkIGeFUTbHcBrurdbWR+Ycv4kzeEGsVtRwCCrj8A/Kep5

# T3vTzM3rvXzDqoO5GkO4sfO7fUbyru2EuxNpCHSEPMYARxVKsKF1LSgIJOvoFCC/

# O5j7n9IvnxIPUZohrNBbd9C3jWcm42veAe/zTAKr+Jm2mxhUyi+cJwA3Nb9YJLfI

# hc+McqowggbtMIIE1aADAgECAhAKgO8YS43xBYLRxHanlXRoMA0GCSqGSIb3DQEB

# CwUAMGkxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjFBMD8G

# A1UEAxM4RGlnaUNlcnQgVHJ1c3RlZCBHNCBUaW1lU3RhbXBpbmcgUlNBNDA5NiBT

# SEEyNTYgMjAyNSBDQTEwHhcNMjUwNjA0MDAwMDAwWhcNMzYwOTAzMjM1OTU5WjBj

# MQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xOzA5BgNVBAMT

# MkRpZ2lDZXJ0IFNIQTI1NiBSU0E0MDk2IFRpbWVzdGFtcCBSZXNwb25kZXIgMjAy

# NSAxMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA0EasLRLGntDqrmBW

# sytXum9R/4ZwCgHfyjfMGUIwYzKomd8U1nH7C8Dr0cVMF3BsfAFI54um8+dnxk36

# +jx0Tb+k+87H9WPxNyFPJIDZHhAqlUPt281mHrBbZHqRK71Em3/hCGC5KyyneqiZ

# 7syvFXJ9A72wzHpkBaMUNg7MOLxI6E9RaUueHTQKWXymOtRwJXcrcTTPPT2V1D/+

# cFllESviH8YjoPFvZSjKs3SKO1QNUdFd2adw44wDcKgH+JRJE5Qg0NP3yiSyi5Mx

# gU6cehGHr7zou1znOM8odbkqoK+lJ25LCHBSai25CFyD23DZgPfDrJJJK77epTwM

# P6eKA0kWa3osAe8fcpK40uhktzUd/Yk0xUvhDU6lvJukx7jphx40DQt82yepyekl

# 4i0r8OEps/FNO4ahfvAk12hE5FVs9HVVWcO5J4dVmVzix4A77p3awLbr89A90/nW

# GjXMGn7FQhmSlIUDy9Z2hSgctaepZTd0ILIUbWuhKuAeNIeWrzHKYueMJtItnj2Q

# +aTyLLKLM0MheP/9w6CtjuuVHJOVoIJ/DtpJRE7Ce7vMRHoRon4CWIvuiNN1Lk9Y

# +xZ66lazs2kKFSTnnkrT3pXWETTJkhd76CIDBbTRofOsNyEhzZtCGmnQigpFHti5

# 8CSmvEyJcAlDVcKacJ+A9/z7eacCAwEAAaOCAZUwggGRMAwGA1UdEwEB/wQCMAAw

# HQYDVR0OBBYEFOQ7/PIx7f391/ORcWMZUEPPYYzoMB8GA1UdIwQYMBaAFO9vU0rp

# 5AZ8esrikFb2L9RJ7MtOMA4GA1UdDwEB/wQEAwIHgDAWBgNVHSUBAf8EDDAKBggr

# BgEFBQcDCDCBlQYIKwYBBQUHAQEEgYgwgYUwJAYIKwYBBQUHMAGGGGh0dHA6Ly9v

# Y3NwLmRpZ2ljZXJ0LmNvbTBdBggrBgEFBQcwAoZRaHR0cDovL2NhY2VydHMuZGln

# aWNlcnQuY29tL0RpZ2lDZXJ0VHJ1c3RlZEc0VGltZVN0YW1waW5nUlNBNDA5NlNI

# QTI1NjIwMjVDQTEuY3J0MF8GA1UdHwRYMFYwVKBSoFCGTmh0dHA6Ly9jcmwzLmRp

# Z2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRHNFRpbWVTdGFtcGluZ1JTQTQwOTZT

# SEEyNTYyMDI1Q0ExLmNybDAgBgNVHSAEGTAXMAgGBmeBDAEEAjALBglghkgBhv1s

# BwEwDQYJKoZIhvcNAQELBQADggIBAGUqrfEcJwS5rmBB7NEIRJ5jQHIh+OT2Ik/b

# NYulCrVvhREafBYF0RkP2AGr181o2YWPoSHz9iZEN/FPsLSTwVQWo2H62yGBvg7o

# uCODwrx6ULj6hYKqdT8wv2UV+Kbz/3ImZlJ7YXwBD9R0oU62PtgxOao872bOySCI

# LdBghQ/ZLcdC8cbUUO75ZSpbh1oipOhcUT8lD8QAGB9lctZTTOJM3pHfKBAEcxQF

# oHlt2s9sXoxFizTeHihsQyfFg5fxUFEp7W42fNBVN4ueLaceRf9Cq9ec1v5iQMWT

# FQa0xNqItH3CPFTG7aEQJmmrJTV3Qhtfparz+BW60OiMEgV5GWoBy4RVPRwqxv7M

# k0Sy4QHs7v9y69NBqycz0BZwhB9WOfOu/CIJnzkQTwtSSpGGhLdjnQ4eBpjtP+XB

# 3pQCtv4E5UCSDag6+iX8MmB10nfldPF9SVD7weCC3yXZi/uuhqdwkgVxuiMFzGVF

# wYbQsiGnoa9F5AaAyBjFBtXVLcKtapnMG3VH3EmAp/jsJ3FVF3+d1SVDTmjFjLbN

# FZUWMXuZyvgLfgyPehwJVxwC+UpX2MSey2ueIu9THFVkT+um1vshETaWyQo8gmBt

# o/m3acaP9QsuLj3FNwFlTxq25+T4QwX9xa6ILs84ZPvmpovq90K8eWyG2N01c4Ih

# SOxqt81nMYIGRTCCBkECAQEwaTBZMQswCQYDVQQGEwJCRTEZMBcGA1UEChMQR2xv

# YmFsU2lnbiBudi1zYTEvMC0GA1UEAxMmR2xvYmFsU2lnbiBHQ0MgUjQ1IENvZGVT

# aWduaW5nIENBIDIwMjACDDWNA0OnfBIYUcq5ETANBglghkgBZQMEAgEFAKCBhDAY

# BgorBgEEAYI3AgEMMQowCKACgAChAoAAMBkGCSqGSIb3DQEJAzEMBgorBgEEAYI3

# AgEEMBwGCisGAQQBgjcCAQsxDjAMBgorBgEEAYI3AgEVMC8GCSqGSIb3DQEJBDEi

# BCC2TB/vk6QIZUdpyQx0loYXdU00TvtCTWTd6/LNn6jEJjANBgkqhkiG9w0BAQEF

# AASCAgBkRFsQS1L1zk6MkF7hXaUm4gkUTzqldAWWnz2JXCblnihKayAdC7aWvRzn

# 8GXxfk24HpNqGt8nYFXYngG/7YiP8k6LLHDq/kRghKaNyFKw0vYq1kbdKbG7Agg+

# i7037e4qgHF6rXAaOuRrpNIyBFv6f7sVp2FBOi5jQdeyZN2L7Tb4l9etBKUk3yaz

# pdbNtNr7qcHTA55zNpIRmEbatP53EtLAVDs04bdAMo35e+l7Cd0oKwQBc7O18r5I

# 3WAD9IqrwVNUnNtDGN7l0Mn+NBVns0SYlSvhnhoQljYZ1LrYBP2WIcl+MCUkhLgy

# cTjoUXHfK0AVE72VOuuVNU6nfXeSG851RnK6+CpZrQBKrg1w8wtCTvnFqDDaTIam

# qAoGdlAIbHVtr8Lz7Y3Ew0eItKcm7dlVNaLBLoaUEviuQHJtd6zPKoaRN0e+mStA

# lPnUUBtshgfVLoo6etny82w8fsMdzTTAHsunfY/maOK6hWXBcDZV96SxdegiZ+de

# zZrVWzWrBXww+UDBn3UDMwsqqQqsycyYqD4yGAr85HtkMEn8r4YomApELicajnRR

# TXBgN9jI9pFFeCkePZe3uKXVhKOMQjb6U2VEFc4UO6aMlaogrGaYrhOPo9+0uOqy

# 9IM09Y1NOUBDM+uGYcib3JaBH/7F6EmLBybGYv340AmrSQL3gaGCAyYwggMiBgkq

# hkiG9w0BCQYxggMTMIIDDwIBATB9MGkxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5E

# aWdpQ2VydCwgSW5jLjFBMD8GA1UEAxM4RGlnaUNlcnQgVHJ1c3RlZCBHNCBUaW1l

# U3RhbXBpbmcgUlNBNDA5NiBTSEEyNTYgMjAyNSBDQTECEAqA7xhLjfEFgtHEdqeV

# dGgwDQYJYIZIAWUDBAIBBQCgaTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG

# CSqGSIb3DQEJBTEPFw0yNTEyMDYwODUyMjdaMC8GCSqGSIb3DQEJBDEiBCDTdo5n

# 0OKZdRPgSGNdjj68RJP3KHgKjLHkNEEiOOHYCzANBgkqhkiG9w0BAQEFAASCAgB4

# EJY/8lyOaSRzTfP8lqXdylkpKA7d/bJyFGVJBhEOqsSk15fgaysDttJYzgPVccNO

# DZOVCprl8gISsnCckM6Qkx96V8U5pIGISgvT5Gg6ykP1enNAM4ddA6lfoyI1IgjB

# q1iS+NuuOQ/1YCqmfGXMZZgop5dnMjvSrKHdZNNQjurmXEGChHKqNqwixkL1HYcZ

# asqMDZ0XaVHVWYQCAqjObRlfW9LgrkcU2leFVXX25fMCWZ3nJqe3EURT7irYCcq2

# Yqsf+msHNPtCe7hvrAW1EBF++7c4muhfai10XroyaazkPx3fMy+/0cpgc46Qu8Yf

# 7592/Z5s6shi6gz9hum2ZjEzdJezUewd0LMBzS6KzoqmPwAhUgJDEmkWZkKaCbHq

# 6e6bKw5/64bdab4Vgz+L4wzNzL98fHzvhWSj3xgNLJGHcskMiNrASF6OHTVMwRwm

# DxpfEt6iT2f/ZTsaMh65WZiWiLPVlYaMpOdeyqZp0SjCtMygz6C2LFEif0qtgXWX

# xlp0fiw48i3soAHAmXzFD3WTvjHKUFl3MUuksSm7JXZ4PtoS+NCTYacj0Q9EL0FT

# ZatmKDxg88WbysIUbHhZCSIU+bo1L0lNhlUULVkUw9rn3IKmAO4dUqBA3XIom43Y

# DmDoUvb5IKjNCwvYFr3OptYoHIfaQAcpbPGeHfNKAA==

# SIG # End signature block