my $searchfield = $input->param('description');
my $script_name = "/cgi-bin/koha/admin/itemtypes.pl";
my $itemtype = $input->param('itemtype');
-my $pagesize = 10;
my $op = $input->param('op');
$searchfield =~ s/\,//g;
my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
query => $input,
type => "intranet",
authnotrequired => 0,
- flagsrequired => { parameters => 1 },
+ flagsrequired => { parameters => 'parameters_remaining_permissions' },
debug => 1,
}
);
imageurl => $data->{'imageurl'},
template => C4::Context->preference('template'),
summary => $data->{summary},
+ checkinmsg => $data->{'checkinmsg'},
+ checkinmsgtype => $data->{'checkinmsgtype'},
imagesets => $imagesets,
remote_image => $remote_image,
);
, notforloan = ?
, imageurl = ?
, summary = ?
+ , checkinmsg = ?
+ , checkinmsgtype = ?
WHERE itemtype = ?
';
$sth = $dbh->prepare($query2);
)
),
$input->param('summary'),
+ $input->param('checkinmsg'),
+ $input->param('checkinmsgtype'),
$input->param('itemtype')
);
}
else { # add a new itemtype & not modif an old
my $query = "
INSERT INTO itemtypes
- (itemtype,description,rentalcharge, notforloan, imageurl,summary)
+ (itemtype,description,rentalcharge, notforloan, imageurl, summary, checkinmsg, checkinmsgtype)
VALUES
- (?,?,?,?,?,?);
+ (?,?,?,?,?,?,?,?);
";
my $sth = $dbh->prepare($query);
my $image = $input->param('image');
$image eq 'remoteImage' ? $input->param('remoteImage') :
$image,
$input->param('summary'),
+ $input->param('checkinmsg'),
+ $input->param('checkinmsgtype'),
);
}
# called by default form, used to confirm deletion of data in DB
}
elsif ( $op eq 'delete_confirm' ) {
- # Check both categoryitem and biblioitems, see Bug 199
- my $total = 0;
- for my $table ('biblioitems') {
- my $sth =
- $dbh->prepare(
- "select count(*) as total from $table where itemtype=?");
- $sth->execute($itemtype);
- $total += $sth->fetchrow_hashref->{total};
- }
+ # Check both items and biblioitems
+ my $sth = $dbh->prepare('
+ SELECT COUNT(*) AS total FROM (
+ SELECT itemtype AS t FROM biblioitems
+ UNION
+ SELECT itype AS t FROM items
+ ) AS tmp
+ WHERE tmp.t=?
+ ');
+ $sth->execute($itemtype);
+ my $total = $sth->fetchrow_hashref->{'total'};
my $sth =
$dbh->prepare(
}
else { # DEFAULT
my ($results) = StringSearch( $searchfield, 'web' );
- my $page = $input->param('page') || 1;
- my $first = ( $page - 1 ) * $pagesize;
-
- # if we are on the last page, the number of the last word to display
- # must not exceed the length of the results array
- my $last = min( $first + $pagesize - 1, scalar @{$results} - 1, );
my @loop;
- foreach my $itemtype ( @{$results}[ $first .. $last ] ) {
+ foreach my $itemtype ( @{$results} ) {
$itemtype->{imageurl} = getitemtypeimagelocation( 'intranet', $itemtype->{imageurl} );
$itemtype->{rentalcharge} = sprintf( '%.2f', $itemtype->{rentalcharge} );
push( @loop, $itemtype );
$template->param(
loop => \@loop,
- pagination_bar => pagination_bar(
- $script_name, getnbpages( scalar @{$results}, $pagesize ),
- $page, 'page'
- )
);
} #---- END $OP eq DEFAULT