1 package Koha::Calendar;
8 use DateTime::Duration;
14 my ( $classname, %options ) = @_;
16 bless $self, $classname;
17 for my $o_name ( keys %options ) {
19 $self->{$o} = $options{$o_name};
21 if ( !defined $self->{branchcode} ) {
22 croak 'No branchcode argument passed to Koha::Calendar->new';
30 my $branch = $self->{branchcode};
31 my $dbh = C4::Context->dbh();
32 my $weekly_closed_days_sth = $dbh->prepare(
33 'SELECT weekday FROM repeatable_holidays WHERE branchcode = ? AND weekday IS NOT NULL'
35 $weekly_closed_days_sth->execute( $branch );
36 $self->{weekly_closed_days} = [ 0, 0, 0, 0, 0, 0, 0 ];
37 while ( my $tuple = $weekly_closed_days_sth->fetchrow_hashref ) {
38 $self->{weekly_closed_days}->[ $tuple->{weekday} ] = 1;
40 my $day_month_closed_days_sth = $dbh->prepare(
41 'SELECT day, month FROM repeatable_holidays WHERE branchcode = ? AND weekday IS NULL'
43 $day_month_closed_days_sth->execute( $branch );
44 $self->{day_month_closed_days} = {};
45 while ( my $tuple = $day_month_closed_days_sth->fetchrow_hashref ) {
46 $self->{day_month_closed_days}->{ $tuple->{month} }->{ $tuple->{day} } =
50 $self->{days_mode} ||= C4::Context->preference('useDaysMode');
55 sub exception_holidays {
58 my $cache = Koha::Caches->get_instance();
59 my $cached = $cache->get_from_cache('exception_holidays');
60 return $cached if $cached;
62 my $dbh = C4::Context->dbh;
63 my $branch = $self->{branchcode};
64 my $exception_holidays_sth = $dbh->prepare(
65 'SELECT day, month, year FROM special_holidays WHERE branchcode = ? AND isexception = 1'
67 $exception_holidays_sth->execute( $branch );
69 while ( my ( $day, $month, $year ) = $exception_holidays_sth->fetchrow ) {
75 time_zone => "floating",
76 )->truncate( to => 'day' );
78 $self->{exception_holidays} =
79 DateTime::Set->from_datetimes( dates => $dates );
80 $cache->set_in_cache( 'exception_holidays', $self->{exception_holidays} );
81 return $self->{exception_holidays};
85 my ( $self, $date ) = @_;
86 my $branchcode = $self->{branchcode};
87 my $cache = Koha::Caches->get_instance();
88 my $single_holidays = $cache->get_from_cache('single_holidays');
90 # $single_holidays looks like:
99 unless ($single_holidays) {
100 my $dbh = C4::Context->dbh;
101 $single_holidays = {};
103 # push holidays for each branch
105 $dbh->prepare('SELECT distinct(branchcode) FROM special_holidays');
106 $branches_sth->execute();
107 while ( my $br = $branches_sth->fetchrow ) {
108 my $single_holidays_sth = $dbh->prepare(
109 'SELECT day, month, year FROM special_holidays WHERE branchcode = ? AND isexception = 0'
111 $single_holidays_sth->execute($br);
114 while ( my ( $day, $month, $year ) =
115 $single_holidays_sth->fetchrow )
117 my $dt = DateTime->new(
121 time_zone => 'floating',
122 )->truncate( to => 'day' );
123 push @ymd_arr, $dt->ymd('');
125 $single_holidays->{$br} = \@ymd_arr;
127 $cache->set_in_cache( 'single_holidays', $single_holidays,
128 { expiry => 76800 } ) #24 hrs ;
130 my $holidays = ( $single_holidays->{$branchcode} );
131 for my $hols (@$holidays ) {
132 return 1 if ( $date == $hols ) #match ymds;
138 my ( $self, $startdate, $add_duration, $unit ) = @_;
140 # Default to days duration (legacy support I guess)
141 if ( ref $add_duration ne 'DateTime::Duration' ) {
142 $add_duration = DateTime::Duration->new( days => $add_duration );
145 $unit ||= 'days'; # default days ?
147 if ( $unit eq 'hours' ) {
148 # Fixed for legacy support. Should be set as a branch parameter
149 my $return_by_hour = 10;
151 $dt = $self->addHours($startdate, $add_duration, $return_by_hour);
154 $dt = $self->addDays($startdate, $add_duration);
160 my ( $self, $startdate, $hours_duration, $return_by_hour ) = @_;
161 my $base_date = $startdate->clone();
163 $base_date->add_duration($hours_duration);
165 # If we are using the calendar behave for now as if Datedue
166 # was the chosen option (current intended behaviour)
168 if ( $self->{days_mode} ne 'Days' &&
169 $self->is_holiday($base_date) ) {
171 if ( $hours_duration->is_negative() ) {
172 $base_date = $self->prev_open_days($base_date, 1);
174 $base_date = $self->next_open_days($base_date, 1);
177 $base_date->set_hour($return_by_hour);
185 my ( $self, $startdate, $days_duration ) = @_;
186 my $base_date = $startdate->clone();
188 $self->{days_mode} ||= q{};
190 if ( $self->{days_mode} eq 'Calendar' ) {
191 # use the calendar to skip all days the library is closed
193 my $days = abs $days_duration->in_units('days');
195 if ( $days_duration->is_negative() ) {
197 $base_date = $self->prev_open_days($base_date, 1);
202 $base_date = $self->next_open_days($base_date, 1);
207 } else { # Days, Datedue or Dayweek
208 # use straight days, then use calendar to push
209 # the date to the next open day as appropriate
210 # if Datedue or Dayweek
211 $base_date->add_duration($days_duration);
213 if ( $self->{days_mode} eq 'Datedue' ||
214 $self->{days_mode} eq 'Dayweek') {
215 # Datedue or Dayweek, then use the calendar to push
216 # the date to the next open day if holiday
217 if ( $self->is_holiday($base_date) ) {
218 my $dow = $base_date->day_of_week;
219 my $days = $days_duration->in_units('days');
221 # We're using Dayweek useDaysMode option
222 $self->{days_mode} eq 'Dayweek' &&
223 # It's period based on weeks
225 # It's not a permanently closed day
226 !$self->{weekly_closed_days}->[$dow] == 1
228 if ( $days_duration->is_negative() ) {
229 $base_date = $self->prev_open_days($base_date, $push_amt);
231 $base_date = $self->next_open_days($base_date, $push_amt);
241 my ( $self, $dt ) = @_;
243 my $localdt = $dt->clone();
244 my $day = $localdt->day;
245 my $month = $localdt->month;
247 #Change timezone to "floating" before doing any calculations or comparisons
248 $localdt->set_time_zone("floating");
249 $localdt->truncate( to => 'day' );
252 if ( $self->exception_holidays->contains($localdt) ) {
253 # exceptions are not holidays
257 my $dow = $localdt->day_of_week;
259 # DateTime object dow (1-7) where Monday is 1
260 # Arrays are 0-based where 0 = Sunday, not 7.
265 if ( $self->{weekly_closed_days}->[$dow] == 1 ) {
269 if ( exists $self->{day_month_closed_days}->{$month}->{$day} ) {
273 my $ymd = $localdt->ymd('') ;
274 if ($self->single_holidays( $ymd ) == 1 ) {
278 # damn have to go to work after all
283 my ( $self, $dt, $to_add ) = @_;
284 my $base_date = $dt->clone();
286 $base_date->add(days => $to_add);
287 while ($self->is_holiday($base_date)) {
288 $base_date->add(days => $to_add);
294 my ( $self, $dt, $to_sub ) = @_;
295 my $base_date = $dt->clone();
297 # It feels logical to be passed a positive number, though we're
298 # subtracting, so do the right thing
299 $to_sub = $to_sub > 0 ? 0 - $to_sub : $to_sub;
301 $base_date->add(days => $to_sub);
303 while ($self->is_holiday($base_date)) {
304 $base_date->add(days => $to_sub);
312 my $start_dt = shift;
313 my $num_days = shift;
315 return $start_dt unless $num_days > 0;
317 my $base_dt = $start_dt->clone();
319 while ($num_days--) {
320 $base_dt = $self->next_open_days($base_dt, 1);
328 my $start_dt = shift;
331 # Change time zone for date math and swap if needed
332 $start_dt = $start_dt->clone->set_time_zone('floating');
333 $end_dt = $end_dt->clone->set_time_zone('floating');
334 if( $start_dt->compare($end_dt) > 0 ) {
335 ( $start_dt, $end_dt ) = ( $end_dt, $start_dt );
338 # start and end should not be closed days
339 my $days = $start_dt->delta_days($end_dt)->delta_days;
340 while( $start_dt->compare($end_dt) < 1 ) {
341 $days-- if $self->is_holiday($start_dt);
342 $start_dt->add( days => 1 );
344 return DateTime::Duration->new( days => $days );
348 my ($self, $start_date, $end_date) = @_;
349 my $start_dt = $start_date->clone()->set_time_zone('floating');
350 my $end_dt = $end_date->clone()->set_time_zone('floating');
351 my $duration = $end_dt->delta_ms($start_dt);
352 $start_dt->truncate( to => 'day' );
353 $end_dt->truncate( to => 'day' );
354 # NB this is a kludge in that it assumes all days are 24 hours
355 # However for hourly loans the logic should be expanded to
356 # take into account open/close times then it would be a duration
357 # of library open hours
358 # start and end should not be closed days
359 my $skipped_days = 0;
360 while( $start_dt->compare($end_dt) < 1 ) {
361 $start_dt->add( days => 1 );
362 $skipped_days++ if $self->is_holiday($start_dt);
365 $duration->subtract_duration(DateTime::Duration->new( hours => 24 * $skipped_days));
372 my ( $self, $mode ) = @_;
374 # if not testing this is a no op
375 if ( $self->{test} ) {
376 $self->{days_mode} = $mode;
382 sub clear_weekly_closed_days {
384 $self->{weekly_closed_days} = [ 0, 0, 0, 0, 0, 0, 0 ]; # Sunday only
393 Koha::Calendar - Object containing a branches calendar
399 my $c = Koha::Calendar->new( branchcode => 'MAIN' );
400 my $dt = DateTime->now();
403 $open = $c->is_holiday($dt);
404 # when will item be due if loan period = $dur (a DateTime::Duration object)
405 $duedate = $c->addDate($dt,$dur,'days');
410 Implements those features of C4::Calendar needed for Staffs Rolling Loans
414 =head2 new : Create a calendar object
416 my $calendar = Koha::Calendar->new( branchcode => 'MAIN' );
418 The option branchcode is required
423 my $dt = $calendar->addDate($date, $dur, $unit)
425 C<$date> is a DateTime object representing the starting date of the interval.
427 C<$offset> is a DateTime::Duration to add to it
429 C<$unit> is a string value 'days' or 'hours' toflag granularity of duration
431 Currently unit is only used to invoke Staffs return Monday at 10 am rule this
432 parameter will be removed when issuingrules properly cope with that
437 my $dt = $calendar->addHours($date, $dur, $return_by_hour )
439 C<$date> is a DateTime object representing the starting date of the interval.
441 C<$offset> is a DateTime::Duration to add to it
443 C<$return_by_hour> is an integer value representing the opening hour for the branch
448 my $dt = $calendar->addDays($date, $dur)
450 C<$date> is a DateTime object representing the starting date of the interval.
452 C<$offset> is a DateTime::Duration to add to it
454 C<$unit> is a string value 'days' or 'hours' toflag granularity of duration
456 Currently unit is only used to invoke Staffs return Monday at 10 am rule this
457 parameter will be removed when issuingrules properly cope with that
460 =head2 single_holidays
462 my $rc = $self->single_holidays( $ymd );
464 Passed a $date in Ymd (yyyymmdd) format - returns 1 if date is a single_holiday, or 0 if not.
469 $yesno = $calendar->is_holiday($dt);
471 passed a DateTime object returns 1 if it is a closed day
472 0 if not according to the calendar
476 $duration = $calendar->days_between($start_dt, $end_dt);
478 Passed two dates returns a DateTime::Duration object measuring the length between them
479 ignoring closed days. Always returns a positive number irrespective of the
480 relative order of the parameters
482 =head2 next_open_days
484 $datetime = $calendar->next_open_days($duedate_dt, $to_add)
486 Passed a Datetime and number of days, returns another Datetime representing
487 the next open day after adding the passed number of days. It is intended for
488 use to calculate the due date when useDaysMode syspref is set to either
489 'Datedue', 'Calendar' or 'Dayweek'.
491 =head2 prev_open_days
493 $datetime = $calendar->prev_open_days($duedate_dt, $to_sub)
495 Passed a Datetime and a number of days, returns another Datetime
496 representing the previous open day after subtracting the number of passed
497 days. It is intended for use to calculate the due date when useDaysMode
498 syspref is set to either 'Datedue', 'Calendar' or 'Dayweek'.
502 For testing only allows the calling script to change days mode
504 =head2 clear_weekly_closed_days
506 In test mode changes the testing set of closed days to a new set with
507 no closed days. TODO passing an array of closed days to this would
508 allow testing of more configurations
512 Passed a datetime object this will add it to the calendar's list of
513 closed days. This is for testing so that we can alter the Calenfar object's
514 list of specified dates
518 Will croak if not passed a branchcode in new
520 =head1 BUGS AND LIMITATIONS
522 This only contains a limited subset of the functionality in C4::Calendar
523 Only enough to support Staffs Rolling loans
527 Colin Campbell colin.campbell@ptfs-europe.com
529 =head1 LICENSE AND COPYRIGHT
531 Copyright (c) 2011 PTFS-Europe Ltd All rights reserved
533 This program is free software: you can redistribute it and/or modify
534 it under the terms of the GNU General Public License as published by
535 the Free Software Foundation, either version 2 of the License, or
536 (at your option) any later version.
538 This program is distributed in the hope that it will be useful,
539 but WITHOUT ANY WARRANTY; without even the implied warranty of
540 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
541 GNU General Public License for more details.
543 You should have received a copy of the GNU General Public License
544 along with this program. If not, see <http://www.gnu.org/licenses/>.