functions/Invoke-Docs.ps1

function Invoke-Docs {
    param
    (
        [Parameter(Mandatory = $True)]
        [psobject]$Data,
        [Parameter(Mandatory = $True)]
        [string]$OutDir,
        [switch]$OutZip
    )
    begin {
        # Get function definition files.
        $Functions = @( Get-ChildItem -Path "$PSScriptRoot\docs" -Filter *.ps1 -ErrorAction SilentlyContinue )

        # Dot source the files
        foreach ($Import in @($Functions)) {
            try {
                . $Import.fullname
            }
            catch {
                Write-Error -Message "Failed to import function $($Import.fullname): $_"
            }
        }

        #remove inactive bindings and non-dataentry entities without bindings
        foreach ($Entity in $Data.Entities) {
            $Bindings = @();
            foreach ($Binding in $Entity.Bindings) {
                if ($Binding.BindingStatus -eq 'Active') {
                    $Bindings += $Binding
                }
            }
            $Entity.Bindings = $Bindings;
                            
            if ($Entity.ClassificationCode -ne 'DataEntry' -and ($Entity.Bindings | Measure-Object).Count -eq 0) {
                $Data.Entities = $Data.Entities | Where-Object { $_ -ne $Data.Entities[$Data.Entities.ContentId.IndexOf($Entity.ContentId)] }
            }
        }
        
        $Filters = Get-EntityFilterCriteria;
        $FilteredEntities = (Invoke-Expression $Filters.PowerShell);
                                       
        function Get-Entity ($ContentId) {
            return $Data.Entities[$Data.Entities.ContentId.IndexOf($ContentId)]
        }
    }
    process {
        $Msg = "DOCS - $($Data._hcposh.FileBaseName)"; Write-Host $Msg -ForegroundColor Magenta; Write-Verbose $Msg; Write-Log $Msg;
        #region ADD LINEAGE
        try {
            $Msg = "$(" " * 4)Adding entity data lineage..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg;
            foreach ($Entity in $Data.Entities) {
                $Entity | Add-Member -Type NoteProperty -Name Lineage -Value @()
                $Entity.Lineage = New-Nodes -entity $Entity
            }
        }
        catch {
            $Msg = "$(" " * 8)Unable to add data lineage properties"; Write-Host $Msg -ForegroundColor Yellow; Write-Verbose $Msg; Write-Log $Msg 'warning';
            $Msg = "$(" " * 8)$($Error[0])"; Write-Host $Msg -ForegroundColor Yellow; Write-Verbose $Msg; Write-Log $Msg 'warning';
        }
        #endregion
        #region ADD DIAGRAMS
        $Data | Add-Member -Type NoteProperty -Name Diagrams -Value (New-Object PSObject -Property @{ Erd = $Null; Dfd = $Null; DfdUpstream = $Null; DfdDownstream = $Null })
        #region ERD
        try {
            $Msg = "$(" " * 4)Adding erd diagram..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg;
            $Data.Diagrams.Erd = (New-Erd -Data $Data).Erd
                            
            if (!$KeepFullLineage) {
                #Remove un-needed properties
                if (($Data.Diagrams.Erd.PSobject.Properties.Name -match 'Data')) {
                    $Data.Diagrams.Erd.PSObject.Properties.Remove('Data')
                }
            }                            
        }
        catch {
            $Msg = "$(" " * 8)Unable to add erd diagram"; Write-Host $Msg -ForegroundColor Yellow; Write-Verbose $Msg; Write-Log $Msg 'warning';
        }
        #endregion
        #region DFD
        $Msg = "$(" " * 4)Adding dfd diagrams..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg;
        try {
            $Data.Diagrams.Dfd = (New-Dfd -Name $Data.DatamartNM -Lineage ($Data.Entities | Where-Object $FilteredEntities).Lineage -Type Both).Dfd
            $Data.Diagrams.DfdUpstream = (New-Dfd -Name $Data.DatamartNM -Lineage ($Data.Entities | Where-Object $FilteredEntities).Lineage -Type Upstream).Dfd
            $Data.Diagrams.DfdDownstream = (New-Dfd -Name $Data.DatamartNM -Lineage ($Data.Entities | Where-Object $FilteredEntities).Lineage -Type Downstream).Dfd
                            
            if (!$KeepFullLineage) {
                #Remove un-needed properties
                if (($Data.Diagrams.Dfd.PSobject.Properties.Name -match 'Data')) {
                    $Data.Diagrams.Dfd.PSObject.Properties.Remove('Data')
                }
                if (($Data.Diagrams.DfdUpstream.PSobject.Properties.Name -match 'Data')) {
                    $Data.Diagrams.DfdUpstream.PSObject.Properties.Remove('Data')
                }
                if (($Data.Diagrams.DfdDownstream.PSobject.Properties.Name -match 'Data')) {
                    $Data.Diagrams.DfdDownstream.PSObject.Properties.Remove('Data')
                }
            }                            
                            
            #ADD DFD DIAGRAM TO EVERY PUBLIC ENTITY
            forEach ($Entity in $Data.Entities | Where-Object $FilteredEntities) {
                if ($Entity.SourcedByEntities) {
                    $Entity | Add-Member -Type NoteProperty -Name Diagrams -Value (New-Object PSObject -Property @{ Dfd = $Null; DfdUpstream = $Null; DfdDownstream = $Null })
                    $Msg = "$(" " * 4)Adding dfd diagrams...$($Entity.FullyQualifiedNames.Table)..."; Write-Host $Msg -ForegroundColor Gray; Write-Verbose $Msg; Write-Log $Msg;
                    $Entity.Diagrams.Dfd = (New-Dfd -Name $Entity.FullyQualifiedNames.Table -Lineage $Entity.Lineage -Type Both).Dfd
                    $Entity.Diagrams.DfdDownstream = (New-Dfd -Name $Entity.FullyQualifiedNames.Table -Lineage $Entity.Lineage -Type Downstream).Dfd
                    $Entity.Diagrams.DfdUpstream = (New-Dfd -Name $Entity.FullyQualifiedNames.Table -Lineage $Entity.Lineage -Type Upstream).Dfd
                }
            }
        }
        catch {
            $Msg = "$(" " * 8)Requirements not met for dfd diagrams:`n$(" " * 10)At least 1 public ""summary"" entity for Framework SAM or 1 public entity in Generic SAM"; Write-Host $Msg -ForegroundColor Yellow; Write-Verbose $Msg; Write-Log $Msg 'warning';
        }
                        
        #Replace Lineage property with a cleaner version for display purposes
        forEach ($Entity in $Data.Entities | Where-Object $FilteredEntities) {
            $Upstream = Get-LineageCollection -Lineage $Entity.Lineage.Upstream -Data $Data;
            $Downstream = New-Object PSObject;
            if ($($Entity.Lineage.Downstream | Where-Object Level -NE 0)) {
                $Downstream = Get-LineageCollection -Lineage $($Entity.Lineage.Downstream | Where-Object Level -NE 0) -Data $Data;
            }
            $Entity | Add-Member -Type NoteProperty -Name LineageMinimal -Value (
                New-Object PSObject -Property @{
                    Upstream   = $Upstream;
                    Downstream = $Downstream;
                }
            )
        }
        if (!$KeepFullLineage) {
            forEach ($Entity in $Data.Entities) {
                if (($Entity.PSobject.Properties.Name -match 'Lineage')) {
                    $Entity.PSObject.Properties.Remove('Lineage')
                }
            }
        }
                        
        #endregion
        #endregion
        #region ADD DYNAMIC ENTITY FILTER LOGIC
         $Data | Add-Member -Type NoteProperty -Name EntityFilterCriteria -Value $Filters.JavaScript;
        #endregion
        #region ADD COUNT DETAILS
        $Sources = New-Object PSObject
        $Sources | Add-Member -Type NoteProperty -Name DelimitedList -Value (($Data.SourcedByEntities | Where-Object { $_.TableOrigin -eq 'External' -and $_.DatabaseNM -notin @('Shared', 'IDEA') } | Group-Object DatabaseNM).Name -join ', ');
        $Sources | Add-Member -Type NoteProperty -Name List -Value ($Data.SourcedByEntities | Where-Object { $_.TableOrigin -eq 'External' -and $_.DatabaseNM -notin @('Shared', 'IDEA') } | Group-Object DatabaseNM | Select-Object Name).Name;
        $Sources | Add-Member -Type NoteProperty -Name Count -Value (($Data.SourcedByEntities | Where-Object { $_.TableOrigin -eq 'External' -and $_.DatabaseNM -notin @('Shared', 'IDEA') } | Group-Object DatabaseNM | Measure-Object).Count);
        $Sources | Add-Member -Type NoteProperty -Name EntitiesCount -Value (($Data.SourcedByEntities | Where-Object { $_.TableOrigin -eq 'External' -and $_.DatabaseNM -notin @('Shared', 'IDEA') } | Measure-Object).Count);
                        
        $Entities = New-Object PSObject
        $Entities | Add-Member -Type NoteProperty -Name Count -Value ($Data.Entities | Measure-Object).Count;
        $Entities | Add-Member -Type NoteProperty -Name PersistedCount -Value ($Data.Entities | Where-Object { $_.IsPersisted } | Measure-Object).Count;
        $Entities | Add-Member -Type NoteProperty -Name NonPersistedCount -Value ($Data.Entities | Where-Object { !($_.IsPersisted) } | Measure-Object).Count;
        $Entities | Add-Member -Type NoteProperty -Name ProtectedCount -Value ($Data.Entities | Where-Object { $_.IsProtected } | Measure-Object).Count;
        $Entities | Add-Member -Type NoteProperty -Name PublicCount -Value ($Data.Entities | Where-Object { $_.IsPublic } | Measure-Object).Count;
                        
        $Columns = New-Object PSObject
        $Columns | Add-Member -Type NoteProperty -Name PublicCount -Value (($Data.Entities | Where-Object { $_.IsPublic }).Columns | Measure-Object).Count;
        $Columns | Add-Member -Type NoteProperty -Name ExtendedCount -Value (($Data.Entities | Where-Object { $_.IsPublic }).Columns | Where-Object { $_.IsExtended } | Measure-Object).Count;
                        
        $Bindings = New-Object PSObject
        $Bindings | Add-Member -Type NoteProperty -Name Count -Value ($Data.Entities.Bindings | Where-Object { $_.BindingStatus -eq 'Active' } | Measure-Object).Count;
        $Bindings | Add-Member -Type NoteProperty -Name ProtectedCount -Value ($Data.Entities.Bindings | Where-Object { $_.BindingStatus -eq 'Active' -and $_.IsProtected } | Measure-Object).Count;
        $Bindings | Add-Member -Type NoteProperty -Name FullCount -Value ($Data.Entities.Bindings | Where-Object { $_.LoadType -eq 'Full' -and $_.BindingStatus -eq 'Active' } | Measure-Object).Count;
        $Bindings | Add-Member -Type NoteProperty -Name IncrementalCount -Value ($Data.Entities.Bindings | Where-Object { $_.LoadType -eq 'Incremental' -and $_.BindingStatus -eq 'Active' } | Measure-Object).Count;
                        
        $Indexes = New-Object PSObject
        $Indexes | Add-Member -Type NoteProperty -Name ClusteredCount -Value ($Data.Entities.Indexes | Where-Object { $_.IndexTypeCode -eq 'Clustered' -and $_.IsActive } | Measure-Object).Count;
        $Indexes | Add-Member -Type NoteProperty -Name NonClusteredCount -Value ($Data.Entities.Indexes | Where-Object { $_.IndexTypeCode -eq 'Non-Clustered' -and $_.IsActive } | Measure-Object).Count;
                        
        $Counts = New-Object PSObject
        $Counts | Add-Member -Type NoteProperty -Name Sources -Value $Sources;
        $Counts | Add-Member -Type NoteProperty -Name Entities -Value $Entities;
        $Counts | Add-Member -Type NoteProperty -Name Columns -Value $Columns;
        $Counts | Add-Member -Type NoteProperty -Name Bindings -Value $Bindings;
        $Counts | Add-Member -Type NoteProperty -Name Indexes -Value $Indexes;
                        
        $Data | Add-Member -Type NoteProperty -Name Counts -Value $Counts;
        #endregion
        #region REMOVE DATA_ALL PROPERTY (UNECESSARY FOR DOCS)
        foreach ($Entity in $Data.Entities) {
            if ($Entity.DataEntryData) {
                if ($Entity.DataEntryData.Data_All) {
                    $Entity.DataEntryData.PSObject.Properties.Remove('Data_All')
                }
            }
        }
        #endregion
                        
        $Data._hcposh.LastWriteTime = (Get-Date -Format "yyyy-MM-ddTHH:mm:ss.ffffff")
                        
        #Directories
        $DataDir = "$($OutDir)\static\data"; New-Directory -Dir $DataDir;
                        
        #Files
        $DocsSourcePath = "$((Get-Item $PSScriptRoot).Parent.FullName)\templates\docs\*";
        $DocsDestinationPath = $OutDir;
        $DataFilePath = "$($DataDir)\dataMart.js";
        try {
            if (($Data.Entities | Where-Object $FilteredEntities | Measure-Object).Count -eq 0) { throw; }
            Copy-Item -Path $DocsSourcePath -Recurse -Destination $DocsDestinationPath -Force
            'dataMart = ' + ($Data | ConvertTo-Json -Depth 100 -Compress) | Out-File $DataFilePath -Encoding Default -Force | Out-Null
            $Msg = "$(" " * 4)Created new file --> $($Data._hcposh.FileBaseName)\$(Split-Path $DataDir -Leaf)\$(Split-Path $DataFilePath -Leaf)."; Write-Host $Msg -ForegroundColor Cyan; Write-Verbose $Msg; Write-Log $Msg;
        }
        catch {
            $Msg = "$(" " * 4)Unable to find valid public entities or An error occurred when trying to create the docs folder structure"; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';
        }
        if ($OutZip) {
            try {
                Zip -Directory $DocsDestinationPath -Destination ($DocsDestinationPath + '_docs.zip')
                if (Test-Path $DocsDestinationPath) {
                    Remove-Item $DocsDestinationPath -Recurse -Force | Out-Null
                }
                $Msg = "$(" " * 4)Zipped file of directory --> $($DocsDestinationPath + '_docs.zip')"; Write-Host $Msg -ForegroundColor Cyan; Write-Verbose $Msg; Write-Log $Msg;
            }
            catch {
                $Msg = "$(" " * 4)Unable to zip the docs directory"; Write-Host $Msg -ForegroundColor Red; Write-Verbose $Msg; Write-Log $Msg 'error';
            }
        }
        $Msg = "Success!`r`n"; Write-Host $Msg -ForegroundColor Green; Write-Verbose $Msg; Write-Log $Msg;
        $Output = New-Object PSObject
        $Output | Add-Member -Type NoteProperty -Name DocsData -Value $Data
        return $Output
    }
}
# SIG # Begin signature block
# MIIaxgYJKoZIhvcNAQcCoIIatzCCGrMCAQExDzANBglghkgBZQMEAgEFADB5Bgor
# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG
# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCByXZAGxrbFEnYm
# Odz/JBX4wYwUOtc7YwZVFqCtcvN7cqCCCqMwggUwMIIEGKADAgECAhAECRgbX9W7
# 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/acZWL659ly3jGCD3kwgg91AgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYD
# VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAv
# BgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EC
# EAwwKlMuyPGj0VH2FqDx49QwDQYJYIZIAWUDBAIBBQCgfDAQBgorBgEEAYI3AgEM
# MQIwADAZBgkqhkiG9w0BCQMxDAYKKwYBBAGCNwIBBDAcBgorBgEEAYI3AgELMQ4w
# DAYKKwYBBAGCNwIBFTAvBgkqhkiG9w0BCQQxIgQgCT26Sh+UFZUddv7aIXpcqbh1
# G+iu15AEMwyuMxhm/yYwDQYJKoZIhvcNAQEBBQAEggEAJ7mMzmoqxnl9V6Z5qN7r
# WA9+/t5V73F+Roz3WHjdYZySQYGoynFuSa5zEGp2X21T+f552omyDASzmg8CQrOF
# oIjk7We75BlQgqzWDT5A/KA1ftLlMHE4dhfUyCojEzSEozssIo4zSduQFbiN1f46
# nZuOQOIYfMy7md3ilVH+fV7BkfHWCtptsVcJypcB9/jIqM9KAxkwk/nU6piUdM1b
# ZyBf8qUeQYjHrvSS9a+CHiq9Uncjbcud2ITfEbViDlX3qTObyNlhmc2td+v9C+IH
# QXtBJwHVtg7FN1hfqkofhVB8bWf3rvoCH82qW8clB9bkES18UtmbnKJfCH576+JE
# XqGCDUUwgg1BBgorBgEEAYI3AwMBMYINMTCCDS0GCSqGSIb3DQEHAqCCDR4wgg0a
# AgEDMQ8wDQYJYIZIAWUDBAIBBQAweAYLKoZIhvcNAQkQAQSgaQRnMGUCAQEGCWCG
# SAGG/WwHATAxMA0GCWCGSAFlAwQCAQUABCAjDIaEO4qR3gNH0duoCoEBmIr9weq0
# QKZCPfkJJ9tmLgIRALKJF3U/B+MFecOFsWf8c/YYDzIwMjEwNTA3MjEzNzI0WqCC
# CjcwggT+MIID5qADAgECAhANQkrgvjqI/2BAIc4UAPDdMA0GCSqGSIb3DQEBCwUA
# MHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsT
# EHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJl
# ZCBJRCBUaW1lc3RhbXBpbmcgQ0EwHhcNMjEwMTAxMDAwMDAwWhcNMzEwMTA2MDAw
# MDAwWjBIMQswCQYDVQQGEwJVUzEXMBUGA1UEChMORGlnaUNlcnQsIEluYy4xIDAe
# BgNVBAMTF0RpZ2lDZXJ0IFRpbWVzdGFtcCAyMDIxMIIBIjANBgkqhkiG9w0BAQEF
# AAOCAQ8AMIIBCgKCAQEAwuZhhGfFivUNCKRFymNrUdc6EUK9CnV1TZS0DFC1JhD+
# HchvkWsMlucaXEjvROW/m2HNFZFiWrj/ZwucY/02aoH6KfjdK3CF3gIY83htvH35
# x20JPb5qdofpir34hF0edsnkxnZ2OlPR0dNaNo/Go+EvGzq3YdZz7E5tM4p8XUUt
# S7FQ5kE6N1aG3JMjjfdQJehk5t3Tjy9XtYcg6w6OLNUj2vRNeEbjA4MxKUpcDDGK
# SoyIxfcwWvkUrxVfbENJCf0mI1P2jWPoGqtbsR0wwptpgrTb/FZUvB+hh6u+elsK
# IC9LCcmVp42y+tZji06lchzun3oBc/gZ1v4NSYS9AQIDAQABo4IBuDCCAbQwDgYD
# VR0PAQH/BAQDAgeAMAwGA1UdEwEB/wQCMAAwFgYDVR0lAQH/BAwwCgYIKwYBBQUH
# AwgwQQYDVR0gBDowODA2BglghkgBhv1sBwEwKTAnBggrBgEFBQcCARYbaHR0cDov
# L3d3dy5kaWdpY2VydC5jb20vQ1BTMB8GA1UdIwQYMBaAFPS24SAd/imu0uRhpbKi
# JbLIFzVuMB0GA1UdDgQWBBQ2RIaOpLqwZr68KC0dRDbd42p6vDBxBgNVHR8EajBo
# MDKgMKAuhixodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vc2hhMi1hc3N1cmVkLXRz
# LmNybDAyoDCgLoYsaHR0cDovL2NybDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJl
# ZC10cy5jcmwwgYUGCCsGAQUFBwEBBHkwdzAkBggrBgEFBQcwAYYYaHR0cDovL29j
# c3AuZGlnaWNlcnQuY29tME8GCCsGAQUFBzAChkNodHRwOi8vY2FjZXJ0cy5kaWdp
# Y2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEVGltZXN0YW1waW5nQ0EuY3J0
# MA0GCSqGSIb3DQEBCwUAA4IBAQBIHNy16ZojvOca5yAOjmdG/UJyUXQKI0ejq5LS
# JcRwWb4UoOUngaVNFBUZB3nw0QTDhtk7vf5EAmZN7WmkD/a4cM9i6PVRSnh5Nnon
# t/PnUp+Tp+1DnnvntN1BIon7h6JGA0789P63ZHdjXyNSaYOC+hpT7ZDMjaEXcw30
# 82U5cEvznNZ6e9oMvD0y0BvL9WH8dQgAdryBDvjA4VzPxBFy5xtkSdgimnUVQvUt
# MjiB2vRgorq0Uvtc4GEkJU+y38kpqHNDUdq9Y9YfW5v3LhtPEx33Sg1xfpe39D+E
# 68Hjo0mh+s6nv1bPull2YYlffqe0jmd4+TaY4cso2luHpoovMIIFMTCCBBmgAwIB
# AgIQCqEl1tYyG35B5AXaNpfCFTANBgkqhkiG9w0BAQsFADBlMQswCQYDVQQGEwJV
# UzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQu
# Y29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVkIElEIFJvb3QgQ0EwHhcNMTYw
# MTA3MTIwMDAwWhcNMzEwMTA3MTIwMDAwWjByMQswCQYDVQQGEwJVUzEVMBMGA1UE
# ChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29tMTEwLwYD
# VQQDEyhEaWdpQ2VydCBTSEEyIEFzc3VyZWQgSUQgVGltZXN0YW1waW5nIENBMIIB
# IjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAvdAy7kvNj3/dqbqCmcU5VChX
# tiNKxA4HRTNREH3Q+X1NaH7ntqD0jbOI5Je/YyGQmL8TvFfTw+F+CNZqFAA49y4e
# O+7MpvYyWf5fZT/gm+vjRkcGGlV+Cyd+wKL1oODeIj8O/36V+/OjuiI+GKwR5PCZ
# A207hXwJ0+5dyJoLVOOoCXFr4M8iEA91z3FyTgqt30A6XLdR4aF5FMZNJCMwXbzs
# PGBqrC8HzP3w6kfZiFBe/WZuVmEnKYmEUeaC50ZQ/ZQqLKfkdT66mA+Ef58xFNat
# 1fJky3seBdCEGXIX8RcG7z3N1k3vBkL9olMqT4UdxB08r8/arBD13ays6Vb/kwID
# AQABo4IBzjCCAcowHQYDVR0OBBYEFPS24SAd/imu0uRhpbKiJbLIFzVuMB8GA1Ud
# IwQYMBaAFEXroq/0ksuCMS1Ri6enIZ3zbcgPMBIGA1UdEwEB/wQIMAYBAf8CAQAw
# DgYDVR0PAQH/BAQDAgGGMBMGA1UdJQQMMAoGCCsGAQUFBwMIMHkGCCsGAQUFBwEB
# BG0wazAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tMEMGCCsG
# AQUFBzAChjdodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1
# cmVkSURSb290Q0EuY3J0MIGBBgNVHR8EejB4MDqgOKA2hjRodHRwOi8vY3JsNC5k
# aWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3JsMDqgOKA2hjRo
# dHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0Eu
# Y3JsMFAGA1UdIARJMEcwOAYKYIZIAYb9bAACBDAqMCgGCCsGAQUFBwIBFhxodHRw
# czovL3d3dy5kaWdpY2VydC5jb20vQ1BTMAsGCWCGSAGG/WwHATANBgkqhkiG9w0B
# AQsFAAOCAQEAcZUS6VGHVmnN793afKpjerN4zwY3QITvS4S/ys8DAv3Fp8MOIEIs
# r3fzKx8MIVoqtwU0HWqumfgnoma/Capg33akOpMP+LLR2HwZYuhegiUexLoceywh
# 4tZbLBQ1QwRostt1AuByx5jWPGTlH0gQGF+JOGFNYkYkh2OMkVIsrymJ5Xgf1gsU
# pYDXEkdws3XVk4WTfraSZ/tTYYmo9WuWwPRYaQ18yAGxuSh1t5ljhSKMYcp5lH5Z
# /IwP42+1ASa2bKXuh1Eh5Fhgm7oMLSttosR+u8QlK0cCCHxJrhO24XxCQijGGFbP
# QTS2Zl22dHv1VjMiLyI2skuiSpXY9aaOUjGCAk0wggJJAgEBMIGGMHIxCzAJBgNV
# BAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdp
# Y2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBUaW1l
# c3RhbXBpbmcgQ0ECEA1CSuC+Ooj/YEAhzhQA8N0wDQYJYIZIAWUDBAIBBQCggZgw
# GgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMBwGCSqGSIb3DQEJBTEPFw0yMTA1
# MDcyMTM3MjRaMCsGCyqGSIb3DQEJEAIMMRwwGjAYMBYEFOHXgqjhkb7va8oWkbWq
# tJSmJJvzMC8GCSqGSIb3DQEJBDEiBCCXSyLL0OfP+8KWkinHndJDY6Pjx6LUeZV2
# /CdrNq1zzTANBgkqhkiG9w0BAQEFAASCAQAXN9wrckkxLDPaVb8ie7PYWUERiIDj
# iQyBtXRTfi1i//KXPLQc3eBntH6ysi3jppUQ8iLGZPpJfx2U+7BCNjzH11lZgTWf
# v6CV4rbAWkiEUBCgfLwlLSyiz8nVfPlPWsKVWQwwGrZycmYYfEzHSveW2IPiyntm
# 3prNDURDKsCajYzfAeJb/dhJumyjKYCpA4zC6zddX0NiaKLVTwpaSPIXNtHrG4aN
# sLRPVl0/fi0he3eBLo51tmB/lee64hAlQvRU5hqTrb6TWWD8w0//K36yDIhGO37W
# BXNIJJjfCN8MAQ34OAwQMId3mMV+IH/ZZ9z0Pu57j3iCi7ybDCcWrmg3
# SIG # End signature block