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+e2FR9JivoLkoBHgIGZnMJnUGc
# GBMyMDI0MDcwOTA4NTQyMi4yMjRaMASAAgH0oIHYpIHVMIHSMQswCQYDVQQGEwJV
# UzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UE
# ChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJl
# bGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxJjAkBgNVBAsTHVRoYWxlcyBUU1MgRVNO
# OkZDNDEtNEJENC1EMjIwMSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBT
# ZXJ2aWNloIIRezCCBycwggUPoAMCAQICEzMAAAHimZmV8dzjIOsAAQAAAeIwDQYJ
# KoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x
# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv
# bjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwHhcNMjMx
# MDEyMTkwNzI1WhcNMjUwMTEwMTkwNzI1WjCB0jELMAkGA1UEBhMCVVMxEzARBgNV
# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv
# c29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxhbmQgT3Bl
# cmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpGQzQxLTRC
# RDQtRDIyMDElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZTCC
# AiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBALVjtZhV+kFmb8cKQpg2mzis
# DlRI978Gb2amGvbAmCd04JVGeTe/QGzM8KbQrMDol7DC7jS03JkcrPsWi9WpVwsI
# ckRQ8AkX1idBG9HhyCspAavfuvz55khl7brPQx7H99UJbsE3wMmpmJasPWpgF05z
# ZlvpWQDULDcIYyl5lXI4HVZ5N6MSxWO8zwWr4r9xkMmUXs7ICxDJr5a39SSePAJR
# IyznaIc0WzZ6MFcTRzLLNyPBE4KrVv1LFd96FNxAzwnetSePg88EmRezr2T3HTFE
# lneJXyQYd6YQ7eCIc7yllWoY03CEg9ghorp9qUKcBUfFcS4XElf3GSERnlzJsK7s
# /ZGPU4daHT2jWGoYha2QCOmkgjOmBFCqQFFwFmsPrZj4eQszYxq4c4HqPnUu4hT4
# aqpvUZ3qIOXbdyU42pNL93cn0rPTTleOUsOQbgvlRdthFCBepxfb6nbsp3fcZaPB
# fTbtXVa8nLQuMCBqyfsebuqnbwj+lHQfqKpivpyd7KCWACoj78XUwYqy1HyYnStT
# me4T9vK6u2O/KThfROeJHiSg44ymFj+34IcFEhPogaKvNNsTVm4QbqphCyknrwBy
# qorBCLH6bllRtJMJwmu7GRdTQsIx2HMKqphEtpSm1z3ufASdPrgPhsQIRFkHZGui
# hL1Jjj4Lu3CbAmha0lOrAgMBAAGjggFJMIIBRTAdBgNVHQ4EFgQURIQOEdq+7Qds
# lptJiCRNpXgJ2gUwHwYDVR0jBBgwFoAUn6cVXQBeYl2D9OXSZacbUzUZ6XIwXwYD
# VR0fBFgwVjBUoFKgUIZOaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9j
# cmwvTWljcm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIwMTAoMSkuY3JsMGwG
# CCsGAQUFBwEBBGAwXjBcBggrBgEFBQcwAoZQaHR0cDovL3d3dy5taWNyb3NvZnQu
# Y29tL3BraW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBUaW1lLVN0YW1wJTIwUENBJTIw
# MjAxMCgxKS5jcnQwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcD
# CDAOBgNVHQ8BAf8EBAMCB4AwDQYJKoZIhvcNAQELBQADggIBAORURDGrVRTbnulf
# sg2cTsyyh7YXvhVU7NZMkITAQYsFEPVgvSviCylr5ap3ka76Yz0t/6lxuczI6w7t
# Xq8n4WxUUgcj5wAhnNorhnD8ljYqbck37fggYK3+wEwLhP1PGC5tvXK0xYomU1nU
# +lXOy9ZRnShI/HZdFrw2srgtsbWow9OMuADS5lg7okrXa2daCOGnxuaD1IO+65E7
# qv2O0W0sGj7AWdOjNdpexPrspL2KEcOMeJVmkk/O0ganhFzzHAnWjtNWneU11WQ6
# Bxv8OpN1fY9wzQoiycgvOOJM93od55EGeXxfF8bofLVlUE3zIikoSed+8s61NDP+
# x9RMya2mwK/Ys1xdvDlZTHndIKssfmu3vu/a+BFf2uIoycVTvBQpv/drRJD68eo4
# 01mkCRFkmy/+BmQlRrx2rapqAu5k0Nev+iUdBUKmX/iOaKZ75vuQg7hCiBA5xIm5
# ZIXDSlX47wwFar3/BgTwntMq9ra6QRAeS/o/uYWkmvqvE8Aq38QmKgTiBnWSS/uV
# PcaHEyArnyFh5G+qeCGmL44MfEnFEhxc3saPmXhe6MhSgCIGJUZDA7336nQD8fn4
# y6534Lel+LuT5F5bFt0mLwd+H5GxGzObZmm/c3pEWtHv1ug7dS/Dfrcd1sn2E4gk
# 4W1L1jdRBbK9xwkMmwY+CHZeMSvBMIIHcTCCBVmgAwIBAgITMwAAABXF52ueAptJ
# 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
# bmQgT3BlcmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjpG
# QzQxLTRCRDQtRDIyMDElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vy
# dmljZaIjCgEBMAcGBSsOAwIaAxUAFpuZafp0bnpJdIhfiB1d8pTohm+ggYMwgYCk
# fjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH
# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD
# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIF
# AOo3O2gwIhgPMjAyNDA3MDkxMjMwMzJaGA8yMDI0MDcxMDEyMzAzMlowdzA9Bgor
# BgEEAYRZCgQBMS8wLTAKAgUA6jc7aAIBADAKAgEAAgIWvgIB/zAHAgEAAgISbDAK
# AgUA6jiM6AIBADA2BgorBgEEAYRZCgQCMSgwJjAMBgorBgEEAYRZCgMCoAowCAIB
# AAIDB6EgoQowCAIBAAIDAYagMA0GCSqGSIb3DQEBBQUAA4GBAAmmPvZZPaClNurB
# qIqFoOI3rIAAmofq4mRT6Pfu0Gs++5Za7+nWQTEkvrJOoHy19rcc61104Jwvr+TQ
# dGOD/n+1B1D4TyYHKNNafbQBcp774mUnLSUYcuJtvesCX1vVk3RCgfSGFVQM66zN
# bawN+GBZHcoCIsMVidf6IIxDuUqsMYIEDTCCBAkCAQEwgZMwfDELMAkGA1UEBhMC
# VVMxEzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNV
# BAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRp
# bWUtU3RhbXAgUENBIDIwMTACEzMAAAHimZmV8dzjIOsAAQAAAeIwDQYJYIZIAWUD
# BAIBBQCgggFKMBoGCSqGSIb3DQEJAzENBgsqhkiG9w0BCRABBDAvBgkqhkiG9w0B
# CQQxIgQgezWJtDL4A0Butua8gQQfUh7X3VH1P3sQOmcCya6jaCswgfoGCyqGSIb3
# DQEJEAIvMYHqMIHnMIHkMIG9BCAriSpKEP0muMbBUETODoL4d5LU6I/bjucIZkOJ
# CI9//zCBmDCBgKR+MHwxCzAJBgNVBAYTAlVTMRMwEQYDVQQIEwpXYXNoaW5ndG9u
# MRAwDgYDVQQHEwdSZWRtb25kMR4wHAYDVQQKExVNaWNyb3NvZnQgQ29ycG9yYXRp
# b24xJjAkBgNVBAMTHU1pY3Jvc29mdCBUaW1lLVN0YW1wIFBDQSAyMDEwAhMzAAAB
# 4pmZlfHc4yDrAAEAAAHiMCIEIF9WHj1hA3a27xExt5J7pNavGYMizrB32YTqjR8u
# 15xHMA0GCSqGSIb3DQEBCwUABIICAHxozvmtBVDDxCiiGcsAH4iEBNe4uurDR4Dv
# 9jsrZskMzzLF3CbiQSPCh/Pja2rf4nAPXoKklZfNAELIIqQS0O000umhJMGsF4KK
# oqa2okD8w11SBaHchELXPB+zv40+ogFx+MfOX2f0TZaFvn9pGIxNnGQ4+UQ901z6
# gf3GL0WjW1o0TBL9qbcOTZKXh8k0iQhe14CdN1w00awVQZACU1NwvNYLYo2w9Wpd
# /OM3tvluWW9c0bU8ZjekdHYPohNA+uQRN2FG6OlwUG92aU7jRuKyVrIxr4ZwLRX+
# dQXHz/wT8SKRYbCymk7tEYH26pzmmbfETSr/g05g5tW+R19eiIvV8ULyoC2gpqbb
# ar8/R9j9nJPltfOmgqSuF1xW5zVSvclIsAUEUlngYEmn89xWYPP2TA1/QCjDq3xP
# RNXu7ft5Zv7i5jqIp8b7S9a2EB/+Tqr1yyl436M5LkZbZtSzU4mrqWa95uK378eR
# lFaQa1atJsSLNtBNInmQQR8qctHad904aHoOVC9fPRcIt8dpN6zqd1LNAy1MKOBo
# BfxZE68ngY3RkhppjtAZbIeRVIlzMGFEg/utg4KkW/y/MVtpd1U//pSfgV+dDozH
# yZY45Ga/gQyLraOh662iw6h91EkQoMYs3LZBVXYlrMqUBhZXxSLtS7A2UsGtjQ5C
# Ky4/xx6m
# SIG # End signature block