package DateTime::Fiscal::Year; use strict; use DateTime; use Params::Validate qw( validate validate_pos); use vars qw($VERSION); $VERSION = '0.02'; my ( @MonthLengths, @LeapYearMonthLengths ); BEGIN { @MonthLengths = ( 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 ); @LeapYearMonthLengths = @MonthLengths; $LeapYearMonthLengths[1]++; } sub new { my $class = shift; my %args = validate( @_, { start => { isa => 'DateTime' } }); my $self = { start => $args{start} }; bless $self, $class; return $self; } sub day_of_fiscal_year { my $self = shift; # return $self->{day_of_fiscal_year} if defined($self->{day_of_fiscal_year}); my @args = validate_pos( @_, { isa => 'DateTime' } ); my $dofy; my $offset = ($self->{start}->day_of_year); my $dify = ( $self->{start}->is_leap_year ? 366 : 365 ); my $doy = $args[0]->day_of_year; if ( $doy >= $offset ) { $dofy = ( $doy - $offset + 1 ); } else { $dofy = (( $dify - $offset) + $doy + 1); } $self->{day_of_fiscal_year} = $dofy; } sub week_of_fiscal_year { my $self = shift; # return $self->{week_of_fiscal_year} if defined($self->{week_of_fiscal_year}); my @args = validate_pos( @_, { isa => 'DateTime' } ); my $wofy; $wofy = $self->day_of_fiscal_year( $args[0] ) / 7; $wofy = ( $wofy == int($wofy) ? $wofy : int($wofy + 1) ); if ($wofy == 53 ) { $wofy = 52 ;} $self->{week_of_fiscal_year} = $wofy; } sub period_of_fiscal_year { my $self = shift; # return $self->{period_of_fiscal_year} if defined($self->{period_of_fiscal_year}); $self->{number_of_fiscal_periods} = shift; my @args = validate_pos( @_, { isa => 'DateTime' } ); $self->_align_fiscal_periods; if ( $self->{number_of_fiscal_periods} == 12 ) { $self->{period_of_fiscal_year} = $self->_period_index( $args[0] ); $self->{period_of_fiscal_year}++ if ( $self->{start}->month == 1 ); } if ( $self->{number_of_fiscal_periods} == 13 ) { $self->{period_of_fiscal_year} = $self->{fiscal_periods}->[$self->week_of_fiscal_year( $args[0] )]; } $self->{period_of_fiscal_year}; } sub quarter_of_fiscal_year { my $self = shift; $self->period_of_fiscal_year( shift, shift ); if ( $self->{number_of_fiscal_periods} == 12 ) { return $self->{quarter_of_fiscal_year} = int((( $self->{period_of_fiscal_year} - 1)/3) + 1); } if ( $self->{number_of_fiscal_periods} == 13 ) { return $self->{quarter_of_fiscal_year} = int((( $self->{period_of_fiscal_year} - 1)/4) + 1); } } sub _align_fiscal_periods { my $self = shift; if ( $self->{number_of_fiscal_periods} == 12 ) { my @periods = $self->{start}->is_leap_year ? @LeapYearMonthLengths : @MonthLengths; for ( my $i = 1; $i < $self->{start}->month; $i++ ) { push @periods, shift @periods; } push @periods, 0; for ( my $i = 0; $i <= $#periods; $i++ ) { $periods[$i] += $periods[$i - 1]; } unshift @periods, 0; $self->{fiscal_periods} = \@periods; }; if ( $self->{number_of_fiscal_periods} == 13 ) { my @periods = 0; my $counter = 0; my $period_index = 1; for ( my $i = 1; $i <= 52; $i++, $counter++ ) { if ( $counter == 4 ) { $counter = 0; $period_index++; } $periods[$i] = $period_index; } $self->{fiscal_periods} = \@periods; } $self->{fiscal_periods}; } sub _period_index { my $self = shift; foreach my $index ( reverse 1..12 ) { return $index if $self->{fiscal_periods}->[$index - 1] < $self->day_of_fiscal_year( @_ ); } } 1; __END__ =head1 NAME DateTime::Fiscal::Year - Calculate the day or week of the Fiscal Year with an arbitrary start date =head1 SYNOPSIS use DateTime; use DateTime::Fiscal::Year; my $dt = DateTime->new(year=>2003, month=>02, day=>01); my $dt2 = DateTime->new(year=>2003, month=>03, day=>01); my $fiscal = DateTime::Fiscal::Year->new( start => $dt ); $fiscal->day_of_fiscal_year( $dt2 ); or $fiscal->week_of_fiscal_year( $dt2 ); or $fiscal->period_of_fiscal_year( 12, $dt2 ); or $fiscal->quarter_fiscal_year( 13, $dt2 ); =head1 DESCRIPTION This module allows you to calulate the day, week, period or quarter of a date in a fiscal year, given a start date and either a target date or number of periods and target date. This is often needed in business, where the fiscal year begins and ends on different days than the calendar year. This module is based on the Gregorian calendar. Using other DT calendar objects will return results, but the behavior is unpredicatable for calendars that have more than 365 or 366 days. =head1 USAGE This module implements the following methods: =over 4 =item * new(start => $dt) The new() method has one named parameter start. The argument to start is a valid DateTime object. This date is the first day of the fiscal year and is used to calculate the offset for the target date. =item * day_of_fiscal_year( $dt2 ) Returns the day of the fiscal year as calculated from the start date given $dt2 is a valid DateTime object. my $dt = DateTime->new(year=>2003, month=>02, day=>01); my $dt2 = DateTime->new(year=>2003, month=>03, day=>01); my $fiscal = DateTime::Fiscal::Year->new( start => $dt ); my $dofy = $fiscal->day_of_fiscal_year( $dt2 ); Day of fiscal year ($dofy) is 29. If given the same day for start and target, the value is 1. =item * week_of_fiscal_year( $dt2 ) Returns the week of the fiscal year as calculated from the start date given $dt2 is a valid DateTime object. my $dt = DateTime->new(year=>2003, month=>02, day=>01); my $dt2 = DateTime->new(year=>2003, month=>03, day=>01); my $fiscal = DateTime::Fiscal::Year->new( start => $dt ); my $wofy = $fiscal->week_of_fiscal_year( $dt2 ); Week of fiscal year ($wofy) is 5. There is not a week 0 or 53. This module was built to assist in financial applications not to satisfy the ISO. =item * period_of_fiscal_year( , $dt2 ) Returns the period of the fiscal year given the first argument is the number of fiscal periods and the second argument is a valid DateTime object. Right now the only acceptable number of periods is either 12 or 13. =item * quarter_of_fiscal_year( , $dt2 ) Returns the quarter of the fiscal year given the first argument is the number of fiscal periods and the second argument is a valid DateTime object. Right now the only acceptable number of periods is either 12 or 13. =back =head1 SUPPORT Support for this module can be obtained from: datetime@perl.org =head1 AUTHOR Jesse Shy , thanks to Dave Rolsky for being brave enough to start the perl date-time project. I hope this helps anyone who has to build programs that due financial date calculations. =head1 COPYRIGHT Copyright (c) 2003 Jesse Shy. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module. =head1 SEE ALSO B, datetime@perl.org mailing list http://datetime.perl.org =cut