bull/statecollection.pl

   1 #!/usr/bin/perl
   2
   3 use strict;
   4 use CGI;
   5 use C4::Auth;
   6 use C4::Date;
   7 use C4::Output;
   8 use C4::Interface::CGI::Output;
   9 use C4::Context;
  10 use C4::Bull;
  11 use HTML::Template;
  12
  13 my $query = new CGI;
  14 my $op = $query->param('op');
  15 my $dbh = C4::Context->dbh;
  16 my $subscriptionid = $query->param('subscriptionid');
  17 my $auser = $query->param('user');
  18 my $histstartdate = format_date_in_iso($query->param('histstartdate'));
  19 my $enddate = format_date_in_iso($query->param('enddate'));
  20 my $recievedlist = $query->param('recievedlist');
  21 my $missinglist = $query->param('missinglist');
  22 my $opacnote = $query->param('opacnote');
  23 my $librariannote = $query->param('librariannote');
  24 my @serialids = $query->param('serialid');
  25 my @serialseqs = $query->param('serialseq');
  26 my @planneddates = $query->param('planneddate');
  27 my @notes = $query->param('notes');
  28 my @status = $query->param('status');
  29
  30 my ($template, $loggedinuser, $cookie)
  31 = get_template_and_user({template_name => "bull/statecollection.tmpl",
  32                                 query => $query,
  33                                 type => "intranet",
  34                                 authnotrequired => 0,
  35                                 flagsrequired => {catalogue => 1},
  36                                 debug => 1,
  37                                 });
  38
  39 my $hassubscriptionexpired = hassubscriptionexpired($subscriptionid);
  40 my $subscription=getsubscription($subscriptionid);
  41 if ($op eq 'modsubscriptionhistory') {
  42         modsubscriptionhistory($subscriptionid,$histstartdate,$enddate,$recievedlist,$missinglist,$opacnote,$librariannote);
  43 }
  44 # change status except, if subscription has expired, for the "waited" issue.
  45 if ($op eq 'serialchangestatus') {
  46         my $sth = $dbh->prepare("select status from serial where serialid=?");
  47         for (my $i=0;$i<=$#serialids;$i++) {
  48                 $sth->execute($serialids[$i]);
  49                 my ($oldstatus) = $sth->fetchrow;
  50                 if ($serialids[$i]) {
  51                         serialchangestatus($serialids[$i],$serialseqs[$i],format_date_in_iso($planneddates[$i]),$status[$i],$notes[$i]) unless ($hassubscriptionexpired && $oldstatus == 1);
  52                 } else {
  53                         # add a special issue
  54                         if ($serialseqs[$i]) {
  55                                 my $subscription=getsubscription($subscriptionid);
  56                                 newissue($serialseqs[$i],$subscriptionid,$subscription->{biblionumber},$status[$i], format_date_in_iso($planneddates[$i]));
  57                         }
  58                 }
  59         }
  60 }
  61 my $subs = &getsubscription($subscriptionid);
  62 my ($totalissues,@serialslist) = getserials($subscriptionid,10);
  63
  64 my $sth=$dbh->prepare("select * from subscriptionhistory where subscriptionid = ?");
  65 $sth->execute($subscriptionid);
  66 my $solhistory = $sth->fetchrow_hashref;
  67
  68         $template->param(
  69                         serialslist => \@serialslist,
  70                         biblionumber => $subscription->{biblionumber},
  71                         histstartdate => format_date($solhistory->{'histstartdate'}),
  72                         enddate => format_date($solhistory->{'enddate'}),
  73                         recievedlist => $solhistory->{'recievedlist'},
  74                         missinglist => $solhistory->{'missinglist'},
  75                         opacnote => $solhistory->{'opacnote'},
  76                         librariannote => $solhistory->{'librariannote'},
  77                         subscriptionid => $subscriptionid,
  78                         bibliotitle => $subs->{bibliotitle},
  79                         biblionumber => $subs->{biblionumber},
  80                         hassubscriptionexpired =>$hassubscriptionexpired,
  81                 );
  82 output_html_with_http_headers $query, $cookie, $template->output;