Get-TimeSheetTotalPerDay.ps1
|
function Get-TimeSheetTotalPerDay { <# .SYNOPSIS Returns total aggregated data for TimeSheets. .DESCRIPTION Parses passed in dates or days, aggregates the timesheet files found and returns the data. .EXAMPLE PS C:\> Get-TimeSheetTotalPerDay -Directory $HOME | Format-Table Subject SubjectDuration SubjectDurationAgg Date Duration DurationAgg ------- --------------- ------------------ ---- -------- ----------- Call with PM: Issue 00:45:00 00:45:00 28/07/2022 00:00:00 05:18:00 05:45:00 Coffee Break 00:49:00 00:45:00 28/07/2022 00:00:00 05:18:00 05:45:00 Daily Checks 01:08:00 01:15:00 28/07/2022 00:00:00 05:18:00 05:45:00 Daily Standup 00:53:00 01:00:00 28/07/2022 00:00:00 05:18:00 05:45:00 Dedicated Code Review 00:15:00 00:15:00 28/07/2022 00:00:00 05:18:00 05:45:00 Prep for Upgrade 00:24:00 00:30:00 28/07/2022 00:00:00 05:18:00 05:45:00 Review Upgrade plan 00:28:00 00:30:00 28/07/2022 00:00:00 05:18:00 05:45:00 Update Meeting 00:36:00 00:45:00 28/07/2022 00:00:00 05:18:00 05:45:00 #> [CmdletBinding(DefaultParameterSetName = 'ByDays')] [OutputType('TimeSheetTotalPerDay')] param ( # How many days back in the timesheets we want to parse. [Parameter( Position = 0, ValueFromPipelineByPropertyName, ValueFromPipeline, ParameterSetName = 'ByDays' )] [ValidateNotNullOrEmpty()] [int] $DaysBack = 0, # Parse a timesheet of a particular date. [Parameter( Position = 0, ValueFromPipelineByPropertyName, ValueFromPipeline, Mandatory, ParameterSetName = 'ByDate' )] [datetime] $Date = (Get-Date) ) begin { $funcsToImport = 'Get-TimeSheet', 'Measure-TimeSheet' foreach ($func in $funcsToImport) { if (Get-ChildItem -Path "Function:\$func" -ErrorAction SilentlyContinue) {continue} Write-PSFMessage -Message "Importing function: $func" -Level Verbose try { . "$PSScriptRoot\$($func).ps1" } catch { Write-PSFMessage -Message "Issue importing function: $func" -Level PSFMessage -Level Warning -Message break } } $DaysTotal = [System.Collections.Generic.List[PSObject]]::new() } process { if ($PSCmdlet.ParameterSetName -eq 'ByDays') { Write-PSFMessage -Message "Gathering timesheet by days" -Level Verbose foreach ($DayBack in ($DaysBack..0)) { $TargetDate = ([datetime]::Today).AddDays(-$DayBack) try { $TimeSheet = Get-TimeSheet -FileDate $TargetDate } catch { Write-PSFMessage -Level Warning -Message "Cannot import timesheet: $TargetDate" } if (-not $TimeSheet) { continue } $DaysTotal.Add(($TimeSheet | Measure-TimeSheet)) $TimeSheet = $null } } if ($PSCmdlet.ParameterSetName -eq 'ByDate') { Write-PSFMessage -Message "Gathering timesheet by date" -Level Verbose try { $TimeSheet = Get-TimeSheet -FileDate $Date } catch { Write-PSFMessage -Level Warning -Message "Cannot import timesheet: $Date" } $DaysTotal.Add(($TimeSheet | Measure-TimeSheet)) } foreach ($Total in $DaysTotal.GetEnumerator()) { $MeasuredSeconds = ($Total.TotalDuration.TotalSeconds | Measure-Object -Sum).Sum $TotalSeconds = New-TimeSpan -Seconds $MeasuredSeconds $MeasuredAggdSeconds = ($Total.TotalDuration15Mins.TotalSeconds | Measure-Object -Sum).Sum $TotalAggSeconds = New-TimeSpan -Seconds $MeasuredAggdSeconds foreach ($DayTotal in $Total) { [PSCustomObject] @{ PSTypeName = 'TimeSheetTotalPerDay' Subject = $DayTotal.Subject SubjectDuration = $DayTotal.TotalDuration SubjectDurationAgg = $DayTotal.TotalDuration15Mins Date = $DayTotal.Date Duration = $TotalSeconds DurationAgg = $TotalAggSeconds } } } } } |