Lines 1856-1867
sub GetLateOrMissingIssues {
Link Here
|
1856 |
$sth = $dbh->prepare( |
1856 |
$sth = $dbh->prepare( |
1857 |
"SELECT |
1857 |
"SELECT |
1858 |
serialid, aqbooksellerid, name, |
1858 |
serialid, aqbooksellerid, name, |
1859 |
biblio.title, planneddate, serialseq, |
1859 |
biblio.title, biblioitems.issn, planneddate, serialseq, |
1860 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1860 |
serial.status, serial.subscriptionid, claimdate, claims_count, |
1861 |
subscription.branchcode |
1861 |
subscription.branchcode |
1862 |
FROM serial |
1862 |
FROM serial |
1863 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1863 |
LEFT JOIN subscription ON serial.subscriptionid=subscription.subscriptionid |
1864 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |
1864 |
LEFT JOIN biblio ON subscription.biblionumber=biblio.biblionumber |
|
|
1865 |
LEFT JOIN biblioitems ON subscription.biblionumber=biblioitems.biblionumber |
1865 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id |
1866 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id |
1866 |
WHERE subscription.subscriptionid = serial.subscriptionid |
1867 |
WHERE subscription.subscriptionid = serial.subscriptionid |
1867 |
AND (serial.STATUS IN ($missing_statuses_string) OR ((planneddate < now() AND serial.STATUS = ?) OR serial.STATUS = ? OR serial.STATUS = ?)) |
1868 |
AND (serial.STATUS IN ($missing_statuses_string) OR ((planneddate < now() AND serial.STATUS = ?) OR serial.STATUS = ? OR serial.STATUS = ?)) |
1868 |
- |
|
|