Lines 714-721
sub GetPendingOrders {
Link Here
|
714 |
my $dbh = C4::Context->dbh; |
714 |
my $dbh = C4::Context->dbh; |
715 |
my $strsth = " |
715 |
my $strsth = " |
716 |
SELECT ".($grouped?"count(*),":"")."aqbasket.basketno, |
716 |
SELECT ".($grouped?"count(*),":"")."aqbasket.basketno, |
717 |
surname,firstname,aqorders.*,biblio.*,biblioitems.isbn, |
717 |
surname,firstname,biblio.*,biblioitems.isbn, |
718 |
aqbasket.closedate, aqbasket.creationdate, aqbasket.basketname |
718 |
aqbasket.closedate, aqbasket.creationdate, aqbasket.basketname, |
|
|
719 |
aqorders.* |
719 |
FROM aqorders |
720 |
FROM aqorders |
720 |
LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno |
721 |
LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno |
721 |
LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber |
722 |
LEFT JOIN borrowers ON aqbasket.authorisedby=borrowers.borrowernumber |
722 |
- |
|
|