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