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');
56 # FIXME: use of package-level variables for caching the holiday
57 # lists breaks persistance engines. As of 2013-12-10, the RM
58 # is allowing this with the expectation that prior to release of
59 # 3.16, bug 8089 will be fixed and we can switch the caching over
62 our $exception_holidays;
64 sub exception_holidays {
66 my $dbh = C4::Context->dbh;
67 my $branch = $self->{branchcode};
68 if ( $exception_holidays ) {
69 $self->{exception_holidays} = $exception_holidays;
70 return $exception_holidays;
72 my $exception_holidays_sth = $dbh->prepare(
73 'SELECT day, month, year FROM special_holidays WHERE branchcode = ? AND isexception = 1'
75 $exception_holidays_sth->execute( $branch );
77 while ( my ( $day, $month, $year ) = $exception_holidays_sth->fetchrow ) {
83 time_zone => C4::Context->tz()
84 )->truncate( to => 'day' );
86 $self->{exception_holidays} =
87 DateTime::Set->from_datetimes( dates => $dates );
88 $exception_holidays = $self->{exception_holidays};
89 return $exception_holidays;
93 my ( $self, $date ) = @_;
94 my $branchcode = $self->{branchcode};
95 my $cache = Koha::Cache->get_instance();
96 my $single_holidays = $cache->get_from_cache('single_holidays');
99 $single_holidays looks like this..
116 unless ($single_holidays) {
117 my $dbh = C4::Context->dbh;
118 $single_holidays = {};
120 # push holidays for each branch
122 $dbh->prepare('SELECT distinct(branchcode) FROM special_holidays');
123 $branches_sth->execute();
124 while ( my $br = $branches_sth->fetchrow ) {
125 my $single_holidays_sth = $dbh->prepare(
126 'SELECT day, month, year FROM special_holidays WHERE branchcode = ? AND isexception = 0'
128 $single_holidays_sth->execute($branchcode);
131 while ( my ( $day, $month, $year ) =
132 $single_holidays_sth->fetchrow )
134 my $dt = DateTime->new(
138 time_zone => C4::Context->tz()
139 )->truncate( to => 'day' );
140 push @ymd_arr, $dt->ymd('');
142 $single_holidays->{$br} = \@ymd_arr;
144 $cache->set_in_cache( 'single_holidays', $single_holidays,
147 my $holidays = ( $single_holidays->{$branchcode} );
148 for my $hols (@$holidays ) {
149 return 1 if ( $date == $hols ) #match ymds;
155 my ( $self, $startdate, $add_duration, $unit ) = @_;
157 # Default to days duration (legacy support I guess)
158 if ( ref $add_duration ne 'DateTime::Duration' ) {
159 $add_duration = DateTime::Duration->new( days => $add_duration );
162 $unit ||= 'days'; # default days ?
165 if ( $unit eq 'hours' ) {
166 # Fixed for legacy support. Should be set as a branch parameter
167 my $return_by_hour = 10;
169 $dt = $self->addHours($startdate, $add_duration, $return_by_hour);
172 $dt = $self->addDays($startdate, $add_duration);
179 my ( $self, $startdate, $hours_duration, $return_by_hour ) = @_;
180 my $base_date = $startdate->clone();
182 $base_date->add_duration($hours_duration);
184 # If we are using the calendar behave for now as if Datedue
185 # was the chosen option (current intended behaviour)
187 if ( $self->{days_mode} ne 'Days' &&
188 $self->is_holiday($base_date) ) {
190 if ( $hours_duration->is_negative() ) {
191 $base_date = $self->prev_open_day($base_date);
193 $base_date = $self->next_open_day($base_date);
196 $base_date->set_hour($return_by_hour);
204 my ( $self, $startdate, $days_duration ) = @_;
205 my $base_date = $startdate->clone();
207 $self->{days_mode} ||= q{};
209 if ( $self->{days_mode} eq 'Calendar' ) {
210 # use the calendar to skip all days the library is closed
212 my $days = abs $days_duration->in_units('days');
214 if ( $days_duration->is_negative() ) {
216 $base_date = $self->prev_open_day($base_date);
221 $base_date = $self->next_open_day($base_date);
226 } else { # Days or Datedue
227 # use straight days, then use calendar to push
228 # the date to the next open day if Datedue
229 $base_date->add_duration($days_duration);
231 if ( $self->{days_mode} eq 'Datedue' ) {
232 # Datedue, then use the calendar to push
233 # the date to the next open day if holiday
234 if ( $self->is_holiday($base_date) ) {
236 if ( $days_duration->is_negative() ) {
237 $base_date = $self->prev_open_day($base_date);
239 $base_date = $self->next_open_day($base_date);
249 my ( $self, $dt ) = @_;
251 my $localdt = $dt->clone();
252 my $day = $localdt->day;
253 my $month = $localdt->month;
255 $localdt->truncate( to => 'day' );
258 if ( $self->exception_holidays->contains($localdt) ) {
259 # exceptions are not holidays
263 my $dow = $localdt->day_of_week;
265 # DateTime object dow (1-7) where Monday is 1
266 # Arrays are 0-based where 0 = Sunday, not 7.
271 if ( $self->{weekly_closed_days}->[$dow] == 1 ) {
275 if ( exists $self->{day_month_closed_days}->{$month}->{$day} ) {
279 my $ymd = $localdt->ymd('') ;
280 if ($self->single_holidays( $ymd ) == 1 ) {
284 # damn have to go to work after all
289 my ( $self, $dt ) = @_;
290 my $base_date = $dt->clone();
292 $base_date->add(days => 1);
294 while ($self->is_holiday($base_date)) {
295 $base_date->add(days => 1);
302 my ( $self, $dt ) = @_;
303 my $base_date = $dt->clone();
305 $base_date->add(days => -1);
307 while ($self->is_holiday($base_date)) {
308 $base_date->add(days => -1);
316 my $start_dt = shift;
319 if ( $start_dt->compare($end_dt) > 0 ) {
321 my $int_dt = $end_dt;
327 # start and end should not be closed days
328 my $days = $start_dt->delta_days($end_dt)->delta_days;
329 for (my $dt = $start_dt->clone();
333 if ($self->is_holiday($dt)) {
337 return DateTime::Duration->new( days => $days );
342 my ($self, $start_date, $end_date) = @_;
343 my $start_dt = $start_date->clone();
344 my $end_dt = $end_date->clone();
345 my $duration = $end_dt->delta_ms($start_dt);
346 $start_dt->truncate( to => 'day' );
347 $end_dt->truncate( to => 'day' );
348 # NB this is a kludge in that it assumes all days are 24 hours
349 # However for hourly loans the logic should be expanded to
350 # take into account open/close times then it would be a duration
351 # of library open hours
352 my $skipped_days = 0;
353 for (my $dt = $start_dt->clone();
357 if ($self->is_holiday($dt)) {
362 $duration->subtract_duration(DateTime::Duration->new( hours => 24 * $skipped_days));
370 my ( $self, $mode ) = @_;
372 # if not testing this is a no op
373 if ( $self->{test} ) {
374 $self->{days_mode} = $mode;
380 sub clear_weekly_closed_days {
382 $self->{weekly_closed_days} = [ 0, 0, 0, 0, 0, 0, 0 ]; # Sunday only
387 sub add_dummy_holiday {
388 my ( $self, $new_dt ) = @_;
390 my $cache = Koha::Cache->get_instance();
391 my $single_holidays = $cache->get_from_cache('single_holidays');
393 # add a dummy holiday to the holiday cache...
394 my $ymd = $new_dt->ymd('');
395 $single_holidays->{'MPL'} = [$ymd];
396 $cache->set_in_cache( 'single_holidays', $single_holidays, 76800 );
398 # ...but *dont* reset the cache, as this holiday was not really written to the db
399 # its only used to mock a holiday insert for 1 test in t/db_dependent/Holidays.t
401 # is( $koha_calendar->is_holiday($custom_holiday), 0, '2013-11-10 does not start off as a holiday' );
402 # $koha_calendar->add_dummy_holiday($custom_holiday );
403 # is( $koha_calendar->is_holiday($custom_holiday), 1, 'able to add holiday for testing' );
413 Koha::Calendar - Object containing a branches calendar
417 This documentation refers to Koha::Calendar version 0.0.1
423 my $c = Koha::Calendar->new( branchcode => 'MAIN' );
424 my $dt = DateTime->now();
427 $open = $c->is_holiday($dt);
428 # when will item be due if loan period = $dur (a DateTime::Duration object)
429 $duedate = $c->addDate($dt,$dur,'days');
434 Implements those features of C4::Calendar needed for Staffs Rolling Loans
438 =head2 new : Create a calendar object
440 my $calendar = Koha::Calendar->new( branchcode => 'MAIN' );
442 The option branchcode is required
447 my $dt = $calendar->addDate($date, $dur, $unit)
449 C<$date> is a DateTime object representing the starting date of the interval.
451 C<$offset> is a DateTime::Duration to add to it
453 C<$unit> is a string value 'days' or 'hours' toflag granularity of duration
455 Currently unit is only used to invoke Staffs return Monday at 10 am rule this
456 parameter will be removed when issuingrules properly cope with that
461 my $dt = $calendar->addHours($date, $dur, $return_by_hour )
463 C<$date> is a DateTime object representing the starting date of the interval.
465 C<$offset> is a DateTime::Duration to add to it
467 C<$return_by_hour> is an integer value representing the opening hour for the branch
472 my $dt = $calendar->addDays($date, $dur)
474 C<$date> is a DateTime object representing the starting date of the interval.
476 C<$offset> is a DateTime::Duration to add to it
478 C<$unit> is a string value 'days' or 'hours' toflag granularity of duration
480 Currently unit is only used to invoke Staffs return Monday at 10 am rule this
481 parameter will be removed when issuingrules properly cope with that
484 =head2 single_holidays
486 my $rc = $self->single_holidays( $ymd );
488 Passed a $date in Ymd (yyyymmdd) format - returns 1 if date is a single_holiday, or 0 if not.
493 $yesno = $calendar->is_holiday($dt);
495 passed a DateTime object returns 1 if it is a closed day
496 0 if not according to the calendar
500 $duration = $calendar->days_between($start_dt, $end_dt);
502 Passed two dates returns a DateTime::Duration object measuring the length between them
503 ignoring closed days. Always returns a positive number irrespective of the
504 relative order of the parameters
508 $datetime = $calendar->next_open_day($duedate_dt)
510 Passed a Datetime returns another Datetime representing the next open day. It is
511 intended for use to calculate the due date when useDaysMode syspref is set to either
512 'Datedue' or 'Calendar'.
516 $datetime = $calendar->prev_open_day($duedate_dt)
518 Passed a Datetime returns another Datetime representing the previous open day. It is
519 intended for use to calculate the due date when useDaysMode syspref is set to either
520 'Datedue' or 'Calendar'.
524 For testing only allows the calling script to change days mode
526 =head2 clear_weekly_closed_days
528 In test mode changes the testing set of closed days to a new set with
529 no closed days. TODO passing an array of closed days to this would
530 allow testing of more configurations
534 Passed a datetime object this will add it to the calendar's list of
535 closed days. This is for testing so that we can alter the Calenfar object's
536 list of specified dates
540 Will croak if not passed a branchcode in new
542 =head1 BUGS AND LIMITATIONS
544 This only contains a limited subset of the functionality in C4::Calendar
545 Only enough to support Staffs Rolling loans
549 Colin Campbell colin.campbell@ptfs-europe.com
551 =head1 LICENSE AND COPYRIGHT
553 Copyright (c) 2011 PTFS-Europe Ltd All rights reserved
555 This program is free software: you can redistribute it and/or modify
556 it under the terms of the GNU General Public License as published by
557 the Free Software Foundation, either version 2 of the License, or
558 (at your option) any later version.
560 This program is distributed in the hope that it will be useful,
561 but WITHOUT ANY WARRANTY; without even the implied warranty of
562 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
563 GNU General Public License for more details.
565 You should have received a copy of the GNU General Public License
566 along with this program. If not, see <http://www.gnu.org/licenses/>.