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

(-)a/C4/Acquisition.pm (-2 / +2 lines)
Lines 1795-1802 sub GetLateOrders { Link Here
1795
    my $having = "";
1795
    my $having = "";
1796
    if ($dbdriver eq "mysql") {
1796
    if ($dbdriver eq "mysql") {
1797
        $select .= "
1797
        $select .= "
1798
        aqorders.quantity - IFNULL(aqorders.quantityreceived,0)                 AS quantity,
1798
        aqorders.quantity - COALESCE(aqorders.quantityreceived,0)                 AS quantity,
1799
        (aqorders.quantity - IFNULL(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
1799
        (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal,
1800
        DATEDIFF(CAST(now() AS date),closedate) AS latesince
1800
        DATEDIFF(CAST(now() AS date),closedate) AS latesince
1801
        ";
1801
        ";
1802
        if ( defined $delay ) {
1802
        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 460-466 sub ShelfPossibleAction { Link Here
460
460
461
    my $dbh = C4::Context->dbh;
461
    my $dbh = C4::Context->dbh;
462
    my $query = qq/
462
    my $query = qq/
463
        SELECT IFNULL(owner,0) AS owner, category, allow_add, allow_delete_own, allow_delete_other, IFNULL(sh.borrowernumber,0) AS borrowernumber
463
        SELECT COALESCE(owner,0) AS owner, category, allow_add, allow_delete_own, allow_delete_other, COALESCE(sh.borrowernumber,0) AS borrowernumber
464
        FROM virtualshelves vs
464
        FROM virtualshelves vs
465
        LEFT JOIN virtualshelfshares sh ON sh.shelfnumber=vs.shelfnumber
465
        LEFT JOIN virtualshelfshares sh ON sh.shelfnumber=vs.shelfnumber
466
        AND sh.borrowernumber=?
466
        AND sh.borrowernumber=?
467
- 

Return to bug 8164