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

(-)a/C4/Suggestions.pm (-2 / +1 lines)
Lines 414-420 sub CountSuggestion { Link Here
414
            FROM suggestions
414
            FROM suggestions
415
                LEFT JOIN borrowers ON borrowers.borrowernumber=suggestions.suggestedby
415
                LEFT JOIN borrowers ON borrowers.borrowernumber=suggestions.suggestedby
416
            WHERE STATUS=?
416
            WHERE STATUS=?
417
                AND (borrowers.branchcode='' OR borrowers.branchcode=?)
417
                AND (suggestions.branchcode='' OR suggestions.branchcode=?)
418
        };
418
        };
419
        $sth = $dbh->prepare($query);
419
        $sth = $dbh->prepare($query);
420
        $sth->execute( $status, $userenv->{branch} );
420
        $sth->execute( $status, $userenv->{branch} );
421
- 

Return to bug 18743