HCPosh

3.0.17.0

HCPosh.psm1

                                <#    

    ===========================================================================

     Created on:       8/8/2017 6:49 PM

     Created by:       spencer.nicol

     Organization:     Health Catalyst

     Filename:         HCPosh.psm1

    -------------------------------------------------------------------------

     Module Name: HCPosh

    ===========================================================================

#>

<#

    .SYNOPSIS

        HCPosh is a powershell module that provides some useful functions and tools when working with data in the Health Catalyst Analytics Platform.

    .DESCRIPTION

        Some key features include:

        * built-in column-level **sql parser**, developed using the Microsoft.SqlServer.TransactSql.ScriptDom library.

        * integration of **Graphviz** software for ERD and Data flow diagram generation (pdf, png, and svg)

        * splits SAM Designer files into smaller files for source control

    .PARAMETER version

        Returns the version number of the **HCPosh** module

    .PARAMETER sqlparser

        Gets tables and columns from sql queries

    .PARAMETER data

        return a metadata_raw.json and metadata_new.json, then splits these objects into a folder structure of content for easier source control management of SAMD data models.

        HCPosh -Data

        output the hcx objects to a variable in-memory

        $Var = HCPosh -Data -OutVar

        other options when using the -Data function

        HCPosh -Data -Force

        HCPosh -Data -NoSplit

        HCPosh -Data -Raw

    .PARAMETER graphviz

        A description of the graphviz parameter.

    .EXAMPLE

        PS C:\> HCPosh -Graphviz

#>

function HCPosh {

    #region PARAMETERS

    param

    (

        [Parameter(ParameterSetName = 'Version')]

        [switch]$Version,

        [Parameter(ParameterSetName = 'Config', Mandatory = $True)]

        [switch]$Config,

        [Parameter(ParameterSetName = 'Config')]

        [switch]$Force,

        [Parameter(ParameterSetName = 'Config')]

        [string]$Json,

        [Parameter(ParameterSetName = 'SqlParser', Mandatory = $True)]

        [switch]$SqlParser,

        [Parameter(ParameterSetName = 'SqlParser', Mandatory = $True)]

        [string]$Query,

        [Parameter(ParameterSetName = 'SqlParser')]

        [switch]$Log,

        [Parameter(ParameterSetName = 'SqlParser')]

        [switch]$SelectStar,

        [Parameter(ParameterSetName = 'SqlParser')]

        [switch]$Brackets,

        [Parameter(ParameterSetName = 'Impact', Mandatory = $True)]

        [switch]$Impact,

        [Parameter(ParameterSetName = 'Impact', Mandatory = $True)]

        [string]$Server,

        [Parameter(ParameterSetName = 'Impact')]

        [string]$ConfigPath,

        [Parameter(ParameterSetName = 'Impact')]

        [Parameter(ParameterSetName = 'Docs')]

        [Parameter(ParameterSetName = 'Graphviz')]

        [Parameter(ParameterSetName = 'Diagrams')]

        [string]$OutDir,

        [Parameter(ParameterSetName = 'Data', Mandatory = $True)]

        [switch]$Data,

        [Parameter(ParameterSetName = 'Data')]

        [Parameter(ParameterSetName = 'Docs')]

        [ValidateScript( { if ( -Not ($_ | Test-Path) -and -Not ($_.EndsWith(".hcx")) ) { throw "File or folder does not exist" } return $true })]

        [string]$Path,

        [Parameter(ParameterSetName = 'Data')]

        [Parameter(ParameterSetName = 'Docs')]

        [Parameter(ParameterSetName = 'Installer')]

        [switch]$OutVar,

        [Parameter(ParameterSetName = 'Data')]

        [switch]$Raw,

        [Parameter(ParameterSetName = 'Data')]

        [switch]$NoSplit,

        [Parameter(ParameterSetName = 'Installer')]

        [switch]$Installer,

        [Parameter(ParameterSetName = 'Docs', Mandatory = $True)]

        [switch]$Docs,

        [Parameter(ParameterSetName = 'Docs')]

        [switch]$KeepFullLineage,

        [Parameter(ParameterSetName = 'Diagrams', Mandatory = $True)]

        [switch]$Diagrams,

        [Parameter(ParameterSetName = 'Diagrams')]

        [Parameter(ParameterSetName = 'Docs')]

        [switch]$OutZip,

        [Parameter(ParameterSetName = 'Graphviz', Mandatory = $True)]

        [switch]$Graphviz,

        [Parameter(ParameterSetName = 'Graphviz')]

        [string]$InputDir,

        [Parameter(ParameterSetName = 'Graphviz')]

        [ValidateSet('pdf', 'png', 'svg')]

        [string]$OutType

    )

    #endregion

    begin {

        # Get function definition files.

        $functions = @( Get-ChildItem -Path $PSScriptRoot\functions -Filter *.ps1 -ErrorAction SilentlyContinue )

        $common = @( Get-ChildItem -Path $PSScriptRoot\functions\common -Filter *.ps1 -ErrorAction SilentlyContinue )

        # Dot source the files

        foreach ($import in @($functions + $common)) {

            try {

                . $import.fullname

            }

            catch {

                Write-Error -Message "Failed to import function $($import.fullname): $_"

            }

        }

    }

    process {

        switch ($PsCmdlet.ParameterSetName) {

            'Version' {

                try {

                    "HCPosh v$((Get-Module HCPosh -ListAvailable)[0].Version -join '.')"

                    if (!$Version) {

                        Get-Help HCPosh

                    }

                }

                catch {

                    "HCPosh is running as an in-memory module"

                }

            }

            'Config' {

                $invokeConfigParams = @{}

                if ($Force) { $invokeConfigParams.Add("Force", $Force) }

                if ($Json) { $invokeConfigParams.Add("Json", $Json) }

                Invoke-Config @invokeConfigParams

            }

            'SqlParser' {

                Invoke-SqlParser -Query $Query -Log $Log -SelectStar $SelectStar -Brackets $Brackets

            }

            'Data' {

                if ($Path) {

                    $Files = Get-Item $Path

                }

                else {

                    $Files = Get-ChildItem | Where-Object Extension -eq '.hcx'

                }

                try {

                    if (($Files | Measure-Object).Count -eq 0) { throw; }

                }

                catch {

                    $Msg = "Unable to find any hcx files in current directory."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';

                }

                $Pipe = $Files | Select-Object @{ n = 'File'; e = { $_.FullName } }, @{ n = 'OutDir'; e = { "$($_.Directory)\_hcposh\$($_.BaseName)" } }

                if ($OutVar) {

                    if ($Raw) {

                        ($Pipe | Invoke-DataRaw | Select-Object RawData).RawData

                    }

                    else {

                        ($Pipe | Invoke-DataRaw | Invoke-Data | Select-Object Data).Data

                    }

                }

                else {

                    if ($Raw) {

                        $Pipe | Invoke-DataRaw | Out-Null

                    }

                    else {

                        $Pipe | Invoke-DataRaw | Invoke-Data | Out-Null

                    }

                }

            }

            'Docs' {

                if (!$OutDir) {

                    $OutDir = (Get-Location).Path + '\_hcposh_docs'

                }

                $params = @{

                    Data    = $true

                    OutVar  = $true

                    NoSplit = $true

                }

                if ($Path) {

                    $params.Add('Path', $Path)

                }

                $OutDataArray = HCPosh @params | Where-Object { $_ };

                forEach ($OutData in $OutDataArray) {

                    $NewOutDir = $OutDir + '\' + $OutData._hcposh.FileBaseName

                    if ($OutZip) {

                        if ($OutVar) {

                            (Invoke-Docs -Data $OutData -OutDir $NewOutDir -OutZip | Select-Object DocsData).DocsData

                        }

                        else {

                            Invoke-Docs -Data $OutData -OutDir $NewOutDir -OutZip | Out-Null

                        }

                    }

                    else {

                        if ($OutVar) {

                            (Invoke-Docs -Data $OutData -OutDir $NewOutDir | Select-Object DocsData).DocsData

                        }

                        else {

                            Invoke-Docs -Data $OutData -OutDir $NewOutDir | Out-Null

                        }

                    }

                }

            }

            'Installer' {

                $Files = Get-ChildItem | Where-Object { $_.Extension -eq '.hcx' -or $_.Extension -eq '.sm' }

                try {

                    if (($Files | Measure-Object).Count -eq 0) { throw; }

                }

                catch {

                    $Msg = "Unable to find any hcx or sm files in current directory."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';

                }

                $Pipe = $Files | Select-Object @{ n = 'File'; e = { $_.FullName } }, @{ n = 'OutDir'; e = { "$($_.Directory)\_hcposh_installer\$($_.BaseName)" } }

                if ($OutVar) {

                    ($Pipe | Invoke-Installer | Select-Object RawData).RawData

                }

                else {

                    $Pipe | Invoke-Installer | Out-Null

                }

            }

            'Diagrams' {

                if (!$OutDir) {

                    $OutDir = (Get-Location).Path + '\_hcposh_diagrams'

                }

                if ($OutZip) {

                    $OutDataArray = HCPosh -Docs -OutVar -OutDir $OutDir -OutZip | Where-Object { $_ };

                }

                else {

                    $OutDataArray = HCPosh -Docs -OutVar -OutDir $OutDir | Where-Object { $_ };

                }

                forEach ($OutData in $OutDataArray) {

                    $NewOutDir = $OutDir + '\' + $OutData._hcposh.FileBaseName

                    if ($OutZip) {

                        Invoke-Diagrams -DocsData $OutData -OutDir $NewOutDir -OutZip | Out-Null

                    }

                    else {

                        Invoke-Diagrams -DocsData $OutData -OutDir $NewOutDir | Out-Null

                    }

                }

            }

            'Impact' {

                if ($ConfigPath -or $OutDir) {

                    if ($ConfigPath -and $OutDir) {

                        Invoke-ImpactAnalysis -Server $Server -ConfigPath $ConfigPath -OutDir $OutDir

                    }

                    elseif ($ConfigPath) {

                        Invoke-ImpactAnalysis -Server $Server -ConfigPath $ConfigPath

                    }

                    else {

                        Invoke-ImpactAnalysis -Server $Server -OutDir $OutDir

                    }

                }

                else {

                    Invoke-ImpactAnalysis -Server $Server

                }

            }

            'Graphviz' {

                if ($InputDir) {

                    $GvFiles = Get-ChildItem -Path $InputDir | Where-Object Extension -eq '.gv'

                }

                else {

                    $GvFiles = Get-ChildItem | Where-Object Extension -eq '.gv'

                }

                try {

                    if (($GvFiles | Measure-Object).Count -eq 0) { throw; }

                }

                catch {

                    $Msg = "Unable to find any gv files in current directory."; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';

                }

                if (!$OutType) { $OutType = 'svg' }

                if (!$OutDir) {

                    if ($InputDir) {

                        $OutDir = $InputDir

                    }

                    else {

                        $OutDir = (Get-Location).Path

                    }

                }

                If (!(Test-Path $OutDir)) {

                    New-Item -ItemType Directory -Force -Path $OutDir -ErrorAction Stop | Out-Null

                }

                $Pipe = $GvFiles | Select-Object @{ n = 'File'; e = { $_.FullName } }, @{ n = 'OutType'; e = { $OutType } }, @{ n = 'OutFile'; e = { "$($OutDir)\$($_.BaseName).$($OutType)" } }

                $Pipe | Invoke-Graphviz | Out-Null

            }

        }

    }

}

Export-ModuleMember -Function HCPosh

# SIG # Begin signature block

# MIIpNAYJKoZIhvcNAQcCoIIpJTCCKSECAQExDzANBglghkgBZQMEAgEFADB5Bgor

# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG

# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCA8n5xgK4Xc8ruD

# 8ZZmZXza92F1XIG/MR2s8C/tzQFN1aCCDiMwggawMIIEmKADAgECAhAIrUCyYNKc

# TJ9ezam9k67ZMA0GCSqGSIb3DQEBDAUAMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQK

# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNV

# BAMTGERpZ2lDZXJ0IFRydXN0ZWQgUm9vdCBHNDAeFw0yMTA0MjkwMDAwMDBaFw0z

# NjA0MjgyMzU5NTlaMGkxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwg

# SW5jLjFBMD8GA1UEAxM4RGlnaUNlcnQgVHJ1c3RlZCBHNCBDb2RlIFNpZ25pbmcg

# UlNBNDA5NiBTSEEzODQgMjAyMSBDQTEwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAw

# ggIKAoICAQDVtC9C0CiteLdd1TlZG7GIQvUzjOs9gZdwxbvEhSYwn6SOaNhc9es0

# JAfhS0/TeEP0F9ce2vnS1WcaUk8OoVf8iJnBkcyBAz5NcCRks43iCH00fUyAVxJr

# Q5qZ8sU7H/Lvy0daE6ZMswEgJfMQ04uy+wjwiuCdCcBlp/qYgEk1hz1RGeiQIXhF

# LqGfLOEYwhrMxe6TSXBCMo/7xuoc82VokaJNTIIRSFJo3hC9FFdd6BgTZcV/sk+F

# LEikVoQ11vkunKoAFdE3/hoGlMJ8yOobMubKwvSnowMOdKWvObarYBLj6Na59zHh

# 3K3kGKDYwSNHR7OhD26jq22YBoMbt2pnLdK9RBqSEIGPsDsJ18ebMlrC/2pgVItJ

# wZPt4bRc4G/rJvmM1bL5OBDm6s6R9b7T+2+TYTRcvJNFKIM2KmYoX7BzzosmJQay

# g9Rc9hUZTO1i4F4z8ujo7AqnsAMrkbI2eb73rQgedaZlzLvjSFDzd5Ea/ttQokbI

# YViY9XwCFjyDKK05huzUtw1T0PhH5nUwjewwk3YUpltLXXRhTT8SkXbev1jLchAp

# QfDVxW0mdmgRQRNYmtwmKwH0iU1Z23jPgUo+QEdfyYFQc4UQIyFZYIpkVMHMIRro

# OBl8ZhzNeDhFMJlP/2NPTLuqDQhTQXxYPUez+rbsjDIJAsxsPAxWEQIDAQABo4IB

# WTCCAVUwEgYDVR0TAQH/BAgwBgEB/wIBADAdBgNVHQ4EFgQUaDfg67Y7+F8Rhvv+

# YXsIiGX0TkIwHwYDVR0jBBgwFoAU7NfjgtJxXWRM3y5nP+e6mK4cD08wDgYDVR0P

# AQH/BAQDAgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMDMHcGCCsGAQUFBwEBBGswaTAk

# BggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEEGCCsGAQUFBzAC

# hjVodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVzdGVkUm9v

# dEc0LmNydDBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsMy5kaWdpY2VydC5j

# b20vRGlnaUNlcnRUcnVzdGVkUm9vdEc0LmNybDAcBgNVHSAEFTATMAcGBWeBDAED

# MAgGBmeBDAEEATANBgkqhkiG9w0BAQwFAAOCAgEAOiNEPY0Idu6PvDqZ01bgAhql

# +Eg08yy25nRm95RysQDKr2wwJxMSnpBEn0v9nqN8JtU3vDpdSG2V1T9J9Ce7FoFF

# UP2cvbaF4HZ+N3HLIvdaqpDP9ZNq4+sg0dVQeYiaiorBtr2hSBh+3NiAGhEZGM1h

# mYFW9snjdufE5BtfQ/g+lP92OT2e1JnPSt0o618moZVYSNUa/tcnP/2Q0XaG3Ryw

# YFzzDaju4ImhvTnhOE7abrs2nfvlIVNaw8rpavGiPttDuDPITzgUkpn13c5Ubdld

# AhQfQDN8A+KVssIhdXNSy0bYxDQcoqVLjc1vdjcshT8azibpGL6QB7BDf5WIIIJw

# 8MzK7/0pNVwfiThV9zeKiwmhywvpMRr/LhlcOXHhvpynCgbWJme3kuZOX956rEnP

# LqR0kq3bPKSchh/jwVYbKyP/j7XqiHtwa+aguv06P0WmxOgWkVKLQcBIhEuWTatE

# QOON8BUozu3xGFYHKi8QxAwIZDwzj64ojDzLj4gLDb879M4ee47vtevLt/B3E+bn

# KD+sEq6lLyJsQfmCXBVmzGwOysWGw/YmMwwHS6DTBwJqakAwSEs0qFEgu60bhQji

# WQ1tygVQK+pKHJ6l/aCnHwZ05/LWUpD9r4VIIflXO7ScA+2GRfS0YW6/aOImYIbq

# yK+p/pQd52MbOoZWeE4wggdrMIIFU6ADAgECAhADsuWQRbq1qj3ect5VAxkgMA0G

# CSqGSIb3DQEBCwUAMGkxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwg

# SW5jLjFBMD8GA1UEAxM4RGlnaUNlcnQgVHJ1c3RlZCBHNCBDb2RlIFNpZ25pbmcg

# UlNBNDA5NiBTSEEzODQgMjAyMSBDQTEwHhcNMjMwNTE2MDAwMDAwWhcNMjYwNTIw

# MjM1OTU5WjBzMQswCQYDVQQGEwJVUzENMAsGA1UECBMEVXRhaDEVMBMGA1UEBxMM

# U291dGggSm9yZGFuMR4wHAYDVQQKExVIZWFsdGggQ2F0YWx5c3QsIEluYy4xHjAc

# BgNVBAMTFUhlYWx0aCBDYXRhbHlzdCwgSW5jLjCCAiIwDQYJKoZIhvcNAQEBBQAD

# ggIPADCCAgoCggIBAObA/ZMm0ngFmqmUW8QpvB5R2WwUIbCHZkoYN3LLelwf6FCX

# NNCZOxBz6CppjoQ4kL1HtQNpENDPMTMxG5/lMTlZvf1mu/mYEYXOddPsgv+QP4bd

# P+9w+NVE4vguFffuBSzQi8KmnrgGgDVLuhTjvN5WlP/AhzHldDNhKtkQh/bzIgrL

# sivSLRo3ow2kVCzJTZYwXudZ/cI2vrNf0jKRQgcC/ao1emvt68RNQJPxDpmd4Eb5

# DOF+jd9w0Sb77/m/ir2rTbVjoLOlPxD9FlGsdB+kyMV45D9hYuD4D1s998j/wDeL

# ezs/sXgrJToXS0Yjpxaul++7GVuLYgBQvB1UAVejXjDuJO2FF7gUeJihWk/OKmaW

# kQTGavOt8/RcOrru1LdJ733fJnMZsmonQPokOdlUADNKBSAEskgRbD3SQ/Y9LKcm

# 8w/hj9L6PSXBF/E/Kaq92SArEjkvYDlsXp7xslKgAxP26pzq7/hn2gro6/jjLUyh

# xt60j8Pm0tjhOdQhCcioRO2zouopusZmPMO6H95T1PEkhd/cEmkywmMqOMVMpAUg

# O796xTvZ4kjOsaQTOKvAEJDjc42EHZd2RWcVUMI41iHpNILkYHSPHe4mVQC8BdZx

# qzGI6ay7U1mEvCYlMYQZwDZ/xYxI7q0YBjQOm5jVuPvAHmlE6pUiWuGz3JKXAgMB

# AAGjggIDMIIB/zAfBgNVHSMEGDAWgBRoN+Drtjv4XxGG+/5hewiIZfROQjAdBgNV

# HQ4EFgQUaRlF8Nw4+YnDPBwkIaUEjV2a1MowDgYDVR0PAQH/BAQDAgeAMBMGA1Ud

# JQQMMAoGCCsGAQUFBwMDMIG1BgNVHR8Ega0wgaowU6BRoE+GTWh0dHA6Ly9jcmwz

# LmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRHNENvZGVTaWduaW5nUlNBNDA5

# NlNIQTM4NDIwMjFDQTEuY3JsMFOgUaBPhk1odHRwOi8vY3JsNC5kaWdpY2VydC5j

# b20vRGlnaUNlcnRUcnVzdGVkRzRDb2RlU2lnbmluZ1JTQTQwOTZTSEEzODQyMDIx

# Q0ExLmNybDA+BgNVHSAENzA1MDMGBmeBDAEEATApMCcGCCsGAQUFBwIBFhtodHRw

# Oi8vd3d3LmRpZ2ljZXJ0LmNvbS9DUFMwgZQGCCsGAQUFBwEBBIGHMIGEMCQGCCsG

# AQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5jb20wXAYIKwYBBQUHMAKGUGh0

# dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRHNENvZGVT

# aWduaW5nUlNBNDA5NlNIQTM4NDIwMjFDQTEuY3J0MAkGA1UdEwQCMAAwDQYJKoZI

# hvcNAQELBQADggIBABpsvUpsQVtdpqQNUxSC3Ix3qXeJ81vNGS7sXYxlYhvEChJF

# gixfjebMfHZu0YLJ3xIeX7VwW8wyF+9RkI4RnPtkJD2JSmDd2mH4y/gy138EZMHa

# n+XbMeMXcsOTL9cI5zUBw86EGj/xcL5NIj9DDym8DPh9/OZY5L5sGXrO1VjA/mUM

# lnpqpoNZaNsjQ7Gla6K5BC0xIoHxNYTX1uRSjmYkKdnNMTcHqOLcgxwaXzix26Bs

# n1pKO+NMe3DqthjFX0Pe6Z47b3GrjEYT4IoJP0N3H1crDfpm2vlBMwdSrNvr+epH

# VfZqOx8/VwS7VKygkP5Dp4zXyOa3W+11sMQIQ4AS4lER4g1GS/DmrlP2FWYGaaVJ

# YB01y1tWA23V3VM/Z/aeOR3uUE8p6tc5AFu2jNa16l9f5XNp9p5Fx2QzFh6pGqBu

# d0ict3T/vGWZWxzOhWqqp/Xd1oV5lMwW50t9CEKWpHidZXZZUkw2vwLnkZZzpFzs

# +b1HFxPKAvBXcwWO9ZV+FGeDk09ZBy3E4hY9JaF2Z9KiYa8EMzEOtHaHAkynD6Za

# TFhRSAnO3OMixVE/ro6dW7drPYKxKKYf1Y5QXaPU9ijer9ub0gnYDjPqsh3gWolp

# 7vjAE7t5JDE1PQDqCuuUn8FQakB/NJVs3Nt/Xz5ADD7e6h6JADmUr1l2e4agMYIa

# ZzCCGmMCAQEwfTBpMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIElu

# Yy4xQTA/BgNVBAMTOERpZ2lDZXJ0IFRydXN0ZWQgRzQgQ29kZSBTaWduaW5nIFJT

# QTQwOTYgU0hBMzg0IDIwMjEgQ0ExAhADsuWQRbq1qj3ect5VAxkgMA0GCWCGSAFl

# AwQCAQUAoHwwEAYKKwYBBAGCNwIBDDECMAAwGQYJKoZIhvcNAQkDMQwGCisGAQQB

# gjcCAQQwHAYKKwYBBAGCNwIBCzEOMAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkE

# MSIEIPBDZnBas9uXxVNi2ZIM13kQsFyUe4YZV4bQIoIMBYgDMA0GCSqGSIb3DQEB

# AQUABIICAHjnX9q2GioPAglwjbhNAqRvRKBvJULvxGG3unMIDgyCJZj++5tz2V77

# HuArES4b02JpR9PMJdPodfjiIDKMCasQnh1zA1FGAx0dkppEOnflEk7XsAh3q0Yu

# /XwUHZmAnndTwlCmyFt/GtZuUP5KFWDdwyaBvSPGgPw818qzyUcfRLVEnZQsaE8s

# zE1GLRloy5Lea1FDiCtjeE7FJEdsrksda7gxgkSpBVV0ggVEV/mA7+zy0pgdGwvq

# FNGOVnp7SdnktZf4KeIhq2WzpWyre1021OPFij0gfr7x8+T3fsaGoEJ2WuNlRikU

# MXTe9XrFwXrEfU3ratJzlNJm7Vx6GnV245AV+sJz/DvjxT9Wz+yvDLUVAQHQppZt

# xS725TXYrJ3NZmSWYWlsmwWuJ0sWaOLZz/LlFpR3seKgjIl4sYTMbEaHlh0UrEYl

# y+qe366llTw5nvdTSFFCX9B/uTm9HT4tmPwu1uhno/mt/gWu/UWwsRo0yuNXtRIe

# E/Wpqp5KO/lQnifQIIEXKmvFFMEWermILiEVRlYJOo63c2ObcreuS6WkTUP2MCnG

# ls+vJ/40WXgfHa+ilBpQ8JX4odkKgMufg/yW2wv6RX/qJzf2eYH3/mbD2EzLNCsi

# AGsd4XiTm8V7tz181ZZsfaMmM66OsvBiXSDmGdXqVGv0dbeWdXFgoYIXPTCCFzkG

# CisGAQQBgjcDAwExghcpMIIXJQYJKoZIhvcNAQcCoIIXFjCCFxICAQMxDzANBglg

# hkgBZQMEAgEFADB3BgsqhkiG9w0BCRABBKBoBGYwZAIBAQYJYIZIAYb9bAcBMDEw

# DQYJYIZIAWUDBAIBBQAEIHzi2cFgUxIWKx9RLwiHOfezMPOGRJNMW01eUsc9aFcU

# AhAZOIVdskmWss4WwAQCn97FGA8yMDIzMDUxNzE3MDkyNlqgghMHMIIGwDCCBKig

# AwIBAgIQDE1pckuU+jwqSj0pB4A9WjANBgkqhkiG9w0BAQsFADBjMQswCQYDVQQG

# EwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xOzA5BgNVBAMTMkRpZ2lDZXJ0

# IFRydXN0ZWQgRzQgUlNBNDA5NiBTSEEyNTYgVGltZVN0YW1waW5nIENBMB4XDTIy

# MDkyMTAwMDAwMFoXDTMzMTEyMTIzNTk1OVowRjELMAkGA1UEBhMCVVMxETAPBgNV

# BAoTCERpZ2lDZXJ0MSQwIgYDVQQDExtEaWdpQ2VydCBUaW1lc3RhbXAgMjAyMiAt

# IDIwggIiMA0GCSqGSIb3DQEBAQUAA4ICDwAwggIKAoICAQDP7KUmOsap8mu7jcEN

# mtuh6BSFdDMaJqzQHFUeHjZtvJJVDGH0nQl3PRWWCC9rZKT9BoMW15GSOBwxApb7

# crGXOlWvM+xhiummKNuQY1y9iVPgOi2Mh0KuJqTku3h4uXoW4VbGwLpkU7sqFudQ

# SLuIaQyIxvG+4C99O7HKU41Agx7ny3JJKB5MgB6FVueF7fJhvKo6B332q27lZt3i

# XPUv7Y3UTZWEaOOAy2p50dIQkUYp6z4m8rSMzUy5Zsi7qlA4DeWMlF0ZWr/1e0Bu

# bxaompyVR4aFeT4MXmaMGgokvpyq0py2909ueMQoP6McD1AGN7oI2TWmtR7aeFgd

# Oej4TJEQln5N4d3CraV++C0bH+wrRhijGfY59/XBT3EuiQMRoku7mL/6T+R7Nu8G

# RORV/zbq5Xwx5/PCUsTmFntafqUlc9vAapkhLWPlWfVNL5AfJ7fSqxTlOGaHUQhr

# +1NDOdBk+lbP4PQK5hRtZHi7mP2Uw3Mh8y/CLiDXgazT8QfU4b3ZXUtuMZQpi+ZB

# pGWUwFjl5S4pkKa3YWT62SBsGFFguqaBDwklU/G/O+mrBw5qBzliGcnWhX8T2Y15

# z2LF7OF7ucxnEweawXjtxojIsG4yeccLWYONxu71LHx7jstkifGxxLjnU15fVdJ9

# GSlZA076XepFcxyEftfO4tQ6dwIDAQABo4IBizCCAYcwDgYDVR0PAQH/BAQDAgeA

# MAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUHAwgwIAYDVR0gBBkw

# FzAIBgZngQwBBAIwCwYJYIZIAYb9bAcBMB8GA1UdIwQYMBaAFLoW2W1NhS9zKXaa

# L3WMaiCPnshvMB0GA1UdDgQWBBRiit7QYfyPMRTtlwvNPSqUFN9SnDBaBgNVHR8E

# UzBRME+gTaBLhklodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRUcnVz

# dGVkRzRSU0E0MDk2U0hBMjU2VGltZVN0YW1waW5nQ0EuY3JsMIGQBggrBgEFBQcB

# AQSBgzCBgDAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMFgG

# CCsGAQUFBzAChkxodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRU

# cnVzdGVkRzRSU0E0MDk2U0hBMjU2VGltZVN0YW1waW5nQ0EuY3J0MA0GCSqGSIb3

# DQEBCwUAA4ICAQBVqioa80bzeFc3MPx140/WhSPx/PmVOZsl5vdyipjDd9Rk/BX7

# NsJJUSx4iGNVCUY5APxp1MqbKfujP8DJAJsTHbCYidx48s18hc1Tna9i4mFmoxQq

# RYdKmEIrUPwbtZ4IMAn65C3XCYl5+QnmiM59G7hqopvBU2AJ6KO4ndetHxy47JhB

# 8PYOgPvk/9+dEKfrALpfSo8aOlK06r8JSRU1NlmaD1TSsht/fl4JrXZUinRtytIF

# Zyt26/+YsiaVOBmIRBTlClmia+ciPkQh0j8cwJvtfEiy2JIMkU88ZpSvXQJT657i

# nuTTH4YBZJwAwuladHUNPeF5iL8cAZfJGSOA1zZaX5YWsWMMxkZAO85dNdRZPkOa

# GK7DycvD+5sTX2q1x+DzBcNZ3ydiK95ByVO5/zQQZ/YmMph7/lxClIGUgp2sCovG

# SxVK05iQRWAzgOAj3vgDpPZFR+XOuANCR+hBNnF3rf2i6Jd0Ti7aHh2MWsgemtXC

# 8MYiqE+bvdgcmlHEL5r2X6cnl7qWLoVXwGDneFZ/au/ClZpLEQLIgpzJGgV8unG1

# TnqZbPTontRamMifv427GFxD9dAq6OJi7ngE273R+1sKqHB+8JeEeOMIA11HLGOo

# JTiXAdI/Otrl5fbmm9x+LMz/F0xNAKLY1gEOuIvu5uByVYksJxlh9ncBjDCCBq4w

# ggSWoAMCAQICEAc2N7ckVHzYR6z9KGYqXlswDQYJKoZIhvcNAQELBQAwYjELMAkG

# A1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRp

# Z2ljZXJ0LmNvbTEhMB8GA1UEAxMYRGlnaUNlcnQgVHJ1c3RlZCBSb290IEc0MB4X

# DTIyMDMyMzAwMDAwMFoXDTM3MDMyMjIzNTk1OVowYzELMAkGA1UEBhMCVVMxFzAV

# BgNVBAoTDkRpZ2lDZXJ0LCBJbmMuMTswOQYDVQQDEzJEaWdpQ2VydCBUcnVzdGVk

# IEc0IFJTQTQwOTYgU0hBMjU2IFRpbWVTdGFtcGluZyBDQTCCAiIwDQYJKoZIhvcN

# AQEBBQADggIPADCCAgoCggIBAMaGNQZJs8E9cklRVcclA8TykTepl1Gh1tKD0Z5M

# om2gsMyD+Vr2EaFEFUJfpIjzaPp985yJC3+dH54PMx9QEwsmc5Zt+FeoAn39Q7SE

# 2hHxc7Gz7iuAhIoiGN/r2j3EF3+rGSs+QtxnjupRPfDWVtTnKC3r07G1decfBmWN

# lCnT2exp39mQh0YAe9tEQYncfGpXevA3eZ9drMvohGS0UvJ2R/dhgxndX7RUCyFo

# bjchu0CsX7LeSn3O9TkSZ+8OpWNs5KbFHc02DVzV5huowWR0QKfAcsW6Th+xtVhN

# ef7Xj3OTrCw54qVI1vCwMROpVymWJy71h6aPTnYVVSZwmCZ/oBpHIEPjQ2OAe3Vu

# JyWQmDo4EbP29p7mO1vsgd4iFNmCKseSv6De4z6ic/rnH1pslPJSlRErWHRAKKtz

# Q87fSqEcazjFKfPKqpZzQmiftkaznTqj1QPgv/CiPMpC3BhIfxQ0z9JMq++bPf4O

# uGQq+nUoJEHtQr8FnGZJUlD0UfM2SU2LINIsVzV5K6jzRWC8I41Y99xh3pP+OcD5

# sjClTNfpmEpYPtMDiP6zj9NeS3YSUZPJjAw7W4oiqMEmCPkUEBIDfV8ju2TjY+Cm

# 4T72wnSyPx4JduyrXUZ14mCjWAkBKAAOhFTuzuldyF4wEr1GnrXTdrnSDmuZDNIz

# tM2xAgMBAAGjggFdMIIBWTASBgNVHRMBAf8ECDAGAQH/AgEAMB0GA1UdDgQWBBS6

# FtltTYUvcyl2mi91jGogj57IbzAfBgNVHSMEGDAWgBTs1+OC0nFdZEzfLmc/57qY

# rhwPTzAOBgNVHQ8BAf8EBAMCAYYwEwYDVR0lBAwwCgYIKwYBBQUHAwgwdwYIKwYB

# BQUHAQEEazBpMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5jb20w

# QQYIKwYBBQUHMAKGNWh0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2Vy

# dFRydXN0ZWRSb290RzQuY3J0MEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwz

# LmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydFRydXN0ZWRSb290RzQuY3JsMCAGA1UdIAQZ

# MBcwCAYGZ4EMAQQCMAsGCWCGSAGG/WwHATANBgkqhkiG9w0BAQsFAAOCAgEAfVmO

# wJO2b5ipRCIBfmbW2CFC4bAYLhBNE88wU86/GPvHUF3iSyn7cIoNqilp/GnBzx0H

# 6T5gyNgL5Vxb122H+oQgJTQxZ822EpZvxFBMYh0MCIKoFr2pVs8Vc40BIiXOlWk/

# R3f7cnQU1/+rT4osequFzUNf7WC2qk+RZp4snuCKrOX9jLxkJodskr2dfNBwCnzv

# qLx1T7pa96kQsl3p/yhUifDVinF2ZdrM8HKjI/rAJ4JErpknG6skHibBt94q6/ae

# sXmZgaNWhqsKRcnfxI2g55j7+6adcq/Ex8HBanHZxhOACcS2n82HhyS7T6NJuXdm

# kfFynOlLAlKnN36TU6w7HQhJD5TNOXrd/yVjmScsPT9rp/Fmw0HNT7ZAmyEhQNC3

# EyTN3B14OuSereU0cZLXJmvkOHOrpgFPvT87eK1MrfvElXvtCl8zOYdBeHo46Zzh

# 3SP9HSjTx/no8Zhf+yvYfvJGnXUsHicsJttvFXseGYs2uJPU5vIXmVnKcPA3v5gA

# 3yAWTyf7YGcWoWa63VXAOimGsJigK+2VQbc61RWYMbRiCQ8KvYHZE/6/pNHzV9m8

# BPqC3jLfBInwAM1dwvnQI38AC+R2AibZ8GV2QqYphwlHK+Z/GqSFD/yYlvZVVCsf

# gPrA8g4r5db7qS9EFUrnEw4d2zc4GqEr9u3WfPwwggWNMIIEdaADAgECAhAOmxiO

# +dAt5+/bUOIIQBhaMA0GCSqGSIb3DQEBDAUAMGUxCzAJBgNVBAYTAlVTMRUwEwYD

# VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAi

# BgNVBAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0yMjA4MDEwMDAw

# MDBaFw0zMTExMDkyMzU5NTlaMGIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdp

# Q2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xITAfBgNVBAMTGERp

# Z2lDZXJ0IFRydXN0ZWQgUm9vdCBHNDCCAiIwDQYJKoZIhvcNAQEBBQADggIPADCC

# AgoCggIBAL/mkHNo3rvkXUo8MCIwaTPswqclLskhPfKK2FnC4SmnPVirdprNrnsb

# hA3EMB/zG6Q4FutWxpdtHauyefLKEdLkX9YFPFIPUh/GnhWlfr6fqVcWWVVyr2iT

# cMKyunWZanMylNEQRBAu34LzB4TmdDttceItDBvuINXJIB1jKS3O7F5OyJP4IWGb

# NOsFxl7sWxq868nPzaw0QF+xembud8hIqGZXV59UWI4MK7dPpzDZVu7Ke13jrclP

# XuU15zHL2pNe3I6PgNq2kZhAkHnDeMe2scS1ahg4AxCN2NQ3pC4FfYj1gj4QkXCr

# VYJBMtfbBHMqbpEBfCFM1LyuGwN1XXhm2ToxRJozQL8I11pJpMLmqaBn3aQnvKFP

# ObURWBf3JFxGj2T3wWmIdph2PVldQnaHiZdpekjw4KISG2aadMreSx7nDmOu5tTv

# kpI6nj3cAORFJYm2mkQZK37AlLTSYW3rM9nF30sEAMx9HJXDj/chsrIRt7t/8tWM

# cCxBYKqxYxhElRp2Yn72gLD76GSmM9GJB+G9t+ZDpBi4pncB4Q+UDCEdslQpJYls

# 5Q5SUUd0viastkF13nqsX40/ybzTQRESW+UQUOsxxcpyFiIJ33xMdT9j7CFfxCBR

# a2+xq4aLT8LWRV+dIPyhHsXAj6KxfgommfXkaS+YHS312amyHeUbAgMBAAGjggE6

# MIIBNjAPBgNVHRMBAf8EBTADAQH/MB0GA1UdDgQWBBTs1+OC0nFdZEzfLmc/57qY

# rhwPTzAfBgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzAOBgNVHQ8BAf8E

# BAMCAYYweQYIKwYBBQUHAQEEbTBrMCQGCCsGAQUFBzABhhhodHRwOi8vb2NzcC5k

# aWdpY2VydC5jb20wQwYIKwYBBQUHMAKGN2h0dHA6Ly9jYWNlcnRzLmRpZ2ljZXJ0

# LmNvbS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcnQwRQYDVR0fBD4wPDA6oDig

# NoY0aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9v

# dENBLmNybDARBgNVHSAECjAIMAYGBFUdIAAwDQYJKoZIhvcNAQEMBQADggEBAHCg

# v0NcVec4X6CjdBs9thbX979XB72arKGHLOyFXqkauyL4hxppVCLtpIh3bb0aFPQT

# SnovLbc47/T/gLn4offyct4kvFIDyE7QKt76LVbP+fT3rDB6mouyXtTP0UNEm0Mh

# 65ZyoUi0mcudT6cGAxN3J0TU53/oWajwvy8LpunyNDzs9wPHh6jSTEAZNUZqaVSw

# uKFWjuyk1T3osdz9HNj0d1pcVIxv76FQPfx2CWiEn2/K2yCNNWAcAgPLILCsWKAO

# QGPFmCLBsln1VWvPJ6tsds5vIy30fnFqI2si/xK4VC0nftg62fC2h5b9W9FcrBjD

# TZ9ztwGpn1eqXijiuZQxggN2MIIDcgIBATB3MGMxCzAJBgNVBAYTAlVTMRcwFQYD

# VQQKEw5EaWdpQ2VydCwgSW5jLjE7MDkGA1UEAxMyRGlnaUNlcnQgVHJ1c3RlZCBH

# NCBSU0E0MDk2IFNIQTI1NiBUaW1lU3RhbXBpbmcgQ0ECEAxNaXJLlPo8Kko9KQeA

# PVowDQYJYIZIAWUDBAIBBQCggdEwGgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEE

# MBwGCSqGSIb3DQEJBTEPFw0yMzA1MTcxNzA5MjZaMCsGCyqGSIb3DQEJEAIMMRww

# GjAYMBYEFPOHIk2GM4KSNamUvL2Plun+HHxzMC8GCSqGSIb3DQEJBDEiBCBcIzFv

# sAiWQAYdSc3Z9Zr/XEeqEhhjQY8uVUSp6QjmbDA3BgsqhkiG9w0BCRACLzEoMCYw

# JDAiBCDH9OG+MiiJIKviJjq+GsT8T+Z4HC1k0EyAdVegI7W2+jANBgkqhkiG9w0B

# AQEFAASCAgCrr/Zde2YTR7I76e/jDhN6x1Kiq/3mN+tqVRMSqaqrKFQ2MRweO835

# iMx52CMM4YLmWXhLuxYrLI9KxGr/7wdzWH9ad31C7TdGy9i4ZdBZjZ67mXiqDwmF

# inJtkbQIqB1ypqRytckhnRI2LEQr41uD1vuG9n0ImA5nJFNynd//dCImgDPf59L1

# KrY/QIqlDzoX6cTDicDkfGe7fbH7PvGPz9Em7gREpfdkYKbdFpHxdzy1es84h6nw

# /PIMXJYRAKt/efhv2HmnRYZY0ZC5XDth/WcoOT9hSW/ngz5kANyfrWZ4zcj0ZkF1

# wo6o4E5GnIro0urVHgJfn0OA0kH47XItyr/aqYV6+o91N5M7et65AJFl8ioZ31oy

# 9nqFNsRZUrsIGcQVy4DA33oL+525MN+eZ0ER7sV9RuXSadiGepWm+JHoJ02qOXco

# VUbZulpKCVMvvxzzUwcuG3aDCjyJIGTSTQqlMQHiTRXDX82Z6vxWtX/B8Yg5lIaZ

# i5bmhjryvEt4hD3lgK7cIX6PxLyJx15M7g7HZUMMAXYBXMlZlGlM5Rpu/pfIdsM6

# LDPVppA5Se4tv+3TQ9gZAPEB4gHTXhTPmKRDKPTWypffoYhtwHZaLaHjyOgDwpwm

# BCBXQ1hLtMfGvQVTe+uOv3C/YF4lZREWLKj+83zsFX7rqSC65Mrtug==

# SIG # End signature block