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 |
- |
|
|