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