HCPosh

3.0.10.0

functions/data/Split-ObjectToFiles.ps1

function Split-ObjectToFiles {
    [CmdletBinding()]
    param
    (
        [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)]
        [psobject]$Data,
        [Parameter(Mandatory = $True, ValueFromPipelineByPropertyName)]
        [string]$SplitDirectory
    )
    process {
        try {
            #create base directory
            New-Directory -Dir $SplitDirectory -Force
            
            #region CREATE DATAMART FILES
            $Exclusions = @('DatamartNoSpacesNM', 'Entities', 'SourcedByEntities', '_hcposh', 'MaxLastModifiedTimestamp')
            $Out = @()
            $Props = $Data.psobject.properties.name | Where-Object { $Data.$_ }
            forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                $OutObj = New-EmptyProperty
                $OutObj.Name = $Data.DatamartNM
                $OutObj.Property = $Prop
                $OutObj.Value = $Data."$($OutObj.Property)"
                if ($OutObj) { $Out += $OutObj }
            }
            $OutFile = "$($SplitDirectory)\_Datamart.csv"
            if ($Out) {
                $Out | Sort-Object Name, @{
                    e = {
                        if ($_.Property -eq 'ContentId') { 0 }
                        else { 1 }
                    }
                }, Property | Export-Csv $OutFile -Force -NoTypeInformation
            }
            #endregion
            #region CREATE SOURCE FILES
            $SourcedByColumns = @()
            forEach ($Entity in $Data.SourcedByEntities | Where-Object TableOrigin -eq 'External' | Sort-Object FullyQualifiedNM) {
                forEach ($Column in $Entity.SourcedByColumns | Sort-Object FullyQualifiedNM) {
                    $SourcedByColumn = New-Object PSObject
                    $SourcedByColumn | Add-Member -Type NoteProperty -Name DatabaseNM -Value $Entity.DatabaseNM
                    $SourcedByColumn | Add-Member -Type NoteProperty -Name SchemaNM -Value $Entity.SchemaNM
                    $SourcedByColumn | Add-Member -Type NoteProperty -Name TableNM -Value $Entity.TableNM
                    $SourcedByColumn | Add-Member -Type NoteProperty -Name ColumnNM -Value $Column.ColumnNM
                    $SourcedByColumns += $SourcedByColumn
                }
            }
            $ByDatabase = $SourcedByColumns | Group-Object DatabaseNM
            forEach ($db in $ByDatabase) {
                $db.Group | Sort-Object SchemaNM, TableNM, ColumnNM | Export-Csv -NoTypeInformation "$SplitDirectory\Sources-$($db.Name).csv" -Force | Out-Null
            }
            #endregion
            #region CREATE ENTITY FILES
            $Exclusions = @('Bindings', 'Columns', 'Indexes', 'SourcedByEntities', 'FullyQualifiedNames', 'LastModifiedTimestamp', 'DataEntryData', 'OverridingExtensionView')
            forEach ($Group in $Data.Entities | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Entity in $Group.Group) {
                    $Props = $Entity.psobject.properties.name | Where-Object { $_ }
                    forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                        $OutObj = New-EmptyProperty
                        $OutObj.Name = $Entity.FullyQualifiedNames.Table
                        $OutObj.Property = $Prop
                        $OutObj.Value = $($Entity."$($OutObj.Property)" -replace "`r`n", "")
                        if ($OutObj) { $Out += $OutObj }
                    }
                }
                $OutFile = "$($SplitDirectory)\Entities-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE BINDING FILES
            $Exclusions = @('BindingNameNoSpaces', 'Script', 'SourcedByEntities', 'IncrementalConfigurations')
            forEach ($Group in $Data.Entities.Bindings | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Binding in $Group.Group) {
                    $Props = $Binding.psobject.properties.name | Where-Object { $_ }
                    forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                        $OutObj = New-EmptyProperty
                        $OutObj.Name = $Binding.BindingName
                        $OutObj.Property = $Prop
                        $OutObj.Value = $($Binding."$($OutObj.Property)" -replace "`r`n", "")
                        if ($OutObj) { $Out += $OutObj }
                    }
                }
                $OutFile = "$($SplitDirectory)\Bindings-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE SQL FILES
            forEach ($Binding in $Data.Entities.Bindings) {
                switch ($Binding.BindingType) {
                    'SqlBinding' { 
                        $OutFile = "$($SplitDirectory)\SQL-$($Binding.ClassificationCode)-$(Get-CleanFileName $Binding.BindingName -RemoveSpace).sql"
                        $Binding.Script | Out-File $OutFile -Encoding Default -Force
                    }
                    'RBinding' {
                        $OutFile = "$($SplitDirectory)\R-$($Binding.ClassificationCode)-$(Get-CleanFileName $Binding.BindingName -RemoveSpace).r"
                        $Binding.Script | Out-File $OutFile -Encoding Default -Force
                    }
                }
            }
            #endregion
            #region CREATE COLUMN FILES
            $Exclusions = @('Ordinal')
            forEach ($Group in $Data.Entities | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Entity in $Group.Group) {
                    forEach ($Column in $Entity.Columns) {
                        $Props = $Column.psobject.properties.name | Where-Object { $_ }
                        forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                            $OutObj = New-EmptyProperty
                            $OutObj.Name = "$($Entity.FullyQualifiedNames.Table).$($Column.ColumnNM)"
                            $OutObj.Property = $Prop
                            $OutObj.Value = $($Column."$($OutObj.Property)" -replace "`r`n", "")
                            if ($OutObj) { $Out += $OutObj }
                        }
                    }
                }
                $OutFile = "$($SplitDirectory)\Columns-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE INDEX FILES
            $Exclusions = @('IndexName')
            forEach ($Group in $Data.Entities | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Entity in $Group.Group) {
                    forEach ($Index in $Entity.Indexes) {
                        $Props = $Index.psobject.properties.name | Where-Object { $_ }
                        forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                            $OutObj = New-EmptyProperty
                            $OutObj.Name = "$($Entity.FullyQualifiedNames.Table).$($Index.IndexName)"
                            $OutObj.Property = $Prop
                            if ($Prop -eq 'IndexColumns') {
                                $OutObj.Value = $(($Index."$($OutObj.Property)" | Sort-Object ColumnNM).ColumnNM -join " | ")
                            }
                            else {
                                $OutObj.Value = $($Index."$($OutObj.Property)" -replace "`r`n", "")
                            }
                            if ($OutObj) { $Out += $OutObj }
                        }
                    }
                }
                $OutFile = "$($SplitDirectory)\Indexes-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE INCREMENTAL CONFIG FILES
            $Exclusions = @()
            forEach ($Group in $Data.Entities.Bindings | Group-Object ClassificationCode) {
                $Out = @()
                forEach ($Binding in $Group.Group) {
                    forEach ($Increment in $Binding.IncrementalConfigurations) {
                        $Props = $Increment.psobject.properties.name | Where-Object { $_ }
                        forEach ($Prop in $Props | Where-Object { $_ -NotIn $Exclusions }) {
                            $OutObj = New-EmptyProperty
                            $OutObj.Name = $Binding.BindingName
                            $OutObj.Property = $Prop
                            $OutObj.Value = $($Increment."$($OutObj.Property)" -replace "`r`n", "")
                            if ($null -ne $OutObj.Value -and $OutObj.Value -ne "") { $Out += $OutObj | Sort-Object { $_.Property, $_.Value } }
                        }
                    }
                }
                $OutFile = "$($SplitDirectory)\IncrementalConfigurations-$($Group.Name).csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #region CREATE DATA ENTRY ENTITY FILES
            ForEach ($Entity in $Data.Entities | Where-Object { $_.ClassificationCode -eq 'DataEntry' }) {
                If ($Entity.DataEntryData) {
                    $OutFile = "$($SplitDirectory)\DataEntryData-$(Get-CleanFileName $Entity.DataEntryData.FullyQualifiedNM -RemoveSpace).csv"
                    if ($Entity.DataEntryData.Data_All) {
                        $Entity.DataEntryData.Data_All | Export-Csv $OutFile -NoTypeInformation -Force
                    }
                }
            }
            #endregion
            #region CREATE ISSUE FILES
            if (($Data.Entities.Bindings.SourcedByEntities.SourcedByPossibleColumns | Measure-Object).Count -gt 0) {
                $Out = @()
                forEach ($Binding in $Data.Entities.Bindings) {
                    forEach ($Issue in $Binding.SourcedByEntities.SourcedByPossibleColumns) {
                        $OutObj = New-EmptyProperty
                        $OutObj.Name = $Binding.BindingName
                        $OutObj.Property = "Missing Alias - Unable To Parse"
                        $OutObj.Value = $Issue.FullyQualifiedNM
                        if ($OutObj.Value) { $Out += $OutObj }
                    }
                }
                $OutFile = "$($SplitDirectory)\_ISSUES-Bindings-MissingAlias.csv"
                if ($Out) {
                    $Out | Sort-Object Name, @{
                        e = {
                            if ($_.Property -eq 'ContentId') { 0 }
                            else { 1 }
                        }
                    }, Property | Export-Csv $OutFile -Force -NoTypeInformation
                }
            }
            #endregion
            #Get-Date | Out-File $SplitDirectory\_lastmodified.txt -Encoding Default -Force | Out-Null
        }
        catch {            
            $ErrorMessage = $_.Exception.Message
            $Msg = "$(" " * 8)An error occurred while trying to split data object into smaller files :( --> $ErrorMessage"; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';
            Exit
        }
    }
}
# SIG # Begin signature block
# MIIcSgYJKoZIhvcNAQcCoIIcOzCCHDcCAQExDzANBglghkgBZQMEAgEFADB5Bgor
# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG
# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCB8SvJMywMufgoO
# sNB3Y5h7FNSjxh2NVDiedoefsCqlMqCCCqMwggUwMIIEGKADAgECAhAECRgbX9W7
# ZnVTQ7VvlVAIMA0GCSqGSIb3DQEBCwUAMGUxCzAJBgNVBAYTAlVTMRUwEwYDVQQK
# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAiBgNV
# BAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0xMzEwMjIxMjAwMDBa
# Fw0yODEwMjIxMjAwMDBaMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2Vy
# dCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lD
# ZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwggEiMA0GCSqGSIb3
# DQEBAQUAA4IBDwAwggEKAoIBAQD407Mcfw4Rr2d3B9MLMUkZz9D7RZmxOttE9X/l
# qJ3bMtdx6nadBS63j/qSQ8Cl+YnUNxnXtqrwnIal2CWsDnkoOn7p0WfTxvspJ8fT
# eyOU5JEjlpB3gvmhhCNmElQzUHSxKCa7JGnCwlLyFGeKiUXULaGj6YgsIJWuHEqH
# CN8M9eJNYBi+qsSyrnAxZjNxPqxwoqvOf+l8y5Kh5TsxHM/q8grkV7tKtel05iv+
# bMt+dDk2DZDv5LVOpKnqagqrhPOsZ061xPeM0SAlI+sIZD5SlsHyDxL0xY4PwaLo
# LFH3c7y9hbFig3NBggfkOItqcyDQD2RzPJ6fpjOp/RnfJZPRAgMBAAGjggHNMIIB
# yTASBgNVHRMBAf8ECDAGAQH/AgEAMA4GA1UdDwEB/wQEAwIBhjATBgNVHSUEDDAK
# BggrBgEFBQcDAzB5BggrBgEFBQcBAQRtMGswJAYIKwYBBQUHMAGGGGh0dHA6Ly9v
# Y3NwLmRpZ2ljZXJ0LmNvbTBDBggrBgEFBQcwAoY3aHR0cDovL2NhY2VydHMuZGln
# aWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNydDCBgQYDVR0fBHow
# eDA6oDigNoY0aHR0cDovL2NybDQuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJl
# ZElEUm9vdENBLmNybDA6oDigNoY0aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0Rp
# Z2lDZXJ0QXNzdXJlZElEUm9vdENBLmNybDBPBgNVHSAESDBGMDgGCmCGSAGG/WwA
# AgQwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzAK
# BghghkgBhv1sAzAdBgNVHQ4EFgQUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHwYDVR0j
# BBgwFoAUReuir/SSy4IxLVGLp6chnfNtyA8wDQYJKoZIhvcNAQELBQADggEBAD7s
# DVoks/Mi0RXILHwlKXaoHV0cLToaxO8wYdd+C2D9wz0PxK+L/e8q3yBVN7Dh9tGS
# dQ9RtG6ljlriXiSBThCk7j9xjmMOE0ut119EefM2FAaK95xGTlz/kLEbBw6RFfu6
# r7VRwo0kriTGxycqoSkoGjpxKAI8LpGjwCUR4pwUR6F6aGivm6dcIFzZcbEMj7uo
# +MUSaJ/PQMtARKUT8OZkDCUIQjKyNookAv4vcn4c10lFluhZHen6dGRrsutmQ9qz
# sIzV6Q3d9gEgzpkxYz0IGhizgZtPxpMQBvwHgfqL2vmCSfdibqFT+hKUGIUukpHq
# aGxEMrJmoecYpJpkUe8wggVrMIIEU6ADAgECAhAMMCpTLsjxo9FR9hag8ePUMA0G
# CSqGSIb3DQEBCwUAMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJ
# bmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0
# IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwHhcNMjAwMzMxMDAwMDAw
# WhcNMjMwNTEwMTIwMDAwWjCBpzELMAkGA1UEBhMCVVMxDTALBgNVBAgTBFV0YWgx
# FzAVBgNVBAcTDlNhbHQgTGFrZSBDaXR5MR4wHAYDVQQKExVIZWFsdGggQ2F0YWx5
# c3QsIEluYy4xHjAcBgNVBAMTFUhlYWx0aCBDYXRhbHlzdCwgSW5jLjEwMC4GCSqG
# SIb3DQEJARYhYWRtaW5uaXN0cmF0b3JAaGVhbHRoY2F0YWx5c3QuY29tMIIBIjAN
# BgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA2fY0HWdxDJezDOsbHp7f9u/lrrD5
# nuZ1mENMgvixlrtC/KXgBRXlcWH7ajIOKljKnWCSAZwlZy4nFGbMagKmMzohXUXg
# xo94u5nCdiBa/kgPazNGpL0AyGgX2VARMbcpm8Gdy+/uH3Kc7L91lcoGZVVBnVIt
# 1oj5iXURqmhL83TrMyYqyj3XOH0So8Y10FVLPSukocMzMqBIRgvn/7EP0iWtOjXx
# +o1wB5Ql+z9G3NCqF6CKE/Pn355XYbbmjF7BPzKoOjocHO6VU2uEflJWq1ZFb0QY
# /tAosyyLYi9kFfO1damtJfRbbsVqavwg2UeQkzhg9CpB6eSsmBXPlFHudQIDAQAB
# o4IBxTCCAcEwHwYDVR0jBBgwFoAUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0O
# BBYEFFjfHOOIre2C4m9NCk8TFJlDwMxUMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUE
# DDAKBggrBgEFBQcDAzB3BgNVHR8EcDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdp
# Y2VydC5jb20vc2hhMi1hc3N1cmVkLWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2Ny
# bDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUw
# QzA3BglghkgBhv1sAwEwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNl
# cnQuY29tL0NQUzAIBgZngQwBBAEwgYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcw
# AYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8v
# Y2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNp
# Z25pbmdDQS5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAsBxn
# 9yJAQi+9cJPZpJvOEV6iHaOBGv8898wNJCc4eB5g8WPziEY70GZVeqEdx3z0wS8U
# QQIr19Hkju2NFZjDtzB9z1jAc/9EgqFGoCZbPijv1EYAa2oOVAp1BPbLjqBSdXqu
# 2mzqo14CJ30oNom9ep9F6LGZ5zEoPsMrJejSbJGr4EacrksX8C8qeFklc7FzwiGk
# GX7IQxidrrhOm2fOvGGAAxnvNYAR0FqJK0LiWWPSt5R/j63H/6HQtqD2sLevI3+O
# bRP74TPchDobFmWlSogX9oB63E7fsbDAqecY0cRPQ6tVWK53Ke2sB514nahFjZDa
# mxsa3/acZWL659ly3jGCEP0wghD5AgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYD
# VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAv
# BgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EC
# EAwwKlMuyPGj0VH2FqDx49QwDQYJYIZIAWUDBAIBBQCgfDAQBgorBgEEAYI3AgEM
# MQIwADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4w
# DAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQg4A+0v4hiZ4n/d8BeyRzOvTFV
# hnJWIbItcBKAkNM0BPcwDQYJKoZIhvcNAQEBBQAEggEASilCnPGSwnS2shi5dzkE
# jytMBLJ2hhZKZUOEndLhESGO+F1JNZOiZ/HH0xp531znl1nXpnkhuUvWfm36HHOX
# XSncHmzL7eVNkJ9AmEQ2kF1oe1yIXo4dTh4tadD/PK7Q3SYkui725yYMihLg+yPI
# CnR4eYa/di+Nem9Ok1i6nD/ZWZtzH3lajX9fh7P2WNqqblLjH/ZYy+pbRGwaz+Ji
# gypfiVxW2Ew1XKzmcvTYmlNpYIjEF0YXz6HsaVlGHg1Cu4I3T1AfgjeeFpOVpDZY
# hGPqogg3mo0IStn5bTV4et8zLPwKliwh8m8tP2ZEbx0wW1FUV3fdT6XHdT1Gyilx
# 76GCDskwgg7FBgorBgEEAYI3AwMBMYIOtTCCDrEGCSqGSIb3DQEHAqCCDqIwgg6e
# AgEDMQ8wDQYJYIZIAWUDBAIBBQAweAYLKoZIhvcNAQkQAQSgaQRnMGUCAQEGCWCG
# SAGG/WwHATAxMA0GCWCGSAFlAwQCAQUABCDdgyec4VQcqksq864CEacd1Pzk2ezd
# PeoK96mDmT76XwIRANbkUrPNKkVxFgMnpN3H9c8YDzIwMjAwNTA1MjMyMzI2WqCC
# C7swggaCMIIFaqADAgECAhAEzT+FaK52xhuw/nFgzKdtMA0GCSqGSIb3DQEBCwUA
# MHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsT
# EHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJl
# ZCBJRCBUaW1lc3RhbXBpbmcgQ0EwHhcNMTkxMDAxMDAwMDAwWhcNMzAxMDE3MDAw
# MDAwWjBMMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xJDAi
# BgNVBAMTG1RJTUVTVEFNUC1TSEEyNTYtMjAxOS0xMC0xNTCCASIwDQYJKoZIhvcN
# AQEBBQADggEPADCCAQoCggEBAOlkNZz6qZhlZBvkF9y4KTbMZwlYhU0w4Mn/5Ts8
# EShQrwcx4l0JGML2iYxpCAQj4HctnRXluOihao7/1K7Sehbv+EG1HTl1wc8vp6xF
# fpRtrAMBmTxiPn56/UWXMbT6t9lCPqdVm99aT1gCqDJpIhO+i4Itxpira5u0yfJl
# EQx0DbLwCJZ0xOiySKKhFKX4+uGJcEQ7je/7pPTDub0ULOsMKCclgKsQSxYSYAtp
# IoxOzcbVsmVZIeB8LBKNcA6Pisrg09ezOXdQ0EIsLnrOnGd6OHdUQP9PlQQg1OvI
# zocUCP4dgN3Q5yt46r8fcMbuQhZTNkWbUxlJYp16ApuVFKMCAwEAAaOCAzgwggM0
# MA4GA1UdDwEB/wQEAwIHgDAMBgNVHRMBAf8EAjAAMBYGA1UdJQEB/wQMMAoGCCsG
# AQUFBwMIMIIBvwYDVR0gBIIBtjCCAbIwggGhBglghkgBhv1sBwEwggGSMCgGCCsG
# AQUFBwIBFhxodHRwczovL3d3dy5kaWdpY2VydC5jb20vQ1BTMIIBZAYIKwYBBQUH
# AgIwggFWHoIBUgBBAG4AeQAgAHUAcwBlACAAbwBmACAAdABoAGkAcwAgAEMAZQBy
# AHQAaQBmAGkAYwBhAHQAZQAgAGMAbwBuAHMAdABpAHQAdQB0AGUAcwAgAGEAYwBj
# AGUAcAB0AGEAbgBjAGUAIABvAGYAIAB0AGgAZQAgAEQAaQBnAGkAQwBlAHIAdAAg
# AEMAUAAvAEMAUABTACAAYQBuAGQAIAB0AGgAZQAgAFIAZQBsAHkAaQBuAGcAIABQ
# AGEAcgB0AHkAIABBAGcAcgBlAGUAbQBlAG4AdAAgAHcAaABpAGMAaAAgAGwAaQBt
# AGkAdAAgAGwAaQBhAGIAaQBsAGkAdAB5ACAAYQBuAGQAIABhAHIAZQAgAGkAbgBj
# AG8AcgBwAG8AcgBhAHQAZQBkACAAaABlAHIAZQBpAG4AIABiAHkAIAByAGUAZgBl
# AHIAZQBuAGMAZQAuMAsGCWCGSAGG/WwDFTAfBgNVHSMEGDAWgBT0tuEgHf4prtLk
# YaWyoiWyyBc1bjAdBgNVHQ4EFgQUVlMPwcYHp03X2G5XcoBQTOTsnsEwcQYDVR0f
# BGowaDAyoDCgLoYsaHR0cDovL2NybDMuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJl
# ZC10cy5jcmwwMqAwoC6GLGh0dHA6Ly9jcmw0LmRpZ2ljZXJ0LmNvbS9zaGEyLWFz
# c3VyZWQtdHMuY3JsMIGFBggrBgEFBQcBAQR5MHcwJAYIKwYBBQUHMAGGGGh0dHA6
# Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBPBggrBgEFBQcwAoZDaHR0cDovL2NhY2VydHMu
# ZGlnaWNlcnQuY29tL0RpZ2lDZXJ0U0hBMkFzc3VyZWRJRFRpbWVzdGFtcGluZ0NB
# LmNydDANBgkqhkiG9w0BAQsFAAOCAQEALoOhRAVKBOO5MlL62YHwGrv4CY0juT3Y
# kqHmRhxKL256PGNuNxejGr9YI7JDnJSDTjkJsCzox+HizO3LeWvO3iMBR+2VVIHg
# gHsSsa8Chqk6c2r++J/BjdEhjOQpgsOKC2AAAp0fR8SftApoU39aEKb4Iub4U5Ix
# X9iCgy1tE0Kug8EQTqQk9Eec3g8icndcf0/pOZgrV5JE1+9uk9lDxwQzY1E3Vp5H
# BBHDo1hUIdjijlbXST9X/AqfI1579JSN3Z0au996KqbSRaZVDI/2TIryls+JRtwx
# spGQo18zMGBV9fxrMKyh7eRHTjOeZ2ootU3C7VuXgvjLqQhsUwm09zCCBTEwggQZ
# oAMCAQICEAqhJdbWMht+QeQF2jaXwhUwDQYJKoZIhvcNAQELBQAwZTELMAkGA1UE
# BhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2lj
# ZXJ0LmNvbTEkMCIGA1UEAxMbRGlnaUNlcnQgQXNzdXJlZCBJRCBSb290IENBMB4X
# DTE2MDEwNzEyMDAwMFoXDTMxMDEwNzEyMDAwMFowcjELMAkGA1UEBhMCVVMxFTAT
# BgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEx
# MC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElEIFRpbWVzdGFtcGluZyBD
# QTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAL3QMu5LzY9/3am6gpnF
# OVQoV7YjSsQOB0UzURB90Pl9TWh+57ag9I2ziOSXv2MhkJi/E7xX08PhfgjWahQA
# OPcuHjvuzKb2Mln+X2U/4Jvr40ZHBhpVfgsnfsCi9aDg3iI/Dv9+lfvzo7oiPhis
# EeTwmQNtO4V8CdPuXciaC1TjqAlxa+DPIhAPdc9xck4Krd9AOly3UeGheRTGTSQj
# MF287DxgaqwvB8z98OpH2YhQXv1mblZhJymJhFHmgudGUP2UKiyn5HU+upgPhH+f
# MRTWrdXyZMt7HgXQhBlyF/EXBu89zdZN7wZC/aJTKk+FHcQdPK/P2qwQ9d2srOlW
# /5MCAwEAAaOCAc4wggHKMB0GA1UdDgQWBBT0tuEgHf4prtLkYaWyoiWyyBc1bjAf
# BgNVHSMEGDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzASBgNVHRMBAf8ECDAGAQH/
# AgEAMA4GA1UdDwEB/wQEAwIBhjATBgNVHSUEDDAKBggrBgEFBQcDCDB5BggrBgEF
# BQcBAQRtMGswJAYIKwYBBQUHMAGGGGh0dHA6Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBD
# BggrBgEFBQcwAoY3aHR0cDovL2NhY2VydHMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0
# QXNzdXJlZElEUm9vdENBLmNydDCBgQYDVR0fBHoweDA6oDigNoY0aHR0cDovL2Ny
# bDQuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNybDA6oDig
# NoY0aHR0cDovL2NybDMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9v
# dENBLmNybDBQBgNVHSAESTBHMDgGCmCGSAGG/WwAAgQwKjAoBggrBgEFBQcCARYc
# aHR0cHM6Ly93d3cuZGlnaWNlcnQuY29tL0NQUzALBglghkgBhv1sBwEwDQYJKoZI
# hvcNAQELBQADggEBAHGVEulRh1Zpze/d2nyqY3qzeM8GN0CE70uEv8rPAwL9xafD
# DiBCLK938ysfDCFaKrcFNB1qrpn4J6JmvwmqYN92pDqTD/iy0dh8GWLoXoIlHsS6
# HHssIeLWWywUNUMEaLLbdQLgcseY1jxk5R9IEBhfiThhTWJGJIdjjJFSLK8pieV4
# H9YLFKWA1xJHcLN11ZOFk362kmf7U2GJqPVrlsD0WGkNfMgBsbkodbeZY4UijGHK
# eZR+WfyMD+NvtQEmtmyl7odRIeRYYJu6DC0rbaLEfrvEJStHAgh8Sa4TtuF8QkIo
# xhhWz0E0tmZdtnR79VYzIi8iNrJLokqV2PWmjlIxggJNMIICSQIBATCBhjByMQsw
# CQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cu
# ZGlnaWNlcnQuY29tMTEwLwYDVQQDEyhEaWdpQ2VydCBTSEEyIEFzc3VyZWQgSUQg
# VGltZXN0YW1waW5nIENBAhAEzT+FaK52xhuw/nFgzKdtMA0GCWCGSAFlAwQCAQUA
# oIGYMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAcBgkqhkiG9w0BCQUxDxcN
# MjAwNTA1MjMyMzI2WjArBgsqhkiG9w0BCRACDDEcMBowGDAWBBQDJb1QXtqWMC3C
# L0+gHkwovig0xTAvBgkqhkiG9w0BCQQxIgQgzf7XisJ4KA1bDdyryVDmG3tTdTiD
# ZvVbm1igsHvonaUwDQYJKoZIhvcNAQEBBQAEggEAmpcpff4dqs9j3jnoFti21YEz
# V8pEovKaRHqaJZQfB4CkePwBh15fc1ZFoxtRgm/u+tpee6bIBO04PoJmozGss9dC
# 1oBf5WZ5Y5EGTg0y75ZSdRSoA4G3xaO0Lx3dWTiRWuv5zV4FU5Zwbd06RPptHKFC
# scbODxuaPyiIGFMLEcj2DUl0ZApGG6eVx4uiAGlQIijhtODS9tTh0wtcdPShzpVH
# Kbi9HNP4/JPdRr+Krv8P3hDYADRuTC2U5VceoFATrF8hU9FEwFel+xkSmExlsMBi
# 8ksdfkBv2nTzZc8G8KWoH8epvAIx+lPIdgzfRWxtyu5WJki1L+LCmPTkA5R8AA==
# SIG # End signature block