|
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 |
- |
|
|