| 
      
            Lines 388-394
          foreach my $branchcode (@branches) {
      
      
        Link Here
      
     | 
  
        
          | 388 | 
           | 
          388 | 
           | 
        
        
          | 389 | 
              $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;  | 
          389 | 
              $verbose and warn sprintf "branchcode : '%s' using %s\n", $branchcode, $admin_email_address;  | 
        
        
          | 390 | 
           | 
          390 | 
           | 
        
          
            
              | 391 | 
                  my $sth2 = $dbh->prepare( <<'END_SQL' );  | 
              391 | 
                  my $sth2 = $dbh->prepare( <<"END_SQL" );  | 
            
        
          | 392 | 
          SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue  | 
          392 | 
          SELECT biblio.*, items.*, issues.*, biblioitems.itemtype, TO_DAYS($date)-TO_DAYS(date_due) AS days_overdue  | 
        
        
          | 393 | 
            FROM issues,items,biblio, biblioitems  | 
          393 | 
            FROM issues,items,biblio, biblioitems  | 
        
        
          | 394 | 
            WHERE items.itemnumber=issues.itemnumber  | 
          394 | 
            WHERE items.itemnumber=issues.itemnumber  | 
        
  
    | 
      
            Lines 455-464
          END_SQL
      
      
        Link Here
      
     | 
  
        
          | 455 | 
                      }  | 
          455 | 
                      }  | 
        
        
          | 456 | 
                      $borrower_sql .= '  AND categories.overduenoticerequired=1 ';  | 
          456 | 
                      $borrower_sql .= '  AND categories.overduenoticerequired=1 ';  | 
        
        
          | 457 | 
                      if($triggered) { | 
          457 | 
                      if($triggered) { | 
        
          
            
              | 458 | 
                              $borrower_sql .= ' AND TO_DAYS($date)-TO_DAYS(date_due) = ?';  | 
              458 | 
                              $borrower_sql .= " AND TO_DAYS($date)-TO_DAYS(date_due) = ?";  | 
            
        
          | 459 | 
                          push @borrower_parameters, $mindays;  | 
          459 | 
                          push @borrower_parameters, $mindays;  | 
        
        
          | 460 | 
                      } else { | 
          460 | 
                      } else { | 
        
          
            
              | 461 | 
                              $borrower_sql .= ' AND TO_DAYS($date)-TO_DAYS(date_due) BETWEEN ? and ? ' ;  | 
              461 | 
                              $borrower_sql .= " AND TO_DAYS($date)-TO_DAYS(date_due) BETWEEN ? and ? " ;  | 
            
        
          | 462 | 
                          push @borrower_parameters, $mindays, $maxdays;  | 
          462 | 
                          push @borrower_parameters, $mindays, $maxdays;  | 
        
        
          | 463 | 
                      }  | 
          463 | 
                      }  | 
        
        
          | 464 | 
           | 
          464 | 
           | 
        
            
              | 465 | 
              -   | 
               | 
               |