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

(-)a/acqui/ordered.pl (-1 lines)
Lines 74-80 WHERE Link Here
74
    (datecancellationprinted IS NULL OR
74
    (datecancellationprinted IS NULL OR
75
        datecancellationprinted='0000-00-00') AND
75
        datecancellationprinted='0000-00-00') AND
76
    (quantity > quantityreceived OR quantityreceived IS NULL)
76
    (quantity > quantityreceived OR quantityreceived IS NULL)
77
    GROUP BY aqorders.ordernumber
78
EOQ
77
EOQ
79
78
80
my $sth = $dbh->prepare($query);
79
my $sth = $dbh->prepare($query);
(-)a/acqui/spent.pl (-2 lines)
Lines 83-89 WHERE Link Here
83
    (datecancellationprinted IS NULL OR
83
    (datecancellationprinted IS NULL OR
84
        datecancellationprinted='0000-00-00') AND
84
        datecancellationprinted='0000-00-00') AND
85
    datereceived IS NOT NULL
85
    datereceived IS NOT NULL
86
    GROUP BY aqorders.ordernumber
87
EOQ
86
EOQ
88
my $sth = $dbh->prepare($query);
87
my $sth = $dbh->prepare($query);
89
$sth->execute($bookfund);
88
$sth->execute($bookfund);
90
- 

Return to bug 21622