Obs/bin/TestObservability/HelperFiles/HTMLReportHelper.psm1

<##############################################################
# #
# Copyright (C) Microsoft Corporation. All rights reserved. #
# #
##############################################################>


Import-Module $PSScriptRoot\..\HelperFiles\TestObsHelper.psm1 -Force

# CSS
$header = @"
<style>
 
    h1 {
        font-family: Arial, Helvetica, sans-serif;
        color: blue;
        font-size: 28px;
    }
 
    h2 {
        font-family: Arial, Helvetica, sans-serif;
        color: #0078d4;
        font-size: 16px;
    }
 
    p {
        margin: 5px
    }
 
   table {
        font-size: 12px;
        border: 0px;
        font-family: Arial, Helvetica, sans-serif;
    }
     
    td {
        padding: 4px;
        margin: 0px;
        border: 0;
        max-width: 350px;
        max-height: 350px;
        overflow: hidden;
        text-overflow: ellipsis;
        white-space: nowrap;
    }
 
    td:hover {
        overflow: visible;
        white-space: normal;
        height:auto;
        max-width:auto;
    }
     
    th {
        background: linear-gradient(#243a5e, #0078d4);
        color: #fff;
        font-size: 11px;
        padding: 10px 15px;
        vertical-align: middle;
    }
 
    tbody tr:nth-child(even) {
        background: #f0f0f2;
    }
 
    tbody tr:nth-child(odd) {
        background: white
    }
 
    .pass {
        color: green;
    }
     
    .fail {
        color: red;
    }
 
</style>
"@


function Generate-HTMLReport
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$true)]
        [string]
        $PathToTestReports,

        [parameter(Mandatory=$true)]
        [string[]]
        $TestNames,

        [parameter(Mandatory=$true)]
        [switch]
        $Repair
    )
    
    $startTime = (Get-Date)
    $title = "Test-Observability Report"
    $reportHTML = "<h1>$title</h1>"
    
    $testReports = Get-ChildItem $PathToTestReports
    $overallResult = Get-OverallResult -TestReports $TestReports -TestNames $TestNames -Repair:$Repair
    $overallResult = Style-Result -Result $overallResult
    $reportHTML += "<h1>Overall Result: $overallResult</h1>"

    $reportHTML += Get-GeneralInformation -TestReports $testReports
    $reportHTML += "<br><br>"
    foreach ($testName in $testNames)
    {
        $testHasRepairAction = Get-TestRepairAction -TestName $TestName
        if ($Repair -and $testHasRepairAction)
        {
            $reportHTML += Create-HTMLForTest -TestReports $testReports -TestName $testName -RepairAction "BeforeRepair"
            $reportHTML += Create-HTMLForTest -TestReports $testReports -TestName $testName -RepairAction "AfterRepair"
        }
        else
        {
            $reportHTML += Create-HTMLForTest -TestReports $testReports -TestName $testName -RepairAction "NoRepair"
        }
    }
    $report = ConvertTo-HTML -Body $reportHTML -Head $header -Title $title -PostContent "<p>Html Report Generated on: $(Get-Date)</p>"
    $report = $report -replace "<td>PASS</td>","<td class='pass'>PASS</td>"
    $report = $report -replace "<td>FAIL</td>","<td class='fail'>FAIL</td>"
    $outputFilePath = Split-Path $PathToTestReports -Parent
    $currentDate = (get-date).ToString("MMddyyyy_HHmm")
    $reportPath = Join-Path $outputFilePath "TestObservability-$currentDate.html"
    
    Trace-Progress "Html Report generated in $('{0:N2}' -f ((Get-Date) - $startTime).totalSeconds)s"
    $report | Out-File $reportPath
    return $reportPath
}

function Get-GeneralInformation
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$false)]
        [Object[]]
        $TestReports
    )

    try
    {
        $generalInfoJSON = Join-Path $PathToTestReports "GeneralReportInfo.json"
        $generalInfo = Get-Content $generalInfoJSON | ConvertFrom-JSON
        if ($null -eq $generalInfo)
        {
            return "<h2>General Information</h2><p class='fail'>Could not get general environment information.</p>"
        }
        $generalInfo = ConvertTo-Html -InputObject ($generalInfo) -As List -Fragment -PreContent "<h2>General Information</h2>"
        return $generalInfo
    }
    catch
    {
        return "<h2>General Information</h2><p class='fail'>Could not get general environment information.</p>"
    }
    
}

function Get-OverallResult
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$false)]
        [Object[]]
        $TestReports,

        [parameter(Mandatory=$true)]
        [string[]]
        $TestNames,

        [parameter(Mandatory=$true)]
        [switch]
        $Repair
    )

    $fail = "FAIL"
    $pass = "PASS"

    if ($null -eq $TestReports)
    {
        return $fail
    }
    foreach ($testName in $TestNames)
    {
        $testHasRepairAction = Get-TestRepairAction -TestName $TestName
        if ($Repair -And $testHasRepairAction)
        {
            $reportFailed = Check-IfTestFailed -TestReports $TestReports -TestName $testName -RepairAction "BeforeRepair"
            # If BeforeRepair failed, OK as long as after repair passed
            # Also, if BeforeRepair passed, there shouldn't be a report for "AfterRepair", so skip test.
            if ($reportFailed)
            {
                $reportFailed = Check-IfTestFailed -TestReports $TestReports -TestName $testName -RepairAction "AfterRepair"
                if ($reportFailed)
                {
                    return $fail
                }
            }
        }  
        else
        {
            $reportFailed = Check-IfTestFailed -TestReports $TestReports -TestName $testName -RepairAction "NoRepair"
            if ($reportFailed)
            {
                return $fail
            }
        }
    }
    return $pass
}

function Check-IfTestFailed
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$false)]
        [Object[]]
        $TestReports,

        [parameter(Mandatory=$true)]
        [string]
        $TestName,

        [parameter(Mandatory=$true)]
        [string]
        $RepairAction
    )
    $reportData = Get-ReportData -TestReports $TestReports -TestName $testName -RepairAction $RepairAction
    return ($null -eq $reportData -or ($null -eq $reportData.OverallResult -or $reportData.OverallResult -ne $pass))
}

function Get-ReportData
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$false)]
        [Object[]]
        $TestReports,

        [parameter(Mandatory=$true)]
        [string]
        $TestName,

        [parameter(Mandatory=$true)]
        [string]
        $RepairAction
    )
    $jsonFileName = Get-JsonFileName -TestName $testName -RepairAction $RepairAction

    $reportName = $jsonFileName += ".json"
    $report = $TestReports | Where-Object { $_.Name -eq $ReportName }
    if ($null -eq $report)
    {
        return $null
    }
    return Get-Content -Path $report.FullName | ConvertFrom-Json
}

function No-TestData
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$true)]
        [string]
        $TestName
    )

     $reportHTML = "<b>Test Name:</b> $TestName"
     $reportHTML += "<p><b>Overall Result: </b>"
     $reportHTML += Style-Result -Result "FAIL"
     $reportHTML += "</p>"
     $reportHTML += "<p>Could not find data for this test.</p>"

     return $reportHTML
}

function Create-HTMLForTest
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$false)]
        [Object[]]
        $TestReports,

        [parameter(Mandatory=$true)]
        [string]
        $TestName,

        [parameter(Mandatory=$false)]
        [string]
        $RepairAction
    )

    $reportHTML = ""
    $functionName = $($MyInvocation.MyCommand.Name)

    try
    {
        $reportData = Get-ReportData -TestReports $TestReports -TestName $testName -RepairAction $RepairAction
        $jsonFileName = Get-JsonFileName -TestName $testName -RepairAction $RepairAction
        if ($null -eq $reportData)
        {
            if ($RepairAction -ieq "NoRepair" -or $RepairAction -ieq "BeforeRepair")
            {
                $reportHTML = No-TestData -TestName $jsonFileName
            }
            else
            {
                #There will be no AfterRepair report if the BeforeRepair report had an overall status of success.
                $reportDataBeforeRepair = Get-ReportData -TestReports $TestReports -TestName $testName -RepairAction "BeforeRepair"
                if ($reportDataBeforeRepair.OverallResult -ne "PASS")
                {
                    $reportHTML = No-TestData -TestName $jsonFileName
                }
            }
            return $reportHTML
        }

        $reportHTML += "<p><b>Test Name:</b> $($reportData.TestName)</p>"

        $reportHTML += "<p><b>Overall Result: </b>"
        $result = $reportData.OverallResult
        $reportHTML += Style-Result -Result $result
        $reportHTML += "</p>"

        $reportHTML += "<p><b>Has Repair Action: </b>"
        $reportHTML += $reportData.HasRepairAction
        $reportHTML += "</p>"

        $reportHTML += "<p><b>Repair Description: </b>"
        $reportHTML += $reportData.RepairDescription
        $reportHTML += "</p><br>"

        # make table of rows
        $rows = $reportData.Rows
        if ($null -eq $rows -or $rows.count -eq 0)
        {
            $reportHTML += "<p>Could not find data for this test.</p>"
            return $reportHTML
        }
        $reportHTML += "<table>"
        $row = $rows[0]
        # Create header Row
        $row.PSObject.Properties | ForEach-Object {
            $name = Convert-CamelCase -Name $_.Name
            $reportHTML += "<th>$name</th>"
        }
        foreach ($row in $rows)
        {
            $reportHTML += "<tr>"
            $row.PSObject.Properties | ForEach-Object {
                $reportHTML += "<td>$($_.Value)</td>"
            }
            $reportHTML += "</tr>"
        }
        $reportHTML += "</table>"
        $reportHTML += "<br><br><br>"
        return $reportHTML
    }
    catch
    {
        Trace-Progress "$functionName : Failed with $_"
        return $reportHTML
    }
}

function Style-Result
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$false)]
        [string]
        $Result
    )

    if ($Result -ieq "PASS")
    {
        $class = "pass"
    }
    else
    {
        $class = "fail"
    }

    return "<span class=$class>$Result</span>"
}

function Convert-CamelCase
{
    [CmdletBinding()]
    param(
        [parameter(Mandatory=$true)]
        [string]
        $Name
    )

    return $Name -creplace '(?<=\w)([A-Z])', ' $1'
}

Export-ModuleMember -Function Generate-HTMLReport -Verbose:$false
# SIG # Begin signature block
# MIInwgYJKoZIhvcNAQcCoIInszCCJ68CAQExDzANBglghkgBZQMEAgEFADB5Bgor
# BgEEAYI3AgEEoGswaTA0BgorBgEEAYI3AgEeMCYCAwEAAAQQH8w7YFlLCE63JNLG
# KX7zUQIBAAIBAAIBAAIBAAIBADAxMA0GCWCGSAFlAwQCAQUABCCRcM1EixxQpv8j
# 4Et17OWclu7IWqO7SQ1z+jojGGTsKqCCDXYwggX0MIID3KADAgECAhMzAAADrzBA
# DkyjTQVBAAAAAAOvMA0GCSqGSIb3DQEBCwUAMH4xCzAJBgNVBAYTAlVTMRMwEQYD
# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy
# b3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNpZ25p
# bmcgUENBIDIwMTEwHhcNMjMxMTE2MTkwOTAwWhcNMjQxMTE0MTkwOTAwWjB0MQsw
# CQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9u
# ZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMR4wHAYDVQQDExVNaWNy
# b3NvZnQgQ29ycG9yYXRpb24wggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIB
# AQDOS8s1ra6f0YGtg0OhEaQa/t3Q+q1MEHhWJhqQVuO5amYXQpy8MDPNoJYk+FWA
# hePP5LxwcSge5aen+f5Q6WNPd6EDxGzotvVpNi5ve0H97S3F7C/axDfKxyNh21MG
# 0W8Sb0vxi/vorcLHOL9i+t2D6yvvDzLlEefUCbQV/zGCBjXGlYJcUj6RAzXyeNAN
# xSpKXAGd7Fh+ocGHPPphcD9LQTOJgG7Y7aYztHqBLJiQQ4eAgZNU4ac6+8LnEGAL
# go1ydC5BJEuJQjYKbNTy959HrKSu7LO3Ws0w8jw6pYdC1IMpdTkk2puTgY2PDNzB
# tLM4evG7FYer3WX+8t1UMYNTAgMBAAGjggFzMIIBbzAfBgNVHSUEGDAWBgorBgEE
# AYI3TAgBBggrBgEFBQcDAzAdBgNVHQ4EFgQURxxxNPIEPGSO8kqz+bgCAQWGXsEw
# RQYDVR0RBD4wPKQ6MDgxHjAcBgNVBAsTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEW
# MBQGA1UEBRMNMjMwMDEyKzUwMTgyNjAfBgNVHSMEGDAWgBRIbmTlUAXTgqoXNzci
# tW2oynUClTBUBgNVHR8ETTBLMEmgR6BFhkNodHRwOi8vd3d3Lm1pY3Jvc29mdC5j
# b20vcGtpb3BzL2NybC9NaWNDb2RTaWdQQ0EyMDExXzIwMTEtMDctMDguY3JsMGEG
# CCsGAQUFBwEBBFUwUzBRBggrBgEFBQcwAoZFaHR0cDovL3d3dy5taWNyb3NvZnQu
# Y29tL3BraW9wcy9jZXJ0cy9NaWNDb2RTaWdQQ0EyMDExXzIwMTEtMDctMDguY3J0
# MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQELBQADggIBAISxFt/zR2frTFPB45Yd
# mhZpB2nNJoOoi+qlgcTlnO4QwlYN1w/vYwbDy/oFJolD5r6FMJd0RGcgEM8q9TgQ
# 2OC7gQEmhweVJ7yuKJlQBH7P7Pg5RiqgV3cSonJ+OM4kFHbP3gPLiyzssSQdRuPY
# 1mIWoGg9i7Y4ZC8ST7WhpSyc0pns2XsUe1XsIjaUcGu7zd7gg97eCUiLRdVklPmp
# XobH9CEAWakRUGNICYN2AgjhRTC4j3KJfqMkU04R6Toyh4/Toswm1uoDcGr5laYn
# TfcX3u5WnJqJLhuPe8Uj9kGAOcyo0O1mNwDa+LhFEzB6CB32+wfJMumfr6degvLT
# e8x55urQLeTjimBQgS49BSUkhFN7ois3cZyNpnrMca5AZaC7pLI72vuqSsSlLalG
# OcZmPHZGYJqZ0BacN274OZ80Q8B11iNokns9Od348bMb5Z4fihxaBWebl8kWEi2O
# PvQImOAeq3nt7UWJBzJYLAGEpfasaA3ZQgIcEXdD+uwo6ymMzDY6UamFOfYqYWXk
# ntxDGu7ngD2ugKUuccYKJJRiiz+LAUcj90BVcSHRLQop9N8zoALr/1sJuwPrVAtx
# HNEgSW+AKBqIxYWM4Ev32l6agSUAezLMbq5f3d8x9qzT031jMDT+sUAoCw0M5wVt
# CUQcqINPuYjbS1WgJyZIiEkBMIIHejCCBWKgAwIBAgIKYQ6Q0gAAAAAAAzANBgkq
# hkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x
# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv
# bjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNhdGUgQXV0aG9yaXR5
# IDIwMTEwHhcNMTEwNzA4MjA1OTA5WhcNMjYwNzA4MjEwOTA5WjB+MQswCQYDVQQG
# EwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwG
# A1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSgwJgYDVQQDEx9NaWNyb3NvZnQg
# Q29kZSBTaWduaW5nIFBDQSAyMDExMIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIIC
# CgKCAgEAq/D6chAcLq3YbqqCEE00uvK2WCGfQhsqa+laUKq4BjgaBEm6f8MMHt03
# a8YS2AvwOMKZBrDIOdUBFDFC04kNeWSHfpRgJGyvnkmc6Whe0t+bU7IKLMOv2akr
# rnoJr9eWWcpgGgXpZnboMlImEi/nqwhQz7NEt13YxC4Ddato88tt8zpcoRb0Rrrg
# OGSsbmQ1eKagYw8t00CT+OPeBw3VXHmlSSnnDb6gE3e+lD3v++MrWhAfTVYoonpy
# 4BI6t0le2O3tQ5GD2Xuye4Yb2T6xjF3oiU+EGvKhL1nkkDstrjNYxbc+/jLTswM9
# sbKvkjh+0p2ALPVOVpEhNSXDOW5kf1O6nA+tGSOEy/S6A4aN91/w0FK/jJSHvMAh
# dCVfGCi2zCcoOCWYOUo2z3yxkq4cI6epZuxhH2rhKEmdX4jiJV3TIUs+UsS1Vz8k
# A/DRelsv1SPjcF0PUUZ3s/gA4bysAoJf28AVs70b1FVL5zmhD+kjSbwYuER8ReTB
# w3J64HLnJN+/RpnF78IcV9uDjexNSTCnq47f7Fufr/zdsGbiwZeBe+3W7UvnSSmn
# Eyimp31ngOaKYnhfsi+E11ecXL93KCjx7W3DKI8sj0A3T8HhhUSJxAlMxdSlQy90
# lfdu+HggWCwTXWCVmj5PM4TasIgX3p5O9JawvEagbJjS4NaIjAsCAwEAAaOCAe0w
# ggHpMBAGCSsGAQQBgjcVAQQDAgEAMB0GA1UdDgQWBBRIbmTlUAXTgqoXNzcitW2o
# ynUClTAZBgkrBgEEAYI3FAIEDB4KAFMAdQBiAEMAQTALBgNVHQ8EBAMCAYYwDwYD
# VR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBRyLToCMZBDuRQFTuHqp8cx0SOJNDBa
# BgNVHR8EUzBRME+gTaBLhklodHRwOi8vY3JsLm1pY3Jvc29mdC5jb20vcGtpL2Ny
# bC9wcm9kdWN0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFfMDNfMjIuY3JsMF4GCCsG
# AQUFBwEBBFIwUDBOBggrBgEFBQcwAoZCaHR0cDovL3d3dy5taWNyb3NvZnQuY29t
# L3BraS9jZXJ0cy9NaWNSb29DZXJBdXQyMDExXzIwMTFfMDNfMjIuY3J0MIGfBgNV
# HSAEgZcwgZQwgZEGCSsGAQQBgjcuAzCBgzA/BggrBgEFBQcCARYzaHR0cDovL3d3
# dy5taWNyb3NvZnQuY29tL3BraW9wcy9kb2NzL3ByaW1hcnljcHMuaHRtMEAGCCsG
# AQUFBwICMDQeMiAdAEwAZQBnAGEAbABfAHAAbwBsAGkAYwB5AF8AcwB0AGEAdABl
# AG0AZQBuAHQALiAdMA0GCSqGSIb3DQEBCwUAA4ICAQBn8oalmOBUeRou09h0ZyKb
# C5YR4WOSmUKWfdJ5DJDBZV8uLD74w3LRbYP+vj/oCso7v0epo/Np22O/IjWll11l
# hJB9i0ZQVdgMknzSGksc8zxCi1LQsP1r4z4HLimb5j0bpdS1HXeUOeLpZMlEPXh6
# I/MTfaaQdION9MsmAkYqwooQu6SpBQyb7Wj6aC6VoCo/KmtYSWMfCWluWpiW5IP0
# wI/zRive/DvQvTXvbiWu5a8n7dDd8w6vmSiXmE0OPQvyCInWH8MyGOLwxS3OW560
# STkKxgrCxq2u5bLZ2xWIUUVYODJxJxp/sfQn+N4sOiBpmLJZiWhub6e3dMNABQam
# ASooPoI/E01mC8CzTfXhj38cbxV9Rad25UAqZaPDXVJihsMdYzaXht/a8/jyFqGa
# J+HNpZfQ7l1jQeNbB5yHPgZ3BtEGsXUfFL5hYbXw3MYbBL7fQccOKO7eZS/sl/ah
# XJbYANahRr1Z85elCUtIEJmAH9AAKcWxm6U/RXceNcbSoqKfenoi+kiVH6v7RyOA
# 9Z74v2u3S5fi63V4GuzqN5l5GEv/1rMjaHXmr/r8i+sLgOppO6/8MO0ETI7f33Vt
# Y5E90Z1WTk+/gFcioXgRMiF670EKsT/7qMykXcGhiJtXcVZOSEXAQsmbdlsKgEhr
# /Xmfwb1tbWrJUnMTDXpQzTGCGaIwghmeAgEBMIGVMH4xCzAJBgNVBAYTAlVTMRMw
# EQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVN
# aWNyb3NvZnQgQ29ycG9yYXRpb24xKDAmBgNVBAMTH01pY3Jvc29mdCBDb2RlIFNp
# Z25pbmcgUENBIDIwMTECEzMAAAOvMEAOTKNNBUEAAAAAA68wDQYJYIZIAWUDBAIB
# BQCgga4wGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIBCzEO
# MAwGCisGAQQBgjcCARUwLwYJKoZIhvcNAQkEMSIEIJSi8Q9N4sgjT1f3A2tRArtv
# +IMiRAwvrPXxyyhXNMKKMEIGCisGAQQBgjcCAQwxNDAyoBSAEgBNAGkAYwByAG8A
# cwBvAGYAdKEagBhodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20wDQYJKoZIhvcNAQEB
# BQAEggEAQdJDWi47la7pzyowLGQTV4Chh/AhSKEippnZZujqR22r4cUgL/CpG4u+
# lR6LGYnZ8JEG/A7Vv+WOMLsTO8vqO5JFfwU2m9Bhq0xH8lfJ86Ok834QknGR41A1
# upP/5bm93Yz0xywV0y20+HH2JUhHBjjPQXAyuHAlZY+v51gUjN23sPzXpO5YIuXD
# 1i606+7PNYa+IfgnPn2dJYxKuvt0JgV6bX172AdPklsG48uY3w/f4/fDiLdMfd+Z
# hlHIRzuLmhvEza25br+bVu5SO6+YmKxPPLoAqCsLNKLzRHb0kMElCIaiZogg5jD0
# X6sOY4GEDoprErNk2BhhFjvn+fPQuqGCFywwghcoBgorBgEEAYI3AwMBMYIXGDCC
# FxQGCSqGSIb3DQEHAqCCFwUwghcBAgEDMQ8wDQYJYIZIAWUDBAIBBQAwggFZBgsq
# hkiG9w0BCRABBKCCAUgEggFEMIIBQAIBAQYKKwYBBAGEWQoDATAxMA0GCWCGSAFl
# AwQCAQUABCCjLsFuCQ2WXA1pEB8VyP7LS0j2LC+e2FR9JivoLkoBHgIGZpfa9w0g
# GBMyMDI0MDcyMzExMDI1My4yNzNaMASAAgH0oIHYpIHVMIHSMQswCQYDVQQGEwJV
# UzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UE
# ChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJl
# bGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxJjAkBgNVBAsTHVRoYWxlcyBUU1MgRVNO
# OkQwODItNEJGRC1FRUJBMSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBT
# ZXJ2aWNloIIRezCCBycwggUPoAMCAQICEzMAAAHcweCMwl9YXo4AAQAAAdwwDQYJ
# KoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x
# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv
# bjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwHhcNMjMx
# MDEyMTkwNzA2WhcNMjUwMTEwMTkwNzA2WjCB0jELMAkGA1UEBhMCVVMxEzARBgNV
# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv
# c29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxhbmQgT3Bl
# cmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpEMDgyLTRC
# RkQtRUVCQTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZTCC
# AiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAIvIsyA1sjg9kSKJzelrUWF5
# ShqYWL83amn3SE5JyIVPUC7F6qTcLphhHZ9idf21f0RaGrU8EHydF8NxPMR2KVNi
# AtCGPJa8kV1CGvn3beGB2m2ltmqJanG71mAywrkKATYniwKLPQLJ00EkXw5TSwfm
# JXbdgQLFlHyfA5Kg+pUsJXzqumkIvEr0DXPvptAGqkdFLKwo4BTlEgnvzeTfXukz
# X8vQtTALfVJuTUgRU7zoP/RFWt3WagahZ6UloI0FC8XlBQDVDX5JeMEsx7jgJDdE
# nK44Y8gHuEWRDq+SG9Xo0GIOjiuTWD5uv3vlEmIAyR/7rSFvcLnwAqMdqcy/iqQP
# MlDOcd0AbniP8ia1BQEUnfZT3UxyK9rLB/SRiKPyHDlg8oWwXyiv3+bGB6dmdM61
# ur6nUtfDf51lPcKhK4Vo83pOE1/niWlVnEHQV9NJ5/DbUSqW2RqTUa2O2KuvsyRG
# MEgjGJA12/SqrRqlvE2fiN5ZmZVtqSPWaIasx7a0GB+fdTw+geRn6Mo2S6+/bZEw
# S/0IJ5gcKGinNbfyQ1xrvWXPtXzKOfjkh75iRuXourGVPRqkmz5UYz+R5ybMJWj+
# mfcGqz2hXV8iZnCZDBrrnZivnErCMh5Flfg8496pT0phjUTH2GChHIvE4SDSk2hw
# WP/uHB9gEs8p/9Pe/mt9AgMBAAGjggFJMIIBRTAdBgNVHQ4EFgQU6HPSBd0OfEX3
# uNWsdkSraUGe3dswHwYDVR0jBBgwFoAUn6cVXQBeYl2D9OXSZacbUzUZ6XIwXwYD
# VR0fBFgwVjBUoFKgUIZOaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9j
# cmwvTWljcm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIwMTAoMSkuY3JsMGwG
# CCsGAQUFBwEBBGAwXjBcBggrBgEFBQcwAoZQaHR0cDovL3d3dy5taWNyb3NvZnQu
# Y29tL3BraW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBUaW1lLVN0YW1wJTIwUENBJTIw
# MjAxMCgxKS5jcnQwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcD
# CDAOBgNVHQ8BAf8EBAMCB4AwDQYJKoZIhvcNAQELBQADggIBANnrb8Ewr8eX/H1s
# Kt3rnwTDx4AqgHbkMNQo+kUGwCINXS3y1GUcdqsK/R1g6Tf7tNx1q0NpKk1JTupU
# JfHdExKtkuhHA+82lT7yISp/Y74dqJ03RCT4Q+8ooQXTMzxiewfErVLt8Wefebnc
# ST0i6ypKv87pCYkxM24bbqbM/V+M5VBppCUs7R+cETiz/zEA1AbZL/viXtHmryA0
# CGd+Pt9c+adsYfm7qe5UMnS0f/YJmEEMkEqGXCzyLK+dh+UsFi0d4lkdcE+Zq5JN
# jIHesX1wztGVAtvX0DYDZdN2WZ1kk+hOMblUV/L8n1YWzhP/5XQnYl03AfXErn+1
# Eatylifzd3ChJ1xuGG76YbWgiRXnDvCiwDqvUJevVRY1qy4y4vlVKaShtbdfgPyG
# eeJ/YcSBONOc0DNTWbjMbL50qeIEC0lHSpL2rRYNVu3hsHzG8n5u5CQajPwx9Pzp
# sZIeFTNHyVF6kujI4Vo9NvO/zF8Ot44IMj4M7UX9Za4QwGf5B71x57OjaX53gxT4
# vzoHvEBXF9qCmHRgXBLbRomJfDn60alzv7dpCVQIuQ062nyIZKnsXxzuKFb0TjXW
# w6OFpG1bsjXpOo5DMHkysribxHor4Yz5dZjVyHANyKo0bSrAlVeihcaG5F74SZT8
# FtyHAW6IgLc5w/3D+R1obDhKZ21WMIIHcTCCBVmgAwIBAgITMwAAABXF52ueAptJ
# mQAAAAAAFTANBgkqhkiG9w0BAQsFADCBiDELMAkGA1UEBhMCVVMxEzARBgNVBAgT
# Cldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29m
# dCBDb3Jwb3JhdGlvbjEyMDAGA1UEAxMpTWljcm9zb2Z0IFJvb3QgQ2VydGlmaWNh
# dGUgQXV0aG9yaXR5IDIwMTAwHhcNMjEwOTMwMTgyMjI1WhcNMzAwOTMwMTgzMjI1
# WjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH
# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD
# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDCCAiIwDQYJKoZIhvcNAQEB
# BQADggIPADCCAgoCggIBAOThpkzntHIhC3miy9ckeb0O1YLT/e6cBwfSqWxOdcjK
# NVf2AX9sSuDivbk+F2Az/1xPx2b3lVNxWuJ+Slr+uDZnhUYjDLWNE893MsAQGOhg
# fWpSg0S3po5GawcU88V29YZQ3MFEyHFcUTE3oAo4bo3t1w/YJlN8OWECesSq/XJp
# rx2rrPY2vjUmZNqYO7oaezOtgFt+jBAcnVL+tuhiJdxqD89d9P6OU8/W7IVWTe/d
# vI2k45GPsjksUZzpcGkNyjYtcI4xyDUoveO0hyTD4MmPfrVUj9z6BVWYbWg7mka9
# 7aSueik3rMvrg0XnRm7KMtXAhjBcTyziYrLNueKNiOSWrAFKu75xqRdbZ2De+JKR
# Hh09/SDPc31BmkZ1zcRfNN0Sidb9pSB9fvzZnkXftnIv231fgLrbqn427DZM9itu
# qBJR6L8FA6PRc6ZNN3SUHDSCD/AQ8rdHGO2n6Jl8P0zbr17C89XYcz1DTsEzOUyO
# ArxCaC4Q6oRRRuLRvWoYWmEBc8pnol7XKHYC4jMYctenIPDC+hIK12NvDMk2ZItb
# oKaDIV1fMHSRlJTYuVD5C4lh8zYGNRiER9vcG9H9stQcxWv2XFJRXRLbJbqvUAV6
# bMURHXLvjflSxIUXk8A8FdsaN8cIFRg/eKtFtvUeh17aj54WcmnGrnu3tz5q4i6t
# AgMBAAGjggHdMIIB2TASBgkrBgEEAYI3FQEEBQIDAQABMCMGCSsGAQQBgjcVAgQW
# BBQqp1L+ZMSavoKRPEY1Kc8Q/y8E7jAdBgNVHQ4EFgQUn6cVXQBeYl2D9OXSZacb
# UzUZ6XIwXAYDVR0gBFUwUzBRBgwrBgEEAYI3TIN9AQEwQTA/BggrBgEFBQcCARYz
# aHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9Eb2NzL1JlcG9zaXRvcnku
# aHRtMBMGA1UdJQQMMAoGCCsGAQUFBwMIMBkGCSsGAQQBgjcUAgQMHgoAUwB1AGIA
# QwBBMAsGA1UdDwQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB8GA1UdIwQYMBaAFNX2
# VsuP6KJcYmjRPZSQW9fOmhjEMFYGA1UdHwRPME0wS6BJoEeGRWh0dHA6Ly9jcmwu
# bWljcm9zb2Z0LmNvbS9wa2kvY3JsL3Byb2R1Y3RzL01pY1Jvb0NlckF1dF8yMDEw
# LTA2LTIzLmNybDBaBggrBgEFBQcBAQROMEwwSgYIKwYBBQUHMAKGPmh0dHA6Ly93
# d3cubWljcm9zb2Z0LmNvbS9wa2kvY2VydHMvTWljUm9vQ2VyQXV0XzIwMTAtMDYt
# MjMuY3J0MA0GCSqGSIb3DQEBCwUAA4ICAQCdVX38Kq3hLB9nATEkW+Geckv8qW/q
# XBS2Pk5HZHixBpOXPTEztTnXwnE2P9pkbHzQdTltuw8x5MKP+2zRoZQYIu7pZmc6
# U03dmLq2HnjYNi6cqYJWAAOwBb6J6Gngugnue99qb74py27YP0h1AdkY3m2CDPVt
# I1TkeFN1JFe53Z/zjj3G82jfZfakVqr3lbYoVSfQJL1AoL8ZthISEV09J+BAljis
# 9/kpicO8F7BUhUKz/AyeixmJ5/ALaoHCgRlCGVJ1ijbCHcNhcy4sa3tuPywJeBTp
# kbKpW99Jo3QMvOyRgNI95ko+ZjtPu4b6MhrZlvSP9pEB9s7GdP32THJvEKt1MMU0
# sHrYUP4KWN1APMdUbZ1jdEgssU5HLcEUBHG/ZPkkvnNtyo4JvbMBV0lUZNlz138e
# W0QBjloZkWsNn6Qo3GcZKCS6OEuabvshVGtqRRFHqfG3rsjoiV5PndLQTHa1V1QJ
# sWkBRH58oWFsc/4Ku+xBZj1p/cvBQUl+fpO+y/g75LcVv7TOPqUxUYS8vwLBgqJ7
# Fx0ViY1w/ue10CgaiQuPNtq6TPmb/wrpNPgkNWcr4A245oyZ1uEi6vAnQj0llOZ0
# dFtq0Z4+7X6gMTN9vMvpe784cETRkPHIqzqKOghif9lwY1NNje6CbaUFEMFxBmoQ
# tB1VM1izoXBm8qGCAtcwggJAAgEBMIIBAKGB2KSB1TCB0jELMAkGA1UEBhMCVVMx
# EzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoT
# FU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxh
# bmQgT3BlcmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpE
# MDgyLTRCRkQtRUVCQTElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vy
# dmljZaIjCgEBMAcGBSsOAwIaAxUAHDn/cz+3yRkIUCJfSbL3djnQEqaggYMwgYCk
# fjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH
# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD
# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIF
# AOpJmQYwIhgPMjAyNDA3MjMxMDUwNDZaGA8yMDI0MDcyNDEwNTA0NlowdzA9Bgor
# BgEEAYRZCgQBMS8wLTAKAgUA6kmZBgIBADAKAgEAAgIL7AIB/zAHAgEAAgIRyDAK
# AgUA6krqhgIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIB
# AAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAEfLpdF85oYM5Bwj
# 1SmLVl8YjRHsbuT/iopll/sg31AX8ikgfYytUKEcTpuOaC3vWAtvtWZPUYq+VFmO
# xFlx+Nf9t+MUfzkc3llNw82WHZXXGNaviLtQeikuczgR1r3atDIdALcKZ4To7FIz
# LnOULpDGamgy0Z+1xIAoMMhFpraPMYIEDTCCBAkCAQEwgZMwfDELMAkGA1UEBhMC
# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV
# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp
# bWUtU3RhbXAgUENBIDIwMTACEzMAAAHcweCMwl9YXo4AAQAAAdwwDQYJYIZIAWUD
# BAIBBQCgggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0B
# CQQxIgQguFPCzr/Zd8Oua6xCJwmkb3Q0jRl9OmeWZxz66UZJVQAwgfoGCyqGSIb3
# DQEJEAIvMYHqMIHnMIHkMIG9BCBTpxeKatlEP4y8qZzjuWL0Ou0IqxELDhX2TLyl
# xIINNzCBmDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u
# MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp
# b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAAB
# 3MHgjMJfWF6OAAEAAAHcMCIEIKTqURuHLgM80AjSI1mL5xzb+1IQzEuuuZtdU4eZ
# PZL7MA0GCSqGSIb3DQEBCwUABIICAHfmYH0sXQ4jWuVpulvyLHvRp2l13bu5Kxho
# AKbqONGkxhEdbk9Rj32ZmEv9K3Au3L7SzvWyFl94Yw7WFETuA14rE5gvdO0haDN/
# MBSipYtl96cMJlYmC4USX4X/7YIB7eP/YyYbfq73+lMIqd0tBECBWyQppjNcggjV
# ICq+jfEBbcSVmQm/hUH7LG/tHDIcsXqHSGVJBbyyI5A+yydQ0UTP/oFBEFxOVmc3
# qhUvS7FnBbcwryskvOgqMwGHveUENJkuQG3LauKds8UMbqpKDjJYKTmVJjAPX7zz
# AZy6PgW34QeZCCg7rVKIg5KYxKE/zNteySDZwXHBVWGKJzL7bNa6jkjDrC7j8WZt
# f0gL6IWJZhkPRkG7/S6MqtGeaxepimwTVx9miKwQWBkCua3c72szGH0QGzEBJ2yg
# Evw+tef9Gq5SB96y4h+cOEylZLlIE1eAcoTb2cwymggmMiGWdVhqDmvN+BlEyeCn
# IJ+VnAioyt3FU0SaojipvKQQPycKzscU2ZurcTCmeTmGcCg+xnzVCzA0oyIG/4Op
# J5Jb0YXSpNihspv95mWn9v4sSRCGFZJxCtxnx6RPp6zSk8HHMYHrIbwhMLBCBClj
# AFL8VfzDvzvbYcq/uEwqS3ujG2asHlYeRZe20O5U47U5cEWVWm33cR1xi098xyBi
# /S5CTd98
# SIG # End signature block