@@ -, +, @@ Improvements to the display of lists of ordered and received orders: - Show the vendor's name instead of the internal number To test: - Make sure you have some pending and received orders - Access the Spent and Ordered pages by clicking on the amount ordered or spent on the acq start page - Verify that - Vendor name shows --- acqui/ordered.pl | 3 +++ acqui/spent.pl | 5 ++++- koha-tmpl/intranet-tmpl/prog/en/modules/acqui/ordered.tt | 2 +- koha-tmpl/intranet-tmpl/prog/en/modules/acqui/spent.tt | 2 +- 4 files changed, 9 insertions(+), 3 deletions(-) --- a/acqui/ordered.pl +++ a/acqui/ordered.pl @@ -56,6 +56,7 @@ SELECT quantity-quantityreceived AS tleft, ecost, budgetdate, entrydate, aqbasket.booksellerid, + aqbooksellers.name as vendorname, itype, title FROM (aqorders, aqbasket) @@ -65,6 +66,8 @@ LEFT JOIN aqorders_items ON aqorders.ordernumber=aqorders_items.ordernumber LEFT JOIN items ON items.itemnumber=aqorders_items.itemnumber +LEFT JOIN aqbooksellers ON + aqbasket.booksellerid = aqbooksellers.id WHERE aqorders.basketno=aqbasket.basketno AND budget_id=? AND --- a/acqui/spent.pl +++ a/acqui/spent.pl @@ -64,7 +64,8 @@ SELECT aqinvoices.invoicenumber, quantityreceived, unitprice, - datereceived + datereceived, + aqbooksellers.name as vendorname FROM (aqorders, aqbasket) LEFT JOIN biblio ON biblio.biblionumber=aqorders.biblionumber @@ -74,6 +75,8 @@ LEFT JOIN items ON aqorders_items.itemnumber = items.itemnumber LEFT JOIN aqinvoices ON aqorders.invoiceid = aqinvoices.invoiceid +LEFT JOIN aqbooksellers ON + aqbasket.booksellerid = aqbooksellers.id WHERE aqorders.basketno=aqbasket.basketno AND budget_id=? AND --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/ordered.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/ordered.tt @@ -52,7 +52,7 @@ [% END %] - [% order.booksellerid | html %] + [% order.vendorname | html %] [% ItemTypes.GetDescription( order.itype ) | html %] --- a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/spent.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/acqui/spent.tt @@ -50,7 +50,7 @@ [% order.ordernumber | html %] - [% order.booksellerid | html %] + [% order.vendorname | html %] [% order.invoicenumber | html %] --