http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14535 Bug ID: 14535 Summary: Late orders doensn't show orders with price = 0 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org If the price is unknown or the book is free, part of another deal or whatever, the orders are entered with 0.00 as a price sometimes. The problem is, that those orders won't ever show up in the late orders page, although you might want to ask for them to be delivered. This is because of a condition in the routine: 110 sub GetBooksellersWithLateOrders { 111 my ( $delay, $estimateddeliverydatefrom, $estimateddeliverydateto ) = @_; 112 my $dbh = C4::Context->dbh; 117 my $query; 118 my @query_params = (); 119 my $dbdriver = C4::Context->config("db_scheme") || "mysql"; 120 $query = " 121 SELECT DISTINCT aqbasket.booksellerid, aqbooksellers.name 122 FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno 123 LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id 124 WHERE 125 ( datereceived = '' 126 OR datereceived IS NULL 127 OR aqorders.quantityreceived < aqorders.quantity 128 ) 129 AND aqorders.rrp <> 0 130 AND aqorders.ecost <> 0 131 AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0 132 AND aqbasket.closedate IS NOT NULL 133 " -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.