http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11016 Bug ID: 11016 Summary: Move SQL query from acqui/spent.pl to C4/Acquisitions.pm ? Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt@gmail.com Reporter: mathieu.saby@univ-rennes2.fr QA Contact: testopia@bugs.koha-community.org I'm surprised to see a big SQL query in acqui/spent.pl. Is not that kind of stuff supposed to be rather in C4/Aquisitions.pm ? my $query = <<EOQ; SELECT aqorders.basketno, aqorders.ordernumber, quantity-quantityreceived AS tleft, ecost, budgetdate, entrydate, aqbasket.booksellerid, itype, title, aqorders.invoiceid, aqinvoices.invoicenumber, quantityreceived, unitprice, datereceived, aqorders.biblionumber FROM (aqorders, aqbasket) LEFT JOIN biblio ON biblio.biblionumber=aqorders.biblionumber LEFT JOIN items ON biblio.biblionumber = items.biblionumber LEFT JOIN aqorders_items ON items.itemnumber = aqorders_items.itemnumber LEFT JOIN aqinvoices ON aqorders.invoiceid = aqinvoices.invoiceid WHERE aqorders.ordernumber=aqorders_items.ordernumber AND aqorders.basketno=aqbasket.basketno AND budget_id=? AND (datecancellationprinted IS NULL OR datecancellationprinted='0000-00-00') GROUP BY aqorders.ordernumber EOQ M. Saby -- You are receiving this mail because: You are watching all bug changes.