From 819dc6d3d743c49e0e64e07728fd5f88903a3b11 Mon Sep 17 00:00:00 2001 From: simith Date: Wed, 20 Aug 2014 15:33:15 -0400 Subject: [PATCH] Bug 12505 - Variable aqorders.listprice in acq claim notice doesn't work Modified: C4/Letters.pm - remove aqbooksellers.* from SELECT statement In Letters - SendAlerts subrotine, is safe to remove aqbooksellers.* from SELECT statement for type=claimacquisition or claimissues. Aqbooksellers is passed to GetPreparedLetter subrotine in tables variable. Testing: I Apply the patch Select Tools -> Notices and slips; Edit ACQCLAIM; Add : Ordernumber <> (<>) (<> ordered) ($<> <> each) has not been received. Save modifications; Create a vendor (Acquisition module); Create an order (Acquisition module); Click Acquisitions -> Late orders; Select the order created; Click Claim order button; Valide <>; Valide <>. Signed-off-by: Paola Rossi Signed-off-by: Katrin Fischer Works as described. It's now possible to output the actual price in the claim notice. Signed-off-by: Tomas Cohen Arazi --- C4/Letters.pm | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) diff --git a/C4/Letters.pm b/C4/Letters.pm index 5673cbc234..a72f3100e2 100644 --- a/C4/Letters.pm +++ b/C4/Letters.pm @@ -306,13 +306,11 @@ sub SendAlerts { # search the biblionumber my $strsth = $type eq 'claimacquisition' ? qq{ - SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.*,aqbooksellers.*, - aqbooksellers.id AS booksellerid + SELECT aqorders.*,aqbasket.*,biblio.*,biblioitems.* 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 ( } : qq{ -- 2.39.5