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

(-)a/C4/Acquisition.pm (-2 / +2 lines)
Lines 1638-1645 sub GetLateOrders { Link Here
1638
    my $having = "";
1638
    my $having = "";
1639
    if ($dbdriver eq "mysql") {
1639
    if ($dbdriver eq "mysql") {
1640
        $select .= "
1640
        $select .= "
1641
        aqorders.quantity - IFNULL(aqorders.quantityreceived,0)                 AS quantity,
1641
        aqorders.quantity - COALESCE(aqorders.quantityreceived,0)                 AS quantity,
1642
        (aqorders.quantity - IFNULL(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
1642
        (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
1643
        DATEDIFF(CAST(now() AS date),closedate) AS latesince
1643
        DATEDIFF(CAST(now() AS date),closedate) AS latesince
1644
        ";
1644
        ";
1645
        if ( defined $delay ) {
1645
        if ( defined $delay ) {
(-)a/C4/Bookseller.pm (-1 / +1 lines)
Lines 125-131 sub GetBooksellersWithLateOrders { Link Here
125
            )
125
            )
126
            AND aqorders.rrp <> 0
126
            AND aqorders.rrp <> 0
127
            AND aqorders.ecost <> 0
127
            AND aqorders.ecost <> 0
128
            AND aqorders.quantity - IFNULL(aqorders.quantityreceived,0) <> 0
128
            AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0
129
            AND aqbasket.closedate IS NOT NULL
129
            AND aqbasket.closedate IS NOT NULL
130
    ";
130
    ";
131
    if ( defined $delay ) {
131
    if ( defined $delay ) {
(-)a/C4/VirtualShelves.pm (-2 / +1 lines)
Lines 454-460 sub ShelfPossibleAction { Link Here
454
    return 0 unless defined($shelfnumber);
454
    return 0 unless defined($shelfnumber);
455
455
456
    my $query = qq/
456
    my $query = qq/
457
        SELECT IFNULL(owner,0) AS owner, category, allow_add, allow_delete_own, allow_delete_other, IFNULL(sh.borrowernumber,0) AS borrowernumber
457
        SELECT COALESCE(owner,0) AS owner, category, allow_add, allow_delete_own, allow_delete_other, COALESCE(sh.borrowernumber,0) AS borrowernumber
458
        FROM virtualshelves vs
458
        FROM virtualshelves vs
459
        LEFT JOIN virtualshelfshares sh ON sh.shelfnumber=vs.shelfnumber
459
        LEFT JOIN virtualshelfshares sh ON sh.shelfnumber=vs.shelfnumber
460
        AND sh.borrowernumber=?
460
        AND sh.borrowernumber=?
461
- 

Return to bug 8164