Bug 13436: DBRev 3.19.00.001
[koha.git] / tools / koha-news.pl
blob1859deb6656c6b5ad8c1fac5e01431e5aa9b0c0a
1 #!/usr/bin/perl
3 # This file is part of Koha.
5 # Script to manage the opac news.
6 # written 11/04
7 # Casta�eda, Carlos Sebastian - seba3c@yahoo.com.ar - Physics Library UNLP Argentina
8 # Modified to include news to KOHA intranet - tgarip@neu.edu.tr NEU library -Cyprus
9 # Copyright 2000-2002 Katipo Communications
10 # Copyright (C) 2013 Mark Tompsett
12 # Koha is free software; you can redistribute it and/or modify it
13 # under the terms of the GNU General Public License as published by
14 # the Free Software Foundation; either version 3 of the License, or
15 # (at your option) any later version.
17 # Koha is distributed in the hope that it will be useful, but
18 # WITHOUT ANY WARRANTY; without even the implied warranty of
19 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
20 # GNU General Public License for more details.
22 # You should have received a copy of the GNU General Public License
23 # along with Koha; if not, see <http://www.gnu.org/licenses>.
25 use strict;
26 # use warnings; FIXME - Bug 2505
27 use CGI;
28 use C4::Auth;
29 use C4::Koha;
30 use C4::Context;
31 use C4::Dates qw(format_date_in_iso);
32 use C4::Output;
33 use C4::NewsChannels;
34 use C4::Languages qw(getTranslatedLanguages);
35 use Date::Calc qw/Date_to_Days Today/;
36 use C4::Branch qw/GetBranches/;
38 my $cgi = new CGI;
40 my $id = $cgi->param('id');
41 my $title = $cgi->param('title');
42 my $new = $cgi->param('new');
43 my $expirationdate = format_date_in_iso($cgi->param('expirationdate'));
44 my $timestamp = format_date_in_iso($cgi->param('timestamp'));
45 my $number = $cgi->param('number');
46 my $lang = $cgi->param('lang');
47 my $branchcode = $cgi->param('branch');
48 my $error_message = $cgi->param('error_message');
50 # Foreign Key constraints work with NULL, not ''
51 # NULL = All branches.
52 $branchcode = undef if (defined($branchcode) && $branchcode eq '');
54 my $new_detail = get_opac_new($id);
56 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
58 template_name => "tools/koha-news.tt",
59 query => $cgi,
60 type => "intranet",
61 authnotrequired => 0,
62 flagsrequired => { tools => 'edit_news' },
63 debug => 1,
67 # Pass error message if there is one.
68 $template->param( error_message => $error_message ) if $error_message;
70 # get lang list
71 my @lang_list;
72 my $tlangs = getTranslatedLanguages() ;
74 foreach my $language ( @$tlangs ) {
75 foreach my $sublanguage ( @{$language->{'sublanguages_loop'}} ) {
76 push @lang_list,
78 language => $sublanguage->{'rfc4646_subtag'},
79 selected => ( $new_detail->{lang} eq $sublanguage->{'rfc4646_subtag'} ? 1 : 0 ),
84 my $branches = GetBranches;
86 $template->param( lang_list => \@lang_list,
87 branch_list => $branches,
88 branchcode => $branchcode );
90 my $op = $cgi->param('op') // '';
92 if ( $op eq 'add_form' ) {
93 $template->param( add_form => 1 );
94 if ($id) {
95 if($new_detail->{lang} eq "slip"){ $template->param( slip => 1); }
96 $template->param(
97 op => 'edit',
98 id => $new_detail->{'idnew'}
100 $template->{VARS}->{'new_detail'} = $new_detail;
102 else {
103 $template->param( op => 'add' );
106 elsif ( $op eq 'add' ) {
107 if ($title) {
108 add_opac_new(
110 title => $title,
111 new => $new,
112 lang => $lang,
113 expirationdate => $expirationdate,
114 timestamp => $timestamp,
115 number => $number,
116 branchcode => $branchcode,
119 print $cgi->redirect("/cgi-bin/koha/tools/koha-news.pl");
121 else {
122 print $cgi->redirect("/cgi-bin/koha/tools/koha-news.pl?error_message=title_missing");
125 elsif ( $op eq 'edit' ) {
126 upd_opac_new(
128 idnew => $id,
129 title => $title,
130 new => $new,
131 lang => $lang,
132 expirationdate => $expirationdate,
133 timestamp => $timestamp,
134 number => $number,
135 branchcode => $branchcode,
138 print $cgi->redirect("/cgi-bin/koha/tools/koha-news.pl");
140 elsif ( $op eq 'del' ) {
141 my @ids = $cgi->param('ids');
142 del_opac_new( join ",", @ids );
143 print $cgi->redirect("/cgi-bin/koha/tools/koha-news.pl");
146 else {
148 my ( $opac_news_count, $opac_news ) = &get_opac_news( undef, $lang, $branchcode );
150 foreach my $new ( @$opac_news ) {
151 next unless $new->{'expirationdate'};
152 #$new->{'expirationdate'}=format_date_in_iso($new->{'expirationdate'});
153 my @date = split (/-/,$new->{'expirationdate'});
154 if ($date[0]*$date[1]*$date[2]>0 && Date_to_Days( @date ) < Date_to_Days(&Today) ){
155 $new->{'expired'} = 1;
159 $template->param(
160 opac_news => $opac_news,
161 opac_news_count => $opac_news_count,
164 $template->param( lang => $lang );
165 output_html_with_http_headers $cgi, $cookie, $template->output;