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

(-)a/reports/borrowers_out.pl (-2 / +8 lines)
Lines 211-217 sub calculate { Link Here
211
    $strcalc .= "SELECT CONCAT( borrowers.surname , \"\\t\",borrowers.firstname, \"\\t\", borrowers.cardnumber)";
211
    $strcalc .= "SELECT CONCAT( borrowers.surname , \"\\t\",borrowers.firstname, \"\\t\", borrowers.cardnumber)";
212
    $strcalc .= " , " . $dbh->quote($colfield) if ($colfield);
212
    $strcalc .= " , " . $dbh->quote($colfield) if ($colfield);
213
    $strcalc .= " FROM borrowers ";
213
    $strcalc .= " FROM borrowers ";
214
    $strcalc .= "WHERE 1 ";
214
    my $cur_lib = C4::Context->userenv->{branch};
215
    if(C4::Context->preference('IndependentBranches') && !C4::Context->IsSuperLibrarian()){
216
      $strcalc .= "WHERE branchcode = '$cur_lib' ";
217
    }
218
    else{
219
      $strcalc .= "WHERE 1 ";
220
    }
221
    
215
    my @query_args;
222
    my @query_args;
216
    if ( @$filters[0] ) {
223
    if ( @$filters[0] ) {
217
        @$filters[0]=~ s/\*/%/g;
224
        @$filters[0]=~ s/\*/%/g;
218
- 

Return to bug 28967