Bug 9455: Remove unnecessary quoting from sql
[koha.git] / reports / itemslost.pl
blob9ecd5997ff4af79e09ac0fe954cf4f327582f298
1 #!/usr/bin/perl
3 # Copyright Liblime 2007
4 # Copyright Biblibre 2009
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it under the
9 # terms of the GNU General Public License as published by the Free Software
10 # Foundation; either version 2 of the License, or (at your option) any later
11 # version.
13 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
14 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
15 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License along
18 # with Koha; if not, write to the Free Software Foundation, Inc.,
19 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
22 =head1 itemslost
24 This script displays lost items.
26 =cut
28 use strict;
29 use warnings;
31 use CGI;
32 use C4::Auth;
33 use C4::Output;
34 use C4::Biblio;
35 use C4::Items;
36 use C4::Koha; # GetItemTypes
37 use C4::Branch; # GetBranches
38 use C4::Dates qw/format_date/;
40 my $query = new CGI;
41 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
43 template_name => "reports/itemslost.tmpl",
44 query => $query,
45 type => "intranet",
46 authnotrequired => 0,
47 flagsrequired => { reports => '*' },
48 debug => 1,
52 my $params = $query->Vars;
53 my $get_items = $params->{'get_items'};
55 if ( $get_items ) {
56 my $orderbyfilter = $params->{'orderbyfilter'} || undef;
57 my $branchfilter = $params->{'branchfilter'} || undef;
58 my $barcodefilter = $params->{'barcodefilter'} || undef;
59 my $itemtypesfilter = $params->{'itemtypesfilter'} || undef;
60 my $loststatusfilter = $params->{'loststatusfilter'} || undef;
62 my %where;
63 $where{'homebranch'} = $branchfilter if defined $branchfilter;
64 $where{'barcode'} = $barcodefilter if defined $barcodefilter;
65 $where{'authorised_value'} = $loststatusfilter if defined $loststatusfilter;
67 my $itype = C4::Context->preference('item-level_itypes') ? "itype" : "itemtype";
68 $where{$itype} = $itemtypesfilter if defined $itemtypesfilter;
70 my $items = GetLostItems( \%where, $orderbyfilter );
71 foreach my $it (@$items) {
72 $it->{'datelastseen'} = format_date($it->{'datelastseen'});
74 $template->param(
75 total => scalar @$items,
76 itemsloop => $items,
77 get_items => $get_items,
78 itype_level => C4::Context->preference('item-level_itypes'),
82 # getting all branches.
83 #my $branches = GetBranches;
84 #my $branch = C4::Context->userenv->{"branchname"};
86 # getting all itemtypes
87 my $itemtypes = &GetItemTypes();
88 my @itemtypesloop;
89 foreach my $thisitemtype ( sort {$itemtypes->{$a}->{description} cmp $itemtypes->{$b}->{description}} keys %$itemtypes ) {
90 my %row = (
91 value => $thisitemtype,
92 description => $itemtypes->{$thisitemtype}->{'description'},
94 push @itemtypesloop, \%row;
97 # get lost statuses
98 my $lost_status_loop = C4::Koha::GetAuthorisedValues( 'LOST' );
100 $template->param( branchloop => GetBranchesLoop(C4::Context->userenv->{'branch'}),
101 itemtypeloop => \@itemtypesloop,
102 loststatusloop => $lost_status_loop,
105 # writing the template
106 output_html_with_http_headers $query, $cookie, $template->output;