Bug 19422: Missing DROP TABLES in kohastructure.sql
[koha.git] / tools / koha-news.pl
blob61c3ec606fcfa8037278f8228cda09521cef32a3
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 qw ( -utf8 );
28 use C4::Auth;
29 use C4::Koha;
30 use C4::Context;
31 use C4::Output;
32 use C4::NewsChannels;
33 use C4::Languages qw(getTranslatedLanguages);
34 use Date::Calc qw/Date_to_Days Today/;
35 use Koha::DateUtils;
37 my $cgi = new CGI;
39 my $id = $cgi->param('id');
40 my $title = $cgi->param('title');
41 my $content = $cgi->param('content');
42 my $expirationdate;
43 if ( $cgi->param('expirationdate') ) {
44 $expirationdate = output_pref({ dt => dt_from_string( scalar $cgi->param('expirationdate') ), dateformat => 'iso', dateonly => 1 });
46 my $timestamp = output_pref({ dt => dt_from_string( scalar $cgi->param('timestamp') ), dateformat => 'iso', dateonly => 1 });
47 my $number = $cgi->param('number');
48 my $lang = $cgi->param('lang');
49 my $branchcode = $cgi->param('branch');
50 my $error_message = $cgi->param('error_message');
52 # Foreign Key constraints work with NULL, not ''
53 # NULL = All branches.
54 $branchcode = undef if (defined($branchcode) && $branchcode eq '');
56 my $new_detail = get_opac_new($id);
58 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
60 template_name => "tools/koha-news.tt",
61 query => $cgi,
62 type => "intranet",
63 authnotrequired => 0,
64 flagsrequired => { tools => 'edit_news' },
65 debug => 1,
69 # Pass error message if there is one.
70 $template->param( error_message => $error_message ) if $error_message;
72 # get lang list
73 my @lang_list;
74 my $tlangs = getTranslatedLanguages() ;
76 foreach my $language ( @$tlangs ) {
77 foreach my $sublanguage ( @{$language->{'sublanguages_loop'}} ) {
78 push @lang_list,
80 language => $sublanguage->{'rfc4646_subtag'},
81 selected => ( $new_detail->{lang} eq $sublanguage->{'rfc4646_subtag'} ? 1 : 0 ),
86 $template->param( lang_list => \@lang_list,
87 branchcode => $branchcode );
89 my $op = $cgi->param('op') // '';
91 if ( $op eq 'add_form' ) {
92 $template->param( add_form => 1 );
93 if ($id) {
94 if($new_detail->{lang} eq "slip"){ $template->param( slip => 1); }
95 $template->param(
96 op => 'edit',
97 id => $new_detail->{'idnew'}
99 $template->{VARS}->{'new_detail'} = $new_detail;
101 else {
102 $template->param( op => 'add' );
105 elsif ( $op eq 'add' ) {
106 if ($title) {
107 add_opac_new(
109 title => $title,
110 content => $content,
111 lang => $lang,
112 expirationdate => $expirationdate,
113 timestamp => $timestamp,
114 number => $number,
115 branchcode => $branchcode,
116 borrowernumber => $borrowernumber,
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 content => $content,
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->multi_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 my @date = split (/-/,$new->{'expirationdate'});
153 if ($date[0]*$date[1]*$date[2]>0 && Date_to_Days( @date ) < Date_to_Days(&Today) ){
154 $new->{'expired'} = 1;
158 $template->param(
159 opac_news => $opac_news,
160 opac_news_count => $opac_news_count,
163 $template->param( lang => $lang );
164 output_html_with_http_headers $cgi, $cookie, $template->output;