KOHA ZS: circ/pendingreserves
authorDobrica Pavlinusic <dpavlin@rot13.org>
Sat, 1 Sep 2018 08:03:31 +0000 (10:03 +0200)
committerDobrica Pavlinusic <dpavlin@rot13.org>
Mon, 25 Mar 2019 14:43:16 +0000 (15:43 +0100)
circ/pendingreserves.pl
koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tt

index 734b8d7..4bc8fee 100755 (executable)
@@ -185,6 +185,8 @@ my $strsth =
             reserves.biblionumber,
             reserves.branchcode as l_branch,
             reserves.itemnumber,
+            reserves.timestamp,
+            reserves.reservenotes,
             items.holdingbranch,
             items.homebranch,
             GROUP_CONCAT(DISTINCT $item_type
@@ -229,7 +231,7 @@ if (C4::Context->preference('IndependentBranches')){
     $strsth .= " AND items.holdingbranch=? ";
     push @query_params, C4::Context->userenv->{'branch'};
 }
-$strsth .= " GROUP BY reserves.biblionumber ORDER BY biblio.title ";
+$strsth .= " GROUP BY reserves.biblionumber,reserves.reserve_id ORDER BY biblio.title ";
 
 my $sth = $dbh->prepare($strsth);
 $sth->execute(@query_params);
@@ -263,6 +265,8 @@ while ( my $data = $sth->fetchrow_hashref ) {
             holdingbranch   => $data->{holdingbranch},
             homebranch      => $data->{homebranch},
             itemnumber      => $data->{itemnumber},
+            timestamp       => $data->{timestamp}, # FFZG
+            reservenotes    => $data->{reservenotes}, # FFZG
         }
     );
 }
index 930c362..02e94b0 100644 (file)
             <td><p><b>[% reserveloo.pullcount | html %]</b></p></td>
             <td>[% reserveloo.count | html %]</td>
             <td>[% reserveloo.rcount | html %]</td>
-            <td><a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% reserveloo.borrowernumber | uri %]">[% reserveloo.firstname | html %] [% reserveloo.surname | html %]</a></td>
+            <td>
+                               [% reserveloo.timestamp | $KohaDates with_hours => 1 %]
+                               <br>
+                               <a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% reserveloo.borrowernumber | uri %]">[% reserveloo.firstname | html %] [% reserveloo.surname | html %]</a>
+                               <br>
+                               <em>[% reserveloo.reservenotes | html %]</em>
+                       </td>
+
             <td>
             <p>
                 [% INCLUDE 'biblio-default-view.inc' biblionumber = reserveloo.biblionumber %]