View | Details | Raw Unified | Return to bug 23397
Collapse All | Expand All

(-)a/acqui/ordered.pl (-2 / +1 lines)
Lines 58-64 SELECT Link Here
58
    ecost_tax_included, budgetdate, entrydate,
58
    ecost_tax_included, budgetdate, entrydate,
59
    aqbasket.booksellerid,
59
    aqbasket.booksellerid,
60
    aqbooksellers.name as vendorname,
60
    aqbooksellers.name as vendorname,
61
    itype,
61
    GROUP_CONCAT(DISTINCT itype),
62
    title
62
    title
63
FROM (aqorders, aqbasket)
63
FROM (aqorders, aqbasket)
64
LEFT JOIN biblio ON
64
LEFT JOIN biblio ON
Lines 80-86 WHERE Link Here
80
             ecost_tax_included, budgetdate, entrydate,
80
             ecost_tax_included, budgetdate, entrydate,
81
             aqbasket.booksellerid,
81
             aqbasket.booksellerid,
82
             aqbooksellers.name,
82
             aqbooksellers.name,
83
             itype,
84
             title
83
             title
85
EOQ
84
EOQ
86
85
(-)a/acqui/spent.pl (-3 / +1 lines)
Lines 59-65 SELECT Link Here
59
    quantity-quantityreceived AS tleft,
59
    quantity-quantityreceived AS tleft,
60
    budgetdate, entrydate,
60
    budgetdate, entrydate,
61
    aqbasket.booksellerid,
61
    aqbasket.booksellerid,
62
    itype,
62
    GROUP_CONCAT(DISTINCT itype),
63
    title,
63
    title,
64
    aqorders.invoiceid,
64
    aqorders.invoiceid,
65
    aqinvoices.invoicenumber,
65
    aqinvoices.invoicenumber,
Lines 88-94 WHERE Link Here
88
             tleft,
88
             tleft,
89
             budgetdate, entrydate,
89
             budgetdate, entrydate,
90
             aqbasket.booksellerid,
90
             aqbasket.booksellerid,
91
             itype,
92
             title,
91
             title,
93
             aqorders.invoiceid,
92
             aqorders.invoiceid,
94
             aqinvoices.invoicenumber,
93
             aqinvoices.invoicenumber,
95
- 

Return to bug 23397