Lines 306-318
sub SendAlerts {
Link Here
|
306 |
# search the biblionumber |
306 |
# search the biblionumber |
307 |
my $strsth = $type eq 'claimacquisition' |
307 |
my $strsth = $type eq 'claimacquisition' |
308 |
? qq{ |
308 |
? qq{ |
309 |
SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.*,aqbooksellers.*, |
309 |
SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.* |
310 |
aqbooksellers.id AS booksellerid |
|
|
311 |
FROM aqorders |
310 |
FROM aqorders |
312 |
LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno |
311 |
LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno |
313 |
LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber |
312 |
LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber |
314 |
LEFT JOIN biblioitems ON aqorders.biblionumber=biblioitems.biblionumber |
313 |
LEFT JOIN biblioitems ON aqorders.biblionumber=biblioitems.biblionumber |
315 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid=aqbooksellers.id |
|
|
316 |
WHERE aqorders.ordernumber IN ( |
314 |
WHERE aqorders.ordernumber IN ( |
317 |
} |
315 |
} |
318 |
: qq{ |
316 |
: qq{ |
319 |
- |
|
|