Summary: | Acq claim email not formatting correctly and missing information | ||
---|---|---|---|
Product: | Koha | Reporter: | Katrin Fischer <katrin.fischer> |
Component: | Notices | Assignee: | Bugs List <koha-bugs> |
Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
Severity: | normal | ||
Priority: | P5 - low | CC: | francois.charbonnier, h.meissner.82, simith.doliveira |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7298 http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12505 |
||
Change sponsored?: | --- | Patch complexity: | --- |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: |
Description
Katrin Fischer
2013-07-20 18:12:41 UTC
This is still a problem on current master. 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. |