admin/authorised_values.pl

   1 #!/usr/bin/perl
   2
   3 # Copyright 2000-2002 Katipo Communications
   4 #
   5 # This file is part of Koha.
   6 #
   7 # Koha is free software; you can redistribute it and/or modify it
   8 # under the terms of the GNU General Public License as published by
   9 # the Free Software Foundation; either version 3 of the License, or
  10 # (at your option) any later version.
  11 #
  12 # Koha is distributed in the hope that it will be useful, but
  13 # WITHOUT ANY WARRANTY; without even the implied warranty of
  14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
  15 # GNU General Public License for more details.
  16 #
  17 # You should have received a copy of the GNU General Public License
  18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
  19
  20 use Modern::Perl;
  21
  22 use CGI qw ( -utf8 );
  23 use List::MoreUtils qw(any);
  24
  25 use C4::Auth;
  26 use C4::Context;
  27 use C4::Koha;
  28 use C4::Output;
  29
  30 use Koha::AuthorisedValues;
  31 use Koha::AuthorisedValueCategories;
  32 use Koha::Libraries;
  33
  34 my $input = new CGI;
  35 my $id          = $input->param('id');
  36 my $op          = $input->param('op') || 'list';
  37 my $searchfield = $input->param('searchfield');
  38 $searchfield = '' unless defined $searchfield;
  39 $searchfield =~ s/\,//g;
  40 my @messages;
  41
  42 our ($template, $borrowernumber, $cookie)= get_template_and_user({
  43     template_name => "admin/authorised_values.tt",
  44     authnotrequired => 0,
  45     flagsrequired => {parameters => 'manage_auth_values'},
  46     query => $input,
  47     type => "intranet",
  48     debug => 1,
  49 });
  50
  51 ################## ADD_FORM ##################################
  52 # called by default. Used to create form to add or  modify a record
  53 if ($op eq 'add_form') {
  54     my ( @selected_branches, $category, $av );
  55     if ($id) {
  56         $av = Koha::AuthorisedValues->new->find( $id );
  57         @selected_branches = $av->library_limits ? $av->library_limits->as_list : ();
  58     } else {
  59         $category = $input->param('category');
  60     }
  61
  62     my $branches = Koha::Libraries->search( {}, { order_by => ['branchname'] } );
  63     my @branches_loop;
  64     while ( my $branch = $branches->next ) {
  65         push @branches_loop, {
  66             branchcode => $branch->branchcode,
  67             branchname => $branch->branchname,
  68             selected   => any {$_->branchcode eq $branch->branchcode} @selected_branches,
  69         };
  70     }
  71
  72         if ($id) {
  73                 $template->param(action_modify => 1);
  74    } elsif ( ! $category ) {
  75                 $template->param(action_add_category => 1);
  76         } else {
  77                 $template->param(action_add_value => 1);
  78         }
  79
  80     if ( $av ) {
  81         $template->param(
  82             category => $av->category,
  83             authorised_value => $av->authorised_value,
  84             lib              => $av->lib,
  85             lib_opac         => $av->lib_opac,
  86             id               => $av->id,
  87             imagesets        => C4::Koha::getImageSets( checked => $av->imageurl ),
  88         );
  89     } else {
  90         $template->param(
  91             category  => $category,
  92             imagesets => C4::Koha::getImageSets(),
  93         );
  94     }
  95     $template->param(
  96         branches_loop    => \@branches_loop,
  97     );
  98
  99 } elsif ($op eq 'add') {
 100     my $new_authorised_value = $input->param('authorised_value');
 101     my $new_category = $input->param('category');
 102     my $imageurl     = $input->param( 'imageurl' ) || '';
 103     $imageurl = '' if $imageurl =~ /removeImage/;
 104     my $duplicate_entry = 0;
 105     my @branches = grep { $_ ne q{} } $input->multi_param('branches');
 106
 107     my $already_exists = Koha::AuthorisedValues->search(
 108         {
 109             category => $new_category,
 110             authorised_value => $new_authorised_value,
 111         }
 112     )->next;
 113
 114     if ( $already_exists and ( not $id or $already_exists->id != $id ) ) {
 115         push @messages, {type => 'error', code => 'already_exists' };
 116     }
 117     elsif ( $new_category eq 'branches' or $new_category eq 'itemtypes' or $new_category eq 'cn_source' ) {
 118         push @messages, {type => 'error', code => 'invalid_category_name' };
 119     }
 120     elsif ( $id ) { # Update
 121         my $av = Koha::AuthorisedValues->new->find( $id );
 122
 123         $av->lib( scalar $input->param('lib') || undef );
 124         $av->lib_opac( scalar $input->param('lib_opac') || undef );
 125         $av->category( $new_category );
 126         $av->authorised_value( $new_authorised_value );
 127         $av->imageurl( $imageurl );
 128         eval{
 129             $av->store;
 130             $av->replace_library_limits( \@branches );
 131         };
 132         if ( $@ ) {
 133             push @messages, {type => 'error', code => 'error_on_update' };
 134         } else {
 135             push @messages, { type => 'message', code => 'success_on_update' };
 136         }
 137     }
 138     else { # Insert
 139         my $av = Koha::AuthorisedValue->new( {
 140             category => $new_category,
 141             authorised_value => $new_authorised_value,
 142             lib => scalar $input->param('lib') || undef,
 143             lib_opac => scalar $input->param('lib_opac') || undef,
 144             imageurl => $imageurl,
 145         } );
 146
 147         eval {
 148             $av->store;
 149             $av->replace_library_limits( \@branches );
 150         };
 151
 152         if ( $@ ) {
 153             push @messages, {type => 'error', code => 'error_on_insert' };
 154         } else {
 155             push @messages, { type => 'message', code => 'success_on_insert' };
 156         }
 157     }
 158
 159     $op = 'list';
 160     $searchfield = $new_category;
 161 } elsif ($op eq 'add_category' ) {
 162     my $new_category = $input->param('category');
 163
 164     my $already_exists = Koha::AuthorisedValueCategories->find(
 165         {
 166             category_name => $new_category,
 167         }
 168     );
 169
 170     if ( $already_exists ) {
 171         if ( $new_category eq 'branches' or $new_category eq 'itemtypes' or $new_category eq 'cn_source' ) {
 172             push @messages, {type => 'error', code => 'invalid_category_name' };
 173         } else {
 174             push @messages, {type => 'error', code => 'cat_already_exists' };
 175         }
 176     }
 177     else { # Insert
 178         my $av = Koha::AuthorisedValueCategory->new( {
 179             category_name => $new_category,
 180         } );
 181
 182         eval {
 183             $av->store;
 184         };
 185
 186         if ( $@ ) {
 187             push @messages, {type => 'error', code => 'error_on_insert_cat' };
 188         } else {
 189             push @messages, { type => 'message', code => 'success_on_insert_cat' };
 190             $searchfield = $new_category;
 191         }
 192     }
 193
 194     $op = 'list';
 195 } elsif ($op eq 'delete') {
 196     my $av = Koha::AuthorisedValues->new->find( $id );
 197     my $deleted = eval {$av->delete};
 198     if ( $@ or not $deleted ) {
 199         push @messages, {type => 'error', code => 'error_on_delete' };
 200     } else {
 201         push @messages, { type => 'message', code => 'success_on_delete' };
 202     }
 203
 204     $op = 'list';
 205     $template->param( delete_success => 1 );
 206 }
 207
 208 $template->param(
 209     op => $op,
 210     searchfield => $searchfield,
 211     messages => \@messages,
 212 );
 213
 214 if ( $op eq 'list' ) {
 215     # build categories list
 216     my @categories = Koha::AuthorisedValueCategories->search({ category_name => { -not_in => ['', 'branches', 'itemtypes', 'cn_source']}}, { order_by => ['category_name'] } );
 217     my @category_list;
 218     for my $category ( @categories ) {
 219         push( @category_list, $category->category_name );
 220     }
 221
 222     $searchfield ||= $category_list[0];
 223
 224     my @avs_by_category = Koha::AuthorisedValues->new->search( { category => $searchfield } );
 225     my @loop_data = ();
 226     # builds value list
 227     for my $av ( @avs_by_category ) {
 228         my %row_data;  # get a fresh hash for the row data
 229         $row_data{category}              = $av->category;
 230         $row_data{authorised_value}      = $av->authorised_value;
 231         $row_data{lib}                   = $av->lib;
 232         $row_data{lib_opac}              = $av->lib_opac;
 233         $row_data{imageurl}              = getitemtypeimagelocation( 'intranet', $av->imageurl );
 234         $row_data{branches}              = $av->library_limits ? $av->library_limits->as_list : [];
 235         $row_data{id}                    = $av->id;
 236         push(@loop_data, \%row_data);
 237     }
 238
 239     $template->param(
 240         loop     => \@loop_data,
 241         category => $searchfield,
 242         categories => \@category_list,
 243     );
 244
 245 }
 246 output_html_with_http_headers $input, $cookie, $template->output;