AzStackHci.EnvironmentChecker

1.2100.2685.475

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

# MIInwQYJKoZIhvcNAQcCoIInsjCCJ64CAQExDzANBglghkgBZQMEAgEFADB5Bgor

# 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

# /Xmfwb1tbWrJUnMTDXpQzTGCGaEwghmdAgEBMIGVMH4xCzAJBgNVBAYTAlVTMRMw

# 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+fPQuqGCFyswghcnBgorBgEEAYI3AwMBMYIXFzCC

# FxMGCSqGSIb3DQEHAqCCFwQwghcAAgEDMQ8wDQYJYIZIAWUDBAIBBQAwggFZBgsq

# hkiG9w0BCRABBKCCAUgEggFEMIIBQAIBAQYKKwYBBAGEWQoDATAxMA0GCWCGSAFl

# AwQCAQUABCCjLsFuCQ2WXA1pEB8VyP7LS0j2LC+e2FR9JivoLkoBHgIGZpZ9uFcD

# GBMyMDI0MDcxNjE2MjcyNS45NDVaMASAAgH0oIHYpIHVMIHSMQswCQYDVQQGEwJV

# UzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UE

# ChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMS0wKwYDVQQLEyRNaWNyb3NvZnQgSXJl

# bGFuZCBPcGVyYXRpb25zIExpbWl0ZWQxJjAkBgNVBAsTHVRoYWxlcyBUU1MgRVNO

# OjE3OUUtNEJCMC04MjQ2MSUwIwYDVQQDExxNaWNyb3NvZnQgVGltZS1TdGFtcCBT

# ZXJ2aWNloIIRejCCBycwggUPoAMCAQICEzMAAAHg1PwfExUffl0AAQAAAeAwDQYJ

# KoZIhvcNAQELBQAwfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x

# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv

# bjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTAwHhcNMjMx

# MDEyMTkwNzE5WhcNMjUwMTEwMTkwNzE5WjCB0jELMAkGA1UEBhMCVVMxEzARBgNV

# BAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jv

# c29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxhbmQgT3Bl

# cmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjoxNzlFLTRC

# QjAtODI0NjElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2VydmljZTCC

# AiIwDQYJKoZIhvcNAQEBBQADggIPADCCAgoCggIBAKyHnPOhxbvRATnGjb/6fuBh

# h3ZLzotAxAgdLaZ/zkRFUdeSKzyNt3tqorMK7GDvcXdKs+qIMUbvenlH+w53ssPa

# 6rYP760ZuFrABrfserf0kFayNXVzwT7jarJOEjnFMBp+yi+uwQ2TnJuxczceG5FD

# HrII6sF6F879lP6ydY0BBZkZ9t39e/svNRieA5gUnv/YcM/bIMY/QYmd9F0B+ebF

# Yi+PH4AkXahNkFgK85OIaRrDGvhnxOa/5zGL7Oiii7+J9/QHkdJGlfnRfbQ3QXM/

# 5/umBOKG4JoFY1niZ5RVH5PT0+uCjwcqhTbnvUtfK+N+yB2b9rEZvp2Tv4ZwYzEd

# 9A9VsYMuZiCSbaFMk77LwVbklpnw4aHWJXJkEYmJvxRbcThE8FQyOoVkSuKc5OWZ

# 2+WM/j50oblA0tCU53AauvUOZRoQBh89nHK+m5pOXKXdYMJ+ceuLYF8h5y/cXLQM

# OmqLJz5l7MLqGwU0zHV+MEO8L1Fo2zEEQ4iL4BX8YknKXonHGQacSCaLZot2kyJV

# RsFSxn0PlPvHVp0YdsCMzdeiw9jAZ7K9s1WxsZGEBrK/obipX6uxjEpyUA9mbVPl

# jlb3R4MWI0E2xI/NM6F4Ac8Ceax3YWLT+aWCZeqiIMLxyyWZg+i1KY8ZEzMeNTKC

# EI5wF1wxqr6T1/MQo+8tAgMBAAGjggFJMIIBRTAdBgNVHQ4EFgQUcF4XP26dV+8S

# usoA1XXQ2TDSmdIwHwYDVR0jBBgwFoAUn6cVXQBeYl2D9OXSZacbUzUZ6XIwXwYD

# VR0fBFgwVjBUoFKgUIZOaHR0cDovL3d3dy5taWNyb3NvZnQuY29tL3BraW9wcy9j

# cmwvTWljcm9zb2Z0JTIwVGltZS1TdGFtcCUyMFBDQSUyMDIwMTAoMSkuY3JsMGwG

# CCsGAQUFBwEBBGAwXjBcBggrBgEFBQcwAoZQaHR0cDovL3d3dy5taWNyb3NvZnQu

# Y29tL3BraW9wcy9jZXJ0cy9NaWNyb3NvZnQlMjBUaW1lLVN0YW1wJTIwUENBJTIw

# MjAxMCgxKS5jcnQwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcD

# CDAOBgNVHQ8BAf8EBAMCB4AwDQYJKoZIhvcNAQELBQADggIBAMATzg6R/A0ldO7M

# qGxD1VJji5yVA1hHb0Hc0Yjtv7WkxQ8iwfflulX5Us64tD3+3NT1JkphWzaAWf2w

# KdAw35RxtQG1iON3HEZ0X23nde4Kg/Wfbx5rEHkZ9bzKnR/2N5A16+w/1pbwJzdf

# RcnJT3cLyawr/kYjMWd63OP0Glq70ua4WUE/Po5pU7rQRbWEoQozY24hAqOcwuRc

# m6Cb0JBeTOCeRBntEKgjKep4pRaQt7b9vusT97WeJcfaVosmmPtsZsawgnpIjbBa

# 55tHfuk0vDkZtbIXjU4mr5dns9dnanBdBS2PY3N3hIfCPEOszquwHLkfkFZ/9bxw

# 8/eRJldtoukHo16afE/AqP/smmGJh5ZR0pmgW6QcX+61rdi5kDJTzCFaoMyYzUS0

# SEbyrDZ/p2KOuKAYNngljiOlllct0uJVz2agfczGjjsKi2AS1WaXvOhgZNmGw42S

# FB1qaloa8Kaux9Q2HHLE8gee/5rgOnx9zSbfVUc7IcRNodq6R7v+Rz+P6XKtOgyC

# qW/+rhPmp/n7Fq2BGTRkcy//hmS32p6qyglr2K4OoJDJXxFs6lwc8D86qlUeGjUy

# o7hVy5VvyA+y0mGnEAuA85tsOcUPlzwWF5sv+B5fz35OW3X4Spk5SiNulnLFRPM5

# XCsSHqvcbC8R3qwj2w1evPhZxDuNMIIHcTCCBVmgAwIBAgITMwAAABXF52ueAptJ

# 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

# tB1VM1izoXBm8qGCAtYwggI/AgEBMIIBAKGB2KSB1TCB0jELMAkGA1UEBhMCVVMx

# EzARBgNVBAgTCldhc2hpbmd0b24xEDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoT

# FU1pY3Jvc29mdCBDb3Jwb3JhdGlvbjEtMCsGA1UECxMkTWljcm9zb2Z0IElyZWxh

# bmQgT3BlcmF0aW9ucyBMaW1pdGVkMSYwJAYDVQQLEx1UaGFsZXMgVFNTIEVTTjox

# NzlFLTRCQjAtODI0NjElMCMGA1UEAxMcTWljcm9zb2Z0IFRpbWUtU3RhbXAgU2Vy

# dmljZaIjCgEBMAcGBSsOAwIaAxUAbfPR1fBX6HxYfyPx8zYzJU5fIQyggYMwgYCk

# fjB8MQswCQYDVQQGEwJVUzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMH

# UmVkbW9uZDEeMBwGA1UEChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQD

# Ex1NaWNyb3NvZnQgVGltZS1TdGFtcCBQQ0EgMjAxMDANBgkqhkiG9w0BAQUFAAIF

# AOpA/DQwIhgPMjAyNDA3MTYyMjAzMzJaGA8yMDI0MDcxNzIyMDMzMlowdjA8Bgor

# BgEEAYRZCgQBMS4wLDAKAgUA6kD8NAIBADAJAgEAAgEJAgH/MAcCAQACAhEgMAoC

# BQDqQk20AgEAMDYGCisGAQQBhFkKBAIxKDAmMAwGCisGAQQBhFkKAwKgCjAIAgEA

# AgMHoSChCjAIAgEAAgMBhqAwDQYJKoZIhvcNAQEFBQADgYEAHSIMop6bF2goNgKC

# +/c/y7GKNDOkVmsYMcke0YmC9HQur4dfjCfRQeT7Lve+hvktLDPk/FJjZacTves9

# 7HKS7lc+xESWm4IgMdF7Z6XI2URMq1ER3mgcWko9f3KGX/1kQYmkp8cMXwdM/9YB

# gpPDSJPFDIOmCNmoLa3pfKZbnrIxggQNMIIECQIBATCBkzB8MQswCQYDVQQGEwJV

# UzETMBEGA1UECBMKV2FzaGluZ3RvbjEQMA4GA1UEBxMHUmVkbW9uZDEeMBwGA1UE

# ChMVTWljcm9zb2Z0IENvcnBvcmF0aW9uMSYwJAYDVQQDEx1NaWNyb3NvZnQgVGlt

# ZS1TdGFtcCBQQ0EgMjAxMAITMwAAAeDU/B8TFR9+XQABAAAB4DANBglghkgBZQME

# AgEFAKCCAUowGgYJKoZIhvcNAQkDMQ0GCyqGSIb3DQEJEAEEMC8GCSqGSIb3DQEJ

# BDEiBCDS901uqIC3BERqmOWZqkfGUL4rnATs8eZHsdjXJ6qHTDCB+gYLKoZIhvcN

# AQkQAi8xgeowgecwgeQwgb0EIOPuUr/yOeVtOM+9zvsMIJJvhNkClj2cmbnCGwr/

# aQrBMIGYMIGApH4wfDELMAkGA1UEBhMCVVMxEzARBgNVBAgTCldhc2hpbmd0b24x

# EDAOBgNVBAcTB1JlZG1vbmQxHjAcBgNVBAoTFU1pY3Jvc29mdCBDb3Jwb3JhdGlv

# bjEmMCQGA1UEAxMdTWljcm9zb2Z0IFRpbWUtU3RhbXAgUENBIDIwMTACEzMAAAHg

# 1PwfExUffl0AAQAAAeAwIgQgcnBuVx8nJrFuw7FnDirjt5/i4d0MFqs2/TMRf2PM

# mCQwDQYJKoZIhvcNAQELBQAEggIAX1xCbtjUdDl7L5Q/uIMWMB2zIpzkVAXyFkPr

# S5dUuyEY52/De0nrM+DHwsJHMW8SMnM2gCIxBqHlTJ+AlwlnbInMJNN79uwM0Idv

# 5EJpOJYrmdVHyKMrsFsHtqZq0lQPu5JflGMhieBcmFuhhpvo+vSVoIRrtrF6O6N5

# s5CnQD+vo46B0GgOcU3bqbeZZkf56N6oRohDvVXyhkxzTLE9JfVYbO1943s+LZSL

# d5rdcSK0slFqP6yRZZNSC8AUKFaB2hQncC2Ad3zUo/fWLFI8RYt6XxDOQ/2nWilG

# jDjJXWtkVgt45kHfpQo3G6zS1lGsH6a9QEJRBL8EXmEJGAl3YWlrF3ffDd6dUNHq

# 0duilmzXtYozCrnWQv0sJV/2q5fnwkOHxU1G0srK2jrJuD+hYMW+NcQBnYBk9TAK

# n9+EOfP31YvuCC3ccxhInAR7/SW4CtTpgUg2yw3lUENcc7/xA+2+FxZ1+yN2qQyG

# NH3XNUg0GqC4q7b0RrbBRiD65qOROL+FqV4JcHUXDb513m9aHEEhoBvuiOlMR5bp

# jiX+hxxaE+Y5nowDrvCtU8L/BG5hcvp3dh12Ao/G707rNp42DRycU6cSMiQ/kGvF

# aE85FlrUF4JhWK0o+Rhq3g5AP5PH3VB7tTgQm7ShOvrKF6ZWHVGqMtKSEAUKAU7l

# dQRetBU=

# SIG # End signature block