BcContainerHelper

6.1.20-preview3009061

AppHandling/Extract-AppFileToFolder.ps1

                                <# 

 .Synopsis

  Extract the content of an App File to a Folder

 .Description

 .Parameter AppFilename

  Path of the application file

 .Parameter AppFolder

  Path of the folder in which the application File will be unpacked. If this folder exists, the content will be deleted. Default is $appFile.source.

 .Parameter GenerateAppJson

  Add this switch to generate an sample app.json file in the AppFolder, containing the manifest properties.

 .Parameter ExcludeRuntimeProperty

  Add this switch to remove the runtime version from the app.json 

 .Parameter LatestSupportedRuntimeVersion

  Add a version number to fail if the runtime version is higher than this version number

 .Parameter OpenFolder

  Add this parameter to open the destination folder in explorer

 .Example

  Extract-AppFileToFolder -appFilename c:\temp\baseapp.app

#>

function Extract-AppFileToFolder {

    Param (

        [string] $appFilename,

        [string] $appFolder = "",

        [switch] $generateAppJson,

        [switch] $excludeRuntimeProperty,

        [string] $latestSupportedRuntimeVersion,

        [switch] $openFolder

    )

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

try {

    Set-StrictMode -Off

    if ($appFolder -eq "") {

        if ($openFolder) {

            $generateAppJson = $true

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

        }

        else {

            $appFolder = "$($appFilename).source"

        }

    }

    if ("$appFolder" -eq "($bcContainerHelperConfig.hostHelperFolder)" -or "$appFolder" -eq "$($bcContainerHelperConfig.hostHelperFolder)\") {

        throw "The folder specified in ObjectsFolder will be erased, you cannot specify $($bcContainerHelperConfig.hostHelperFolder)"

    }

    if (!(Test-Path $appFileName)) {

        throw "Unable to find $appFileName"

    }

    $appFileName = (Get-Item $appFileName).FullName

    Write-Host "Extracting $appFilename"    

    if (Test-Path $appFolder -PathType Container) {

        Get-ChildItem -Path $appFolder -Include * | Remove-Item -Recurse -Force

    } else {

        New-Item -Path $appFolder -ItemType Directory -Force -ErrorAction Ignore | Out-Null

    }

    try {

        $filestream      = [System.IO.File]::OpenRead($appFileName)

        $binaryReader    = [System.IO.BinaryReader]::new($filestream)

        $magicNumber1    = $binaryReader.ReadUInt32()

        $metadataSize    = $binaryReader.ReadUInt32()

        $metadataVersion = $binaryReader.ReadUInt32()

        $packageId       = [Guid]::new($binaryReader.ReadBytes(16))

        $contentLength   = $binaryReader.ReadInt64()

        $magicNumber2    = $binaryReader.ReadUInt32()

        if ($magicNumber1 -ne 0x5856414E -or 

            $magicNumber2 -ne 0x5856414E -or 

            $metadataVersion -gt 2 -or

            $filestream.Position + $contentLength -gt $filestream.Length)

        {

            throw "Unsupported package format"

        }

        Add-Type -Assembly System.IO.Compression

        Add-Type -Assembly System.IO.Compression.FileSystem

        $content = $binaryReader.ReadBytes($contentLength)

        if ([bitConverter]::ToInt64($content,0) -eq 72057595132988974) {

            throw "You cannot extract a runtime package"

        }

        $memoryStream = [System.IO.MemoryStream]::new($content)

        $zipArchive = [System.IO.Compression.ZipArchive]::new($memoryStream, [System.IO.Compression.ZipArchiveMode]::Read)

        $prevdir = ""

        # If the app file is a ready-to-run app, it has a readytorunappmanifest.json file inside the archive

        $readyToRunAppManifest = $zipArchive.Entries | Where-Object { $_.FullName -eq "readytorunappmanifest.json" }

        if ($readyToRunAppManifest) {

            # Create a temporary folder to extract the ready-to-run app manifest

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

            New-Item -Path $tmpFolder -ItemType Directory -Force | Out-Null

            # Extract the ready-to-run app manifest and get the embedded app file name

            $fullname = Join-Path $tmpFolder "readytorunappmanifest.json"

            [System.IO.Compression.ZipFileExtensions]::ExtractToFile($readyToRunAppManifest, $fullname)

            $embeddedAppFileName = (Get-Content -Path $fullname -Raw | ConvertFrom-Json).EmbeddedAppFileName

            $embeddedAppFile = $zipArchive.Entries | Where-Object { $_.FullName -eq $embeddedAppFileName }

            if (-not $embeddedAppFile) {

                throw "Unable to find embedded app file '$embeddedAppFile' in the ready-to-run app."

            }

            # Create a temporary folder to extract the app file to

            $fullname = Join-Path $tmpFolder ([Uri]::UnescapeDataString($embeddedAppFile.FullName))

            [System.IO.Compression.ZipFileExtensions]::ExtractToFile($embeddedAppFile, $fullname)

            # Close stream and binary reader before recursive call

            $binaryReader.Close()

            $filestream.Close()

            $memoryStream.Close()

            try {

                # Call the Extract-AppFileToFolder function again to extract the content of the app file

                Extract-AppFileToFolder -appFilename $fullname -appFolder $appFolder -generateAppJson:$generateAppJson -excludeRuntimeProperty:$excludeRuntimeProperty -latestSupportedRuntimeVersion:$latestSupportedRuntimeVersion -openFolder:$openFolder

            } finally {

                # Clean up the temporary folder

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

            }

            return

        }

        $zipArchive.Entries | ForEach-Object {

            $fullname = Join-Path $appFolder ([Uri]::UnescapeDataString($_.FullName))

            $dir = [System.IO.Path]::GetDirectoryName($fullname)

            if ($dir -cne $prevdir) {

                if (-not (Test-Path $dir -PathType Container)) {

                    New-Item -Path $dir -ItemType Directory | Out-Null

                }

            }

            $prevdir = $dir

            [System.IO.Compression.ZipFileExtensions]::ExtractToFile($_, $fullname)

        }

    }

    finally {

        $binaryReader.Close()

        $filestream.Close()

    }

    "/addin/src/", "/perm/", "/entit/", "/serv/", "/tabledata/", "/replay/", "/migration/", "/layout/" | ForEach-Object {

        $folder = Join-Path $appFolder $_

        if (Test-Path $folder) {

            @(Get-ChildItem $folder) | ForEach-Object {

                Copy-Item -Path $_.FullName -Destination $appFolder -Recurse -Force

                Remove-Item -Path $_.FullName -Recurse -Force

            }

        }

    }

    if ($generateAppJson) {

        $manifest = [xml](Get-Content -path (Join-Path $appFolder "NavxManifest.xml") -Encoding UTF8)

        $runtimeStr = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "Runtime" } | ForEach-Object { $_.Value } )"

        if ($runtimeStr) {

            $runtime = [System.Version]$runtimeStr

        }

        else {

            $runtime = [System.Version]"9.2"

        }

        $application = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "Application" } | ForEach-Object { $_.Value } )"

        $appJson = [ordered]@{

            "id" = $manifest.Package.App.Id

            "name" = $manifest.Package.App.Name

            "publisher" = $manifest.Package.App.Publisher

            "version" = $manifest.Package.App.Version

            "brief" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "Brief" } | ForEach-Object { $_.Value } )"

            "description" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "Description" } | ForEach-Object { $_.Value } )"

            "platform" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "Platform" } | ForEach-Object { $_.Value } )"

        }

        if ($application) {

            $appJson += @{

                "application" = $application

            }

        }

        if ($latestSupportedRuntimeVersion -and $runtimeStr) {

            Write-Host "App Runtime Version is '$runtimeStr'"

            if ($runtime -gt [System.Version]$latestSupportedRuntimeVersion) {

                throw "App is using runtime version $runtimeStr, latest supported runtime version is $latestSupportedRuntimeVersion."

            }

        }

        if ($excludeRuntimeProperty.IsPresent) {

            Write-Host "Excluding Runtime Version from app.json"

        }

        else {

            $appJson += @{

                "runtime" = "$($runtime.Major).$($runtime.Minor)"

            }

        }

        $appJson += [ordered]@{

            "logo" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "Logo" } | ForEach-Object { $_.Value } )".TrimStart('/')

            "url" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "Url" } | ForEach-Object { $_.Value } )"

            "EULA" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "EULA" } | ForEach-Object { $_.Value } )"

            "privacyStatement" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "PrivacyStatement" } | ForEach-Object { $_.Value } )"

            "help" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "Help" } | ForEach-Object { $_.Value } )"

            "target" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "target" } | ForEach-Object { $_.Value } )"

            "screenshots" = @()

            "dependencies" = @()

            "idRanges" = @()

            "features" = @()

        }

        if ($runtime -lt [System.Version]"8.0")  {

            $appJson += @{

                "showMyCode" = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "ShowMyCode" } | ForEach-Object { $_.Value } )" -eq "True"

            }

        }

        else {

            $manifest.Package.ChildNodes | Where-Object { $_.name -eq "ResourceExposurePolicy" } | ForEach-Object { 

                $resExp = [ordered]@{}

                "allowDebugging", "allowDownloadingSource", "includeSourceInSymbolFile","applyToDevExtension" | ForEach-Object {

                    $prop = $_

                    if ($manifest.Package.ResourceExposurePolicy.Attributes | Where-Object { $_.name -eq $prop } | ForEach-Object { $_.Value -eq "true" }) {

                        $resExp += @{

                            "$prop" = $true

                        }

                    }

                }

                $appJson += @{ "resourceExposurePolicy" = $resExp }

            }

        }

        if ($runtime -ge [System.Version]"12.0")  {

            $manifest.Package.ChildNodes | Where-Object { $_.name -eq "Source" } | ForEach-Object { 

                $node = $_

                $ht = [ordered]@{}

                "repositoryUrl", "commit" | ForEach-Object {

                    $prop = $_

                    if ($node) {

                        $node.Attributes | Where-Object { $_.name -eq $prop } | ForEach-Object {

                            $ht += @{

                                "$prop" = $_.Value.Trim('"')

                            }

                        }

                    }

                }

                $appJson += @{ "source" = $ht }

            }

            $manifest.Package.ChildNodes | Where-Object { $_.name -eq "Build" } | ForEach-Object { 

                $node = $_

                $ht = [ordered]@{}

                "by", "url" | ForEach-Object {

                    $prop = $_

                    if ($node) {

                        $node.Attributes | Where-Object { $_.name -eq $prop } | ForEach-Object {

                            $ht += @{

                                "$prop" = $_.Value.Trim('"')

                            }

                        }

                    }

                }

                $appJson += @{ "build" = $ht }

            }

        }

        if ($runtime -ge [System.Version]"5.0")  {

            $appInsightsKey = $manifest.Package.App.Attributes | Where-Object { $_.name -eq "applicationInsightsKey" } | ForEach-Object { $_.Value } 

            if ($appInsightsKey) {

                $appJson += @{

                    "applicationInsightsKey" = "$appInsightsKey"

                }

            }

            elseif ($runtime -ge [System.Version]"7.2")  {

                $appInsightsConnectionString = $manifest.Package.App.Attributes | Where-Object { $_.name -eq "applicationInsightsConnectionString" } | ForEach-Object { $_.Value } 

                if ($appInsightsConnectionString) {

                    $appJson += @{

                        "applicationInsightsConnectionString" = "$appInsightsConnectionString"

                    }

                }

            }

        }

        $contextSensitiveHelpUrl = "$($manifest.Package.App.Attributes | Where-Object { $_.name -eq "contextSensitiveHelpUrl" } | ForEach-Object { $_.Value } )"

        if ($contextSensitiveHelpUrl) {

            $appJson += @{

                "contextSensitiveHelpUrl" = $contextSensitiveHelpUrl

            }

        }

        $manifest.Package.ChildNodes | Where-Object { $_.name -eq "Dependencies" } | ForEach-Object { 

            $_.GetEnumerator() | ForEach-Object {

                if ($runtime -gt [System.Version]"4.1") {

                    $propname = "id"

                }

                else {

                    $propname = "appId"

                }

                $appJson.dependencies += [ordered]@{

                    "$propname" = $_.Id

                    "publisher" = $_.publisher

                    "name" = $_.name

                    "version" = $_.minVersion

                }

            }

        }

        $manifest.Package.ChildNodes | Where-Object { $_.name -eq "IdRanges" } | ForEach-Object { 

            $_.GetEnumerator() | ForEach-Object {

                $appJson.idRanges += [ordered]@{

                    "from" = [Int]::Parse($_.MinObjectId)

                    "to" = [Int]::Parse($_.MaxObjectId)

                }

            }

        }

        $manifest.Package.ChildNodes | Where-Object { $_.name -eq "Features" } | ForEach-Object { 

            $_.GetEnumerator() | ForEach-Object {

                $feature = $_.'#text'

                'ExcludeGeneratedTranslations','GenerateCaptions','GenerateLockedTranslations','NoImplicitWith','TranslationFile' | ForEach-Object {

                    if ($feature -eq $_) {

                        $appJson.features += $_

                    }

                }

            }

        }

        $manifest.Package.ChildNodes | Where-Object { $_.name -eq "SupportedLocales" } | ForEach-Object { 

            $first = $true

            $_.GetEnumerator() | ForEach-Object {

                if ($first) {

                    $appJson += @{ "supportedLocales" = @() }

                    $first = $false

                }

                $appJson.supportedLocales += @($_.Local)

            }

        }

        if ($runtime -ge [System.Version]"4.0")  {

            $first = $true

            $manifest.Package.ChildNodes | Where-Object { $_.name -eq "internalsVisibleTo" } | ForEach-Object { 

                if ($first) {

                    $appJson += @{

                        "internalsVisibleTo" = @()

                    }

                }

                $_.GetEnumerator() | ForEach-Object {

                    $appJson.internalsVisibleTo += [ordered]@{

                        "id" = $_.Id

                        "publisher" = $_.publisher

                        "name" = $_.name

                    }

                }

            }

        }

        if ($runtime -ge [System.Version]"6.0") {

            $manifest.Package.ChildNodes | Where-Object { $_.name -eq "preprocessorSymbols" } | ForEach-Object { 

                $first = $true

                $_.GetEnumerator() | ForEach-Object {

                    if ($first) {

                        $appJson += @{ "preprocessorSymbols" = @() }

                        $first = $false

                    }

                    $appJson.preprocessorSymbols += @($_.Name)

                }

            }

            $appJson += @{ "keyVaultUrls" = @() }

            $manifest.Package.ChildNodes | Where-Object { $_.name -eq "KeyVaultUrls" } | ForEach-Object { 

                $_.GetEnumerator() | ForEach-Object {

                    $appJson.keyVaultUrls += @($_.Name)

                }

            }

        }

        $appJson | convertTo-json | Set-Content -Path (Join-Path $appFolder "app.json") -Encoding UTF8

    }

    if ($openFolder) {

        Start-Process $appFolder

    }

}

catch {

    TrackException -telemetryScope $telemetryScope -errorRecord $_

    throw

}

finally {

    Set-StrictMode -Version 2.0

    TrackTrace -telemetryScope $telemetryScope

}

}

Export-ModuleMember -Function Extract-AppFileToFolder

# SIG # Begin signature block

# MIInbQYJKoZIhvcNAQcCoIInXjCCJ1oCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCCOch6M/ZkNkrlV

# p2Uu5q+Ha6HkNZKIVQxi11GhWGylyaCCDMkwggYEMIID7KADAgECAhMzAAACHPrN

# xZvoL37EAAAAAAIcMA0GCSqGSIb3DQEBCwUAMFcxCzAJBgNVBAYTAlVTMR4wHAYD

# VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBD

# b2RlIFNpZ25pbmcgUENBIDIwMjQwHhcNMjYwNDE2MTg1OTQxWhcNMjcwNDE1MTg1

# OTQxWjB0MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE

# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYD

# VQQDExVNaWNyb3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IB

# DwAwggEKAoIBAQDVsZfgOKmM31HPfoWOoNEiw0SlCiIxUMC0I9NMWbucKOw/e9lP

# oAoehQVu6SG65V4EPzrYsnBnFPNoi4/HoOdjhz1qkrEt4I6tEcxXU6oOeY9zGveC

# /3iBeuhLYxM3M/PkcUoebF+Nednm8OkdSPoDu8imViHPQq/8CQUu0WRR4rE+dMRf

# rpVqfmNi2qWCX94T4MsepijGVkwE//tJg0ryAiYdHT34LSnlG/RSBZmQRGWZ5g8j

# qnKjRParSqMft1gvjuUTVgtWNZfgcLFSK5Wa0myrq8OPcgTGGsRgun+tnSS+IxDT

# xVsAPH1OzvPjwomguByhUe/OcvUN0D5Wmp7xAgMBAAGjggGqMIIBpjAOBgNVHQ8B

# Af8EBAMCB4AwHwYDVR0lBBgwFgYKKwYBBAGCN0wIAQYIKwYBBQUHAwMwHQYDVR0O

# BBYEFNoH7a2YDjOSwpkp6DHcmUS7J+0yMFQGA1UdEQRNMEukSTBHMS0wKwYDVQQL

# EyRNaWNyb3NvZnQgSXJlbGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxFjAUBgNVBAUT

# DTIzMDAxMis1MDc1NjkwHwYDVR0jBBgwFoAUf1k/VCHarU/vBeXmo9ctBpQSCDEw

# YAYDVR0fBFkwVzBVoFOgUYZPaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9w

# cy9jcmwvTWljcm9zb2Z0JTIwQ29kZSUyMFNpZ25pbmclMjBQQ0ElMjAyMDI0LmNy

# bDBtBggrBgEFBQcBAQRhMF8wXQYIKwYBBQUHMAKGUWh0dHA6Ly93d3cubWljcm9z

# b2Z0LmNvbS9wa2lvcHMvY2VydHMvTWljcm9zb2Z0JTIwQ29kZSUyMFNpZ25pbmcl

# MjBQQ0ElMjAyMDI0LmNydDAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBCwUAA4IC

# AQAUnEqhaRXe0T3hIJjvdQErEkrA/7bByjn6t5IArODkkRjzkYwtKMc2yYj2quaN

# rLutWw2YZcngKPy1b71YyDJQTy4NDRwaSh9Tw5thrk3NmcPrAHia5vtcBJ1CgtKK

# 7mQbIcQ22d/N3813ayCDDFewu1+jsZmX+r/aTEqaOM4TVxVtRSkuCy8nAXKuChOK

# Li/zA4XuH8iEYqIsj2YoNaeSxVmeGiERXpKdo3dDmYi0kO5w2D8VS4c3+9h6gElY

# BaAAg/dYErBg27qT3vv0zRDJhJufvCNylA8S7/+8H5E/PV5cng6na9VV/w9OV3qu

# uND6zdGa2EX38Glp50F9AIQk3p2xXmcvorDeM4XJ7UlWYBi6g80J1SSOQnInCYFE

# msfUNn3+1AaTJKSJL83quKArTac2pKhu0Yzzzrzo6HrsRiQKzpnRBb1/dMa6P3hz

# 75XbMRBctNsFhZC07WCmjExdLg2eHW5uV0TY8D5+6wozJf7vF3+WHkYPO85Z+BC6

# U4FkNbYNycZ9cE4j1tXRdyDCfml6c0HWPHjNVDObrv9lKt3qUqFpX38VCqVCyNOO

# 1UcXfQiVjJw32U2WUKZjt/neJKHEBsm9kFsLuWzkQ53+qcaSaytmsCnk2gOglrlD

# 5d3kKyvvAw+rzm0lT8K38P6PLxfZQHhu4W8dV7Av8N2ZmDCCBr0wggSloAMCAQIC

# EzMAAAA5O7Y3Gb8GHWcAAAAAADkwDQYJKoZIhvcNAQEMBQAwgYgxCzAJBgNVBAYT

# AlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYD

# VQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xMjAwBgNVBAMTKU1pY3Jvc29mdCBS

# b290IENlcnRpZmljYXRlIEF1dGhvcml0eSAyMDExMB4XDTI0MDgwODIwNTQxOFoX

# DTM2MDMyMjIyMTMwNFowVzELMAkGA1UEBhMCVVMxHjAcBgNVBAoTFU1pY3Jvc29m

# dCBDb3Jwb3JhdGlvbjEoMCYGA1UEAxMfTWljcm9zb2Z0IENvZGUgU2lnbmluZyBQ

# Q0EgMjAyNDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBANgBnB7jOMeq

# lRYHNa265v4IY9fH8TKhemHfPINe1gpLaV3dhg324WwH06LcHbpnsBukCDNitryo

# 0dtS/EW6I/yEL/bLSY8hKpbfQuWusBPr9qazYcDxCW/qnjb5JsI1s8bNOg3bVATv

# QVL4tcf03aTycsz8QeCdM0l/yHRObJ9QqazM1r6VPEOJ7LL+uEEb73w6QCuhs89a

# 1uv1zerOYMnsneRRwCbpyW11IcggU0cRKDDq1pjVJzIbIF6+oiXXbReOsgeI8zu1

# FyQfK0fVkaya8SmVHQ/tOf23mZ4W9k0Ri22QW9p3UgSC5OUDktKxxcCmGL6tXLfO

# GSWHIIV4YrTJTT6PNty5REojHJuZHArkF9VnHTERWoTjAzfI3kP+5b4alUdhgAZ7

# ttOu1bVnXfHaqPYl2rPs20ji03LOVWsh/radgE17es5hL+t6lV0eVHrVhsssROWJ

# uz2MXMCt7iw7lFPG9LXKGjsmonn2gotGdHIuEg5JnJMJVmixd5LRlkmgYRZKzhxS

# CwyoGIq0PhaA7Y+VPct5pCHkijcIIDm0nlkK+0KyepolcqGm0T/GYQRMhHJlGOOm

# VQop36wUVUYklUy++vDWeEgEo4s7hxN6mIbf2MSIQ/iIfMZgJxC69oukMUXCrOC3

# SkE/xIkgpfl22MM1itkZ35nNXkMolU1lAgMBAAGjggFOMIIBSjAOBgNVHQ8BAf8E

# BAMCAYYwEAYJKwYBBAGCNxUBBAMCAQAwHQYDVR0OBBYEFH9ZP1Qh2q1P7wXl5qPX

# LQaUEggxMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIAQwBBMA8GA1UdEwEB/wQFMAMB

# Af8wHwYDVR0jBBgwFoAUci06AjGQQ7kUBU7h6qfHMdEjiTQwWgYDVR0fBFMwUTBP

# oE2gS4ZJaHR0cDovL2NybC5taWNyb3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMv

# TWljUm9vQ2VyQXV0MjAxMV8yMDExXzAzXzIyLmNybDBeBggrBgEFBQcBAQRSMFAw

# TgYIKwYBBQUHMAKGQmh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2kvY2VydHMv

# TWljUm9vQ2VyQXV0MjAxMV8yMDExXzAzXzIyLmNydDANBgkqhkiG9w0BAQwFAAOC

# AgEAFJQfOChP7onn6fLIMKrSlN1WYKwDFgAddymOUO3FrM8d7B/W/iQ6DxXsDn7D

# 5W4wMwYeLystcEqfkjz4NURRgazyMu5yRzQh4LqjA4tStTcJh1opExo7nn5PuPBY

# nbu0+THSuVHTe0VTTPVhily/piFrDo3axQ9P4C+Ol5yet+2gTfekICS5xS+cYfSI

# vgn0JksVBVMYVI5QFu/qhnLhsEFEUzG8fvv0hjgkO+lkpV9ty6GkN4vdnd7ya6Q6

# aR9y34aiM1qmxaxBi6OUnyNl6fkuun/diTFnYDLTppOkr/mg5WSfCiDVMNCxtj4w

# PKC5OmHm1DQIt/MNokbbH3UGsFP1QbzsLocuSqLCvH09Io3fDPTmscR9Y75G4qX7

# RTX8AdBPo0I6OEojf39zuFZt0qOHm65YWQE69cZM2ueE1MB05dNNgHK9gTE7zKvK

# /fg8B2qjW88MT/WF5V5uvZGtqa9FSL2RazArA+rDPuf6JGYz4HpgMZHB4S6szWSK

# YBv0VisCzfxgeU+dquXW9bd0auYlOB58DPcOYKdc3Se94g+xL4pcEhbB54JOgAkw

# YTu/9dLeH2pDqeJZAABVDWRQCaXfO5LgyKwKCLYXpigrZYCjUSBcr+Ve8PFWMhVT

# Ql0v4q8J/AUmQN5W4n101cY2L4A7GTQG1h32HHAvfQESWP0xghn6MIIZ9gIBATBu

# MFcxCzAJBgNVBAYTAlVTMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24x

# KDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMjQCEzMAAAIc

# +s3Fm+gvfsQAAAAAAhwwDQYJYIZIAWUDBAIBBQCgga4wGQYJKoZIhvcNAQkDMQwG

# CisGAQQBgjcCAQQwHAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZI

# hvcNAQkEMSIEIN9OQHPRcIDo3CxylbDzCdcxOoW+yLNBOqbw4IYrGNIqMEIGCisG

# AQQBgjcCAQwxNDAyoBSAEgBNAGkAYwByAG8AcwBvAGYAdKEagBhodHRwOi8vd3d3

# Lm1pY3Jvc29mdC5jb20wDQYJKoZIhvcNAQEBBQAEggEAahFemYe/B5/fYvkglaOz

# hp/ePV2BO/syy859Pyz/7LygB8gF9i3n5eDLDGCm0bMe5g0WgPGfsgLPhEE6rRGl

# Wl3UwL3CRoMrVzhB6qFmPH8PxzI//7a5MeKMZmP5qlXqHo6+DzGwZaU9UC9aX34l

# Fco04b5xKM1oJ7fPP8hOZ1KZ/hpx4fI7sMr8ia/rWQGzpEmiQgRyS//ItJrzvwhk

# 0Klb2m2ETvJBQVVatYPcL/qfnuScxFAyyClk1fffsp13SihcsNlpI/YvoM/mM8ca

# 0EpBwZic8zfu3IKIEymJTMOt/qCm7SH/BK7mUOkaCgzcC2ArDczAxYaoV2tizCba

# s6GCF6wwgheoBgorBgEEAYI3AwMBMYIXmDCCF5QGCSqGSIb3DQEHAqCCF4UwgheB

# AgEDMQ8wDQYJYIZIAWUDBAIBBQAwggFaBgsqhkiG9w0BCRABBKCCAUkEggFFMIIB

# QQIBAQYKKwYBBAGEWQoDATAxMA0GCWCGSAFlAwQCAQUABCByQs/7BbxxXF7L7U60

# x4VtWsK3+uv5KetzbASWby1OhwIGauvdOqAaGBMyMDI2MTEwNTEwMjE1My42NDRa

# MASAAgH0oIHZpIHWMIHTMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3Rv

# bjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0

# aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJlbGFuZCBPcGVyYXRpb25zIExpbWl0

# ZWQxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVTTjo0MzFBLTA1RTAtRDk0NzElMCMG

# A1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZaCCEfowggcoMIIFEKAD

# AgECAhMzAAACNZsWed5GYdQrAAEAAAI1MA0GCSqGSIb3DQEBCwUAMHwxCzAJBgNV

# BAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4w

# HAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29m

# dCBUaW1lLVN0YW1wIFBDQSAyMDEwMB4XDTI2MTAxNTE4Mzc0M1oXDTI4MDExMTE4

# Mzc0M1owgdMxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYD

# VQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xLTAr

# BgNVBAsTJE1pY3Jvc29mdCBJcmVsYW5kIE9wZXJhdGlvbnMgTGltaXRlZDEnMCUG

# A1UECxMeblNoaWVsZCBUU1MgRVNOOjQzMUEtMDVFMC1EOTQ3MSUwIwYDVQQDExxN

# aWNyb3NvZnQgVGltZS1TdGFtcCBTZXJ2aWNlMIICIjANBgkqhkiG9w0BAQEFAAOC

# Ag8AMIICCgKCAgEAvA2sNh2bPpbdonwoPppQdy7rBQU2AYvZmVhKyXoLox21Owvo

# cY4P+BvqLOAtL67cWoekZxO9MMZ66lvqROg6EI8fsWbHn+OT/RYZps9h4drAIPhi

# E3fUzjwVM3XdZ90VvxutuVbCaj0z2xAbfGJnC1emXUNnZ/1BR85NvWen44bCrJYt

# ghstvh4So+UpUZg2ZdVDpR1n7spqnkG5hJBwK1pSom46V/SwisMIhfcY7Ie89Na9

# TJ5S47U1Nwf9JWEdrFLsCwrnh+65fAdfOzGy9oBdjSn/HEBE4H/7mgHIO+vkx2/q

# 2TRWjNdSIi2Sj+THCRPZe+c+LBM925/pncGt42JE/gH1QcAKtF6x0sLIh9yyUfJZ

# om5ZiD5s4aq/QDxEQZLA1UcWHIqFc5z+Aartxjre04B3bvwiVC6C5Yt7yxgzZHsQ

# lLsOoVKPwS2fO2yA5XWNEKpuomBjICT9owmvSW/dpVGSwbypHDZt5kWO3PrNiOTj

# pQXijznyE5bXFi9JlQF5Bm/BaF2Sxg7sLHstgxpP5SYoRoBjOPLqVWqtQfGEG7G1

# qxJL0YfaFnhWM8U0M90oQvV5jeGwAYq+ArsvGsYAV8r2po/xCK8R7eaNTzL5cjPz

# t23S0AO224NZnGmqm5G/QXVQOX3YI/NvqSoH6kYUmqmx6n22W9B7vq9jGYUCAwEA

# AaOCAUkwggFFMB0GA1UdDgQWBBQwSUMAYtxdCS9tvQtArQCayL3kLDAfBgNVHSME

# GDAWgBSfpxVdAF5iXYP05dJlpxtTNRnpcjBfBgNVHR8EWDBWMFSgUqBQhk5odHRw

# Oi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NybC9NaWNyb3NvZnQlMjBUaW1l

# LVN0YW1wJTIwUENBJTIwMjAxMCgxKS5jcmwwbAYIKwYBBQUHAQEEYDBeMFwGCCsG

# AQUFBzAChlBodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL2NlcnRzL01p

# Y3Jvc29mdCUyMFRpbWUtU3RhbXAlMjBQQ0ElMjAyMDEwKDEpLmNydDAMBgNVHRMB

# Af8EAjAAMBYGA1UdJQEB/wQMMAoGCCsGAQUFBwMIMA4GA1UdDwEB/wQEAwIHgDAN

# BgkqhkiG9w0BAQsFAAOCAgEApX6cT9hL8p3gSnGdvnoPm07DiccGrmj2SFZYaPRy

# raviUBiKmjVy3jLXKQT0Mfbzkf8zfm5l2kr0YFQ9JW/LB/zt4p4cIVCAe+EdoxIJ

# VzTGeLDkHDcvmZqhIFeh33uPrbtX9HQc5QU5TpOWute7AfohT6tqTblNLlz5OLKV

# KFEJBQGFh/Mnw2t9ZLeCm4Gf1DeZ1sWNft/rHbzkwudXBh280BFKVG3AoyHbOMo3

# W5GwAyVq7IAAI39QcThuYKxNHPoVrL36WHcyfjk9eIDz6GMQhOoWI7MdgQHr0jOf

# 9UQHWhN0jG6pBMKnfgPWFXUL6XlHCGYROaETJVxpzmmKQblHmWmnCTYNWb0QPWiQ

# b5ZNNYD+zWI6KcpsGcRC6cYITgwYw+OfjejWV4wQW6V5mvN7e87RSMMjcMtRFoy8

# FULlM8l/B6hlnFiBbrCO24X57A0SO1TTFPn3dSx/37bjhI9ABaHuiGZlDe9IjsEV

# LTzfOdE59i9ZhooyUsO/ceSZp4x0Icw3PJzq1r4/1AOlG8mQDbCsddauUM6n8VSf

# q8rBJCdqdrcWpRqUerFnyAp0S+97C0YfBsaVpXUGVBPfqF+KwKlGGjxP32s3qcUi

# TM8Mqt1OwRbp66d6k4/8XXLPrfqx1StgUwDjd/N8vzMPFj1pDYt1GiVXwjKNNvnR

# ei8wggdxMIIFWaADAgECAhMzAAAAFcXna54Cm0mZAAAAAAAVMA0GCSqGSIb3DQEB

# CwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE

# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMTIwMAYD

# VQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZpY2F0ZSBBdXRob3JpdHkgMjAxMDAe

# Fw0yMTA5MzAxODIyMjVaFw0zMDA5MzAxODMyMjVaMHwxCzAJBgNVBAYTAlVTMRMw

# EQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVN

# aWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0

# YW1wIFBDQSAyMDEwMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA5OGm

# TOe0ciELeaLL1yR5vQ7VgtP97pwHB9KpbE51yMo1V/YBf2xK4OK9uT4XYDP/XE/H

# ZveVU3Fa4n5KWv64NmeFRiMMtY0Tz3cywBAY6GB9alKDRLemjkZrBxTzxXb1hlDc

# wUTIcVxRMTegCjhuje3XD9gmU3w5YQJ6xKr9cmmvHaus9ja+NSZk2pg7uhp7M62A

# W36MEBydUv626GIl3GoPz130/o5Tz9bshVZN7928jaTjkY+yOSxRnOlwaQ3KNi1w

# jjHINSi947SHJMPgyY9+tVSP3PoFVZhtaDuaRr3tpK56KTesy+uDRedGbsoy1cCG

# MFxPLOJiss254o2I5JasAUq7vnGpF1tnYN74kpEeHT39IM9zfUGaRnXNxF803RKJ

# 1v2lIH1+/NmeRd+2ci/bfV+AutuqfjbsNkz2K26oElHovwUDo9Fzpk03dJQcNIIP

# 8BDyt0cY7afomXw/TNuvXsLz1dhzPUNOwTM5TI4CvEJoLhDqhFFG4tG9ahhaYQFz

# ymeiXtcodgLiMxhy16cg8ML6EgrXY28MyTZki1ugpoMhXV8wdJGUlNi5UPkLiWHz

# NgY1GIRH29wb0f2y1BzFa/ZcUlFdEtsluq9QBXpsxREdcu+N+VLEhReTwDwV2xo3

# xwgVGD94q0W29R6HXtqPnhZyacaue7e3PmriLq0CAwEAAaOCAd0wggHZMBIGCSsG

# AQQBgjcVAQQFAgMBAAEwIwYJKwYBBAGCNxUCBBYEFCqnUv5kxJq+gpE8RjUpzxD/

# LwTuMB0GA1UdDgQWBBSfpxVdAF5iXYP05dJlpxtTNRnpcjBcBgNVHSAEVTBTMFEG

# DCsGAQQBgjdMg30BATBBMD8GCCsGAQUFBwIBFjNodHRwOi8vd3d3Lm1pY3Jvc29m

# dC5jb20vcGtpb3BzL0RvY3MvUmVwb3NpdG9yeS5odG0wEwYDVR0lBAwwCgYIKwYB

# BQUHAwgwGQYJKwYBBAGCNxQCBAweCgBTAHUAYgBDAEEwCwYDVR0PBAQDAgGGMA8G

# A1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU1fZWy4/oolxiaNE9lJBb186aGMQw

# VgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDovL2NybC5taWNyb3NvZnQuY29tL3BraS9j

# cmwvcHJvZHVjdHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYtMjMuY3JsMFoGCCsGAQUF

# BwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3Br

# aS9jZXJ0cy9NaWNSb29DZXJBdXRfMjAxMC0wNi0yMy5jcnQwDQYJKoZIhvcNAQEL

# BQADggIBAJ1VffwqreEsH2cBMSRb4Z5yS/ypb+pcFLY+TkdkeLEGk5c9MTO1OdfC

# cTY/2mRsfNB1OW27DzHkwo/7bNGhlBgi7ulmZzpTTd2YurYeeNg2LpypglYAA7AF

# vonoaeC6Ce5732pvvinLbtg/SHUB2RjebYIM9W0jVOR4U3UkV7ndn/OOPcbzaN9l

# 9qRWqveVtihVJ9AkvUCgvxm2EhIRXT0n4ECWOKz3+SmJw7wXsFSFQrP8DJ6LGYnn

# 8AtqgcKBGUIZUnWKNsIdw2FzLixre24/LAl4FOmRsqlb30mjdAy87JGA0j3mSj5m

# O0+7hvoyGtmW9I/2kQH2zsZ0/fZMcm8Qq3UwxTSwethQ/gpY3UA8x1RtnWN0SCyx

# TkctwRQEcb9k+SS+c23Kjgm9swFXSVRk2XPXfx5bRAGOWhmRaw2fpCjcZxkoJLo4

# S5pu+yFUa2pFEUep8beuyOiJXk+d0tBMdrVXVAmxaQFEfnyhYWxz/gq77EFmPWn9

# y8FBSX5+k77L+DvktxW/tM4+pTFRhLy/AsGConsXHRWJjXD+57XQKBqJC4822rpM

# +Zv/Cuk0+CQ1ZyvgDbjmjJnW4SLq8CdCPSWU5nR0W2rRnj7tfqAxM328y+l7vzhw

# RNGQ8cirOoo6CGJ/2XBjU02N7oJtpQUQwXEGahC0HVUzWLOhcGbyoYIDVTCCAj0C

# AQEwggEBoYHZpIHWMIHTMQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3Rv

# bjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0

# aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJlbGFuZCBPcGVyYXRpb25zIExpbWl0

# ZWQxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVTTjo0MzFBLTA1RTAtRDk0NzElMCMG

# A1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZaIjCgEBMAcGBSsOAwIa

# AxUAWss3eoS1rlla0gVyedUYK2xMzzCggYMwgYCkfjB8MQswCQYDVQQGEwJVUzET

# MBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMV

# TWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1T

# dGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQsFAAIFAO6WW7AwIhgPMjAyNjExMDUw

# MTM0NDBaGA8yMDI2MTEwNjAxMzQ0MFowczA5BgorBgEEAYRZCgQBMSswKTAKAgUA

# 7pZbsAIBADAGAgEAAgEaMAcCAQACAhN4MAoCBQDul60wAgEAMDYGCisGAQQBhFkK

# BAIxKDAmMAwGCisGAQQBhFkKAwKgCjAIAgEAAgMHoSChCjAIAgEAAgMBhqAwDQYJ

# KoZIhvcNAQELBQADggEBAHsT3bwgj1ram32y6inzfTi4xOjTKXlzccWe0oU/l6PZ

# VLHBX5iWoHy9FG3rqnJ+qjGvbv0gHaRkwbm+y2AkF07ME1f43mhGTXAy2L8iHRWM

# fNX3cC29C0KYZrkEKJUNSa+qcaZu06WvBi/F0/C6oiH4Bh/2BtAEpD2yZTI6XDOA

# y1OObC46U7xtFVeymYHhw7PF6ra66hOLgresjn8gSF/Eo3ePNzQ6ulkqkmxd71Lq

# is2smqxHlq8s4hCAnjU5hqz7BL0uhN16P6Sq9r4rQcwv0mukE9xuCbbDxc4o+opy

# NiW6W4Wb6zYwC/WIz0/Cb6mOi8Jk+r7otYsW7STFLroxggQNMIIECQIBATCBkzB8

# MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVk

# bW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1N

# aWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMAITMwAAAjWbFnneRmHUKwABAAAC

# NTANBglghkgBZQMEAgEFAKCCAUowGgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEE

# MC8GCSqGSIb3DQEJBDEiBCA17JvhDnJRQ76ygSAskXEmZirVu6WuRzR5UpAE+mwr

# ZTCB+gYLKoZIhvcNAQkQAi8xgeowgecwgeQwgb0EILSmuCosvR8n9AW8ugAmM+Qp

# goFN9j6qphrP9k5KcxDKMIGYMIGApH4wfDELMAkGA1UEBhMCVVMxEzARBgNVBAgT

# Cldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29m

# dCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENB

# IDIwMTACEzMAAAI1mxZ53kZh1CsAAQAAAjUwIgQgnr4WpJZ2y8rn0Loyi1tsFMIU

# I3f+07enAvmQ8s2akckwDQYJKoZIhvcNAQELBQAEggIAHqsg4F+E2WA6BTcsHFV4

# 3tD4nwCP6C7OcNmUE8p3mIGZyjcfVWGoytprrP4n+ivJHoiYSfI1SukW7hV7oKKr

# F5k70mlyWwb7df/S2+//sKidmBNojnjKPoQ+4JQtZGKdDQ/B4MFwCEdC3CJg+ijr

# 8vnbRWw3RpM77PsL/32y2l504k2RIDOg0bZCMWCz52QCQy/VLZk5guFFInTmc4BU

# VehYqXJHYieOWyaGzikFGBiQeL0xyZpWSulMdmgyNgyM6zucojt878zB3YEhmBe6

# fO9OVg7m1sedh0O9dxu6qyLuHqkG+9kUxRzyAW2bCobRfA1AKand8V2EG2IJtH/O

# 3zecNnC6u1541G6kdMIZrKAiFMyRH0BSVD32gRNWWFDuXfEpgnQBIzKsjzC2c/Y0

# WByMGl183l7mKyDUwbG3zu0ikYqEbpVbtedzYn8GNJaXhRTBDIeM0A2kSWlJIs1i

# MSv4UPW1mqIOEi9KyXjK9S7+yrtgNRE3sbMt1CX2nMWKo8bBdC4igA/Edvs4MwWZ

# CU/CjphyXwD75uK6+OTsyRD/9nrKxPEkD9vUzdLULBdeNVus+tr+rDfrsTSJbjCv

# NzE4u2H3ixdasC6PXcxplVAE+URvNi4JFn4QlUvwdDQlFw4f83vHfUxOOiX3NcMA

# kAEIblpPIqdrsDlIv/++FLE=

# SIG # End signature block