From b438625c6e01bd44864eb1a79b64589c32b59224 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Tue, 28 Apr 2009 22:47:42 +0200 Subject: [PATCH] remove bookfunds references --- C4/Serials.pm | 9 +-------- 1 file changed, 1 insertion(+), 8 deletions(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index b0ad919d42..5077d83be6 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -352,7 +352,6 @@ sub GetSubscription { my $query = qq( SELECT subscription.*, subscriptionhistory.*, - aqbudget.bookfundid, aqbooksellers.name AS aqbooksellername, biblio.title AS bibliotitle, subscription.biblionumber as bibnum); @@ -365,7 +364,6 @@ sub GetSubscription { $query .= qq( FROM subscription LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid - LEFT JOIN aqbudget ON subscription.aqbudgetid=aqbudget.aqbudgetid LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber WHERE subscription.subscriptionid = ? @@ -404,7 +402,7 @@ sub GetFullSubscription { serial.status, serial.notes as notes, year(IF(serial.publisheddate="00-00-0000",serial.planneddate,serial.publisheddate)) as year, - aqbudget.bookfundid,aqbooksellers.name as aqbooksellername, + aqbooksellers.name as aqbooksellername, biblio.title as bibliotitle, subscription.branchcode AS branchcode, subscription.subscriptionid AS subscriptionid |; @@ -418,7 +416,6 @@ sub GetFullSubscription { FROM serial LEFT JOIN subscription ON (serial.subscriptionid=subscription.subscriptionid ) - LEFT JOIN aqbudget ON subscription.aqbudgetid=aqbudget.aqbudgetid LEFT JOIN aqbooksellers on subscription.aqbooksellerid=aqbooksellers.id LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber WHERE serial.subscriptionid = ? @@ -515,12 +512,10 @@ sub GetSubscriptionsFromBiblionumber { SELECT subscription.*, branches.branchname, subscriptionhistory.*, - aqbudget.bookfundid, aqbooksellers.name AS aqbooksellername, biblio.title AS bibliotitle FROM subscription LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid - LEFT JOIN aqbudget ON subscription.aqbudgetid=aqbudget.aqbudgetid LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber LEFT JOIN branches ON branches.branchcode=subscription.branchcode @@ -584,7 +579,6 @@ sub GetFullSubscriptionsFromBiblionumber { serial.status, serial.notes as notes, year(IF(serial.publisheddate="00-00-0000",serial.planneddate,serial.publisheddate)) as year, - aqbudget.bookfundid,aqbooksellers.name as aqbooksellername, biblio.title as bibliotitle, subscription.branchcode AS branchcode, subscription.subscriptionid AS subscriptionid|; @@ -599,7 +593,6 @@ sub GetFullSubscriptionsFromBiblionumber { FROM serial LEFT JOIN subscription ON (serial.subscriptionid=subscription.subscriptionid) - LEFT JOIN aqbudget ON subscription.aqbudgetid=aqbudget.aqbudgetid LEFT JOIN aqbooksellers on subscription.aqbooksellerid=aqbooksellers.id LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber WHERE subscription.biblionumber = ? -- 2.39.5