[Bug 10618] New: Acq claim email not formatting correctly and missing information
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618 Bug ID: 10618 Summary: Acq claim email not formatting correctly and missing information Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Notices Assignee: koha-bugs@lists.koha-community.org Reporter: katrin.fischer@bsz-bw.de QA Contact: testopia@bugs.koha-community.org The sample notice for Acquisition claims looks like this: <order>Ordernumber <<aqorders.ordernumber>> (<<biblio.title>>) (<<aqorders.quantity>> ordered) ($<<aqorders.listprice>> each) has not been received.</order> But this will give you the following output in an email: <order>Ordernumber 928 (Learning Perl (1 ordered) ($EUR each) has not been received.</order> <order>Ordernumber 1690 (FIZ Technik) (1 ordered) ($EUR each) has not been received.</order> The listprice is missing and the <order> tags are printed into the email. lisprice was empty in the database for ordernumber 928, but 10.00 for 1690. Note: The notice still works when you remove the <order></order> from the template. Tested with text emails, not HTML. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=7298 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- This is still a problem on current master. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618 Holger Meißner <h.meissner.82@web.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |h.meissner.82@web.de -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618 --- Comment #2 from Holger Meißner <h.meissner.82@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.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |http://bugs.koha-community. | |org/bugzilla3/show_bug.cgi? | |id=12505 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618 simith.doliveira@inlibro.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED CC| |simith.doliveira@inlibro.co | |m Resolution|--- |DUPLICATE --- Comment #3 from simith.doliveira@inlibro.com --- *** This bug has been marked as a duplicate of bug 12505 *** -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10618 Francois Charbonnier <francois.charbonnier@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |francois.charbonnier@inlibr | |o.com -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org