|
Lines 1650-1656
C<$pending> Finds pending orders. Ignores completed and cancelled orders.
Link Here
|
| 1650 |
|
1650 |
|
| 1651 |
|
1651 |
|
| 1652 |
C<@results> is an array of references-to-hash with the keys are fields |
1652 |
C<@results> is an array of references-to-hash with the keys are fields |
| 1653 |
from aqorders, biblio, biblioitems and aqbasket tables. |
1653 |
from aqorders, biblio, biblioitems and aqbasket tables, except for |
|
|
1654 |
biblio.notes returned as biblionotes and biblio.timestamp returned as bibliotimestamp. |
| 1654 |
|
1655 |
|
| 1655 |
=cut |
1656 |
=cut |
| 1656 |
|
1657 |
|
|
Lines 1672-1678
sub SearchOrders {
Link Here
|
| 1672 |
SELECT aqbasket.basketno, |
1673 |
SELECT aqbasket.basketno, |
| 1673 |
borrowers.surname, |
1674 |
borrowers.surname, |
| 1674 |
borrowers.firstname, |
1675 |
borrowers.firstname, |
| 1675 |
biblio.*, |
1676 |
biblio.frameworkcode, |
|
|
1677 |
biblio.author, |
| 1678 |
biblio.title, |
| 1679 |
biblio.unititle, |
| 1680 |
biblio.serial, |
| 1681 |
biblio.seriestitle, |
| 1682 |
biblio.copyrightdate, |
| 1683 |
biblio.datecreated, |
| 1684 |
biblio.abstract, |
| 1685 |
biblio.notes as biblionotes, |
| 1686 |
biblio.timestamp as bibliotimestamp, |
| 1676 |
biblioitems.isbn, |
1687 |
biblioitems.isbn, |
| 1677 |
biblioitems.biblioitemnumber, |
1688 |
biblioitems.biblioitemnumber, |
| 1678 |
aqbasket.closedate, |
1689 |
aqbasket.closedate, |
| 1679 |
- |
|
|