Reflection

4.8

JoinObject.psm1

                                function AddItemProperties($item, $properties, $output)

{

    if($item -ne $null)

    {

        foreach($property in $properties)

        {

            # Support hashtables like Select-Object

            $propertyHash =$property -as [hashtable]

            if($propertyHash -ne $null)

            {

                $hashName=$propertyHash["name"] -as [string]

                if($hashName -eq $null)

                {

                    throw "there should be a string Name" 

                }

                $expression=$propertyHash["expression"] -as [scriptblock]

                if($expression -eq $null)

                {

                    throw "there should be a ScriptBlock Expression" 

                }

                $_=$item

                $expressionValue=& $expression

                $output | add-member -MemberType "NoteProperty" -Name $hashName -Value $expressionValue

            }

            else

            {

                # .psobject.Properties allows you to list the properties of any object, also known as "reflection"

                foreach($itemProperty in $item.psobject.Properties)

                {

                    if ($itemProperty.Name -like $property)

                    {

                        $output | add-member -MemberType "NoteProperty" -Name $itemProperty.Name -Value $itemProperty.Value

                    }

                }

            }

        }

    }

}

function WriteJoinObjectOutput($leftItem, $rightItem, $leftProperties, $rightProperties, $Type)

{

    $output = new-object psobject

    if($Type -eq "AllInRight")

    {

        # This mix of rightItem with LeftProperties and vice versa is due to

        # the switch of Left and Right arguments for AllInRight

        AddItemProperties $rightItem $leftProperties $output

        AddItemProperties $leftItem $rightProperties $output

    }

    else

    {

        AddItemProperties $leftItem $leftProperties $output

        AddItemProperties $rightItem $rightProperties $output

    }

    $output

}

<#

.Synopsis

   Joins two lists of objects

.DESCRIPTION

   Joins two lists of objects

.EXAMPLE

   Join-Object $a $b "Id" ("Name","Salary")

#>

function Join-Object

{

    [CmdletBinding()]

    [OutputType([int])]

    param(

        # List to join with $Right

        [Parameter(Mandatory=$true,

                   Position=0)]

        [object[]]

        $Left,

        # List to join with $Left

        [Parameter(Mandatory=$true,

                   Position=1)]

        [object[]]

        $Right,

        # Condition in which an item in the left matches an item in the right

        # typically something like: {$args[0].Id -eq $args[1].Id}

        [Parameter(Mandatory=$true,

                   Position=2)]

        [scriptblock]

        $Where,

        # Properties from $Left we want in the output.

        # Each property can:

        # - Be a plain property name like "Name"

        # - Contain wildcards like "*"

        # - Be a hashtable like @{Name="Product Name";Expression={$_.Name}}. Name is the output property name

        #   and Expression is the property value. The same syntax is available in select-object and it is

        #   important for join-object because joined lists could have a property with the same name

        [Parameter(Mandatory=$true,

                   Position=3)]

        [object[]]

        $LeftProperties,

        # Properties from $Right we want in the output.

        # Like LeftProperties, each can be a plain name, wildcard or hashtable. See the LeftProperties comments.

        [Parameter(Mandatory=$true,

                   Position=4)]

        [object[]]

        $RightProperties,

        # Type of join.

        #   AllInLeft will have all elements from Left at least once in the output, and might appear more than once

        # if the where clause is true for more than one element in right, Left elements with matches in Right are

        # preceded by elements with no matches. This is equivalent to an outer left join (or simply left join)

        # SQL statement.

        #  AllInRight is similar to AllInLeft.

        #  OnlyIfInBoth will cause all elements from Left to be placed in the output, only if there is at least one

        # match in Right. This is equivalent to a SQL inner join (or simply join) statement.

        #  AllInBoth will have all entries in right and left in the output. Specifically, it will have all entries

        # in right with at least one match in left, followed by all entries in Right with no matches in left,

        # followed by all entries in Left with no matches in Right.This is equivallent to a SQL full join.

        [Parameter(Mandatory=$false,

                   Position=5)]

        [ValidateSet("AllInLeft","OnlyIfInBoth","AllInBoth", "AllInRight")]

        [string]

        $Type="OnlyIfInBoth"

    )

    Begin

    {

        # a list of the matches in right for each object in left

        $leftMatchesInRight = new-object System.Collections.ArrayList

        # the count for all matches 

        $rightMatchesCount = New-Object "object[]" $Right.Count

        for($i=0;$i -lt $Right.Count;$i++)

        {

            $rightMatchesCount[$i]=0

        }

    }

    Process

    {

        if($Type -eq "AllInRight")

        {

            # for AllInRight we just switch Left and Right

            $aux = $Left

            $Left = $Right

            $Right = $aux

        }

        # go over items in $Left and produce the list of matches

        foreach($leftItem in $Left)

        {

            $leftItemMatchesInRight = new-object System.Collections.ArrayList

            $null = $leftMatchesInRight.Add($leftItemMatchesInRight)

            for($i=0; $i -lt $right.Count;$i++)

            {

                $rightItem=$right[$i]

                if($Type -eq "AllInRight")

                {

                    # For AllInRight, we want $args[0] to refer to the left and $args[1] to refer to right,

                    # but since we switched left and right, we have to switch the where arguments

                    $whereLeft = $rightItem

                    $whereRight = $leftItem

                }

                else

                {

                    $whereLeft = $leftItem

                    $whereRight = $rightItem

                }

                if(Invoke-Command -ScriptBlock $where -ArgumentList $whereLeft,$whereRight)

                {

                    $null = $leftItemMatchesInRight.Add($rightItem)

                    $rightMatchesCount[$i]++

                }

            }

        }

        # go over the list of matches and produce output

        for($i=0; $i -lt $left.Count;$i++)

        {

            $leftItemMatchesInRight=$leftMatchesInRight[$i]

            $leftItem=$left[$i]

            if($leftItemMatchesInRight.Count -eq 0)

            {

                if($Type -ne "OnlyIfInBoth")

                {

                    WriteJoinObjectOutput $leftItem  $null  $LeftProperties  $RightProperties $Type

                }

                continue

            }

            foreach($leftItemMatchInRight in $leftItemMatchesInRight)

            {

                WriteJoinObjectOutput $leftItem $leftItemMatchInRight  $LeftProperties  $RightProperties $Type

            }

        }

    }

    End

    {

        #produce final output for members of right with no matches for the AllInBoth option

        if($Type -eq "AllInBoth")

        {

            for($i=0; $i -lt $right.Count;$i++)

            {

                $rightMatchCount=$rightMatchesCount[$i]

                if($rightMatchCount -eq 0)

                {

                    $rightItem=$Right[$i]

                    WriteJoinObjectOutput $null $rightItem $LeftProperties $RightProperties $Type

                }

            }

        }

    }

}

# SIG # Begin signature block

# MIIXxAYJKoZIhvcNAQcCoIIXtTCCF7ECAQExCzAJBgUrDgMCGgUAMGkGCisGAQQB

# gjcCAQSgWzBZMDQGCisGAQQBgjcCAR4wJgIDAQAABBAfzDtgWUsITrck0sYpfvNR

# AgEAAgEAAgEAAgEAAgEAMCEwCQYFKw4DAhoFAAQU6YksIPJX1qwUwu85oNakEcWI

# C2qgghL3MIID7jCCA1egAwIBAgIQfpPr+3zGTlnqS5p31Ab8OzANBgkqhkiG9w0B

# AQUFADCBizELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2FwZTEUMBIG

# A1UEBxMLRHVyYmFudmlsbGUxDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUVGhh

# d3RlIENlcnRpZmljYXRpb24xHzAdBgNVBAMTFlRoYXd0ZSBUaW1lc3RhbXBpbmcg

# Q0EwHhcNMTIxMjIxMDAwMDAwWhcNMjAxMjMwMjM1OTU5WjBeMQswCQYDVQQGEwJV

# UzEdMBsGA1UEChMUU3ltYW50ZWMgQ29ycG9yYXRpb24xMDAuBgNVBAMTJ1N5bWFu

# dGVjIFRpbWUgU3RhbXBpbmcgU2VydmljZXMgQ0EgLSBHMjCCASIwDQYJKoZIhvcN

# AQEBBQADggEPADCCAQoCggEBALGss0lUS5ccEgrYJXmRIlcqb9y4JsRDc2vCvy5Q

# WvsUwnaOQwElQ7Sh4kX06Ld7w3TMIte0lAAC903tv7S3RCRrzV9FO9FEzkMScxeC

# i2m0K8uZHqxyGyZNcR+xMd37UWECU6aq9UksBXhFpS+JzueZ5/6M4lc/PcaS3Er4

# ezPkeQr78HWIQZz/xQNRmarXbJ+TaYdlKYOFwmAUxMjJOxTawIHwHw103pIiq8r3

# +3R8J+b3Sht/p8OeLa6K6qbmqicWfWH3mHERvOJQoUvlXfrlDqcsn6plINPYlujI

# fKVOSET/GeJEB5IL12iEgF1qeGRFzWBGflTBE3zFefHJwXECAwEAAaOB+jCB9zAd

# BgNVHQ4EFgQUX5r1blzMzHSa1N197z/b7EyALt0wMgYIKwYBBQUHAQEEJjAkMCIG

# CCsGAQUFBzABhhZodHRwOi8vb2NzcC50aGF3dGUuY29tMBIGA1UdEwEB/wQIMAYB

# Af8CAQAwPwYDVR0fBDgwNjA0oDKgMIYuaHR0cDovL2NybC50aGF3dGUuY29tL1Ro

# YXd0ZVRpbWVzdGFtcGluZ0NBLmNybDATBgNVHSUEDDAKBggrBgEFBQcDCDAOBgNV

# HQ8BAf8EBAMCAQYwKAYDVR0RBCEwH6QdMBsxGTAXBgNVBAMTEFRpbWVTdGFtcC0y

# MDQ4LTEwDQYJKoZIhvcNAQEFBQADgYEAAwmbj3nvf1kwqu9otfrjCR27T4IGXTdf

# plKfFo3qHJIJRG71betYfDDo+WmNI3MLEm9Hqa45EfgqsZuwGsOO61mWAK3ODE2y

# 0DGmCFwqevzieh1XTKhlGOl5QGIllm7HxzdqgyEIjkHq3dlXPx13SYcqFgZepjhq

# IhKjURmDfrYwggSjMIIDi6ADAgECAhAOz/Q4yP6/NW4E2GqYGxpQMA0GCSqGSIb3

# DQEBBQUAMF4xCzAJBgNVBAYTAlVTMR0wGwYDVQQKExRTeW1hbnRlYyBDb3Jwb3Jh

# dGlvbjEwMC4GA1UEAxMnU3ltYW50ZWMgVGltZSBTdGFtcGluZyBTZXJ2aWNlcyBD

# QSAtIEcyMB4XDTEyMTAxODAwMDAwMFoXDTIwMTIyOTIzNTk1OVowYjELMAkGA1UE

# BhMCVVMxHTAbBgNVBAoTFFN5bWFudGVjIENvcnBvcmF0aW9uMTQwMgYDVQQDEytT

# eW1hbnRlYyBUaW1lIFN0YW1waW5nIFNlcnZpY2VzIFNpZ25lciAtIEc0MIIBIjAN

# BgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAomMLOUS4uyOnREm7Dv+h8GEKU5Ow

# mNutLA9KxW7/hjxTVQ8VzgQ/K/2plpbZvmF5C1vJTIZ25eBDSyKV7sIrQ8Gf2Gi0

# jkBP7oU4uRHFI/JkWPAVMm9OV6GuiKQC1yoezUvh3WPVF4kyW7BemVqonShQDhfu

# ltthO0VRHc8SVguSR/yrrvZmPUescHLnkudfzRC5xINklBm9JYDh6NIipdC6Anqh

# d5NbZcPuF3S8QYYq3AhMjJKMkS2ed0QfaNaodHfbDlsyi1aLM73ZY8hJnTrFxeoz

# C9Lxoxv0i77Zs1eLO94Ep3oisiSuLsdwxb5OgyYI+wu9qU+ZCOEQKHKqzQIDAQAB

# o4IBVzCCAVMwDAYDVR0TAQH/BAIwADAWBgNVHSUBAf8EDDAKBggrBgEFBQcDCDAO

# BgNVHQ8BAf8EBAMCB4AwcwYIKwYBBQUHAQEEZzBlMCoGCCsGAQUFBzABhh5odHRw

# Oi8vdHMtb2NzcC53cy5zeW1hbnRlYy5jb20wNwYIKwYBBQUHMAKGK2h0dHA6Ly90

# cy1haWEud3Muc3ltYW50ZWMuY29tL3Rzcy1jYS1nMi5jZXIwPAYDVR0fBDUwMzAx

# oC+gLYYraHR0cDovL3RzLWNybC53cy5zeW1hbnRlYy5jb20vdHNzLWNhLWcyLmNy

# bDAoBgNVHREEITAfpB0wGzEZMBcGA1UEAxMQVGltZVN0YW1wLTIwNDgtMjAdBgNV

# HQ4EFgQURsZpow5KFB7VTNpSYxc/Xja8DeYwHwYDVR0jBBgwFoAUX5r1blzMzHSa

# 1N197z/b7EyALt0wDQYJKoZIhvcNAQEFBQADggEBAHg7tJEqAEzwj2IwN3ijhCcH

# bxiy3iXcoNSUA6qGTiWfmkADHN3O43nLIWgG2rYytG2/9CwmYzPkSWRtDebDZw73

# BaQ1bHyJFsbpst+y6d0gxnEPzZV03LZc3r03H0N45ni1zSgEIKOq8UvEiCmRDoDR

# EfzdXHZuT14ORUZBbg2w6jiasTraCXEQ/Bx5tIB7rGn0/Zy2DBYr8X9bCT2bW+IW

# yhOBbQAuOA2oKY8s4bL0WqkBrxWcLC9JG9siu8P+eJRRw4axgohd8D20UaF5Mysu

# e7ncIAkTcetqGVvP6KUwVyyJST+5z3/Jvz4iaGNTmr1pdKzFHTx/kuDDvBzYBHUw

# ggUmMIIEDqADAgECAhACXbrxBhFj1/jVxh2rtd9BMA0GCSqGSIb3DQEBCwUAMHIx

# CzAJBgNVBAYTAlVTMRUwEwYDVQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3

# dy5kaWdpY2VydC5jb20xMTAvBgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJ

# RCBDb2RlIFNpZ25pbmcgQ0EwHhcNMTUwNTA0MDAwMDAwWhcNMTYwNTExMTIwMDAw

# WjBtMQswCQYDVQQGEwJVUzERMA8GA1UECBMITmV3IFlvcmsxFzAVBgNVBAcTDldl

# c3QgSGVucmlldHRhMRgwFgYDVQQKEw9Kb2VsIEguIEJlbm5ldHQxGDAWBgNVBAMT

# D0pvZWwgSC4gQmVubmV0dDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEB

# AJfRKhfiDjMovUELYgagznWf+HFcDENk118Y/K6UkQDwKmVyVOvDyaVefjSmZZcV

# NZqqYpm9d/Iajf2dauyC3pg3oay8KfXAADLHgbmbvYDc5zGuUNsTzMUOKlp9h13c

# qsg898JwpRpI659xCQgJjZ6V83QJh+wnHvjA9ojjA4xkbwhGp4Eit6B/uGthEA11

# IHcFcXeNI3fIkbwWiAw7ZoFtSLm688NFhxwm+JH3Xwj0HxuezsmU0Yc/po31CoST

# nGPVN8wppHYZ0GfPwuNK4TwaI0FEXxwdwB+mEduxa5e4zB8DyUZByFW338XkGfc1

# qcJJ+WTyNKFN7saevhwp02cCAwEAAaOCAbswggG3MB8GA1UdIwQYMBaAFFrEuXsq

# CqOl6nEDwGD5LfZldQ5YMB0GA1UdDgQWBBQV0aryV1RTeVOG+wlr2Z2bOVFAbTAO

# BgNVHQ8BAf8EBAMCB4AwEwYDVR0lBAwwCgYIKwYBBQUHAwMwdwYDVR0fBHAwbjA1

# oDOgMYYvaHR0cDovL2NybDMuZGlnaWNlcnQuY29tL3NoYTItYXNzdXJlZC1jcy1n

# MS5jcmwwNaAzoDGGL2h0dHA6Ly9jcmw0LmRpZ2ljZXJ0LmNvbS9zaGEyLWFzc3Vy

# ZWQtY3MtZzEuY3JsMEIGA1UdIAQ7MDkwNwYJYIZIAYb9bAMBMCowKAYIKwYBBQUH

# AgEWHGh0dHBzOi8vd3d3LmRpZ2ljZXJ0LmNvbS9DUFMwgYQGCCsGAQUFBwEBBHgw

# djAkBggrBgEFBQcwAYYYaHR0cDovL29jc3AuZGlnaWNlcnQuY29tME4GCCsGAQUF

# BzAChkJodHRwOi8vY2FjZXJ0cy5kaWdpY2VydC5jb20vRGlnaUNlcnRTSEEyQXNz

# dXJlZElEQ29kZVNpZ25pbmdDQS5jcnQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0B

# AQsFAAOCAQEAIi5p+6eRu6bMOSwJt9HSBkGbaPZlqKkMd4e6AyKIqCRabyjLISwd

# i32p8AT7r2oOubFy+R1LmbBMaPXORLLO9N88qxmJfwFSd+ZzfALevANdbGNp9+6A

# khe3PiR0+eL8ZM5gPJv26OvpYaRebJTfU++T1sS5dYaPAztMNsDzY3krc92O27AS

# WjTjWeILSryqRHXyj8KQbYyWpnG2gWRibjXi5ofL+BHyJQRET5pZbERvl2l9Bo4Z

# st8CM9EQDrdG2vhELNiA6jwenxNPOa6tPkgf8cH8qpGRBVr9yuTMSHS1p9Rc+ybx

# FSKiZkOw8iCR6ZQIeKkSVdwFf8V+HHPrETCCBTAwggQYoAMCAQICEAQJGBtf1btm

# dVNDtW+VUAgwDQYJKoZIhvcNAQELBQAwZTELMAkGA1UEBhMCVVMxFTATBgNVBAoT

# DERpZ2lDZXJ0IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTEkMCIGA1UE

# AxMbRGlnaUNlcnQgQXNzdXJlZCBJRCBSb290IENBMB4XDTEzMTAyMjEyMDAwMFoX

# DTI4MTAyMjEyMDAwMFowcjELMAkGA1UEBhMCVVMxFTATBgNVBAoTDERpZ2lDZXJ0

# IEluYzEZMBcGA1UECxMQd3d3LmRpZ2ljZXJ0LmNvbTExMC8GA1UEAxMoRGlnaUNl

# cnQgU0hBMiBBc3N1cmVkIElEIENvZGUgU2lnbmluZyBDQTCCASIwDQYJKoZIhvcN

# AQEBBQADggEPADCCAQoCggEBAPjTsxx/DhGvZ3cH0wsxSRnP0PtFmbE620T1f+Wo

# ndsy13Hqdp0FLreP+pJDwKX5idQ3Gde2qvCchqXYJawOeSg6funRZ9PG+yknx9N7

# I5TkkSOWkHeC+aGEI2YSVDNQdLEoJrskacLCUvIUZ4qJRdQtoaPpiCwgla4cSocI

# 3wz14k1gGL6qxLKucDFmM3E+rHCiq85/6XzLkqHlOzEcz+ryCuRXu0q16XTmK/5s

# y350OTYNkO/ktU6kqepqCquE86xnTrXE94zRICUj6whkPlKWwfIPEvTFjg/Bougs

# UfdzvL2FsWKDc0GCB+Q4i2pzINAPZHM8np+mM6n9Gd8lk9ECAwEAAaOCAc0wggHJ

# MBIGA1UdEwEB/wQIMAYBAf8CAQAwDgYDVR0PAQH/BAQDAgGGMBMGA1UdJQQMMAoG

# CCsGAQUFBwMDMHkGCCsGAQUFBwEBBG0wazAkBggrBgEFBQcwAYYYaHR0cDovL29j

# c3AuZGlnaWNlcnQuY29tMEMGCCsGAQUFBzAChjdodHRwOi8vY2FjZXJ0cy5kaWdp

# Y2VydC5jb20vRGlnaUNlcnRBc3N1cmVkSURSb290Q0EuY3J0MIGBBgNVHR8EejB4

# MDqgOKA2hjRodHRwOi8vY3JsNC5kaWdpY2VydC5jb20vRGlnaUNlcnRBc3N1cmVk

# SURSb290Q0EuY3JsMDqgOKA2hjRodHRwOi8vY3JsMy5kaWdpY2VydC5jb20vRGln

# aUNlcnRBc3N1cmVkSURSb290Q0EuY3JsME8GA1UdIARIMEYwOAYKYIZIAYb9bAAC

# BDAqMCgGCCsGAQUFBwIBFhxodHRwczovL3d3dy5kaWdpY2VydC5jb20vQ1BTMAoG

# CGCGSAGG/WwDMB0GA1UdDgQWBBRaxLl7KgqjpepxA8Bg+S32ZXUOWDAfBgNVHSME

# GDAWgBRF66Kv9JLLgjEtUYunpyGd823IDzANBgkqhkiG9w0BAQsFAAOCAQEAPuwN

# WiSz8yLRFcgsfCUpdqgdXRwtOhrE7zBh134LYP3DPQ/Er4v97yrfIFU3sOH20ZJ1

# D1G0bqWOWuJeJIFOEKTuP3GOYw4TS63XX0R58zYUBor3nEZOXP+QsRsHDpEV+7qv

# tVHCjSSuJMbHJyqhKSgaOnEoAjwukaPAJRHinBRHoXpoaK+bp1wgXNlxsQyPu6j4

# xRJon89Ay0BEpRPw5mQMJQhCMrI2iiQC/i9yfhzXSUWW6Fkd6fp0ZGuy62ZD2rOw

# jNXpDd32ASDOmTFjPQgaGLOBm0/GkxAG/AeB+ova+YJJ92JuoVP6EpQYhS6Skepo

# bEQysmah5xikmmRR7zGCBDcwggQzAgEBMIGGMHIxCzAJBgNVBAYTAlVTMRUwEwYD

# VQQKEwxEaWdpQ2VydCBJbmMxGTAXBgNVBAsTEHd3dy5kaWdpY2VydC5jb20xMTAv

# BgNVBAMTKERpZ2lDZXJ0IFNIQTIgQXNzdXJlZCBJRCBDb2RlIFNpZ25pbmcgQ0EC

# EAJduvEGEWPX+NXGHau130EwCQYFKw4DAhoFAKB4MBgGCisGAQQBgjcCAQwxCjAI

# oAKAAKECgAAwGQYJKoZIhvcNAQkDMQwGCisGAQQBgjcCAQQwHAYKKwYBBAGCNwIB

# CzEOMAwGCisGAQQBgjcCARUwIwYJKoZIhvcNAQkEMRYEFBdUF6f3sOjIHr0YwaSD

# zhLoV7gEMA0GCSqGSIb3DQEBAQUABIIBAASC1b7uOzXLpB04O1Sv7E9TPiA1jZ4n

# odpZXDQ4fzkySgNarW76VjAJ1CsMbcTxD5ViGHn56DhFTTd357AZsTNXjUn5xGSg

# mND1pIxJkJRhzjaM6Lylpy86eaZcjmGZzADXfZib4kuXM/CbTEvwzelSzl5I+WnJ

# hXC810c4EGZAptzg8+gFVR8Lh8EsFGEbhn9MPSUqbNh4wyUaQNjT5siT7Qca8MBD

# GEIygu/KVXC+cgTk0lSlyxoX14mHlwF8x8Ojw4P4xJciePEQu0yl7a5XExPbpvo0

# cPqt4UdhLiG95wqtnKPleuz3CMk/gLzUN0CzXccHJXT6BcBh742ou7GhggILMIIC

# BwYJKoZIhvcNAQkGMYIB+DCCAfQCAQEwcjBeMQswCQYDVQQGEwJVUzEdMBsGA1UE

# ChMUU3ltYW50ZWMgQ29ycG9yYXRpb24xMDAuBgNVBAMTJ1N5bWFudGVjIFRpbWUg

# U3RhbXBpbmcgU2VydmljZXMgQ0EgLSBHMgIQDs/0OMj+vzVuBNhqmBsaUDAJBgUr

# DgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUx

# DxcNMTUwNTA1MDU1ODQ0WjAjBgkqhkiG9w0BCQQxFgQUiGBOWVGGwK0jQVUdOW5X

# QqKMcigwDQYJKoZIhvcNAQEBBQAEggEAm3rWRDpPdzN6dQfmVL8UIirDJScl6pWP

# J8CWKktCskSCeeg/qJJw2DY5c6CulNggKYP4aNGbYOpMsNKDoefqPHTOB8fG66UY

# 1y8aCaTgTcnTh1ZWXYldUXoDcaekOgMQDqbPxOcPQ+ZtRWO49pZPxVhxLzDLmS4i

# 1nUdhCpw1NVOo2uQvmtmFU3oZdcAD1RKG6OsBRj5lk3RPWFhan/oPQk7v4PwJe5q

# p45Ar5mhWUEQOfRGM2bU6/T25aR5XoaFFCo6BS/Bzsc7LyejpMLLng64zDsTxBHQ

# xppEbBL0sTiTxIZodzw7r06kYb33+o6y5FsUl2915+BbTxdtH+xYCQ==

# SIG # End signature block