BcContainerHelper

6.1.13

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 -ne $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

# MIInRgYJKoZIhvcNAQcCoIInNzCCJzMCAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCCzEDyDBOpjZpxN

# rrUYiHCrHBVtZcfBzVRqEeygjOVf26CCDLowggX1MIID3aADAgECAhMzAAACHU0Z

# 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

# 1cY2L4A7GTQG1h32HHAvfQESWP0xghniMIIZ3gIBATBuMFcxCzAJBgNVBAYTAlVT

# MR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jv

# c29mdCBDb2RlIFNpZ25pbmcgUENBIDIwMjQCEzMAAAIdTRnITtcPV0gAAAAAAh0w

# DQYJYIZIAWUDBAIBBQCgga4wGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYK

# KwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIDJU9P9D

# 52AuxtUfmnObA9+3SOAaYMX+BuQrlRluqG/sMEIGCisGAQQBgjcCAQwxNDAyoBSA

# EgBNAGkAYwByAG8AcwBvAGYAdKEagBhodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20w

# DQYJKoZIhvcNAQEBBQAEggEAv1PyNYC+P9eFJ6yhAecY3tM0wTu2dtXlr+sTJQPd

# o3/wn8f1MmhYjHQw6XoMy7oyVl9qGHLc24ehEpcRNz0jbLNgxKB4pyfNbx9zxps6

# DU3d+q1F9lmeEDA3SqE5sedNZJN/Ko9+fmMKVlBwCwq9S4b/fS94z10Qih3OYtpW

# UQa//qEBGG2sW3bkxbqrya2J2IBBZqJj2V/AwJ3Q4k+9pETfFvIbHbyU/z8g/lsl

# O/9rUggpBZGX09izous1djz/DW+8IppmR7jm445+K9xaplFxPp4deGaOVWPDyMBh

# J3xsqo/oCSnsLg6DR2WrMUaV2C2FzUhCiIvoHWbMkIw5SqGCF5QwgheQBgorBgEE

# AYI3AwMBMYIXgDCCF3wGCSqGSIb3DQEHAqCCF20wghdpAgEDMQ8wDQYJYIZIAWUD

# BAIBBQAwggFSBgsqhkiG9w0BCRABBKCCAUEEggE9MIIBOQIBAQYKKwYBBAGEWQoD

# ATAxMA0GCWCGSAFlAwQCAQUABCCXN1Rlzy+7gxypfp4SCTsBI+J97nMyd0XtnFRp

# L/DsJQIGaeewPiLlGBMyMDI2MDQyNzA5MDI1My4wMTNaMASAAgH0oIHRpIHOMIHL

# MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVk

# bW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxN

# aWNyb3NvZnQgQW1lcmljYSBPcGVyYXRpb25zMScwJQYDVQQLEx5uU2hpZWxkIFRT

# UyBFU046ODkwMC0wNUUwLUQ5NDcxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0

# YW1wIFNlcnZpY2WgghHqMIIHIDCCBQigAwIBAgITMwAAAiJB0vaq/8i1/wABAAAC

# IjANBgkqhkiG9w0BAQsFADB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGlu

# Z3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBv

# cmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDAe

# Fw0yNjAyMTkxOTM5NTZaFw0yNzA1MTcxOTM5NTZaMIHLMQswCQYDVQQGEwJVUzET

# MBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMV

# TWljcm9zb2Z0IENvcnBvcmF0aW9uMSUwIwYDVQQLExxNaWNyb3NvZnQgQW1lcmlj

# YSBPcGVyYXRpb25zMScwJQYDVQQLEx5uU2hpZWxkIFRTUyBFU046ODkwMC0wNUUw

# LUQ5NDcxJTAjBgNVBAMTHE1pY3Jvc29mdCBUaW1lLVN0YW1wIFNlcnZpY2UwggIi

# MA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQC1ueKJukIuUsAAJo/AY5DZRqH7

# bhgv7CWGNlEdbRGoITrdE6Wsn57NaNu1BTdjBbFcv7Rfixte0x+HRvXSqsD+WeSX

# /6/y9wE0Mz+xRPTGIY20K7aQDa68OyzVyUeUCypyZC/gW/3ytO/ZOnU9H2ri77kJ

# P8ABrqyy1UxX/OseEgvHsj8yikWT0ARtrjWbXMHFzSOo5hQcfUmMXKqWWz6+N0+U

# ynhGy1n+doW4WZgpH8Y5W7hpSokWj1M/Lu4wi3o6Dz9vVWukcgUFGjLAl4YZpOha

# h7HuiC/alXImMQf8C3A8q/6/1hFoeIZB4UGkywxB/OSTOSsL6+39pDqzM7CgOpf4

# V799kN94yM9uXJI5T/SiA5MdIZIhEW0+bh85RqDh5YW3/oav54RPxw5OPlH64QV6

# KJkl0FIElMVoLNo8UWRQcMD179x7WASjC6LsaNZ7yK0qcESIsL1wiQmdfQBxcqrF

# CpIQfnmQFkOp9IyXUWqza8tmpz8E6aXg9b1eiAT3PVTgrOlPi/hYZCfPxX/6jGty

# Pjy1CiwOmJamohmSU//COAenfRT2G2HMRUpCX1zs+AmDmdQM1XRab4YSALLAlDzG

# CsgI77nnuJjoXAliJmv7NfrvWAcA5KqCUOWQ6kSPt5r28MfKXWJJpSXtFeS/MkDz

# Jy/iJRVyHcFy/B+MtwIDAQABo4IBSTCCAUUwHQYDVR0OBBYEFFkHwGoDJ5ZbEEiu

# 8KstiusqaozQMB8GA1UdIwQYMBaAFJ+nFV0AXmJdg/Tl0mWnG1M1GelyMF8GA1Ud

# HwRYMFYwVKBSoFCGTmh0dHA6Ly93d3cubWljcm9zb2Z0LmNvbS9wa2lvcHMvY3Js

# L01pY3Jvc29mdCUyMFRpbWUtU3RhbXAlMjBQQ0ElMjAyMDEwKDEpLmNybDBsBggr

# BgEFBQcBAQRgMF4wXAYIKwYBBQUHMAKGUGh0dHA6Ly93d3cubWljcm9zb2Z0LmNv

# bS9wa2lvcHMvY2VydHMvTWljcm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIw

# MTAoMSkuY3J0MAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUHAwgw

# DgYDVR0PAQH/BAQDAgeAMA0GCSqGSIb3DQEBCwUAA4ICAQBiAM+nqrpwG29txSXv

# 42o+CsTe2C4boaRfFju9JaWkLTHwq7pknNONL3n+UG3x/B083EKXiFYrAmul7BTH

# CGXU63/xRsZ2wj3ZmR0A4d9nf9saCJVm4juPVFBai/oktOOYH2j+1+zM70woN5on

# gB/pvy7X8AfY6JB4XPvb80Qz7fY5eddbnwjzg1sZhUPFbbcweWeACINrzqFK62mM

# eXKmhtufMraoogJeJXfWY3x4/pbubgENT3+pXT65203CPF9kfdKE7GKAIRYy3xkB

# TDvFd8dufjOpCn38nK6qMlVtnBjDhWQG0PM3E/oxBs5UBrI6pBYkmIHtbjifDquH

# T+ThaVV7xHc6InoSc3aNzX49JHUgQmuvDdMjLkbYXeA0/1q5IxSg2U+ycZBOvAi3

# udZPKhA5VzODjf/ucu/vFtXrYcRkmGKN3jujaK3/yMZi2Ju5NEL3ISWorwp7RjeZ

# g+JMIK0fosuVj+YCm5r64LH/D9QJDAj+XfZaNeFdv90K5A0QRRGP/poB9yTIVjEX

# j/uJzp8L4Dd44sAquqDOiHdkLgxfK8nPqpCSWPZ9G+RCPm85o9cAfxENtrSuOwcp

# yKzxsRCYCL+PK4+98orit9EVJ/LLoCeG+jLlj0KaD4Qy6sZe4rWMr1brQLosTBZN

# wFnXxNjInCWBd0i7is1yTS/4qTCCB3EwggVZoAMCAQICEzMAAAAVxedrngKbSZkA

# 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

# VTNYs6FwZvKhggNNMIICNQIBATCB+aGB0aSBzjCByzELMAkGA1UEBhMCVVMxEzAR

# BgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1p

# Y3Jvc29mdCBDb3Jwb3JhdGlvbjElMCMGA1UECxMcTWljcm9zb2Z0IEFtZXJpY2Eg

# T3BlcmF0aW9uczEnMCUGA1UECxMeblNoaWVsZCBUU1MgRVNOOjg5MDAtMDVFMC1E

# OTQ3MSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBTZXJ2aWNloiMKAQEw

# BwYFKw4DAhoDFQC7ycXVZx3bsDpJkr7VucgpksozuKCBgzCBgKR+MHwxCzAJBgNV

# BAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4w

# HAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1pY3Jvc29m

# dCBUaW1lLVN0YW1wIFBDQSAyMDEwMA0GCSqGSIb3DQEBCwUAAgUA7ZluLjAiGA8y

# MDI2MDQyNzA1MTAwNloYDzIwMjYwNDI4MDUxMDA2WjB0MDoGCisGAQQBhFkKBAEx

# LDAqMAoCBQDtmW4uAgEAMAcCAQACAgMmMAcCAQACAhK1MAoCBQDtmr+uAgEAMDYG

# CisGAQQBhFkKBAIxKDAmMAwGCisGAQQBhFkKAwKgCjAIAgEAAgMHoSChCjAIAgEA

# AgMBhqAwDQYJKoZIhvcNAQELBQADggEBACwAyleL2Yqe1BY5zhop6f9b38xTseRL

# nK8lk6xN56Sa/+V76FEsa8GVmoPZ56j67jaf1+OfbmdRGFgJqoMIOg1aF2O9rmbb

# nLFh9KeYizoHIQ60M+Fj4ChCcAW1eP/hTAGRcYbGONeBwmdrE3TdH4DKGDAEAb7M

# nBZKkkEGutwLaiGv/wlTo2Z4EtKszFWu9Ctvq+gVWKI9ZxGbvrT5koaMxDONvh3R

# gjQmi+VSL4X2xnXT5zhHWNl/VvgvddFczfxzIYRdBmQQKAGYIeGUzTDiMhIGPd03

# QydCa1yDlZsFj9JfqIxH5HwfjwDLPAUFm6YUFndGZEPmDa3jQmzbsioxggQNMIIE

# CQIBATCBkzB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4G

# A1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYw

# JAYDVQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMAITMwAAAiJB0vaq

# /8i1/wABAAACIjANBglghkgBZQMEAgEFAKCCAUowGgYJKoZIhvcNAQkDMQ0GCyqG

# SIb3DQEJEAEEMC8GCSqGSIb3DQEJBDEiBCCfbmThs+bG6wwSjPVBqxVC9GL1DybM

# TErLPi6ClIoqKDCB+gYLKoZIhvcNAQkQAi8xgeowgecwgeQwgb0EIAVgXQEKBOfG

# gjNskmDOmbcEIOnHGNwA+QcRufDR5AkTMIGYMIGApH4wfDELMAkGA1UEBhMCVVMx

# EzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoT

# FU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUt

# U3RhbXAgUENBIDIwMTACEzMAAAIiQdL2qv/Itf8AAQAAAiIwIgQgpDxkkBWXQKKa

# R/4wzVwXhSWnf30TdS5kqVGLjI81yVcwDQYJKoZIhvcNAQELBQAEggIApRCPOdyc

# 7zHwWToJ7K0kSuHY/aaOUv7Oq+UmHBUCs9ihD09H7WQaEpcgc8F+Y0NjdKDYoLFY

# pM4KKoeLl85yrKxvpd3ILx0WNqlVO30v57afWE2rkN1QLZCBvJupoiJGNFIEqvUA

# WjUqppWvLFMtDjU3Mo5DMiDjYu55HsoNeIJCik0Hchi65ilmk6XfZ4xpt3nzNDAE

# THPk7hUydjenL26t/BDKz85lqBfwPO8fcJ7ZQdAHwh/7qPLAsS07SJfT15omEE0P

# BCUBvC5qm5PErqkeucgbebsDtAa+eekYrvcd7xbCDIEAAlp5lkXr9bOVQBKg37mv

# Wvf3VBN/azZGAIRTtyNxC/YCtS3KUjWzgqvjp1SuUH4FS6kQInvm6sx/jYW4jfQz

# Qu+gKocdnhigXymMzboZ5qrAf/PI2/0xLXuBMsk/jsfPhnw+13iD+f1Poas+A63N

# nNbMVlyVfmiyOVMWf/BhlFxR0IlB6ug7iJQn8XRUvGan+A3JpCvltAtMU2GQfwVc

# VssaQT4iVGdhMJvIZNx/NJ/zEWlRefC4GmW8SGFuNqgAj/j0Vz3/BtDCDFtrcHlu

# utjXxsts4+Mn0JUKXYWVhLBN5E37mOF4zOTiFX1reIj8l1BhngptH5vo7VUexrXt

# bzhNBUczz8+eTqAnDnBxrTAyn0xZJjSkHpE=

# SIG # End signature block