|
Lines 304-310
sub GetFullSubscription {
Link Here
|
| 304 |
serial.publisheddatetext, |
304 |
serial.publisheddatetext, |
| 305 |
serial.status, |
305 |
serial.status, |
| 306 |
serial.notes as notes, |
306 |
serial.notes as notes, |
| 307 |
year(IF(serial.publisheddate IS NULL,serial.publisheddate,serial.planneddate)) as year, |
307 |
year(IF(serial.publisheddate IS NULL,serial.planneddate,serial.publisheddate)) as year, |
| 308 |
aqbooksellers.name as aqbooksellername, |
308 |
aqbooksellers.name as aqbooksellername, |
| 309 |
biblio.title as bibliotitle, |
309 |
biblio.title as bibliotitle, |
| 310 |
subscription.branchcode AS branchcode, |
310 |
subscription.branchcode AS branchcode, |
|
Lines 316-322
sub GetFullSubscription {
Link Here
|
| 316 |
LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber |
316 |
LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber |
| 317 |
WHERE serial.subscriptionid = ? |
317 |
WHERE serial.subscriptionid = ? |
| 318 |
ORDER BY year DESC, |
318 |
ORDER BY year DESC, |
| 319 |
IF(serial.publisheddate IS NULL,serial.publisheddate,serial.planneddate) DESC, |
319 |
IF(serial.publisheddate IS NULL,serial.planneddate,serial.publisheddate) DESC, |
| 320 |
serial.subscriptionid |
320 |
serial.subscriptionid |
| 321 |
|; |
321 |
|; |
| 322 |
$debug and warn "GetFullSubscription query: $query"; |
322 |
$debug and warn "GetFullSubscription query: $query"; |
|
Lines 464-470
sub GetFullSubscriptionsFromBiblionumber {
Link Here
|
| 464 |
serial.publisheddatetext, |
464 |
serial.publisheddatetext, |
| 465 |
serial.status, |
465 |
serial.status, |
| 466 |
serial.notes as notes, |
466 |
serial.notes as notes, |
| 467 |
year(IF(serial.publisheddate IS NULL,serial.publisheddate,serial.planneddate)) as year, |
467 |
year(IF(serial.publisheddate IS NULL,serial.planneddate,serial.publisheddate)) as year, |
| 468 |
biblio.title as bibliotitle, |
468 |
biblio.title as bibliotitle, |
| 469 |
subscription.branchcode AS branchcode, |
469 |
subscription.branchcode AS branchcode, |
| 470 |
subscription.subscriptionid AS subscriptionid |
470 |
subscription.subscriptionid AS subscriptionid |
|
Lines 475-481
sub GetFullSubscriptionsFromBiblionumber {
Link Here
|
| 475 |
LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber |
475 |
LEFT JOIN biblio on biblio.biblionumber=subscription.biblionumber |
| 476 |
WHERE subscription.biblionumber = ? |
476 |
WHERE subscription.biblionumber = ? |
| 477 |
ORDER BY year DESC, |
477 |
ORDER BY year DESC, |
| 478 |
IF(serial.publisheddate IS NULL,serial.publisheddate,serial.planneddate) DESC, |
478 |
IF(serial.publisheddate IS NULL,serial.planneddate,serial.publisheddate) DESC, |
| 479 |
serial.subscriptionid |
479 |
serial.subscriptionid |
| 480 |
|; |
480 |
|; |
| 481 |
my $sth = $dbh->prepare($query); |
481 |
my $sth = $dbh->prepare($query); |
| 482 |
- |
|
|