SPSAeries

0.3.5

Public/Get-SPSAeriesDistrictAssetTitle.ps1

Function Get-SPSAeriesDistrictAssetTitle{
<#
.SYNOPSIS
    Get district asset from SQL DB
.DESCRIPTION
    The Get-SPSAeriesDistrictAsset function gets asset data from the Aeries DB.
.EXAMPLE
    Get-SPSAeriesDistrictAsset -Code CB
.PARAMETER
.INPUTS
.OUTPUTS
.NOTES
.LINK
#>
    [CmdletBinding()] #Enable all the default paramters, including -Verbose
    Param(
        [Parameter(Mandatory=$false,
            ValueFromPipeline=$true,
            ValueFromPipelineByPropertyName=$true,
            # HelpMessage='HelpMessage',
            Position=0)]
        # ToDo - better build parameters to work together / separately.
        [String[]]$AssetTitleNumber,
        [String[]]$Type
    )

    Begin{
        Write-Verbose -Message "Starting $($MyInvocation.InvocationName) with $($PsCmdlet.ParameterSetName) parameterset..."
        Write-Verbose -Message "Parameters are $($PSBoundParameters | Select-Object -Property *)"
        Connect-AeriesSQLDB
        $result = @()
    }
    Process{
        $SQLData = $null

        
        if ($AssetTitleNumber) {
            $SQLData = Invoke-Sqlcmd @InvokeSQLSplat -Query "SELECT * FROM $SQLDB.dbo.DRT WHERE RID = $AssetTitleNumber"
        } elseif ($Type) {
            $SQLData = Invoke-Sqlcmd @InvokeSQLSplat -Query "SELECT * FROM $SQLDB.dbo.DRT WHERE TY = '$Type'"
        } else {
            $SQLData = Read-SqlTableData @SQLSplat -TableName "DRT"
        }

        $SQLData | ForEach-Object {
            $AssetTitle = [PSCustomObject]@{
                'AssetTitleNumber' = $_.RID;
                'Title' = $_.TI;
                'Author' = $_.AU;
                'Edition' = $_.ED;
                'Copies' = $_.CP;
                'Available' = $_.AV;
                'FirstNumber' = $_.FC;
                'LastNumber' = $_.LC;
                'Price' = $_.PR;
                'Department' = $_.DP;
                'Publiser' = $_.PB;
                'CopyrightYear' = $_.CR;
                'ApprovalDate' = $_.AD;
                'Vendor' = $_.VN;
                'Catalog' = $_.CT;
                'ReplacementCost' = $_.RC;
                'LibraryOfCongressNumber' = $_.LB;
                'ISBN' = $_.IS;
                # Aeries API says these fields are Not used
                # Grab them anyways
                'D1' = $_.D1;
                'D2' = $_.D2;
                'D3' = $_.D3;
                'D4' = $_.D4;
                'C1' = $_.C1;
                'C2' = $_.C2;
                'C3' = $_.C3;
                # End of unused fields
                'UserCode1' = $_.U1;
                'UserCode2' = $_.U2;
                'UserCode3' = $_.U3;
                'UserCode4' = $_.U4;
                'UserCode5' = $_.U5;
                'UserCode6' = $_.U6;
                'UserCode7' = $_.U7;
                'UserCode8' = $_.U8;
                'Type' = $_.TY;
            }
            $result += $AssetTitle
        }
        $result
    }
    End{
        $Script:SQLConnection.Close()
        Write-Verbose -Message "Ending $($MyInvocation.InvocationName)..."
    }
}