From 965f96e1965da7fe6cbd16290309d38f062a3c7e 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>
Signed-off-by: Henri-Damien LAURENT <henridamien.laurent@biblibre.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 c358d7ac24..c7955d7ca1 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 ca5440933a..15bf0d68d0 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/acceptorreject.tmpl
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/suggestion/acceptorreject.tmpl
@@ -146,7 +146,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 /><!-- TMPL_IF name="note" --><!-- TMPL VAR NAME="note" --><!-- /TMPL_IF -->
@@ -154,8 +154,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.5