Public/Update-FSvcPlannedEndDates.ps1
|
function Update-FSvcPlannedEndDates { <# .SYNOPSIS Sets planned_end_date to the ticket's last comment + N business days, at a chosen hour and timezone. .DESCRIPTION Defaults to the SelfAssigned view (self-assigned unresolved tickets); pass -View Unassigned or a raw -QueryHash to target something else. Every scanned ticket is recomputed so its planned end stays close to N business days after its latest comment (private note or public reply). A date that would be in the past is clamped to the nearest future business slot, so the planned end is always in the future. Identical dates are skipped. Supports -WhatIf / -Confirm; use -Confirm:$false for unattended runs. Runs are serialised with a lock file. .EXAMPLE Update-FSvcPlannedEndDates -BusinessDays 3 -TargetHour 17 -UtcOffset '+04:00' -WhatIf .EXAMPLE Update-FSvcPlannedEndDates -Confirm:$false -LogPath C:\logs\fsvc.log #> [CmdletBinding(SupportsShouldProcess, ConfirmImpact = 'Medium')] param( [ValidateSet('SelfAssigned', 'Unassigned')][string]$View = 'SelfAssigned', [string]$QueryHash, [int]$BusinessDays = 3, [ValidateRange(0, 23)][int]$TargetHour = 17, [string]$TimeZoneId, [string]$UtcOffset, [int]$PerPage = 100, [string]$LogPath ) $cfg = Get-FSvcEffectiveConfig $tz = if ($PSBoundParameters.ContainsKey('TimeZoneId')) { $TimeZoneId } else { $cfg.TimeZoneId } $off = if ($PSBoundParameters.ContainsKey('UtcOffset')) { $UtcOffset } else { $cfg.UtcOffset } $effectiveLog = if ($PSBoundParameters.ContainsKey('LogPath')) { $LogPath } else { $cfg.LogPath } $zone = Resolve-FSvcTimeZone -Id $tz $offset = ConvertTo-FSvcUtcOffset -Value $off $tickets = @(if ($QueryHash) { Get-FSvcTickets -QueryHash $QueryHash -PerPage $PerPage -Config $cfg } else { Get-FSvcViewTickets -View $View -PerPage $PerPage -Config $cfg }) $accountOffset = Get-FSvcAccountOffset -Tickets $tickets -Fallback ([datetimeoffset]::Now) $now = ([datetimeoffset]::Now).ToOffset($accountOffset) $changes = @() foreach ($t in $tickets) { $latest = Get-FSvcLatestConversation -TicketId $t.id -Config $cfg $latestAt = if ($null -ne $latest) { $latest.At } else { $null } $target = Get-FSvcPlannedEndDate -Ticket $t -LatestConversationAt $latestAt -Now $now ` -BusinessDays $BusinessDays -TargetHour $TargetHour -Zone $zone -Offset $offset if ($null -eq $target) { continue } $changes += [pscustomobject]@{ Id = $t.id Field = 'planned_end_date' From = $t.planned_end_date To = Format-Iso8601 $target } } Invoke-FSvcChangeSet -Change $changes -Config $cfg -LogPath $effectiveLog ` -LockName 'fsvc-planned-end-dates' ` -Should { param($Target, $Action) $PSCmdlet.ShouldProcess($Target, $Action) } ` -Apply { param($c) Invoke-FSvcPut -Path ("tickets/{0}" -f $c.Id) -Body @{ planned_end_date = $c.To } -Config $cfg } } |