WordManager

0.0.1

WordManager.psm1

                                function Write-Color {

    <#

    .SYNOPSIS

        Write-Color is a wrapper around Write-Host.

        It provides:

        - Easy manipulation of colors,

        - Logging output to file (log)

        - Nice formatting options out of the box.

    .DESCRIPTION

        Author: przemyslaw.klys at evotec.pl

        Project website: https://evotec.xyz/hub/scripts/write-color-ps1/

        Project support: https://github.com/EvotecIT/PSWriteColor

        Original idea: Josh (https://stackoverflow.com/users/81769/josh)

    .EXAMPLE

    Write-Color -Text "Red ", "Green ", "Yellow " -Color Red,Green,Yellow

    .EXAMPLE

    Write-Color -Text "This is text in Green ",

                    "followed by red ",

                    "and then we have Magenta... ",

                    "isn't it fun? ",

                    "Here goes DarkCyan" -Color Green,Red,Magenta,White,DarkCyan

    .EXAMPLE

    Write-Color -Text "This is text in Green ",

                    "followed by red ",

                    "and then we have Magenta... ",

                    "isn't it fun? ",

                    "Here goes DarkCyan" -Color Green,Red,Magenta,White,DarkCyan -StartTab 3 -LinesBefore 1 -LinesAfter 1

    .EXAMPLE

    Write-Color "1. ", "Option 1" -Color Yellow, Green

    Write-Color "2. ", "Option 2" -Color Yellow, Green

    Write-Color "3. ", "Option 3" -Color Yellow, Green

    Write-Color "4. ", "Option 4" -Color Yellow, Green

    Write-Color "9. ", "Press 9 to exit" -Color Yellow, Gray -LinesBefore 1

    .EXAMPLE

    Write-Color -LinesBefore 2 -Text "This little ","message is ", "written to log ", "file as well." `

                -Color Yellow, White, Green, Red, Red -LogFile "C:\testing.txt" -TimeFormat "yyyy-MM-dd HH:mm:ss"

    Write-Color -Text "This can get ","handy if ", "want to display things, and log actions to file ", "at the same time." `

                -Color Yellow, White, Green, Red, Red -LogFile "C:\testing.txt"

    .EXAMPLE

    # Added in 0.5

    Write-Color -T "My text", " is ", "all colorful" -C Yellow, Red, Green -B Green, Green, Yellow

    wc -t "my text" -c yellow -b green

    wc -text "my text" -c red

    .NOTES

        Additional Notes:

        - TimeFormat https://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

    #>

    [alias('Write-Colour')]

    [CmdletBinding()]

    param ([alias ('T')] [String[]]$Text,

        [alias ('C', 'ForegroundColor', 'FGC')] [ConsoleColor[]]$Color = [ConsoleColor]::White,

        [alias ('B', 'BGC')] [ConsoleColor[]]$BackGroundColor = $null,

        [alias ('Indent')][int] $StartTab = 0,

        [int] $LinesBefore = 0,

        [int] $LinesAfter = 0,

        [int] $StartSpaces = 0,

        [alias ('L')] [string] $LogFile = '',

        [Alias('DateFormat', 'TimeFormat')][string] $DateTimeFormat = 'yyyy-MM-dd HH:mm:ss',

        [alias ('LogTimeStamp')][bool] $LogTime = $true,

        [int] $LogRetry = 2,

        [ValidateSet('unknown', 'string', 'unicode', 'bigendianunicode', 'utf8', 'utf7', 'utf32', 'ascii', 'default', 'oem')][string]$Encoding = 'Unicode',

        [switch] $ShowTime,

        [switch] $NoNewLine)

    $DefaultColor = $Color[0]

    if ($null -ne $BackGroundColor -and $BackGroundColor.Count -ne $Color.Count) {

        Write-Error "Colors, BackGroundColors parameters count doesn't match. Terminated."

        return

    }

    if ($LinesBefore -ne 0) { for ($i = 0; $i -lt $LinesBefore; $i++) { Write-Host -Object "`n" -NoNewline } }

    if ($StartTab -ne 0) { for ($i = 0; $i -lt $StartTab; $i++) { Write-Host -Object "`t" -NoNewline } }

    if ($StartSpaces -ne 0) { for ($i = 0; $i -lt $StartSpaces; $i++) { Write-Host -Object ' ' -NoNewline } }

    if ($ShowTime) { Write-Host -Object "[$([datetime]::Now.ToString($DateTimeFormat))] " -NoNewline }

    if ($Text.Count -ne 0) {

        if ($Color.Count -ge $Text.Count) { if ($null -eq $BackGroundColor) { for ($i = 0; $i -lt $Text.Length; $i++) { Write-Host -Object $Text[$i] -ForegroundColor $Color[$i] -NoNewline } } else { for ($i = 0; $i -lt $Text.Length; $i++) { Write-Host -Object $Text[$i] -ForegroundColor $Color[$i] -BackgroundColor $BackGroundColor[$i] -NoNewline } } } else {

            if ($null -eq $BackGroundColor) {

                for ($i = 0; $i -lt $Color.Length; $i++) { Write-Host -Object $Text[$i] -ForegroundColor $Color[$i] -NoNewline }

                for ($i = $Color.Length; $i -lt $Text.Length; $i++) { Write-Host -Object $Text[$i] -ForegroundColor $DefaultColor -NoNewline }

            } else {

                for ($i = 0; $i -lt $Color.Length; $i++) { Write-Host -Object $Text[$i] -ForegroundColor $Color[$i] -BackgroundColor $BackGroundColor[$i] -NoNewline }

                for ($i = $Color.Length; $i -lt $Text.Length; $i++) { Write-Host -Object $Text[$i] -ForegroundColor $DefaultColor -BackgroundColor $BackGroundColor[0] -NoNewline }

            }

        }

    }

    if ($NoNewLine -eq $true) { Write-Host -NoNewline } else { Write-Host }

    if ($LinesAfter -ne 0) { for ($i = 0; $i -lt $LinesAfter; $i++) { Write-Host -Object "`n" -NoNewline } }

    if ($Text.Count -and $LogFile) {

        $TextToFile = ""

        for ($i = 0; $i -lt $Text.Length; $i++) { $TextToFile += $Text[$i] }

        $Saved = $false

        $Retry = 0

        Do {

            $Retry++

            try {

                if ($LogTime) { "[$([datetime]::Now.ToString($DateTimeFormat))] $TextToFile" | Out-File -FilePath $LogFile -Encoding $Encoding -Append -ErrorAction Stop -WhatIf:$false } else { "$TextToFile" | Out-File -FilePath $LogFile -Encoding $Encoding -Append -ErrorAction Stop -WhatIf:$false }

                $Saved = $true

            } catch { if ($Saved -eq $false -and $Retry -eq $LogRetry) { $PSCmdlet.WriteError($_) } else { Write-Warning "Write-Color - Couldn't write to log file $($_.Exception.Message). Retrying... ($Retry/$LogRetry)" } }

        } Until ($Saved -eq $true -or $Retry -ge $LogRetry)

    }

}

function Convert-WordDocumentToPDF {

    [cmdletBinding()]

    param([Parameter(Mandatory)][string] $SourceFolder,

        [string] $DestinationFolder,

        [switch] $DestinationSameFolder,

        [switch] $Recursive,

        [int] $LimitProcessing)

    if ($LimitProcessing -eq 0) { $ListOfFiles = Get-ChildItem -Path $SourceFolder -Filter *.doc? -File -Recurse:$Recursive.IsPresent } else { $ListOfFiles = Get-ChildItem -Path $SourceFolder -Filter *.doc? -File -Recurse:$Recursive.IsPresent | Select-Object -First $LimitProcessing }

    $WordApplication = New-Object -ComObject Word.Application

    $WordApplication.Visible = $false

    foreach ($File in $ListOfFiles) {

        Write-Color -Text "Konwertuje plik ", "$($File.FullName)", ' do PDF ' -Color Yellow, Green, Yellow

        $document = $WordApplication.Documents.Open($File.FullName)

        if ($DestinationFolder) {

            if ($DestinationSameFolder) { $NewPath = [System.IO.Path]::Combine($DestinationFolder, $File.BaseName + ".pdf") } else {

                $RemainingPart = $File.DirectoryName.Replace($SourceFolder, "").TrimStart('\\').TrimEnd('\\')

                $NewDirectory = [System.IO.Path]::Combine($DestinationFolder, $RemainingPart)

                $NewPath = [System.IO.Path]::Combine($NewDirectory, $File.BaseName + ".pdf")

                if (-not (Test-Path -LiteralPath $NewDirectory)) { $null = New-Item -ItemType Directory -Force -Path $NewDirectory }

                if (Test-Path -LiteralPath $NewDirectory) { $pdf_filename = "$NewPath" } else {

                    Write-Color -Text "Folder docelowy nie istnieje ", $DestinationFolder, ". Stwórz go i spróbuj ponownie" -Color White, Red, White

                    return

                }

            }

        } else {

            if (-not (Test-Path -LiteralPath $File.DirectoryName)) { $null = New-Item -ItemType Directory -Force -Path $File.DirectoryName }

            $pdf_filename = "$($File.DirectoryName)\$($File.BaseName).pdf"

        }

        try {

            Write-Color -Text "Zapisuje plik jako ", "$($pdf_filename)", ' do PDF ' -Color Yellow, Green, Yellow

            $document.SaveAs([ref] $pdf_filename, [ref] 17)

        } catch { Write-Color -Text "Nie udało się zapisać pliku ", $pdf_filename, " do folderu ", $DestinationFolder, ". błąd: ", $_.Exception.Message -Color White, Red, White, Red, White, Red }

        $document.Close()

    }

    $WordApplication.Quit()

}

function Update-WordDocument {

    [cmdletBinding()]

    param([Parameter(Mandatory)][string] $TemplateDocument,

        [Parameter(Mandatory)][string] $SourceFolder,

        [string] $DestinationFolder,

        [switch] $Recursive,

        [int] $LimitProcessing,

        [switch] $DifferentFirstPage,

        [switch] $DifferentOddAndEvenPages,

        [switch] $OpenDocument)

    if (-not (Test-Path -LiteralPath $SourceFolder)) {

        Write-Color -Text "Folder ", $SourceFolder, " nie istnieje. Wskaż poprawnhy folder..." -Color Red, Yellow, Red

        return

    }

    if ($LimitProcessing -eq 0) { $ListOfFiles = Get-ChildItem -Path $SourceFolder -File -Recurse:$Recursive.IsPresent -Filter '*.docx' } else { $ListOfFiles = Get-ChildItem -Path $SourceFolder -File -Recurse:$Recursive.IsPresent -Filter '*.docx' | Select-Object -First $LimitProcessing }

    $Table = $null

    $DocumentStopka = Get-WordDocument -FilePath $TemplateDocument

    $Table = $DocumentStopka.Tables[0]

    foreach ($File in $ListOfFiles) {

        Write-Color -Text "Procesuje ", "$($File.FullName)" -Color White, Yellow, White, Yellow

        $DestinationFile = "$env:TEMP\$($File.Name)"

        Write-Color -Text "[+] Kopiuje plik ", $File.FullName, " do ", "$($DestinationFile)" -Color White, Yellow, White, Yellow

        try { Copy-Item -LiteralPath $File.FullName -Destination $DestinationFile -Force -ErrorAction Stop } catch {

            Write-Color -Text "[-] Nie udalo sie skopiowac pliku ", "$($File.FullName)", " do ", $DestinationFile, ". Błąd: ", $_.Exception.Message -Color White, Red, White, Red

            if ($ErrorActionPreference -eq 'Stop') { break } else { continue }

        }

        Write-Color -Text "[+] Otwieram plik ", $DestinationFile, " do edycji by usunąć mu stopki" -Color White, Yellow, White, Yellow

        $DocumentWord = Get-OfficeWord -FilePath $DestinationFile

        $null = Remove-OfficeWordFooter -Document $DocumentWord

        Save-OfficeWord -Document $DocumentWord -FilePath $DestinationFile -Retry 1

        Write-Color -Text "[+] Otwieram plik ", $DestinationFile, " do edycji by podmienić mu stopki" -Color White, Yellow, White, Yellow

        $Document = Get-WordDocument -FilePath $DestinationFile -WarningAction SilentlyContinue -WarningVariable varWarning

        if ($varWarning) {

            Write-Color -Text "Nie mozna otworzyć dokumentu ", "$($DestinationFile). ", $varWarning -Color White, Red, White

            if ($ErrorActionPreference -eq 'Stop') { break } else { continue }

        }

        if ($Document) {

            $Document.Footers.Odd = $null

            $Document.Footers.Even = $null

            $Document.Footers.First = $null

            $Document.AddFooters()

            $Document.DifferentFirstPage = $DifferentFirstPage.IsPresent

            $Document.DifferentOddAndEvenPages = $DifferentOddAndEvenPages.IsPresent

            foreach ($Type in @('Odd', 'Even', 'First')) {

                $null = $Document.Footers.$Type.InsertTable($Table)

                $null = $Document.Footers.$Type.Paragraphs[0].Remove($false)

                $Paragraph = $Document.Footers.$Type.InsertParagraph()

                $Paragraph.LineSpacing = 0.1

            }

            Save-WordDocument -WordDocument $Document -Supress $true -FilePath $DestinationFile

        }

        $Document.Dispose()

        if ($DestinationFolder) {

            $RemainingPart = $File.DirectoryName.Replace($SourceFolder, "").TrimStart('\\').TrimEnd('\\')

            $NewDirectory = [System.IO.Path]::Combine($DestinationFolder, $RemainingPart)

            $NewPath = [System.IO.Path]::Combine($NewDirectory, $File.Name)

            if (-not (Test-Path -LiteralPath $NewDirectory)) { $null = New-Item -ItemType Directory -Force -Path $NewDirectory }

            if (Test-Path -LiteralPath $NewDirectory) {

                Write-Color -Text "[+] Kopiuje plik ", $DestinationFile, " do ", "$($NewPath)" -Color White, Yellow, White, Yellow

                try { Copy-Item -LiteralPath $DestinationFile -Destination $NewPath -Force -ErrorAction Stop } catch {

                    Write-Color -Text "[-] Nie udalo sie skopiowac pliku ", "$($DestinationFile)", " do ", $NewPath, ". Błąd: ", $_.Exception.Message -Color White, Red, White, Red

                    if ($ErrorActionPreference -eq 'Stop') { break } else { continue }

                }

            } else {

                Write-Color -Text "Folder docelowy nie istnieje ", $DestinationFolder, ". Stwórz go i spróbuj ponownie" -Color White, Red, White

                return

            }

        } else {

            Write-Color -Text "[+] Kopiuje plik ", $DestinationFile, " do ", "$($File.FullName)" -Color White, Yellow, White, Yellow

            try { Copy-Item -LiteralPath $DestinationFile -Destination $File.FullName -Force -ErrorAction Stop } catch {

                Write-Color -Text "[-] Nie udalo sie skopiowac pliku ", "$($DestinationFile)", " do ", $File.FullName, ". Błąd: ", $_.Exception.Message -Color White, Red, White, Red

                if ($ErrorActionPreference -eq 'Stop') { break } else { continue }

            }

        }

    }

    $DocumentStopka.Dispose()

}

Export-ModuleMember -Function @('Convert-WordDocumentToPDF', 'Update-WordDocument') -Alias @()

# SIG # Begin signature block

# MIIdWQYJKoZIhvcNAQcCoIIdSjCCHUYCAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQUxKvxbHOG8rsjZ5BdMwIoSmTi

# u/KgghhnMIIDtzCCAp+gAwIBAgIQDOfg5RfYRv6P5WD8G/AwOTANBgkqhkiG9w0B

# AQUFADBlMQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYD

# VQQLExB3d3cuZGlnaWNlcnQuY29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVk

# IElEIFJvb3QgQ0EwHhcNMDYxMTEwMDAwMDAwWhcNMzExMTEwMDAwMDAwWjBlMQsw

# CQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5jMRkwFwYDVQQLExB3d3cu

# ZGlnaWNlcnQuY29tMSQwIgYDVQQDExtEaWdpQ2VydCBBc3N1cmVkIElEIFJvb3Qg

# Q0EwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQCtDhXO5EOAXLGH87dg

# +XESpa7cJpSIqvTO9SA5KFhgDPiA2qkVlTJhPLWxKISKityfCgyDF3qPkKyK53lT

# XDGEKvYPmDI2dsze3Tyoou9q+yHyUmHfnyDXH+Kx2f4YZNISW1/5WBg1vEfNoTb5

# a3/UsDg+wRvDjDPZ2C8Y/igPs6eD1sNuRMBhNZYW/lmci3Zt1/GiSw0r/wty2p5g

# 0I6QNcZ4VYcgoc/lbQrISXwxmDNsIumH0DJaoroTghHtORedmTpyoeb6pNnVFzF1

# roV9Iq4/AUaG9ih5yLHa5FcXxH4cDrC0kqZWs72yl+2qp/C3xag/lRbQ/6GW6whf

# GHdPAgMBAAGjYzBhMA4GA1UdDwEB/wQEAwIBhjAPBgNVHRMBAf8EBTADAQH/MB0G

# A1UdDgQWBBRF66Kv9JLLgjEtUYunpyGd823IDzAfBgNVHSMEGDAWgBRF66Kv9JLL

# gjEtUYunpyGd823IDzANBgkqhkiG9w0BAQUFAAOCAQEAog683+Lt8ONyc3pklL/3

# cmbYMuRCdWKuh+vy1dneVrOfzM4UKLkNl2BcEkxY5NM9g0lFWJc1aRqoR+pWxnmr

# EthngYTffwk8lOa4JiwgvT2zKIn3X/8i4peEH+ll74fg38FnSbNd67IJKusm7Xi+

# fT8r87cmNW1fiQG2SVufAQWbqz0lwcy2f8Lxb4bG+mRo64EtlOtCt/qMHt1i8b5Q

# Z7dsvfPxH2sMNgcWfzd8qVttevESRmCD1ycEvkvOl77DZypoEd+A5wwzZr8TDRRu

# 838fYxAe+o0bJW1sj6W3YQGx0qMmoRBxna3iw/nDmVG3KwcIzi7mULKn+gpFL6Lw

# 8jCCBP4wggPmoAMCAQICEA1CSuC+Ooj/YEAhzhQA8N0wDQYJKoZIhvcNAQELBQAw

# cjELMAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQ

# d3d3LmRpZ2ljZXJ0LmNvbTExMC8GA1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVk

# IElEIFRpbWVzdGFtcGluZyBDQTAeFw0yMTAxMDEwMDAwMDBaFw0zMTAxMDYwMDAw

# MDBaMEgxCzAJBgNVBAYTAlVTMRcwFQYDVQQKEw5EaWdpQ2VydCwgSW5jLjEgMB4G

# A1UEAxMXRGlnaUNlcnQgVGltZXN0YW1wIDIwMjEwggEiMA0GCSqGSIb3DQEBAQUA

# A4IBDwAwggEKAoIBAQDC5mGEZ8WK9Q0IpEXKY2tR1zoRQr0KdXVNlLQMULUmEP4d

# yG+RawyW5xpcSO9E5b+bYc0VkWJauP9nC5xj/TZqgfop+N0rcIXeAhjzeG28ffnH

# bQk9vmp2h+mKvfiEXR52yeTGdnY6U9HR01o2j8aj4S8bOrdh1nPsTm0zinxdRS1L

# sVDmQTo3VobckyON91Al6GTm3dOPL1e1hyDrDo4s1SPa9E14RuMDgzEpSlwMMYpK

# jIjF9zBa+RSvFV9sQ0kJ/SYjU/aNY+gaq1uxHTDCm2mCtNv8VlS8H6GHq756Wwog

# L0sJyZWnjbL61mOLTqVyHO6fegFz+BnW/g1JhL0BAgMBAAGjggG4MIIBtDAOBgNV

# HQ8BAf8EBAMCB4AwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcD

# CDBBBgNVHSAEOjA4MDYGCWCGSAGG/WwHATApMCcGCCsGAQUFBwIBFhtodHRwOi8v

# d3d3LmRpZ2ljZXJ0LmNvbS9DUFMwHwYDVR0jBBgwFoAU9LbhIB3+Ka7S5GGlsqIl

# ssgXNW4wHQYDVR0OBBYEFDZEho6kurBmvrwoLR1ENt3janq8MHEGA1UdHwRqMGgw

# MqAwoC6GLGh0dHA6Ly9jcmwzLmRpZ2ljZXJ0LmNvbS9zaGEyLWFzc3VyZWQtdHMu

# Y3JsMDKgMKAuhixodHRwOi8vY3JsNC5kaWdpY2VydC5jb20vc2hhMi1hc3N1cmVk

# LXRzLmNybDCBhQYIKwYBBQUHAQEEeTB3MCQGCCsGAQUFBzABhhhodHRwOi8vb2Nz

# cC5kaWdpY2VydC5jb20wTwYIKwYBBQUHMAKGQ2h0dHA6Ly9jYWNlcnRzLmRpZ2lj

# ZXJ0LmNvbS9EaWdpQ2VydFNIQTJBc3N1cmVkSURUaW1lc3RhbXBpbmdDQS5jcnQw

# DQYJKoZIhvcNAQELBQADggEBAEgc3LXpmiO85xrnIA6OZ0b9QnJRdAojR6OrktIl

# xHBZvhSg5SeBpU0UFRkHefDRBMOG2Tu9/kQCZk3taaQP9rhwz2Lo9VFKeHk2eie3

# 8+dSn5On7UOee+e03UEiifuHokYDTvz0/rdkd2NfI1Jpg4L6GlPtkMyNoRdzDfTz

# ZTlwS/Oc1np72gy8PTLQG8v1Yfx1CAB2vIEO+MDhXM/EEXLnG2RJ2CKadRVC9S0y

# OIHa9GCiurRS+1zgYSQlT7LfySmoc0NR2r1j1h9bm/cuG08THfdKDXF+l7f0P4Tr

# weOjSaH6zqe/Vs+6WXZhiV9+p7SOZ3j5NpjhyyjaW4emii8wggUwMIIEGKADAgEC

# AhAECRgbX9W7ZnVTQ7VvlVAIMA0GCSqGSIb3DQEBCwUAMGUxCzAJBgNVBAYTAlVT

# MRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5j

# b20xJDAiBgNVBAMTG0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0xMzEw

# MjIxMjAwMDBaFw0yODEwMjIxMjAwMDBaMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQK

# EwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNV

# BAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EwggEi

# MA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQD407Mcfw4Rr2d3B9MLMUkZz9D7

# RZmxOttE9X/lqJ3bMtdx6nadBS63j/qSQ8Cl+YnUNxnXtqrwnIal2CWsDnkoOn7p

# 0WfTxvspJ8fTeyOU5JEjlpB3gvmhhCNmElQzUHSxKCa7JGnCwlLyFGeKiUXULaGj

# 6YgsIJWuHEqHCN8M9eJNYBi+qsSyrnAxZjNxPqxwoqvOf+l8y5Kh5TsxHM/q8grk

# V7tKtel05iv+bMt+dDk2DZDv5LVOpKnqagqrhPOsZ061xPeM0SAlI+sIZD5SlsHy

# DxL0xY4PwaLoLFH3c7y9hbFig3NBggfkOItqcyDQD2RzPJ6fpjOp/RnfJZPRAgMB

# AAGjggHNMIIByTASBgNVHRMBAf8ECDAGAQH/AgEAMA4GA1UdDwEB/wQEAwIBhjAT

# BgNVHSUEDDAKBggrBgEFBQcDAzB5BggrBgEFBQcBAQRtMGswJAYIKwYBBQUHMAGG

# GGh0dHA6Ly9vY3NwLmRpZ2ljZXJ0LmNvbTBDBggrBgEFBQcwAoY3aHR0cDovL2Nh

# Y2VydHMuZGlnaWNlcnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNydDCB

# gQYDVR0fBHoweDA6oDigNoY0aHR0cDovL2NybDQuZGlnaWNlcnQuY29tL0RpZ2lD

# ZXJ0QXNzdXJlZElEUm9vdENBLmNybDA6oDigNoY0aHR0cDovL2NybDMuZGlnaWNl

# cnQuY29tL0RpZ2lDZXJ0QXNzdXJlZElEUm9vdENBLmNybDBPBgNVHSAESDBGMDgG

# CmCGSAGG/WwAAgQwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNlcnQu

# Y29tL0NQUzAKBghghkgBhv1sAzAdBgNVHQ4EFgQUWsS5eyoKo6XqcQPAYPkt9mV1

# DlgwHwYDVR0jBBgwFoAUReuir/SSy4IxLVGLp6chnfNtyA8wDQYJKoZIhvcNAQEL

# BQADggEBAD7sDVoks/Mi0RXILHwlKXaoHV0cLToaxO8wYdd+C2D9wz0PxK+L/e8q

# 3yBVN7Dh9tGSdQ9RtG6ljlriXiSBThCk7j9xjmMOE0ut119EefM2FAaK95xGTlz/

# kLEbBw6RFfu6r7VRwo0kriTGxycqoSkoGjpxKAI8LpGjwCUR4pwUR6F6aGivm6dc

# IFzZcbEMj7uo+MUSaJ/PQMtARKUT8OZkDCUIQjKyNookAv4vcn4c10lFluhZHen6

# dGRrsutmQ9qzsIzV6Q3d9gEgzpkxYz0IGhizgZtPxpMQBvwHgfqL2vmCSfdibqFT

# +hKUGIUukpHqaGxEMrJmoecYpJpkUe8wggUxMIIEGaADAgECAhAKoSXW1jIbfkHk

# Bdo2l8IVMA0GCSqGSIb3DQEBCwUAMGUxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxE

# aWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xJDAiBgNVBAMT

# G0RpZ2lDZXJ0IEFzc3VyZWQgSUQgUm9vdCBDQTAeFw0xNjAxMDcxMjAwMDBaFw0z

# MTAxMDcxMjAwMDBaMHIxCzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJ

# bmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0

# IFNIQTIgQXNzdXJlZCBJRCBUaW1lc3RhbXBpbmcgQ0EwggEiMA0GCSqGSIb3DQEB

# AQUAA4IBDwAwggEKAoIBAQC90DLuS82Pf92puoKZxTlUKFe2I0rEDgdFM1EQfdD5

# fU1ofue2oPSNs4jkl79jIZCYvxO8V9PD4X4I1moUADj3Lh477sym9jJZ/l9lP+Cb

# 6+NGRwYaVX4LJ37AovWg4N4iPw7/fpX786O6Ij4YrBHk8JkDbTuFfAnT7l3ImgtU

# 46gJcWvgzyIQD3XPcXJOCq3fQDpct1HhoXkUxk0kIzBdvOw8YGqsLwfM/fDqR9mI

# UF79Zm5WYScpiYRR5oLnRlD9lCosp+R1PrqYD4R/nzEU1q3V8mTLex4F0IQZchfx

# FwbvPc3WTe8GQv2iUypPhR3EHTyvz9qsEPXdrKzpVv+TAgMBAAGjggHOMIIByjAd

# BgNVHQ4EFgQU9LbhIB3+Ka7S5GGlsqIlssgXNW4wHwYDVR0jBBgwFoAUReuir/SS

# y4IxLVGLp6chnfNtyA8wEgYDVR0TAQH/BAgwBgEB/wIBADAOBgNVHQ8BAf8EBAMC

# AYYwEwYDVR0lBAwwCgYIKwYBBQUHAwgweQYIKwYBBQUHAQEEbTBrMCQGCCsGAQUF

# BzABhhhodHRwOi8vb2NzcC5kaWdpY2VydC5jb20wQwYIKwYBBQUHMAKGN2h0dHA6

# Ly9jYWNlcnRzLmRpZ2ljZXJ0LmNvbS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5j

# cnQwgYEGA1UdHwR6MHgwOqA4oDaGNGh0dHA6Ly9jcmw0LmRpZ2ljZXJ0LmNvbS9E

# aWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcmwwOqA4oDaGNGh0dHA6Ly9jcmwzLmRp

# Z2ljZXJ0LmNvbS9EaWdpQ2VydEFzc3VyZWRJRFJvb3RDQS5jcmwwUAYDVR0gBEkw

# RzA4BgpghkgBhv1sAAIEMCowKAYIKwYBBQUHAgEWHGh0dHBzOi8vd3d3LmRpZ2lj

# ZXJ0LmNvbS9DUFMwCwYJYIZIAYb9bAcBMA0GCSqGSIb3DQEBCwUAA4IBAQBxlRLp

# UYdWac3v3dp8qmN6s3jPBjdAhO9LhL/KzwMC/cWnww4gQiyvd/MrHwwhWiq3BTQd

# aq6Z+CeiZr8JqmDfdqQ6kw/4stHYfBli6F6CJR7Euhx7LCHi1lssFDVDBGiy23UC

# 4HLHmNY8ZOUfSBAYX4k4YU1iRiSHY4yRUiyvKYnleB/WCxSlgNcSR3CzddWThZN+

# tpJn+1Nhiaj1a5bA9FhpDXzIAbG5KHW3mWOFIoxhynmUfln8jA/jb7UBJrZspe6H

# USHkWGCbugwtK22ixH67xCUrRwIIfEmuE7bhfEJCKMYYVs9BNLZmXbZ0e/VWMyIv

# IjayS6JKldj1po5SMIIFPTCCBCWgAwIBAgIQBNXcH0jqydhSALrNmpsqpzANBgkq

# hkiG9w0BAQsFADByMQswCQYDVQQGEwJVUzEVMBMGA1UEChMMRGlnaUNlcnQgSW5j

# MRkwFwYDVQQLExB3d3cuZGlnaWNlcnQuY29tMTEwLwYDVQQDEyhEaWdpQ2VydCBT

# SEEyIEFzc3VyZWQgSUQgQ29kZSBTaWduaW5nIENBMB4XDTIwMDYyNjAwMDAwMFoX

# DTIzMDcwNzEyMDAwMFowejELMAkGA1UEBhMCUEwxEjAQBgNVBAgMCcWabMSFc2tp

# ZTERMA8GA1UEBxMIS2F0b3dpY2UxITAfBgNVBAoMGFByemVteXPFgmF3IEvFgnlz

# IEVWT1RFQzEhMB8GA1UEAwwYUHJ6ZW15c8WCYXcgS8WCeXMgRVZPVEVDMIIBIjAN

# BgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAv7KB3iyBrhkLUbbFe9qxhKKPBYqD

# Bqlnr3AtpZplkiVjpi9dMZCchSeT5ODsShPuZCIxJp5I86uf8ibo3vi2S9F9AlfF

# jVye3dTz/9TmCuGH8JQt13ozf9niHecwKrstDVhVprgxi5v0XxY51c7zgMA2g1Ub

# +3tii0vi/OpmKXdL2keNqJ2neQ5cYly/GsI8CREUEq9SZijbdA8VrRF3SoDdsWGf

# 3tZZzO6nWn3TLYKQ5/bw5U445u/V80QSoykszHRivTj+H4s8ABiforhi0i76beA6

# Ea41zcH4zJuAp48B4UhjgRDNuq8IzLWK4dlvqrqCBHKqsnrF6BmBrv+BXQIDAQAB

# o4IBxTCCAcEwHwYDVR0jBBgwFoAUWsS5eyoKo6XqcQPAYPkt9mV1DlgwHQYDVR0O

# BBYEFBixNSfoHFAgJk4JkDQLFLRNlJRmMA4GA1UdDwEB/wQEAwIHgDATBgNVHSUE

# DDAKBggrBgEFBQcDAzB3BgNVHR8EcDBuMDWgM6Axhi9odHRwOi8vY3JsMy5kaWdp

# Y2VydC5jb20vc2hhMi1hc3N1cmVkLWNzLWcxLmNybDA1oDOgMYYvaHR0cDovL2Ny

# bDQuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJlZC1jcy1nMS5jcmwwTAYDVR0gBEUw

# QzA3BglghkgBhv1sAwEwKjAoBggrBgEFBQcCARYcaHR0cHM6Ly93d3cuZGlnaWNl

# cnQuY29tL0NQUzAIBgZngQwBBAEwgYQGCCsGAQUFBwEBBHgwdjAkBggrBgEFBQcw

# AYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tME4GCCsGAQUFBzAChkJodHRwOi8v

# Y2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRTSEEyQXNzdXJlZElEQ29kZVNp

# Z25pbmdDQS5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQsFAAOCAQEAmr1s

# z4lsLARi4wG1eg0B8fVJFowtect7SnJUrp6XRnUG0/GI1wXiLIeow1UPiI6uDMsR

# XPHUF/+xjJw8SfIbwava2eXu7UoZKNh6dfgshcJmo0QNAJ5PIyy02/3fXjbUREHI

# NrTCvPVbPmV6kx4Kpd7KJrCo7ED18H/XTqWJHXa8va3MYLrbJetXpaEPpb6zk+l8

# Rj9yG4jBVRhenUBUUj3CLaWDSBpOA/+sx8/XB9W9opYfYGb+1TmbCkhUg7TB3gD6

# o6ESJre+fcnZnPVAPESmstwsT17caZ0bn7zETKlNHbc1q+Em9kyBjaQRcEQoQQNp

# ezQug9ufqExx6lHYDjGCBFwwggRYAgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYD

# VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAv

# BgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EC

# EATV3B9I6snYUgC6zZqbKqcwCQYFKw4DAhoFAKB4MBgGCisGAQQBgjcCAQwxCjAI

# oAKAAKECgAAwGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIB

# CzEOMAwGCisGAQQBgjcCARUwIwYJKoZIhvcNAQkEMRYEFNoyNuPUw6S7NKKg0PAT

# tUG2DywoMA0GCSqGSIb3DQEBAQUABIIBAEazetNURcL458MKMTiJ84tKAK0SYsUI

# xFTs4nqNb0eKlgbED2B6QyCcSK1mbuSGNG/NzVeTRIVNLMCo7K9MN7XXGsnq1Xup

# PWaEUed77Zpxwug5pAVUtoYaAKgt38WuiMhR8r8CGUzhgQxzcj6OrRiPAUlhLr0+

# LDfujOn+urLaD9Bp+wDJXiiZKF6NqT/9WgqqKIjiw043Ujyh8bTne1KB/vISirB3

# TsSYR7v5j+qYFQJoa7mFaRHP3YjQzd+qAA7E3iA676MDGiYdw/L1QeWvGJ8NvaiZ

# /L27E3G87luVaLQYi8Iw4NVL9/i5Jo77f3pLOYrUurs1YfNKXZKOfbyhggIwMIIC

# LAYJKoZIhvcNAQkGMYICHTCCAhkCAQEwgYYwcjELMAkGA1UEBhMCVVMxFTATBgNV

# BAoTDERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTExMC8G

# A1UEAxMoRGlnaUNlcnQgU0hBMiBBc3N1cmVkIElEIFRpbWVzdGFtcGluZyBDQQIQ

# DUJK4L46iP9gQCHOFADw3TANBglghkgBZQMEAgEFAKBpMBgGCSqGSIb3DQEJAzEL

# BgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTIyMDExMTIxMzcxNFowLwYJKoZI

# hvcNAQkEMSIEICYaRYGqhgpf+oPXuyt8Mtv5Tt3X0lZxIUnTaCKu4JCqMA0GCSqG

# SIb3DQEBAQUABIIBAHayvIZA2uw0+3to0TD3cg8e1Ff+RKMMtZcmeejHTWaJDuZt

# 2pbFQoYrWbFrUNyc9zfPmWKo3qqlkX9kCRxuJkOeDsEbgTXcJWthxFC1b/xAEOWU

# J87R0o3vp0BbxcZtJSHPiIArFXIc3ZNpuiUO2Cr0502/ArBKbhhYDHgRnzf67eRm

# T4Ob2JgZIjHu7DmhRIvmyT0F0mXIufYx1AXPFaQT/XRWyYV7txm1akDQTZJsziTI

# +nOfYQiYpgbKLHHFYC5mQPC4SRoQIBv0sw7R6rUHFiDDNau+UDEz91EpUUIYRMEm

# 90sttmpHLbkcbmw7DmidX20hOHVj1AwrMlMad7E=

# SIG # End signature block