Bug 28704: Library MARCOrgCode field needs maxlength attribute
[koha.git] / acqui / histsearch.pl
1 #!/usr/bin/perl
2
3 # This file is part of Koha.
4 #
5 # Copyright 2004 Biblibre
6 # Parts copyright 2011 Catalyst IT Ltd.
7 #
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
12 #
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
17 #
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
20
21 =head1 NAME
22
23 histsearch.pl
24
25 =head1 DESCRIPTION
26
27 this script offer a interface to search among order.
28
29 =head1 CGI PARAMETERS
30
31 =over 4
32
33 =item title
34 if the script has to filter the results on title.
35
36 =item author
37 if the script has to filter the results on author.
38
39 =item name
40 if the script has to filter the results on supplier.
41
42 =item fromplacedon
43 to filter on started date.
44
45 =item toplacedon
46 to filter on ended date.
47
48 =back
49
50 =cut
51
52 use Modern::Perl;
53 use CGI qw ( -utf8 );
54 use C4::Auth;    # get_template_and_user
55 use C4::Output;
56 use C4::Acquisition;
57 use C4::Debug;
58 use C4::Koha;
59 use Koha::AdditionalFields;
60 use Koha::DateUtils;
61
62 my $input = CGI->new;
63 my $do_search               = $input->param('do_search') || 0;
64
65 my $dbh = C4::Context->dbh;
66 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
67     {
68         template_name   => "acqui/histsearch.tt",
69         query           => $input,
70         type            => "intranet",
71         flagsrequired   => { acquisition => '*' },
72         debug           => 1,
73     }
74 );
75
76 my $filters = {
77     basket                  => scalar $input->param('basket'),
78     title                   => scalar $input->param('title'),
79     author                  => scalar $input->param('author'),
80     isbn                    => scalar $input->param('isbn'),
81     name                    => scalar $input->param('name'),
82     ean                     => scalar $input->param('ean'),
83     basketgroupname         => scalar $input->param('basketgroupname'),
84     budget                  => scalar $input->param('budget'),
85     booksellerinvoicenumber => scalar $input->param('booksellerinvoicenumber'),
86     budget                  => scalar $input->param('budget'),
87     orderstatus             => scalar $input->param('orderstatus'),
88     is_standing             => scalar $input->param('is_standing'),
89     ordernumber             => scalar $input->param('ordernumber'),
90     search_children_too     => scalar $input->param('search_children_too'),
91     created_by              => [ $input->multi_param('created_by') ],
92     managing_library        => scalar $input->param('managing_library'),
93 };
94
95 my $from_placed_on = eval { dt_from_string( scalar $input->param('from') ) } || dt_from_string;
96 my $to_placed_on   = eval { dt_from_string( scalar $input->param('to')   ) } || dt_from_string;
97 unless ( $input->param('from') ) {
98     # Fill the form with year-1
99     $from_placed_on->set_time_zone('floating')->subtract( years => 1 );
100 }
101 $filters->{from_placed_on} = output_pref( { dt => $from_placed_on, dateformat => 'iso', dateonly => 1 } );
102 $filters->{to_placed_on} = output_pref( { dt => $to_placed_on, dateformat => 'iso', dateonly => 1 } );
103 my @additional_fields = Koha::AdditionalFields->search( { tablename => 'aqbasket', searchable => 1 } );
104 $template->param( available_additional_fields => \@additional_fields );
105 my @additional_field_filters;
106 foreach my $additional_field (@additional_fields) {
107     my $value = $input->param('additional_field_' . $additional_field->id);
108     if (defined $value and $value ne '') {
109         push @additional_field_filters, {
110             id => $additional_field->id,
111             value => $value,
112         };
113     }
114 }
115 $filters->{additional_fields} = \@additional_field_filters;
116
117
118 my $order_loop;
119 # If we're supplied any value then we do a search. Otherwise we don't.
120 if ($do_search) {
121     $order_loop = GetHistory(%$filters);
122 }
123
124 my $budgetperiods = C4::Budgets::GetBudgetPeriods;
125 my $bp_loop = $budgetperiods;
126 for my $bp ( @{$budgetperiods} ) {
127     my $hierarchy = C4::Budgets::GetBudgetHierarchy( $$bp{budget_period_id} );
128     for my $budget ( @{$hierarchy} ) {
129         $$budget{budget_display_name} = sprintf("%s", ">" x $$budget{depth} . $$budget{budget_name});
130     }
131     $$bp{hierarchy} = $hierarchy;
132 }
133
134 $template->param(
135     order_loop  => $order_loop,
136     filters     => $filters,
137     bp_loop     => $bp_loop,
138     search_done => $do_search,
139 );
140
141 output_html_with_http_headers $input, $cookie, $template->output;