3 # Copyright 2007 Liblime ltd
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along
17 # with Koha; if not, write to the Free Software Foundation, Inc.,
18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19 use CGI
::Carp
qw(fatalsToBrowser warningsToBrowser);
25 use C4
::Reports
::Guided
;
30 Script to control the guided report creation
37 my $referer = $input->referer();
39 my $phase = $input->param('phase') || 'View Dictionary';
40 my $definition_name = $input->param('definition_name');
41 my $definition_description = $input->param('definition_description');
42 my $area = $input->param('area') || '';
43 my $no_html = 0; # this will be set if we dont want to print out an html::template
44 my ( $template, $borrowernumber, $cookie ) = get_template_and_user
(
45 { template_name
=> "reports/dictionary.tmpl",
49 flagsrequired
=> { reports
=> '*' },
54 if ($phase eq 'View Dictionary'){
55 # view the dictionary we use to set up abstract variables such as all borrowers over fifty who live in a certain town
56 my $definitions = get_from_dictionary
($area);
59 'start_dictionary' => 1,
60 'definitions' => $definitions,
62 } elsif ( $phase eq 'Add New Definition' ) {
64 # display form allowing them to add a new definition
65 $template->param( 'new_dictionary' => 1, );
68 elsif ( $phase eq 'New Term step 2' ) {
74 'definition_name' => $definition_name,
75 'definition_description' => $definition_description,
79 elsif ( $phase eq 'New Term step 3' ) {
81 # Choosing the columns
82 my $columns = get_columns
( $area, $input );
86 'columns' => $columns,
87 'definition_name' => $definition_name,
88 'definition_description' => $definition_description,
92 elsif ( $phase eq 'New Term step 4' ) {
95 my @columns = $input->param('columns');
96 my $columnstring = join( ',', @columns );
98 foreach my $column (@columns) {
100 $tmp_hash{'name'} = $column;
101 my $type = get_column_type
($column);
102 if ( $type eq 'distinct' ) {
103 my $values = get_distinct_values
($column);
104 $tmp_hash{'values'} = $values;
105 $tmp_hash{'distinct'} = 1;
108 if ( $type eq 'DATE' || $type eq 'DATETIME' ) {
109 $tmp_hash{'date'} = 1;
111 if ($type eq 'TEXT' || $type eq 'MEDIUMTEXT'){
112 $tmp_hash{'text'} = 1;
118 push @column_loop, \
%tmp_hash;
121 $template->param( 'step_4' => 1,
123 'definition_name' => $definition_name,
124 'definition_description' => $definition_description,
125 'columns' => \
@column_loop,
126 'columnstring' => $columnstring,
127 'DHTMLcalendar_dateformat' => C4
::Dates
->DHTMLcalendar(),
131 elsif ( $phase eq 'New Term step 5' ) {
132 # Confirmation screen
133 my $columnstring = $input->param('columnstring');
134 my @criteria = $input->param('criteria_column');
138 foreach my $crit (@criteria) {
139 my $value = $input->param( $crit . "_value" );
142 $tmp_hash{'name'} = $crit;
143 $tmp_hash{'value'} = $value;
144 push @criteria_loop, \
%tmp_hash;
145 if ( $value =~ C4
::Dates
->regexp( C4
::Context
->preference('dateformat') ) ) {
146 my $date = C4
::Dates
->new($value);
147 $value = $date->output("iso");
149 $query_criteria .= " AND $crit='$value'";
151 $value = $input->param( $crit . "_start_value" );
154 $tmp_hash{'name'} = "$crit Start";
155 $tmp_hash{'value'} = $value;
156 push @criteria_loop, \
%tmp_hash;
157 if ( $value =~ C4
::Dates
->regexp( C4
::Context
->preference('dateformat') ) ) {
158 my $date = C4
::Dates
->new($value);
159 $value = $date->output("iso");
161 $query_criteria .= " AND $crit >= '$value'";
163 $value = $input->param( $crit . "_end_value" );
166 $tmp_hash{'name'} = "$crit End";
167 $tmp_hash{'value'} = $value;
168 push @criteria_loop, \
%tmp_hash;
169 if ( $value =~ C4
::Dates
->regexp( C4
::Context
->preference('dateformat') ) ) {
170 my $date = C4
::Dates
->new($value);
171 $value = $date->output("iso");
173 $query_criteria .= " AND $crit <= '$value'";
176 my %report_areas = map @
$_, get_report_areas
();
180 'areaname' => $report_areas{$area},
181 'definition_name' => $definition_name,
182 'definition_description' => $definition_description,
183 'query' => $query_criteria,
184 'columnstring' => $columnstring,
185 'criteria_loop' => \
@criteria_loop,
189 elsif ( $phase eq 'New Term step 6' ) {
191 my $area = $input->param('area');
192 my $sql = $input->param('sql');
193 save_dictionary
( $definition_name, $definition_description, $sql, $area );
195 print $input->redirect("/cgi-bin/koha/reports/dictionary.pl?phase=View%20Dictionary");
197 } elsif ( $phase eq 'Delete Definition' ) {
199 my $id = $input->param('id');
200 delete_definition
($id);
201 print $input->redirect("/cgi-bin/koha/reports/dictionary.pl?phase=View%20Dictionary");
204 $template->param( 'referer' => $referer );
208 output_html_with_http_headers
$input, $cookie, $template->output;
212 my $areas = get_report_areas
();
218 selected
=> ($_->[0] eq $area),