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 |
- |
|
|