From 67f9ea0264f0882c6cd9b5bd467047e7448a415b Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Wed, 10 Mar 2010 22:26:29 +0100 Subject: [PATCH] (MT #3007) update hold transfer slip datas This patch add information to hold transfer slip: * itemcallnumber * location * waiting date Signed-off-by: Henri-Damien LAURENT Signed-off-by: Galen Charlton --- C4/Reserves.pm | 50 +++++++++++++------ .../en/modules/circ/hold-transfer-slip.tmpl | 32 ++++++++---- 2 files changed, 57 insertions(+), 25 deletions(-) diff --git a/C4/Reserves.pm b/C4/Reserves.pm index 464b3f37c5..21051a5ede 100644 --- a/C4/Reserves.pm +++ b/C4/Reserves.pm @@ -1296,23 +1296,41 @@ sub ModReserveMinusPriority { sub GetReserveInfo { my ( $borrowernumber, $biblionumber ) = @_; my $dbh = C4::Context->dbh; - my $strsth="SELECT reservedate, reservenotes, reserves.borrowernumber, - reserves.biblionumber, reserves.branchcode, - notificationdate, reminderdate, priority, found, - firstname, surname, phone, - email, address, address2, - cardnumber, city, zipcode, - biblio.title, biblio.author, - items.holdingbranch, items.itemcallnumber, items.itemnumber, - barcode, notes - FROM reserves left join items - ON items.itemnumber=reserves.itemnumber , - borrowers, biblio + my $strsth="SELECT + reservedate, + reservenotes, + reserves.borrowernumber, + reserves.biblionumber, + reserves.branchcode, + reserves.waitingdate, + notificationdate, + reminderdate, + priority, + found, + firstname, + surname, + phone, + email, + address, + address2, + cardnumber, + city, + zipcode, + biblio.title, + biblio.author, + items.holdingbranch, + items.itemcallnumber, + items.itemnumber, + items.location, + barcode, + notes + FROM reserves + LEFT JOIN items USING(itemnumber) + LEFT JOIN borrowers USING(borrowernumber) + LEFT JOIN biblio ON (reserves.biblionumber=biblio.biblionumber) WHERE - reserves.borrowernumber=? && - reserves.biblionumber=? && - reserves.borrowernumber=borrowers.borrowernumber && - reserves.biblionumber=biblio.biblionumber "; + reserves.borrowernumber=? + AND reserves.biblionumber=?"; my $sth = $dbh->prepare($strsth); $sth->execute($borrowernumber,$biblionumber); diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/hold-transfer-slip.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/hold-transfer-slip.tmpl index 2b82cd8f3c..4b13bef7ea 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/hold-transfer-slip.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/hold-transfer-slip.tmpl @@ -8,7 +8,9 @@ window.close();
- + + +
Date:

Transfer to Hold in

@@ -18,21 +20,33 @@ window.close();
    • -
    • -

  • -
    -
    • -
    • + +
    • + +
  • +
    +
    + +
    • + +
    • +

RESERVED ITEM

-

-

Notes:

+
    +
    • +
    • +
    • +
+ +

Notes:

+ - +
-- 2.39.5