|
Lines 113-119
sub SearchSuggestion {
Link Here
|
| 113 |
LEFT JOIN borrowers AS U2 ON managedby=U2.borrowernumber |
113 |
LEFT JOIN borrowers AS U2 ON managedby=U2.borrowernumber |
| 114 |
LEFT JOIN branches AS B2 ON B2.branchcode=U2.branchcode |
114 |
LEFT JOIN branches AS B2 ON B2.branchcode=U2.branchcode |
| 115 |
LEFT JOIN categories AS C2 ON C2.categorycode = U2.categorycode |
115 |
LEFT JOIN categories AS C2 ON C2.categorycode = U2.categorycode |
| 116 |
WHERE STATUS NOT IN ('ORDERED') |
116 |
WHERE 1=1 |
| 117 |
} , map { |
117 |
} , map { |
| 118 |
if ( my $s = $suggestion->{$_} ) { |
118 |
if ( my $s = $suggestion->{$_} ) { |
| 119 |
push @sql_params,'%'.$s.'%'; |
119 |
push @sql_params,'%'.$s.'%'; |
| 120 |
- |
|
|