[Koha-bugs] [Bug 10618] Acq claim email not formatting correctly and missing information

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618

--- Comment #2 from Holger Meißner <h.meissner.82 at web.de> ---
I took a look at this and found out where it goes wrong. But I have no idea how
to fix it. The problem is in C4::Letters.

In sub SendAlerts there's this bit of SQL:

            SELECT
aqorders.*,aqbasket.*,biblio.*,biblioitems.*,aqbooksellers.*,
            aqbooksellers.id AS booksellerid
            FROM aqorders
            LEFT JOIN aqbasket ON aqbasket.basketno=aqorders.basketno
            LEFT JOIN biblio ON aqorders.biblionumber=biblio.biblionumber
            LEFT JOIN biblioitems ON
aqorders.biblionumber=biblioitems.biblionumber
            LEFT JOIN aqbooksellers ON aqbasket.booksellerid=aqbooksellers.id
            WHERE aqorders.ordernumber IN (

The result of this query is stored in hash refs.

my $dataorders = $sthorders->fetchall_arrayref( {} );

But among the resulting columns there are aqorders.listprice and
aqbooksellers.listprice. And the hash keys only consist of field names, without
the table names, so one of them gets lost.

So in Katrins example, it's really aqbooksellers.listprice that is displayed
instead of aqorders.listprice, which is dropped.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.