From 0a9ee0c59bca2ceed0e6ea9a4493cc3774ab032b Mon Sep 17 00:00:00 2001
From: hdl <hdl>
Date: Sat, 30 Jun 2007 05:26:25 +0000
Subject: [PATCH] Changing GetSerials2 to take more than one status in
 parameter. status=1,3 will display all the serials late and waited.

---
 C4/Serials.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/C4/Serials.pm b/C4/Serials.pm
index d0949d20e3..ed6edc7e09 100644
--- a/C4/Serials.pm
+++ b/C4/Serials.pm
@@ -526,7 +526,7 @@ sub GetSubscriptionsFromBiblionumber {
     if (C4::Context->preference('IndependantBranches') && 
         C4::Context->userenv && 
         C4::Context->userenv->{'flags'} != 1){
-       $query.=" AND subscription.branchcode IN ('".C4::Context->userenv->{'branch'}."',\"''\")";
+       $query.=" AND subscription.branchcode IN ('".C4::Context->userenv->{'branch'}."',\"\")";
     }
     my $sth = $dbh->prepare($query);
     $sth->execute($biblionumber);
@@ -793,7 +793,7 @@ sub GetSerials2 {
     my $query = qq|
                  SELECT   serialid,serialseq, status, planneddate, publisheddate,notes
                  FROM     serial 
-                 WHERE    subscriptionid=$subscription AND status=$status 
+                 WHERE    subscriptionid=$subscription AND status IN ($status)
                  ORDER BY publisheddate,serialid DESC
                     |;
 #     warn $query;
-- 
2.39.2