|
Lines 83-89
WHERE
Link Here
|
| 83 |
(datecancellationprinted IS NULL OR |
83 |
(datecancellationprinted IS NULL OR |
| 84 |
datecancellationprinted='0000-00-00') AND |
84 |
datecancellationprinted='0000-00-00') AND |
| 85 |
datereceived IS NOT NULL |
85 |
datereceived IS NOT NULL |
| 86 |
GROUP BY aqorders.ordernumber |
86 |
GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber, |
|
|
87 |
tleft, |
| 88 |
ecost, budgetdate, entrydate, |
| 89 |
aqbasket.booksellerid, |
| 90 |
itype, |
| 91 |
title, |
| 92 |
aqorders.invoiceid, |
| 93 |
aqinvoices.invoicenumber, |
| 94 |
quantityreceived, |
| 95 |
unitprice, |
| 96 |
datereceived, |
| 97 |
aqbooksellers.name |
| 98 |
|
| 87 |
EOQ |
99 |
EOQ |
| 88 |
my $sth = $dbh->prepare($query); |
100 |
my $sth = $dbh->prepare($query); |
| 89 |
$sth->execute($bookfund); |
101 |
$sth->execute($bookfund); |
| 90 |
- |
|
|