View | Details | Raw Unified | Return to bug 24002
Collapse All | Expand All

(-)a/C4/Serials.pm (-5 / +4 lines)
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="00-00-0000",serial.planneddate,serial.publisheddate)) as year,
307
            year(IF(serial.publisheddate IS NULL,serial.publisheddate,serial.planneddate)) 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="00-00-0000",serial.planneddate,serial.publisheddate) DESC,
319
          IF(serial.publisheddate IS NULL,serial.publisheddate,serial.planneddate) 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="00-00-0000",serial.planneddate,serial.publisheddate)) as year,
467
            year(IF(serial.publisheddate IS NULL,serial.publisheddate,serial.planneddate)) 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="00-00-0000",serial.planneddate,serial.publisheddate) DESC,
478
          IF(serial.publisheddate IS NULL,serial.publisheddate,serial.planneddate) DESC,
479
          serial.subscriptionid
479
          serial.subscriptionid
480
          |;
480
          |;
481
    my $sth = $dbh->prepare($query);
481
    my $sth = $dbh->prepare($query);
482
- 

Return to bug 24002