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

(-)a/acqui/ordered.pl (-2 / +1 lines)
Lines 71-78 LEFT JOIN aqbooksellers ON Link Here
71
    aqbasket.booksellerid = aqbooksellers.id
71
    aqbasket.booksellerid = aqbooksellers.id
72
WHERE
72
WHERE
73
    budget_id=? AND
73
    budget_id=? AND
74
    (datecancellationprinted IS NULL OR
74
    datecancellationprinted IS NULL AND
75
        datecancellationprinted='0000-00-00') AND
76
    (quantity > quantityreceived OR quantityreceived IS NULL)
75
    (quantity > quantityreceived OR quantityreceived IS NULL)
77
    GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,
76
    GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,
78
             tleft,
77
             tleft,
(-)a/acqui/spent.pl (-3 / +1 lines)
Lines 80-87 LEFT JOIN aqbooksellers ON Link Here
80
WHERE
80
WHERE
81
    aqorders.basketno=aqbasket.basketno AND
81
    aqorders.basketno=aqbasket.basketno AND
82
    budget_id=? AND
82
    budget_id=? AND
83
    (datecancellationprinted IS NULL OR
83
    datecancellationprinted IS NULL AND
84
        datecancellationprinted='0000-00-00') AND
85
    datereceived IS NOT NULL
84
    datereceived IS NOT NULL
86
    GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,
85
    GROUP BY aqorders.biblionumber, aqorders.basketno, aqorders.ordernumber,
87
             tleft,
86
             tleft,
88
- 

Return to bug 26997