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 # MIIcSgYJKoZIhvcNAQcCoIIcOzCCHDcCAQExDzANBglghkgBZQMEAgEFADB5Bgor # 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/acZWL659ly3jGCEP0wghD5AgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYD # 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 # XqGCDskwgg7FBgorBgEEAYI3AwMBMYIOtTCCDrEGCSqGSIb3DQEHAqCCDqIwgg6e # AgEDMQ8wDQYJYIZIAWUDBAIBBQAweAYLKoZIhvcNAQkQAQSgaQRnMGUCAQEGCWCG # SAGG/WwHATAxMA0GCWCGSAFlAwQCAQUABCAjDIaEO4qR3gNH0duoCoEBmIr9weq0 # QKZCPfkJJ9tmLgIRAPznnql1qdH9Z7FWeWZj26EYDzIwMjAwNTA1MjMyMzI0WqCC # 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 # MjAwNTA1MjMyMzI0WjArBgsqhkiG9w0BCRACDDEcMBowGDAWBBQDJb1QXtqWMC3C # L0+gHkwovig0xTAvBgkqhkiG9w0BCQQxIgQgequBxWM5W5YDMOfD1Ag4lLT/w2pk # GCeJbNmJdrpE1tEwDQYJKoZIhvcNAQEBBQAEggEAEYnbn3kvBW6vBHa1EchXfXha # oH4LZFdVkkp5xlPJh5Q/tWJUMa7t9hV6eqH6PD4mtpnln6pRkCyPhNBxcK1DV7Bm # c1KBXDHeoGHX/wPrztIwFtIoQafK7kRrf4PnV+MRx9iwtbmv7Oj+Jq41Cp5IJSoL # ZXCsQ8RRc8zPX35grA1NKCorY75JMe2akbt6AK5zv5Xv3WZuJdXM5u0+3ZElx9M7 # FaVckifEhuSbR6IV0aoXdASlWcGXnQ9ENT1vopzn/gsdgJXH+qWP4Ma7A914+Dd/ # cdlNAuz9LDOAULtue9RtlDDkh9yv+iEGmDVAb5hMD7JayhD4uCUBQfupXkgT6w== # SIG # End signature block |