X-Git-Url: http://koha-dev.rot13.org:8081/gitweb/?a=blobdiff_plain;f=tools%2FbatchMod.pl;h=e416d444da46cb79a1f9b997856839cb9abe3f56;hb=f1b122c2d0a2f04a5b0f5feec8629b2e7a82ce76;hp=3ba93a8ec4153bd8aacd5a88983b3ff148afeec3;hpb=108e901043f0766f8c103f3826b5af1cdb6daaa4;p=koha_fer diff --git a/tools/batchMod.pl b/tools/batchMod.pl index 3ba93a8ec4..e416d444da 100755 --- a/tools/batchMod.pl +++ b/tools/batchMod.pl @@ -34,6 +34,7 @@ use C4::ClassSource; use C4::Dates; use C4::Debug; use MARC::File::XML; +use List::MoreUtils qw/uniq/; my $input = new CGI; my $dbh = C4::Context->dbh; @@ -53,6 +54,7 @@ my $template_flag; if (!defined $op) { $template_name = "tools/batchMod.tmpl"; $template_flag = { tools => '*' }; + $op = q{}; } else { $template_name = ($del) ? "tools/batchMod-del.tmpl" : "tools/batchMod-edit.tmpl"; $template_flag = ($del) ? { tools => 'items_batchdel' } : { tools => 'items_batchmod' }; @@ -236,7 +238,7 @@ if ($op eq "show"){ } } if ( my $list=$input->param('barcodelist')){ - push my @barcodelist, split(/\s\n/, $list); + push my @barcodelist, uniq( split(/\s\n/, $list) ); foreach my $barcode (@barcodelist) { @@ -265,7 +267,13 @@ if ($op eq "show"){ # now, build the item form for entering a new item my @loop_data =(); my $i=0; -my $authorised_values_sth = $dbh->prepare("SELECT authorised_value,lib FROM authorised_values WHERE category=? ORDER BY lib"); +my $branch_limit = C4::Context->userenv ? C4::Context->userenv->{"branch"} : ""; +my $query = qq{SELECT authorised_value, lib FROM authorised_values}; +$query .= qq{ LEFT JOIN authorised_values_branches ON ( id = av_id ) } if $branch_limit; +$query .= qq{ WHERE category = ?}; +$query .= qq{ AND ( branchcode = ? OR branchcode IS NULL ) } if $branch_limit; +$query .= qq{ GROUP BY lib ORDER BY lib, lib_opac}; +my $authorised_values_sth = $dbh->prepare( $query ); my $branches = GetBranchesLoop(); # build once ahead of time, instead of multiple times later. @@ -358,7 +366,7 @@ foreach my $tag (sort keys %{$tagslib}) { } else { push @authorised_values, ""; # unless ( $tagslib->{$tag}->{$subfield}->{mandatory} ); - $authorised_values_sth->execute( $tagslib->{$tag}->{$subfield}->{authorised_value} ); + $authorised_values_sth->execute( $tagslib->{$tag}->{$subfield}->{authorised_value}, $branch_limit ? $branch_limit : () ); while ( my ( $value, $lib ) = $authorised_values_sth->fetchrow_array ) { push @authorised_values, $value; $authorised_lib{$value} = $lib; @@ -393,14 +401,14 @@ foreach my $tag (sort keys %{$tagslib}) { my $temp; my $extended_param = plugin_parameters( $dbh, $temp, $tagslib, $subfield_data{id}, \@loop_data ); my ( $function_name, $javascript ) = plugin_javascript( $dbh, $temp, $tagslib, $subfield_data{id}, \@loop_data ); - $subfield_data{marc_value} = qq[ ... $javascript]; } else { warn "Plugin Failed: $plugin"; - $subfield_data{marc_value} = ""; # supply default input form + $subfield_data{marc_value} = ""; # supply default input form } } elsif ( $tag eq '' ) { # it's an hidden field @@ -419,13 +427,15 @@ foreach my $tag (sort keys %{$tagslib}) { $subfield_data{marc_value} = "\n"; } else { # it's a standard field - $subfield_data{marc_value} = ""; + $subfield_data{marc_value} = ""; } # $subfield_data{marc_value}=""; push (@loop_data, \%subfield_data); $i++ } } # -- End foreach tag +$authorised_values_sth->finish; + # what's the next op ? it's what we are not in : an add if we're editing, otherwise, and edit. @@ -440,8 +450,8 @@ foreach my $tag (sort keys %{$tagslib}) { $template->param(%$items_display_hashref) if $items_display_hashref; $template->param( op => $nextop, - $op => 1, ); +$template->param( $op => 1 ) if $op; if ($op eq "action") { @@ -457,9 +467,10 @@ if ($op eq "action") { } foreach my $error (@errors) { - $template->param($error => 1); + $template->param($error => 1) if $error; } $template->param(src => $src); +$template->param(biblionumber => $biblionumber); output_html_with_http_headers $input, $cookie, $template->output; exit;