Lines 233-239
if ($op eq 'add_form') {
Link Here
|
233 |
$template->param(else => 1); |
233 |
$template->param(else => 1); |
234 |
my @loop; |
234 |
my @loop; |
235 |
my ($count,$results)=StringSearch($searchfield,'web'); |
235 |
my ($count,$results)=StringSearch($searchfield,'web'); |
|
|
236 |
my $dbh = C4::Context->dbh; |
237 |
my $sth = $dbh->prepare("SELECT b.branchcode, b.branchname FROM categories_branches AS cb, branches AS b WHERE cb.branchcode = b.branchcode AND cb.categorycode = ?"); |
236 |
for (my $i=0; $i < $count; $i++){ |
238 |
for (my $i=0; $i < $count; $i++){ |
|
|
239 |
$sth->execute( $results->[$i]{'categorycode'} ); |
240 |
my @selected_branches; |
241 |
while ( my $branch = $sth->fetchrow_hashref ) { |
242 |
push @selected_branches, $branch; |
243 |
} |
237 |
my %row = ( |
244 |
my %row = ( |
238 |
categorycode => $results->[$i]{'categorycode'}, |
245 |
categorycode => $results->[$i]{'categorycode'}, |
239 |
description => $results->[$i]{'description'}, |
246 |
description => $results->[$i]{'description'}, |
Lines 247-253
if ($op eq 'add_form') {
Link Here
|
247 |
reservefee => sprintf("%.2f",$results->[$i]{'reservefee'}), |
254 |
reservefee => sprintf("%.2f",$results->[$i]{'reservefee'}), |
248 |
hidelostitems => $results->[$i]{'hidelostitems'}, |
255 |
hidelostitems => $results->[$i]{'hidelostitems'}, |
249 |
category_type => $results->[$i]{'category_type'}, |
256 |
category_type => $results->[$i]{'category_type'}, |
250 |
"type_".$results->[$i]{'category_type'} => 1); |
257 |
"type_".$results->[$i]{'category_type'} => 1, |
|
|
258 |
branches => \@selected_branches, |
259 |
); |
251 |
if (C4::Context->preference('EnhancedMessagingPreferences')) { |
260 |
if (C4::Context->preference('EnhancedMessagingPreferences')) { |
252 |
my $brief_prefs = _get_brief_messaging_prefs($results->[$i]{'categorycode'}); |
261 |
my $brief_prefs = _get_brief_messaging_prefs($results->[$i]{'categorycode'}); |
253 |
$row{messaging_prefs} = $brief_prefs if @$brief_prefs; |
262 |
$row{messaging_prefs} = $brief_prefs if @$brief_prefs; |