Bug 8176 [SIGNED-OFF] Assign an intial value to $sqlwhere
[koha.git] / about.pl
blob7189a229c14b88bbdcc95cef969709a6686b4f76
1 #!/usr/bin/perl
3 # Copyright Pat Eyler 2003
4 # Copyright Biblibre 2006
5 # Parts Copyright Liblime 2008
6 # Parts Copyright Chris Nighswonger 2010
8 # This file is part of Koha.
10 # Koha is free software; you can redistribute it and/or modify it under the
11 # terms of the GNU General Public License as published by the Free Software
12 # Foundation; either version 2 of the License, or (at your option) any later
13 # version.
15 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
16 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
17 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
19 # You should have received a copy of the GNU General Public License along
20 # with Koha; if not, write to the Free Software Foundation, Inc.,
21 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
23 use strict;
24 use warnings;
26 use CGI;
27 use LWP::Simple;
28 use XML::Simple;
29 use Config;
31 use C4::Output;
32 use C4::Auth;
33 use C4::Context;
34 use C4::Installer;
36 #use Smart::Comments '####';
38 my $query = new CGI;
39 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
41 template_name => "about.tmpl",
42 query => $query,
43 type => "intranet",
44 authnotrequired => 0,
45 flagsrequired => { catalogue => 1 },
46 debug => 1,
50 my $kohaVersion = C4::Context::KOHAVERSION;
51 my $osVersion = `uname -a`;
52 my $perl_path = $^X;
53 if ($^O ne 'VMS') {
54 $perl_path .= $Config{_exe} unless $perl_path =~ m/$Config{_exe}$/i;
56 my $perlVersion = $];
57 my $mysqlVersion = `mysql -V`;
58 my $apacheVersion = `httpd -v`;
59 $apacheVersion = `httpd2 -v` unless $apacheVersion;
60 $apacheVersion = (`/usr/sbin/apache2 -V`)[0] unless $apacheVersion;
61 my $zebraVersion = `zebraidx -V`;
63 $template->param(
64 kohaVersion => $kohaVersion,
65 osVersion => $osVersion,
66 perlPath => $perl_path,
67 perlVersion => $perlVersion,
68 perlIncPath => [ map { perlinc => $_ }, @INC ],
69 mysqlVersion => $mysqlVersion,
70 apacheVersion => $apacheVersion,
71 zebraVersion => $zebraVersion,
74 my @components = ();
76 my $perl_modules = C4::Installer::PerlModules->new;
77 $perl_modules->version_info;
79 my @pm_types = qw(missing_pm upgrade_pm current_pm);
81 foreach my $pm_type(@pm_types) {
82 my $modules = $perl_modules->get_attr($pm_type);
83 foreach (@$modules) {
84 my ($module, $stats) = each %$_;
85 push(
86 @components,
88 name => $module,
89 version => $stats->{'cur_ver'},
90 missing => ($pm_type eq 'missing_pm' ? 1 : 0),
91 upgrade => ($pm_type eq 'upgrade_pm' ? 1 : 0),
92 current => ($pm_type eq 'current_pm' ? 1 : 0),
93 require => $stats->{'required'},
99 @components = sort {$a->{'name'} cmp $b->{'name'}} @components;
101 my $counter=0;
102 my $row = [];
103 my $table = [];
104 foreach (@components) {
105 push (@$row, $_);
106 unless (++$counter % 4) {
107 push (@$table, {row => $row});
108 $row = [];
111 ## ## $table
113 $template->param( table => $table );
116 ## ------------------------------------------
117 ## Koha time line code
119 #get file location
120 my $dir = C4::Context->config('intranetdir');
121 open( my $file, "<", "$dir" . "/docs/history.txt" );
122 my $i = 0;
124 my @rows2 = ();
125 my $row2 = [];
127 my @lines = <$file>;
128 close($file);
130 shift @lines; #remove header row
132 foreach (@lines) {
133 my ( $date, $desc, $tag ) = split(/\t/);
134 push(
135 @rows2,
137 date => $date,
138 desc => $desc,
143 my $table2 = [];
144 #foreach my $row2 (@rows2) {
145 foreach (@rows2) {
146 push (@$row2, $_);
147 push( @$table2, { row2 => $row2 } );
148 $row2 = [];
151 $template->param( table2 => $table2 );
153 output_html_with_http_headers $query, $cookie, $template->output;