---
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
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
