Private/Helper/New-BDFilter.ps1

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
function New-BDFilter { 
    [System.Diagnostics.CodeAnalysis.SuppressMessageAttribute('PSUseShouldProcessForStateChangingFunctions','')] 
    <#
    .SYNOPSIS
    Generate a filter statement based on MatchExact and StartsWith params
    .DESCRIPTION
    All expressions are joined with an and statement
 
    .PARAMETER IsExactly
 
    .PARAMETER StartsWith
 
    .INPUTS
    N/A
    .OUTPUTS
    <string> containing the filter statement
    .EXAMPLE
    New-MSGFilter -IsExactly $IsExactly -StartsWith $StartsWith
 
    .EXAMPLE
    New-MSGFilter -IsExactly $IsExactly
    .EXAMPLE
    New-MSGFilter -StartsWith $StartsWith
 
    .NOTES
    #>

    [CmdletBinding()]
    [OutputType([string])]
    param (
        [parameter(Mandatory=$false)]
        [hashtable] $IsExactly = @{},
        [parameter(Mandatory=$false)]
        [hashtable] $StartsWith = @{},
        [parameter(Mandatory=$false)]
        [hashtable] $Contains = @{}
    )
    
    begin {
        $filterStart = '&$filter='
        $filter = $filterStart 
    }
    
    process {
        foreach($Key in $IsExactly.Keys){
            if($filter -ne  $filterStart){$filter += " and "}
            if('System.Boolean' -in ($isExactly[$key]).psObject.Typenames) {
                $filter += "$key eq $([System.Web.HttpUtility]::UrlEncode(([string]$isExactly[$key])).toLower())"
            }
            else {
                $filter += "$key eq '$([System.Web.HttpUtility]::UrlEncode($isExactly[$key]))'"
            }
            
            Write-Verbose "adding $key eq '$($isExactly[$key])' to filter expression"
        }

        foreach($Key in $StartsWith.Keys){
            if($filter -ne  $filterStart){$filter += " and "}
            $filter += "startswith($key,'$([System.Web.HttpUtility]::UrlEncode($StartsWith[$key]))')"
            Write-Verbose "adding startswith($key,'$($StartsWith[$key])') to filter expression"
        }
        foreach($Key in $Contains.Keys){
            if($filter -ne  $filterStart){$filter += " and "}
            $filter += "contains($key,'$([System.Web.HttpUtility]::UrlEncode($Contains[$key]))')"
            Write-Verbose "adding startswith($key,'$($Contains[$key])') to filter expression"
        }
    }
    
    end {
        if($filter -ne  $filterStart){
            return $filter
        } else {
            return ""
        }      
    }
}