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
# MIIoQwYJKoZIhvcNAQcCoIIoNDCCKDACAQExDzANBglghkgBZQMEAgEFADB5Bgor
# 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
# /Xmfwb1tbWrJUnMTDXpQzTGCGiMwghofAgEBMIGVMH4xCzAJBgNVBAYTAlVTMRMw
# 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+fPQuqGCF60wghepBgorBgEEAYI3AwMBMYIXmTCC
# F5UGCSqGSIb3DQEHAqCCF4YwgheCAgEDMQ8wDQYJYIZIAWUDBAIBBQAwggFaBgsq
# hkiG9w0BCRABBKCCAUkEggFFMIIBQQIBAQYKKwYBBAGEWQoDATAxMA0GCWCGSAFl
# AwQCAQUABCCjLsFuCQ2WXA1pEB8VyP7LS0j2LC+e2FR9JivoLkoBHgIGZutJ0vEA
# GBMyMDI0MTAwOTAxMTIzOS43MjdaMASAAgH0oIHZpIHWMIHTMQswCQYDVQQGEwJV
# UzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UE
# ChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJl
# bGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVT
# Tjo0QzFBLTA1RTAtRDk0NzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAg
# U2VydmljZaCCEfswggcoMIIFEKADAgECAhMzAAAB/xI4fPfBZdahAAEAAAH/MA0G
# CSqGSIb3DQEBCwUAMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u
# MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp
# b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwMB4XDTI0
# MDcyNTE4MzExOVoXDTI1MTAyMjE4MzExOVowgdMxCzAJBgNVBAYTAlVTMRMwEQYD
# VQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNy
# b3NvZnQgQ29ycG9yYXRpb24xLTArBgNVBAsTJE1pY3Jvc29mdCBJcmVsYW5kIE9w
# ZXJhdGlvbnMgTGltaXRlZDEnMCUGA1UECxMeblNoaWVsZCBUU1MgRVNOOjRDMUEt
# MDVFMC1EOTQ3MSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBTZXJ2aWNl
# MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEAyeiV0pB7bg8/qc/mkiDd
# JXnzJWPYgk9mTGeI3pzQpsyrRJREWcKYHd/9db+g3z4dU4VCkAZEXqvkxP5QNTtB
# G5Ipexpph4PhbiJKwvX+US4KkSFhf1wflDAY1tu9CQqhhxfHFV7vhtmqHLCCmDxh
# ZPmCBh9/XfFJQIUwVZR8RtUkgzmN9bmWiYgfX0R+bDAnncUdtp1xjGmCpdBMygk/
# K0h3bUTUzQHb4kPf2ylkKPoWFYn2GNYgWw8PGBUO0vTMKjYD6pLeBP0hZDh5P3f4
# xhGLm6x98xuIQp/RFnzBbgthySXGl+NT1cZAqGyEhT7L0SdR7qQlv5pwDNerbK3Y
# SEDKk3sDh9S60hLJNqP71iHKkG175HAyg6zmE5p3fONr9/fIEpPAlC8YisxXaGX4
# RpDBYVKpGj0FCZwisiZsxm0X9w6ZSk8OOXf8JxTYWIqfRuWzdUir0Z3jiOOtaDq7
# XdypB4gZrhr90KcPTDRwvy60zrQca/1D1J7PQJAJObbiaboi12usV8axtlT/dCeP
# C4ndcFcar1v+fnClhs9u3Fn6LkHDRZfNzhXgLDEwb6dA4y3s6G+gQ35o90j2i6am
# aa8JsV/cCF+iDSGzAxZY1sQ1mrdMmzxfWzXN6sPJMy49tdsWTIgZWVOSS9uUHhSY
# kbgMxnLeiKXeB5MB9QMcOScCAwEAAaOCAUkwggFFMB0GA1UdDgQWBBTD+pXk/rT/
# d7E/0QE7hH0wz+6UYTAfBgNVHSMEGDAWgBSfpxVdAF5iXYP05dJlpxtTNRnpcjBf
# BgNVHR8EWDBWMFSgUqBQhk5odHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3Bz
# L2NybC9NaWNyb3NvZnQlMjBUaW1lLVN0YW1wJTIwUENBJTIwMjAxMCgxKS5jcmww
# bAYIKwYBBQUHAQEEYDBeMFwGCCsGAQUFBzAChlBodHRwOi8vd3d3Lm1pY3Jvc29m
# dC5jb20vcGtpb3BzL2NlcnRzL01pY3Jvc29mdCUyMFRpbWUtU3RhbXAlMjBQQ0El
# MjAyMDEwKDEpLmNydDAMBgNVHRMBAf8EAjAAMBYGA1UdJQEB/wQMMAoGCCsGAQUF
# BwMIMA4GA1UdDwEB/wQEAwIHgDANBgkqhkiG9w0BAQsFAAOCAgEAOSNN5MpLiyun
# m866frWIi0hdazKNLgRp3WZPfhYgPC3K/DNMzLliYQUAp6WtgolIrativXjOG1lI
# jayG9r6ew4H1n5XZdDfJ12DLjopap5e1iU/Yk0eutPyfOievfbsIzTk/G51+uiUJ
# k772nVzau6hI2KGyGBJOvAbAVFR0g8ppZwLghT4z3mkGZjq/O4Z/PcmVGtjGps2T
# CtI4rZjPNW8O4c/4aJRmYQ/NdW91JRrOXRpyXrTKUPe3kN8N56jpl9kotLhdvd89
# RbOsJNf2XzqbAV7XjV4caCglA2btzDxcyffwXhLu9HMU3dLYTAI91gTNUF7BA9q1
# EvSlCKKlN8N10Y4iU0nyIkfpRxYyAbRyq5QPYPJHGA0Ty0PD83aCt79Ra0IdDIMS
# uwXlpUnyIyxwrDylgfOGyysWBwQ/js249bqQOYPdpyOdgRe8tXdGrgDoBeuVOK+c
# RClXpimNYwr61oZ2/kPMzVrzRUYMkBXe9WqdSezh8tytuulYYcRK95qihF0irQs6
# /WOQJltQX79lzFXE9FFln9Mix0as+C4HPzd+S0bBN3A3XRROwAv016ICuT8hY1In
# yW7jwVmN+OkQ1zei66LrU5RtAz0nTxx5OePyjnTaItTSY4OGuGU1SXaH49JSP3t8
# yGYA/vorbW4VneeD721FgwaJToHFkOIwggdxMIIFWaADAgECAhMzAAAAFcXna54C
# m0mZAAAAAAAVMA0GCSqGSIb3DQEBCwUAMIGIMQswCQYDVQQGEwJVUzETMBEGA1UE
# CBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9z
# b2Z0IENvcnBvcmF0aW9uMTIwMAYDVQQDEylNaWNyb3NvZnQgUm9vdCBDZXJ0aWZp
# Y2F0ZSBBdXRob3JpdHkgMjAxMDAeFw0yMTA5MzAxODIyMjVaFw0zMDA5MzAxODMy
# MjVaMHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQH
# EwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNV
# BAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwMIICIjANBgkqhkiG9w0B
# AQEFAAOCAg8AMIICCgKCAgEA5OGmTOe0ciELeaLL1yR5vQ7VgtP97pwHB9KpbE51
# yMo1V/YBf2xK4OK9uT4XYDP/XE/HZveVU3Fa4n5KWv64NmeFRiMMtY0Tz3cywBAY
# 6GB9alKDRLemjkZrBxTzxXb1hlDcwUTIcVxRMTegCjhuje3XD9gmU3w5YQJ6xKr9
# cmmvHaus9ja+NSZk2pg7uhp7M62AW36MEBydUv626GIl3GoPz130/o5Tz9bshVZN
# 7928jaTjkY+yOSxRnOlwaQ3KNi1wjjHINSi947SHJMPgyY9+tVSP3PoFVZhtaDua
# Rr3tpK56KTesy+uDRedGbsoy1cCGMFxPLOJiss254o2I5JasAUq7vnGpF1tnYN74
# kpEeHT39IM9zfUGaRnXNxF803RKJ1v2lIH1+/NmeRd+2ci/bfV+AutuqfjbsNkz2
# K26oElHovwUDo9Fzpk03dJQcNIIP8BDyt0cY7afomXw/TNuvXsLz1dhzPUNOwTM5
# TI4CvEJoLhDqhFFG4tG9ahhaYQFzymeiXtcodgLiMxhy16cg8ML6EgrXY28MyTZk
# i1ugpoMhXV8wdJGUlNi5UPkLiWHzNgY1GIRH29wb0f2y1BzFa/ZcUlFdEtsluq9Q
# BXpsxREdcu+N+VLEhReTwDwV2xo3xwgVGD94q0W29R6HXtqPnhZyacaue7e3Pmri
# Lq0CAwEAAaOCAd0wggHZMBIGCSsGAQQBgjcVAQQFAgMBAAEwIwYJKwYBBAGCNxUC
# BBYEFCqnUv5kxJq+gpE8RjUpzxD/LwTuMB0GA1UdDgQWBBSfpxVdAF5iXYP05dJl
# pxtTNRnpcjBcBgNVHSAEVTBTMFEGDCsGAQQBgjdMg30BATBBMD8GCCsGAQUFBwIB
# FjNodHRwOi8vd3d3Lm1pY3Jvc29mdC5jb20vcGtpb3BzL0RvY3MvUmVwb3NpdG9y
# eS5odG0wEwYDVR0lBAwwCgYIKwYBBQUHAwgwGQYJKwYBBAGCNxQCBAweCgBTAHUA
# YgBDAEEwCwYDVR0PBAQDAgGGMA8GA1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAU
# 1fZWy4/oolxiaNE9lJBb186aGMQwVgYDVR0fBE8wTTBLoEmgR4ZFaHR0cDovL2Ny
# bC5taWNyb3NvZnQuY29tL3BraS9jcmwvcHJvZHVjdHMvTWljUm9vQ2VyQXV0XzIw
# MTAtMDYtMjMuY3JsMFoGCCsGAQUFBwEBBE4wTDBKBggrBgEFBQcwAoY+aHR0cDov
# L3d3dy5taWNyb3NvZnQuY29tL3BraS9jZXJ0cy9NaWNSb29DZXJBdXRfMjAxMC0w
# Ni0yMy5jcnQwDQYJKoZIhvcNAQELBQADggIBAJ1VffwqreEsH2cBMSRb4Z5yS/yp
# b+pcFLY+TkdkeLEGk5c9MTO1OdfCcTY/2mRsfNB1OW27DzHkwo/7bNGhlBgi7ulm
# ZzpTTd2YurYeeNg2LpypglYAA7AFvonoaeC6Ce5732pvvinLbtg/SHUB2RjebYIM
# 9W0jVOR4U3UkV7ndn/OOPcbzaN9l9qRWqveVtihVJ9AkvUCgvxm2EhIRXT0n4ECW
# OKz3+SmJw7wXsFSFQrP8DJ6LGYnn8AtqgcKBGUIZUnWKNsIdw2FzLixre24/LAl4
# FOmRsqlb30mjdAy87JGA0j3mSj5mO0+7hvoyGtmW9I/2kQH2zsZ0/fZMcm8Qq3Uw
# xTSwethQ/gpY3UA8x1RtnWN0SCyxTkctwRQEcb9k+SS+c23Kjgm9swFXSVRk2XPX
# fx5bRAGOWhmRaw2fpCjcZxkoJLo4S5pu+yFUa2pFEUep8beuyOiJXk+d0tBMdrVX
# VAmxaQFEfnyhYWxz/gq77EFmPWn9y8FBSX5+k77L+DvktxW/tM4+pTFRhLy/AsGC
# onsXHRWJjXD+57XQKBqJC4822rpM+Zv/Cuk0+CQ1ZyvgDbjmjJnW4SLq8CdCPSWU
# 5nR0W2rRnj7tfqAxM328y+l7vzhwRNGQ8cirOoo6CGJ/2XBjU02N7oJtpQUQwXEG
# ahC0HVUzWLOhcGbyoYIDVjCCAj4CAQEwggEBoYHZpIHWMIHTMQswCQYDVQQGEwJV
# UzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UE
# ChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJl
# bGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxJzAlBgNVBAsTHm5TaGllbGQgVFNTIEVT
# Tjo0QzFBLTA1RTAtRDk0NzElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAg
# U2VydmljZaIjCgEBMAcGBSsOAwIaAxUAqROMbMS8JcUlcnPkwRLFRPXFspmggYMw
# gYCkfjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UE
# BxMHUmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYD
# VQQDEx1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQsF
# AAIFAOqwJSYwIhgPMjAyNDEwMDgyMTM5NTBaGA8yMDI0MTAwOTIxMzk1MFowdDA6
# BgorBgEEAYRZCgQBMSwwKjAKAgUA6rAlJgIBADAHAgEAAgIKXzAHAgEAAgITsTAK
# AgUA6rF2pgIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIB
# AAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBCwUAA4IBAQBzQiY07FEUhOen
# m6kx2rf8qISPVuJ1BYoPjZErEMx0EaWVhAQGHaFgy0OPKikbZSHfyIx4L5IIQatu
# xi5cbfyrXZOZFaZ4cCEJ3SZ1y9HrWkKeSv6dUeAG4gSiSUAODA7TGm/HVJZLQ7yp
# rQtTZRnP0OLnwM1k5xyZJU8TKdql3DMNU4QQOAZrXCj3g88uAl7Kfx6bBC+T1Nyb
# 511GI8z/qqRV4RBtc9y3u7UNs4k4yPP6wfuetHmc8mZTkf0ss7nNuTFIXRH3jO2R
# yV8mxYypEBRILqGWoEmiIoNn9wthrlIFa6JxO8JWZuTKAdyhGtEvQxeh6b0uQDGq
# Nia/VapdMYIEDTCCBAkCAQEwgZMwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldh
# c2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBD
# b3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIw
# MTACEzMAAAH/Ejh898Fl1qEAAQAAAf8wDQYJYIZIAWUDBAIBBQCgggFKMBoGCSqG
# SIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0BCQQxIgQgiy/IZM7sjojq
# dNOERMoOg7UmwOd0bFCfQuWnsG9MYTYwgfoGCyqGSIb3DQEJEAIvMYHqMIHnMIHk
# MIG9BCDkMu++yQJ3aaycIuMT6vA7JNuMaVOI3qDjSEV8upyn/TCBmDCBgKR+MHwx
# CzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9uMRAwDgYDVQQHEwdSZWRt
# b25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRpb24xJjAkBgNVBAMTHU1p
# Y3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAAB/xI4fPfBZdahAAEAAAH/
# MCIEIL5Cc5fop5CuEtPzNX9xsNxj8mMvTAQugdNYCYrnpaQkMA0GCSqGSIb3DQEB
# CwUABIICAIUT441Jgz97Vp4vu2clk4I2S1gh6lF36NOEx4NkYsv+Xj3B/KcIukAK
# mwT5UcJ82zF++Wb+wENhlLIrpshmAApQXRLJne6Gqi/a8Qu6NPdDLUi2auCzvuUz
# 5oJIURzTurWzzE4pa1GHiM0GW5t6bd8jXq2yofBtyRFW4mEsMBM/QshRsmy6dONF
# U3cYD/gxYhjQIZOgyLOiX7jyN6NF9KeiN/7vh5neWh4KtL8q0h0tlA5DiwHfBcPZ
# zlyqNp/0oKZlQwFZyrqAwDIQRhf9x3yRBSxcG5rtbXNkkjgQauVie+NKAb2MIUhn
# CXawG/Wbvy8kK2h0g8l5iDuoT0KmnQv7kzR4c6R/nIIlU3HRvtOaTDCqIZJUyZl1
# LjkQckNnDb7PWG3+VqZqLkwHWovxEIIEwUVLdwXxgiaiplxLh4i91+BBPGIDf2ms
# H/oRdLDYGCRn/zbu8Tre+7pCiamT+Vo+M1vkwVtcys2itHNDn8B5Mx3PxbJpaN9T
# /lwvZ3/nzxOZfZXz0Vnh8EWbRUx4yhg7I1xOI5V65X07gH58XxwvQUL7gFR9qtNn
# C5qj/8gjw3Ba1CWtRe/36CxgrIFfcoMvKqgLWzKBy2IwS6ev8AIgcKBk2GeUeyln
# f8osFYZ7E76HP+7qf31eEI2oBsxxFg5jny6ZOpSjLp9nOviIrez+
# SIG # End signature block