View | Details | Raw Unified | Return to bug 6292
Collapse All | Expand All

(-)a/misc/cronjobs/overdue_notices.pl (-6 / +5 lines)
Lines 425-431 END_SQL Link Here
425
            # <date> <itemcount> <firstname> <lastname> <address1> <address2> <address3> <city> <postcode>
425
            # <date> <itemcount> <firstname> <lastname> <address1> <address2> <address3> <city> <postcode>
426
426
427
            my $borrower_sql = <<'END_SQL';
427
            my $borrower_sql = <<'END_SQL';
428
SELECT distinct(issues.borrowernumber), firstname, surname, address, address2, city, zipcode, country, email, date_due 
428
SELECT distinct(issues.borrowernumber), firstname, surname, address, address2, city, zipcode, country, email
429
FROM   issues,borrowers,categories
429
FROM   issues,borrowers,categories
430
WHERE  issues.borrowernumber=borrowers.borrowernumber
430
WHERE  issues.borrowernumber=borrowers.borrowernumber
431
AND    borrowers.categorycode=categories.categorycode
431
AND    borrowers.categorycode=categories.categorycode
Lines 441-450 END_SQL Link Here
441
            }
441
            }
442
            $borrower_sql .= '  AND categories.overduenoticerequired=1 ';
442
            $borrower_sql .= '  AND categories.overduenoticerequired=1 ';
443
            if($triggered) {
443
            if($triggered) {
444
                $borrower_sql .= ' HAVING TO_DAYS(NOW())-TO_DAYS(date_due) = ?';
444
                $borrower_sql .= ' AND TO_DAYS(NOW())-TO_DAYS(date_due) = ?';
445
                push @borrower_parameters, $mindays;
445
                push @borrower_parameters, $mindays;
446
            } else {
446
            } else {
447
                $borrower_sql .= ' HAVING TO_DAYS(NOW())-TO_DAYS(date_due) BETWEEN ? and ? ' ;
447
                $borrower_sql .= ' AND TO_DAYS(NOW())-TO_DAYS(date_due) BETWEEN ? and ? ' ;
448
                push @borrower_parameters, $mindays, $maxdays;
448
                push @borrower_parameters, $mindays, $maxdays;
449
            }
449
            }
450
450
Lines 454-461 END_SQL Link Here
454
            $verbose and warn $borrower_sql . "\n $branchcode | " . $overdue_rules->{'categorycode'} . "\n ($mindays, $maxdays)\nreturns " . $sth->rows . " rows";
454
            $verbose and warn $borrower_sql . "\n $branchcode | " . $overdue_rules->{'categorycode'} . "\n ($mindays, $maxdays)\nreturns " . $sth->rows . " rows";
455
455
456
            while ( my ( $borrowernumber, $firstname, $lastname,
456
            while ( my ( $borrowernumber, $firstname, $lastname,
457
                    $address1, $address2, $city, $postcode, $country, $email,
457
                    $address1, $address2, $city, $postcode, $country, $email
458
                    $date_due ) = $sth->fetchrow )
458
                    ) = $sth->fetchrow )
459
            {
459
            {
460
                $verbose and warn "borrower $firstname, $lastname ($borrowernumber) has items triggering level $i.";
460
                $verbose and warn "borrower $firstname, $lastname ($borrowernumber) has items triggering level $i.";
461
    
461
    
462
- 

Return to bug 6292