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} ); |