|
Lines 660-666
sub GetSerials {
Link Here
|
| 660 |
publisheddatetext, planneddate,notes, routingnotes |
660 |
publisheddatetext, planneddate,notes, routingnotes |
| 661 |
FROM serial |
661 |
FROM serial |
| 662 |
WHERE subscriptionid = ? AND status NOT IN ( $statuses ) |
662 |
WHERE subscriptionid = ? AND status NOT IN ( $statuses ) |
| 663 |
ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC"; |
663 |
ORDER BY IF(publisheddate IS NULL,planneddate,publisheddate) DESC"; |
| 664 |
my $sth = $dbh->prepare($query); |
664 |
my $sth = $dbh->prepare($query); |
| 665 |
$sth->execute($subscriptionid); |
665 |
$sth->execute($subscriptionid); |
| 666 |
|
666 |
|
|
Lines 682-688
sub GetSerials {
Link Here
|
| 682 |
FROM serial |
682 |
FROM serial |
| 683 |
WHERE subscriptionid = ? |
683 |
WHERE subscriptionid = ? |
| 684 |
AND status IN ( $statuses ) |
684 |
AND status IN ( $statuses ) |
| 685 |
ORDER BY IF(publisheddate<>'0000-00-00',publisheddate,planneddate) DESC |
685 |
ORDER BY IF(publisheddate IS NULL,planneddate,publisheddate) DESC |
| 686 |
"; |
686 |
"; |
| 687 |
$sth = $dbh->prepare($query); |
687 |
$sth = $dbh->prepare($query); |
| 688 |
$sth->execute($subscriptionid); |
688 |
$sth->execute($subscriptionid); |
| 689 |
- |
|
|