[Koha-patches] [PATCH] Bug 2695 - Children cannot be attached to staff

[Chris Cormack]

---
 C4/Members.pm                                      |    2 +-
 .../prog/en/modules/members/guarantor_search.tmpl  |    3 ++-
 members/guarantor_search.pl                        |    7 ++++---
 3 files changed, 7 insertions(+), 5 deletions(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index d82e5e4..2046a07 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -168,7 +168,7 @@ sub SearchMember {
     
     # this is used by circulation everytime a new borrowers cardnumber is scanned
     # so we can check an exact match first, if that works return, otherwise do the rest
-    $query = "SELECT * FROM borrowers
+    $query = "SELECT *,categories.description FROM borrowers
         LEFT JOIN categories ON borrowers.categorycode=categories.categorycode
         ";
     my $sth = $dbh->prepare("$query WHERE cardnumber = ?");
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/members/guarantor_search.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/members/guarantor_search.tmpl
index 7fa5099..77877a4 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/members/guarantor_search.tmpl
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/members/guarantor_search.tmpl
@@ -70,7 +70,8 @@
 				<td><!-- TMPL_VAR NAME="cardnumber" --></td>
                 <td>
                     <!-- TMPL_VAR NAME="surname" -->, <!-- TMPL_VAR NAME="firstname" -->
-                </td> 
+                </td>
+        <td><!-- TMPL_VAR NAME="category" --></td> 
 				<td><!-- TMPL_VAR NAME="dateofbirth" --></td>
 				<td><p><!-- TMPL_VAR NAME="address" --> <!-- TMPL_VAR NAME="city" --></p></td>
                 <td>
diff --git a/members/guarantor_search.pl b/members/guarantor_search.pl
index 4224da8..a2212a6 100755
--- a/members/guarantor_search.pl
+++ b/members/guarantor_search.pl
@@ -61,11 +61,11 @@ my $background = 0;
 if ($member ne ''){
 	if(length($member) == 1)
 	{
-		($count,$results)=SearchMember($member,$orderby,"simple",'A');
+		($count,$results)=SearchMember($member,$orderby,"simple");
 	}
 	else
 	{
-		($count,$results)=SearchMember($member,$orderby,"advanced",'A');
+		($count,$results)=SearchMember($member,$orderby,"advanced");
 	}
 	for (my $i=0; $i < $count; $i++){
 	#find out stats
@@ -79,7 +79,8 @@ if ($member ne ''){
 		surname => $results->[$i]{'surname'},
 		firstname => $results->[$i]{'firstname'},
 		categorycode => $results->[$i]{'categorycode'},
-		streetnumber => $results->[$i]{'streetnumber'},
+		category => $results->[$i]{'description'},
+    streetnumber => $results->[$i]{'streetnumber'},
 		address => $results->[$i]{'address'},
 		city => $results->[$i]{'city'},
 		zipcode => $results->[$i]{'zipcode'},
-- 
1.6.0.4