View | Details | Raw Unified | Return to bug 10215
Collapse All | Expand All

(-)a/C4/Serials.pm (+6 lines)
Lines 483-488 sub GetSubscriptionsFromBiblionumber { Link Here
483
        $subs->{startdate}     = format_date( $subs->{startdate} );
483
        $subs->{startdate}     = format_date( $subs->{startdate} );
484
        $subs->{histstartdate} = format_date( $subs->{histstartdate} );
484
        $subs->{histstartdate} = format_date( $subs->{histstartdate} );
485
        $subs->{histenddate}   = format_date( $subs->{histenddate} );
485
        $subs->{histenddate}   = format_date( $subs->{histenddate} );
486
        $subs->{opacnote} ||= q{};
486
        $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
487
        $subs->{opacnote}     =~ s/\n/\<br\/\>/g;
487
        $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
488
        $subs->{missinglist}  =~ s/\n/\<br\/\>/g;
488
        $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
489
        $subs->{recievedlist} =~ s/\n/\<br\/\>/g;
Lines 1081-1086 returns the number of rows affected Link Here
1081
1082
1082
sub ModSubscriptionHistory {
1083
sub ModSubscriptionHistory {
1083
    my ( $subscriptionid, $histstartdate, $enddate, $recievedlist, $missinglist, $opacnote, $librariannote ) = @_;
1084
    my ( $subscriptionid, $histstartdate, $enddate, $recievedlist, $missinglist, $opacnote, $librariannote ) = @_;
1085
1086
    $recievedlist ||= q{};
1087
    $missinglist  ||= q{};
1088
    $opacnote     ||= q{};
1089
1084
    my $dbh   = C4::Context->dbh;
1090
    my $dbh   = C4::Context->dbh;
1085
    my $query = "UPDATE subscriptionhistory 
1091
    my $query = "UPDATE subscriptionhistory 
1086
                    SET histstartdate=?,histenddate=?,recievedlist=?,missinglist=?,opacnote=?,librariannote=?
1092
                    SET histstartdate=?,histenddate=?,recievedlist=?,missinglist=?,opacnote=?,librariannote=?
(-)a/installer/data/mysql/kohastructure.sql (-2 / +2 lines)
Lines 2046-2053 CREATE TABLE `subscriptionhistory` ( Link Here
2046
  `histenddate` date default NULL,
2046
  `histenddate` date default NULL,
2047
  `missinglist` longtext NOT NULL,
2047
  `missinglist` longtext NOT NULL,
2048
  `recievedlist` longtext NOT NULL,
2048
  `recievedlist` longtext NOT NULL,
2049
  `opacnote` varchar(150) NOT NULL default '',
2049
  `opacnote` text NULL,
2050
  `librariannote` varchar(150) NOT NULL default '',
2050
  `librariannote` text NULL,
2051
  PRIMARY KEY  (`subscriptionid`),
2051
  PRIMARY KEY  (`subscriptionid`),
2052
  KEY `biblionumber` (`biblionumber`)
2052
  KEY `biblionumber` (`biblionumber`)
2053
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2053
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7010-7015 CREATE TABLE IF NOT EXISTS borrower_files ( Link Here
7010
    SetVersion($DBversion);
7010
    SetVersion($DBversion);
7011
}
7011
}
7012
7012
7013
$DBversion = "3.13.00.XXX";
7014
if ( CheckVersion($DBversion) ) {
7015
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE opacnote opacnote TEXT NULL});
7016
    $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE librariannote librariannote TEXT NULL});
7017
    print "Upgrade to $DBversion done (Bug 10215 - Increase the size of opacnote and librariannote for table subscriptionhistory)\n";
7018
    SetVersion ($DBversion);
7019
}
7020
7013
=head1 FUNCTIONS
7021
=head1 FUNCTIONS
7014
7022
7015
=head2 TableExists($table)
7023
=head2 TableExists($table)
7016
- 

Return to bug 10215