tools/koha-news.pl

   1 #!/usr/bin/perl
   2
   3 # This file is part of Koha.
   4 #
   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
  11 #
  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.
  16 #
  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.
  21 #
  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>.
  24
  25 use Modern::Perl;
  26 use CGI qw ( -utf8 );
  27 use C4::Auth;
  28 use C4::Koha;
  29 use C4::Context;
  30 use C4::Output;
  31 use C4::NewsChannels;
  32 use C4::Languages qw(getTranslatedLanguages);
  33 use Date::Calc qw/Date_to_Days Today/;
  34 use Koha::DateUtils;
  35
  36 my $cgi = new CGI;
  37
  38 my $id             = $cgi->param('id');
  39 my $title          = $cgi->param('title');
  40 my $content        = $cgi->param('content');
  41 my $expirationdate;
  42 if ( $cgi->param('expirationdate') ) {
  43     $expirationdate = output_pref({ dt => dt_from_string( scalar $cgi->param('expirationdate') ), dateformat => 'iso', dateonly => 1 });
  44 }
  45 my $published_on= output_pref({ dt => dt_from_string( scalar $cgi->param('published_on') ), dateformat => 'iso', dateonly => 1 });
  46 my $number         = $cgi->param('number');
  47 my $lang           = $cgi->param('lang');
  48 my $branchcode     = $cgi->param('branch');
  49 my $error_message  = $cgi->param('error_message');
  50 my $wysiwyg;
  51 if( $cgi->param('editmode') ){
  52     $wysiwyg = $cgi->param('editmode') eq "wysiwyg" ? 1 : 0;
  53 } else {
  54     $wysiwyg = C4::Context->preference("NewsToolEditor") eq "tinymce" ? 1 : 0;
  55 }
  56
  57 # Foreign Key constraints work with NULL, not ''
  58 # NULL = All branches.
  59 $branchcode = undef if (defined($branchcode) && $branchcode eq '');
  60
  61 my $new_detail = get_opac_new($id);
  62
  63 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
  64     {
  65         template_name   => "tools/koha-news.tt",
  66         query           => $cgi,
  67         type            => "intranet",
  68         flagsrequired   => { tools => 'edit_news' },
  69         debug           => 1,
  70     }
  71 );
  72
  73 # Pass error message if there is one.
  74 $template->param( error_message => $error_message ) if $error_message;
  75
  76 # get lang list
  77 my @lang_list;
  78 my $tlangs = getTranslatedLanguages() ;
  79
  80 foreach my $language ( @$tlangs ) {
  81     foreach my $sublanguage ( @{$language->{'sublanguages_loop'}} ) {
  82         push @lang_list,
  83         {
  84             language => $sublanguage->{'rfc4646_subtag'},
  85             selected => ( $new_detail->{lang} eq $sublanguage->{'rfc4646_subtag'} ? 1 : 0 ),
  86         };
  87     }
  88 }
  89
  90 $template->param( lang_list   => \@lang_list,
  91                   branchcode  => $branchcode );
  92
  93 my $op = $cgi->param('op') // '';
  94
  95 if ( $op eq 'add_form' ) {
  96     $template->param( add_form => 1 );
  97     if ($id) {
  98         if($new_detail->{lang} eq "slip"){ $template->param( slip => 1); }
  99         $template->param(
 100             op => 'edit',
 101             id => $new_detail->{'idnew'}
 102         );
 103         $template->{VARS}->{'new_detail'} = $new_detail;
 104     }
 105     else {
 106         $template->param( op => 'add' );
 107     }
 108 }
 109 elsif ( $op eq 'add' ) {
 110     if ($title) {
 111         add_opac_new(
 112             {
 113                 title          => $title,
 114                 content        => $content,
 115                 lang           => $lang,
 116                 expirationdate => $expirationdate,
 117                 published_on=> $published_on,
 118                 number         => $number,
 119                 branchcode     => $branchcode,
 120                 borrowernumber => $borrowernumber,
 121             }
 122         );
 123         print $cgi->redirect("/cgi-bin/koha/tools/koha-news.pl");
 124     }
 125     else {
 126         print $cgi->redirect("/cgi-bin/koha/tools/koha-news.pl?error_message=title_missing");
 127     }
 128 }
 129 elsif ( $op eq 'edit' ) {
 130     upd_opac_new(
 131         {
 132             idnew          => $id,
 133             title          => $title,
 134             content        => $content,
 135             lang           => $lang,
 136             expirationdate => $expirationdate,
 137             published_on=> $published_on,
 138             number         => $number,
 139             branchcode     => $branchcode,
 140         }
 141     );
 142     print $cgi->redirect("/cgi-bin/koha/tools/koha-news.pl");
 143 }
 144 elsif ( $op eq 'del' ) {
 145     my @ids = $cgi->multi_param('ids');
 146     del_opac_new( join ",", @ids );
 147     print $cgi->redirect("/cgi-bin/koha/tools/koha-news.pl");
 148 }
 149
 150 else {
 151
 152     my ( $opac_news_count, $opac_news ) = &get_opac_news( undef, undef, undef );
 153
 154     foreach my $new ( @$opac_news ) {
 155         next unless $new->{'expirationdate'};
 156         my @date = split (/-/,$new->{'expirationdate'});
 157         if ($date[0]*$date[1]*$date[2]>0 && Date_to_Days( @date ) < Date_to_Days(&Today) ){
 158                         $new->{'expired'} = 1;
 159         }
 160     }
 161
 162     $template->param(
 163         opac_news       => $opac_news,
 164         opac_news_count => $opac_news_count,
 165                 );
 166 }
 167 $template->param(
 168     lang => $lang,
 169     wysiwyg => $wysiwyg,
 170 );
 171 output_html_with_http_headers $cgi, $cookie, $template->output;