@@ -, +, @@ +----------------+ +----------------+ +----------------+ +----------------+ +----------------+ +----------------+ +-------------------+ +-------------------+ +-------------------+ +------------------+ +------------------+ +------------------+ +------------------+ +------------------+ +------------------+ +---------------------+ +---------------------+ +---------------------+ --- C4/Acquisition.pm | 4 ++-- C4/Bookseller.pm | 2 +- C4/VirtualShelves.pm | 2 +- 3 files changed, 4 insertions(+), 4 deletions(-) --- a/C4/Acquisition.pm +++ a/C4/Acquisition.pm @@ -1638,8 +1638,8 @@ sub GetLateOrders { my $having = ""; if ($dbdriver eq "mysql") { $select .= " - aqorders.quantity - IFNULL(aqorders.quantityreceived,0) AS quantity, - (aqorders.quantity - IFNULL(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal, + aqorders.quantity - COALESCE(aqorders.quantityreceived,0) AS quantity, + (aqorders.quantity - COALESCE(aqorders.quantityreceived,0)) * aqorders.rrp AS subtotal, DATEDIFF(CAST(now() AS date),closedate) AS latesince "; if ( defined $delay ) { --- a/C4/Bookseller.pm +++ a/C4/Bookseller.pm @@ -125,7 +125,7 @@ sub GetBooksellersWithLateOrders { ) AND aqorders.rrp <> 0 AND aqorders.ecost <> 0 - AND aqorders.quantity - IFNULL(aqorders.quantityreceived,0) <> 0 + AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0 AND aqbasket.closedate IS NOT NULL "; if ( defined $delay ) { --- a/C4/VirtualShelves.pm +++ a/C4/VirtualShelves.pm @@ -454,7 +454,7 @@ sub ShelfPossibleAction { return 0 unless defined($shelfnumber); my $query = qq/ - SELECT IFNULL(owner,0) AS owner, category, allow_add, allow_delete_own, allow_delete_other, IFNULL(sh.borrowernumber,0) AS borrowernumber + SELECT COALESCE(owner,0) AS owner, category, allow_add, allow_delete_own, allow_delete_other, COALESCE(sh.borrowernumber,0) AS borrowernumber FROM virtualshelves vs LEFT JOIN virtualshelfshares sh ON sh.shelfnumber=vs.shelfnumber AND sh.borrowernumber=? --