|
Lines 62-71
SELECT
Link Here
|
| 62 |
FROM (aqorders, aqbasket) |
62 |
FROM (aqorders, aqbasket) |
| 63 |
LEFT JOIN biblio ON |
63 |
LEFT JOIN biblio ON |
| 64 |
biblio.biblionumber=aqorders.biblionumber |
64 |
biblio.biblionumber=aqorders.biblionumber |
| 65 |
LEFT JOIN aqorders_items ON |
65 |
LEFT JOIN |
| 66 |
aqorders.ordernumber=aqorders_items.ordernumber |
66 |
(SELECT ordernumber, GROUP_CONCAT(DISTINCT itype) as itype |
| 67 |
LEFT JOIN items ON |
67 |
FROM aqorders_items |
| 68 |
items.itemnumber=aqorders_items.itemnumber |
68 |
LEFT JOIN items USING (itemnumber) |
|
|
69 |
GROUP BY ordernumber) aqitems USING (ordernumber) |
| 69 |
LEFT JOIN aqbooksellers ON |
70 |
LEFT JOIN aqbooksellers ON |
| 70 |
aqbasket.booksellerid = aqbooksellers.id |
71 |
aqbasket.booksellerid = aqbooksellers.id |
| 71 |
WHERE |
72 |
WHERE |
|
Lines 74-80
WHERE
Link Here
|
| 74 |
(datecancellationprinted IS NULL OR |
75 |
(datecancellationprinted IS NULL OR |
| 75 |
datecancellationprinted='0000-00-00') AND |
76 |
datecancellationprinted='0000-00-00') AND |
| 76 |
(quantity > quantityreceived OR quantityreceived IS NULL) |
77 |
(quantity > quantityreceived OR quantityreceived IS NULL) |
| 77 |
GROUP BY aqorders.ordernumber |
|
|
| 78 |
EOQ |
78 |
EOQ |
| 79 |
|
79 |
|
| 80 |
my $sth = $dbh->prepare($query); |
80 |
my $sth = $dbh->prepare($query); |