|
Lines 287-300
sub GetWaitingHolds {
Link Here
|
| 287 |
$sth->execute(); |
287 |
$sth->execute(); |
| 288 |
my @results; |
288 |
my @results; |
| 289 |
while ( my $issue = $sth->fetchrow_hashref() ) { |
289 |
while ( my $issue = $sth->fetchrow_hashref() ) { |
| 290 |
my @waitingdate = split( /-/, $issue->{'waitingdate'} ); |
290 |
my $calendar = C4::Calendar->new( branchcode => $issue->{'site'} ); |
| 291 |
my @date_due = Add_Delta_Days( $waitingdate[0], $waitingdate[1], $waitingdate[2], $pickupdelay ); |
291 |
|
| 292 |
$issue->{'date_due'} = sprintf( "%04d-%02d-%02d", $date_due[0], $date_due[1], $date_due[2] ); |
292 |
my ( $waiting_year, $waiting_month, $waiting_day ) = split( /-/, $issue->{'waitingdate'} ); |
|
|
293 |
my ( $pickup_year, $pickup_month, $pickup_day ) = Add_Delta_Days( $waiting_year, $waiting_month, $waiting_day, $pickupdelay ); |
| 294 |
|
| 295 |
while ( $calendar->isHoliday( $pickup_day, $pickup_month, $pickup_year ) ) { |
| 296 |
( $pickup_year, $pickup_month, $pickup_day ) = Add_Delta_Days( $pickup_year, $pickup_month, $pickup_day, 1 ); |
| 297 |
} |
| 298 |
|
| 299 |
$issue->{'date_due'} = sprintf( "%04d-%02d-%02d", $pickup_year, $pickup_month, $pickup_day ); |
| 293 |
$issue->{'level'} = 1; # only one level for Hold Waiting notifications |
300 |
$issue->{'level'} = 1; # only one level for Hold Waiting notifications |
| 294 |
|
301 |
|
| 295 |
my $days_to_subtract = 0; |
302 |
my $days_to_subtract = 0; |
| 296 |
my $calendar = C4::Calendar->new( branchcode => $issue->{'site'} ); |
303 |
while ( $calendar->isHoliday( reverse( Add_Delta_Days( $waiting_year, $waiting_month, $waiting_day, $days_to_subtract ) ) ) ) { |
| 297 |
while ( $calendar->isHoliday( reverse( Add_Delta_Days( $waitingdate[0], $waitingdate[1], $waitingdate[2], $days_to_subtract ) ) ) ) { |
|
|
| 298 |
$days_to_subtract++; |
304 |
$days_to_subtract++; |
| 299 |
} |
305 |
} |
| 300 |
$issue->{'days_since_waiting'} = $issue->{'days_since_waiting'} - $days_to_subtract; |
306 |
$issue->{'days_since_waiting'} = $issue->{'days_since_waiting'} - $days_to_subtract; |
| 301 |
- |
|
|