Lines 299-311
sub SendAlerts {
Link Here
|
299 |
# search the biblionumber |
299 |
# search the biblionumber |
300 |
my $strsth = $type eq 'claimacquisition' |
300 |
my $strsth = $type eq 'claimacquisition' |
301 |
? qq{ |
301 |
? qq{ |
302 |
SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.*,aqbooksellers.*, |
302 |
SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.* |
303 |
aqbooksellers.id AS booksellerid |
|
|
304 |
FROM aqorders |
303 |
FROM aqorders |
305 |
LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno |
304 |
LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno |
306 |
LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber |
305 |
LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber |
307 |
LEFT JOIN biblioitems ON aqorders.biblionumber=biblioitems.biblionumber |
306 |
LEFT JOIN biblioitems ON aqorders.biblionumber=biblioitems.biblionumber |
308 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid=aqbooksellers.id |
|
|
309 |
WHERE aqorders.ordernumber IN ( |
307 |
WHERE aqorders.ordernumber IN ( |
310 |
} |
308 |
} |
311 |
: qq{ |
309 |
: qq{ |
312 |
- |
|
|