Lines 254-266
sub GetSubscription {
Link Here
|
254 |
my ($subscriptionid) = @_; |
254 |
my ($subscriptionid) = @_; |
255 |
my $dbh = C4::Context->dbh; |
255 |
my $dbh = C4::Context->dbh; |
256 |
my $query = qq( |
256 |
my $query = qq( |
257 |
SELECT subscription.*, |
257 |
SELECT |
258 |
subscriptionhistory.*, |
258 |
subscription.*, |
|
|
259 |
histstartdate, histenddate, missinglist, recievedlist, opacnote, librariannote, |
259 |
aqbooksellers.name AS aqbooksellername, |
260 |
aqbooksellers.name AS aqbooksellername, |
260 |
biblio.title AS bibliotitle, |
261 |
biblio.title AS bibliotitle, |
261 |
subscription.biblionumber as bibnum |
262 |
subscription.biblionumber as bibnum |
262 |
FROM subscription |
263 |
FROM subscription |
263 |
LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid |
264 |
LEFT JOIN subscriptionhistory USING(subscriptionid) |
264 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id |
265 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id |
265 |
LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber |
266 |
LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber |
266 |
WHERE subscription.subscriptionid = ? |
267 |
WHERE subscription.subscriptionid = ? |
Lines 408-418
sub GetSubscriptionsFromBiblionumber {
Link Here
|
408 |
my $query = qq( |
409 |
my $query = qq( |
409 |
SELECT subscription.*, |
410 |
SELECT subscription.*, |
410 |
branches.branchname, |
411 |
branches.branchname, |
411 |
subscriptionhistory.*, |
412 |
histstartdate, histenddate, missinglist, recievedlist, opacnote, librariannote, |
412 |
aqbooksellers.name AS aqbooksellername, |
413 |
aqbooksellers.name AS aqbooksellername, |
413 |
biblio.title AS bibliotitle |
414 |
biblio.title AS bibliotitle |
414 |
FROM subscription |
415 |
FROM subscription |
415 |
LEFT JOIN subscriptionhistory ON subscription.subscriptionid=subscriptionhistory.subscriptionid |
416 |
LEFT JOIN subscriptionhistory USING(subscriptionid) |
416 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id |
417 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid=aqbooksellers.id |
417 |
LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber |
418 |
LEFT JOIN biblio ON biblio.biblionumber=subscription.biblionumber |
418 |
LEFT JOIN branches ON branches.branchcode=subscription.branchcode |
419 |
LEFT JOIN branches ON branches.branchcode=subscription.branchcode |
419 |
- |
|
|