[Koha-bugs] [Bug 14535] New: Late orders doensn't show orders with price = 0

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: katrin.fischer at bsz-bw.de
        QA Contact: testopia at 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.