[Koha-cvs] koha/C4 Bull.pm [rel_2_2]
Ryan Higgins
rch at liblime.com
Wed Jul 18 07:56:34 CEST 2007
CVSROOT: /sources/koha
Module name: koha
Branch: rel_2_2
Changes by: Ryan Higgins <rych> 07/07/18 05:56:34
Modified files:
C4 : Bull.pm
Log message:
mysql 5 syntax fixes
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Bull.pm?cvsroot=koha&only_with_tag=rel_2_2&r1=1.6.2.46&r2=1.6.2.47
Patches:
Index: Bull.pm
===================================================================
RCS file: /sources/koha/koha/C4/Attic/Bull.pm,v
retrieving revision 1.6.2.46
retrieving revision 1.6.2.47
diff -u -b -r1.6.2.46 -r1.6.2.47
--- Bull.pm 26 Apr 2007 01:23:43 -0000 1.6.2.46
+++ Bull.pm 18 Jul 2007 05:56:34 -0000 1.6.2.47
@@ -204,7 +204,7 @@
sub getSupplierListWithLateIssues {
my $dbh = C4::Context->dbh;
my $sth = $dbh->prepare("SELECT DISTINCT id, name
- FROM subscription, serial
+ FROM serial , subscription
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
WHERE subscription.subscriptionid = serial.subscriptionid AND
(planneddate < now( ) OR serial.STATUS = 3 OR serial.STATUS = 4)
@@ -225,7 +225,7 @@
my $sth;
if ($supplierid) {
$sth = $dbh->prepare("SELECT name,title,planneddate,serialseq,serial.subscriptionid
- FROM subscription, serial, biblio
+ FROM serial, biblio, subscription
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
WHERE subscription.subscriptionid = serial.subscriptionid AND
((planneddate < now() and serial.STATUS =1) OR serial.STATUS = 3) and
@@ -234,7 +234,7 @@
");
} else {
$sth = $dbh->prepare("SELECT name,title,planneddate,serialseq,serial.subscriptionid
- FROM subscription, serial, biblio
+ FROM serial, biblio, subscription
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
WHERE subscription.subscriptionid = serial.subscriptionid AND
((planneddate < now() and serial.STATUS =1) OR serial.STATUS = 3) and
@@ -269,7 +269,7 @@
if ($supplierid) {
$sth = $dbh->prepare("SELECT serialid,aqbooksellerid,name,title,planneddate,serialseq,serial.subscriptionid
- FROM subscription, serial, biblio
+ FROM serial, biblio, subscription
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
WHERE subscription.subscriptionid = serial.subscriptionid AND
serial.STATUS = 4 and
@@ -278,7 +278,7 @@
");
} else {
$sth = $dbh->prepare("SELECT serialid,aqbooksellerid,name,title,planneddate,serialseq,serial.subscriptionid
- FROM subscription, serial, biblio
+ FROM serial, biblio, subscription
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id
WHERE subscription.subscriptionid = serial.subscriptionid AND
serial.STATUS =4 and
More information about the Koha-cvs
mailing list