|
Lines 135-146
sub SearchSuggestion {
Link Here
|
| 135 |
if ( C4::Context->preference('IndependentBranches') ) { |
135 |
if ( C4::Context->preference('IndependentBranches') ) { |
| 136 |
my $userenv = C4::Context->userenv; |
136 |
my $userenv = C4::Context->userenv; |
| 137 |
if ($userenv) { |
137 |
if ($userenv) { |
| 138 |
if ( !C4::Context->IsSuperLibrarian() && !$suggestion->{branchcode} ) |
138 |
if ( !C4::Context->IsSuperLibrarian()) |
| 139 |
{ |
139 |
{ |
| 140 |
push @sql_params, $$userenv{branch}; |
140 |
if( !$suggestion->{branchcode} || $suggestion->{branchcode} eq $userenv->{branch}){ |
| 141 |
push @query, q{ |
141 |
push @sql_params, $$userenv{branch}; |
| 142 |
AND (suggestions.branchcode=? OR suggestions.branchcode='') |
142 |
push @query, q{ |
| 143 |
}; |
143 |
AND (suggestions.branchcode=? OR suggestions.branchcode='') |
|
|
144 |
}; |
| 145 |
} |
| 144 |
} |
146 |
} |
| 145 |
} |
147 |
} |
| 146 |
} else { |
148 |
} else { |
|
Lines 405-411
sub CountSuggestion {
Link Here
|
| 405 |
FROM suggestions |
407 |
FROM suggestions |
| 406 |
LEFT JOIN borrowers ON borrowers.borrowernumber=suggestions.suggestedby |
408 |
LEFT JOIN borrowers ON borrowers.borrowernumber=suggestions.suggestedby |
| 407 |
WHERE STATUS=? |
409 |
WHERE STATUS=? |
| 408 |
AND (borrowers.branchcode='' OR borrowers.branchcode=?) |
410 |
AND (suggestions.branchcode='' OR suggestions.branchcode=?) |
| 409 |
}; |
411 |
}; |
| 410 |
$sth = $dbh->prepare($query); |
412 |
$sth = $dbh->prepare($query); |
| 411 |
$sth->execute( $status, $userenv->{branch} ); |
413 |
$sth->execute( $status, $userenv->{branch} ); |