Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $State = "QLD"
- $StartDate = (Get-Date -Date '25/06/2012')
- $LongServiceElligible = $StartDate.AddYears(7)
- $FortnightRDO = (Get-Date -Date '02/03/2018') #Enter start date
- #https://data.gov.au/dataset/australian-holidays-machine-readable-dataset
- $PublicHols = @()
- @(
- "https://data.gov.au/dataset/b1bc6077-dadd-4f61-9f8c-002ab2cdff10/resource/56a5ee91-8e94-416e-81f7-3fe626958f7e/download/australianpublicholidays-201415.csv---australianpublicholidays.csv.csv",
- "https://data.gov.au/dataset/b1bc6077-dadd-4f61-9f8c-002ab2cdff10/resource/13ca6df3-f6c9-42a1-bb20-6e2c12fe9d94/download/australianpublicholidays-201516.csv",
- "https://data.gov.au/dataset/b1bc6077-dadd-4f61-9f8c-002ab2cdff10/resource/a24ecaf2-044a-4e66-989c-eacc81ded62f/download/australianpublicholidays-201617.csv",
- "https://data.gov.au/dataset/b1bc6077-dadd-4f61-9f8c-002ab2cdff10/resource/253d63c0-af1f-4f4c-b8d5-eb9d9b1d46ab/download/australianpublicholidays-201718.csv",
- "https://data.gov.au/dataset/b1bc6077-dadd-4f61-9f8c-002ab2cdff10/resource/429f3cb9-44e8-4032-9e48-6febace6c47f/download/australianpublicholidays-2019-incomplete.csv"
- ) | %{
- $PublicHols += @(Invoke-WebRequest $_ | %{$_.Content} | ConvertFrom-CSV | ?{$_.'Applicable To' -match $State} | %{[DateTime]::ParseExact($_.Date,"yyyyMMdd",[System.Globalization.CultureInfo]::InvariantCulture)})
- }
- $DaysOff = 0
- $DaysLeft = 0
- for( $CurDay = (Get-Date).Date ; $CurDay -lt $LongServiceElligible ; $CurDay = $CurDay.AddDays(1) ) {
- if( $CurDay -eq $FortnightRDO ) {
- #RDO
- $DaysOff++
- #Calculate next
- $FortnightRDO = $FortnightRDO.AddDays(14)
- }
- elseif( $CurDay.DayOfWeek -match "Sat|Sun" ) {
- #Weekend
- $DaysOff++
- }
- elseif( $PublicHols.Contains($CurDay) ) {
- #Public holiday
- $DaysOff++
- }
- else {
- $DaysLeft++
- }
- }
- Write-Host "Days until LSL:" $DaysLeft
- Write-Host "(not considering Annual Leave days)"
- Write-Host "Days off before LSL:" $DaysOff
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement