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

(-)a/C4/Acquisition.pm (-3 / +2 lines)
Lines 2198-2204 sub GetLateOrders { Link Here
2198
    if ($dbdriver eq "mysql") {
2198
    if ($dbdriver eq "mysql") {
2199
        $select .= "
2199
        $select .= "
2200
        aqorders.quantity - COALESCE(aqorders.quantityreceived,0)                 AS quantity,
2200
        aqorders.quantity - COALESCE(aqorders.quantityreceived,0)                 AS quantity,
2201
        (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * " . _get_rounding_sql("aqorders.rrp") . " AS subtotal,
2201
        (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
2202
        DATEDIFF(CAST(now() AS date),closedate) AS latesince
2202
        DATEDIFF(CAST(now() AS date),closedate) AS latesince
2203
        ";
2203
        ";
2204
        print STDERR "C4/Acquisition.pm 9\n";
2204
        print STDERR "C4/Acquisition.pm 9\n";
Lines 2211-2217 sub GetLateOrders { Link Here
2211
        # FIXME: account for IFNULL as above
2211
        # FIXME: account for IFNULL as above
2212
        $select .= "
2212
        $select .= "
2213
                aqorders.quantity                AS quantity,
2213
                aqorders.quantity                AS quantity,
2214
                aqorders.quantity * "._get_rounding_sql("aqorders.rrp")." AS subtotal,
2214
                aqorders.quantity * aqorders.rrp AS subtotal,
2215
                (CAST(now() AS date) - closedate)            AS latesince
2215
                (CAST(now() AS date) - closedate)            AS latesince
2216
        ";
2216
        ";
2217
        print STDERR "C4/Acquisition.pm 10\n";
2217
        print STDERR "C4/Acquisition.pm 10\n";
2218
- 

Return to bug 18736