|
Lines 96-102
sub GetSuppliersWithLateIssues {
Link Here
|
| 96 |
FROM subscription |
96 |
FROM subscription |
| 97 |
LEFT JOIN serial ON serial.subscriptionid=subscription.subscriptionid |
97 |
LEFT JOIN serial ON serial.subscriptionid=subscription.subscriptionid |
| 98 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id |
98 |
LEFT JOIN aqbooksellers ON subscription.aqbooksellerid = aqbooksellers.id |
| 99 |
WHERE (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|; |
99 |
WHERE id > 0 AND (planneddate < now() OR serial.STATUS = 3 OR serial.STATUS = 4) ORDER BY name|; |
| 100 |
return $dbh->selectall_arrayref($query, { Slice => {} }); |
100 |
return $dbh->selectall_arrayref($query, { Slice => {} }); |
| 101 |
} |
101 |
} |
| 102 |
|
102 |
|
| 103 |
- |
|
|