From 11f05061ccbd6321285f27d0556c7986f2fa376c Mon Sep 17 00:00:00 2001
From: Garry Collum <gcollum@gmail.com>
Date: Tue, 28 Jul 2009 20:49:58 -0400
Subject: [PATCH] Bug 3452: Displays borrower category and adds links to
 Suggestions Management

A couple of enhancments to Suggestions Management.

Adds a display of the borrower category of the suggesting patron for each item.

Adds links to the title and author displays so that the catalog can be quickly search for an existing bib.

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
---
 C4/Suggestions.pm                                          | 6 ++++--
 .../prog/en/modules/suggestion/acceptorreject.tmpl         | 7 ++++---
 2 files changed, 8 insertions(+), 5 deletions(-)

diff --git a/C4/Suggestions.pm b/C4/Suggestions.pm
index 17325401ea..dceea5ccb7 100644
--- a/C4/Suggestions.pm
+++ b/C4/Suggestions.pm
@@ -93,7 +93,8 @@ sub SearchSuggestion  {
         U1.surname   AS surnamesuggestedby,
         U1.firstname AS firstnamesuggestedby,
         U1.borrowernumber AS borrnumsuggestedby,
-        U1.branchcode AS branchcodesuggestedby,
+        U1.categorycode AS categorycodesuggestedby,
+        U2.branchcode AS branchcodemanagedby,
         U2.surname   AS surnamemanagedby,
         U2.firstname AS firstnamemanagedby,
         U2.borrowernumber AS borrnummanagedby
@@ -226,7 +227,8 @@ sub GetSuggestionByStatus {
                         U1.surname   AS surnamesuggestedby,
                         U1.firstname AS firstnamesuggestedby,
             U1.branchcode AS branchcodesuggestedby,
-						U1.borrowernumber AS borrnumsuggestedby,
+			U1.borrowernumber AS borrnumsuggestedby,
+			U1.categorycode AS categorycodesuggestedby,
                         U2.surname   AS surnamemanagedby,
                         U2.firstname AS firstnamemanagedby,
 						U2.borrowernumber AS borrnummanagedby
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/acceptorreject.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/acceptorreject.tmpl
index e0cecbfb60..c3aa93d257 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/acceptorreject.tmpl
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/acceptorreject.tmpl
@@ -147,7 +147,7 @@
         <tbody><!-- TMPL_LOOP NAME="suggestions_loop" -->
             <!-- TMPL_IF name="even" --><tr class="highlight"><!-- TMPL_ELSE --><tr><!-- /TMPL_IF -->
                 <td>
-    <!-- TMPL_VAR NAME="title" escape="html" --><!-- TMPL_IF NAME="author" -->, by <!-- TMPL_VAR NAME="author" --><!-- /TMPL_IF --><br />
+    <!-- TMPL_IF NAME="title" --><a href="/cgi-bin/koha/catalogue/search.pl?q=<!-- TMPL_VAR NAME="title" ESCAPE="URL" -->"><!-- TMPL_VAR NAME="title" escape="html" --></a><!-- /TMPL_IF --><!-- TMPL_IF NAME="author" -->, by <a href="/cgi-bin/koha/catalogue/search.pl?q=au:<!-- TMPL_VAR NAME="author" ESCAPE="URL" -->"><!-- TMPL_VAR NAME="author" --></a><!-- /TMPL_IF --><br />
                     <!-- TMPL_IF name="copyrightdate" -->&copy; <!-- TMPL_VAR name="copyrightdate" --> <!-- /TMPL_IF -->
                         <!-- TMPL_IF name="volumedesc" -->; Volume:<i><!-- TMPL_VAR name="volumedesc" --></i> <!-- /TMPL_IF -->
                         <!-- TMPL_IF name="isbn" -->; ISBN :<i><!-- TMPL_VAR name="isbn" --></i> <!-- /TMPL_IF --><!-- TMPL_IF name="publishercode" -->; Published by <!-- TMPL_VAR name="publishercode" --> <!-- /TMPL_IF --><!-- TMPL_IF name="publicationyear" --> in <i><!-- TMPL_VAR name="publicationyear" --></i> <!-- /TMPL_IF --><!-- TMPL_IF name="place" --> in <i><!-- TMPL_VAR name="place" --></i> <!-- /TMPL_IF --><br /></td>
@@ -155,8 +155,9 @@
                 <td>
                     <a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=<!-- TMPL_VAR NAME="borrnumsuggestedby" -->"><!-- TMPL_VAR name="surnamesuggestedby" -->
                     <!-- TMPL_IF name="firstnamesuggestedby" -->,<!-- /TMPL_IF -->
-                    <!-- TMPL_VAR name="firstnamesuggestedby" --></a>
-                    (<!-- TMPL_VAR name="branchcodesuggestedby" -->)
+                    <!-- TMPL_VAR name="firstnamesuggestedby" --></a><br />
+                    Branch: <!-- TMPL_VAR name="branchcodesuggestedby" --><br />
+                    Category: <!-- TMPL_VAR name="categorycodesuggestedby" -->
                 </td>
                 <td>
                     <!-- TMPL_VAR name="date" -->
-- 
2.39.2