From 77826791d7c7c8fc212602c7556ea2d0ed09d120 Mon Sep 17 00:00:00 2001 From: Mason James Date: Mon, 29 Oct 2007 02:27:49 -0500 Subject: [PATCH] adding missing 'routingnotes' cols to sql Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- C4/Serials.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index 8731434729..3f98ea8edc 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -738,7 +738,7 @@ sub GetSerials { $count=5 unless ($count); my @serials; my $query = - "SELECT serialid,serialseq, status, publisheddate, planneddate,notes + "SELECT serialid,serialseq, status, publisheddate, planneddate,notes, routingnotes FROM serial WHERE subscriptionid = ? AND status NOT IN (2,4,5) ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC"; @@ -753,7 +753,7 @@ sub GetSerials { } # OK, now add the last 5 issues arrives/missing $query = - "SELECT serialid,serialseq, status, planneddate, publisheddate,notes + "SELECT serialid,serialseq, status, planneddate, publisheddate,notes, routingnotes FROM serial WHERE subscriptionid = ? AND (status in (2,4,5)) @@ -793,7 +793,7 @@ sub GetSerials2 { my ($subscription,$status) = @_; my $dbh = C4::Context->dbh; my $query = qq| - SELECT serialid,serialseq, status, planneddate, publisheddate,notes + SELECT serialid,serialseq, status, planneddate, publisheddate,notes, routingnotes FROM serial WHERE subscriptionid=$subscription AND status IN ($status) ORDER BY publisheddate,serialid DESC -- 2.39.2