From e4788e8a9732bef997bb6c385c2dab3d555284b0 Mon Sep 17 00:00:00 2001
From: Ryan Higgins <rch@liblime.com>
Date: Sat, 8 Dec 2007 17:32:47 -0600
Subject: [PATCH] Add 'Staff' category_type to new dropdown, add category_type
 to GetMemberDetails retval

Signed-off-by: Joshua Ferraro <jmf@liblime.com>
---
 C4/Members.pm                                               | 4 ++--
 koha-tmpl/intranet-tmpl/prog/en/includes/patron-toolbar.inc | 3 +++
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index dde01f9f19..7d77e84f4a 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -335,11 +335,11 @@ sub GetMemberDetails {
     my $query;
     my $sth;
     if ($borrowernumber) {
-        $sth = $dbh->prepare("select * from borrowers where borrowernumber=?");
+        $sth = $dbh->prepare("select borrowers.*,category_type from borrowers left join categories on borrowers.categorycode=categories.categorycode where  borrowernumber=?");
         $sth->execute($borrowernumber);
     }
     elsif ($cardnumber) {
-        $sth = $dbh->prepare("select * from borrowers where cardnumber=?");
+        $sth = $dbh->prepare("select borrowers.*,category_type from borrowers left join categories on borrowers.categorycode=categories.categorycode where cardnumber=?");
         $sth->execute($cardnumber);
     }
     else {
diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-toolbar.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/patron-toolbar.inc
index 7033bb93fb..44fe726cfb 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/includes/patron-toolbar.inc
+++ b/koha-tmpl/intranet-tmpl/prog/en/includes/patron-toolbar.inc
@@ -8,6 +8,7 @@
 	 	$("#addchild").parent().remove();
 		$("#addprofessional").parent().remove();
 		$("#addorganisation").parent().remove();
+		$("#addstaff").parent().remove();
 	    $("#newmenuc").empty();
 	    yuiToolbar();
 	 });
@@ -21,6 +22,7 @@
 			{ text: "Child Patron",  url: "/cgi-bin/koha/members/memberentry.pl?op=add&amp;category_type=C" },
 			{ text: "Professional Patron",  url: "/cgi-bin/koha/members/memberentry.pl?op=add&amp;category_type=P" },
 			{ text: "Organisation",  url: "/cgi-bin/koha/members/memberentry.pl?op=add&amp;category_type=I" },
+			{ text: "Staff",  url: "/cgi-bin/koha/members/memberentry.pl?op=add&amp;category_type=S" },
 		] 
 	
 	    new YAHOO.widget.Button({
@@ -40,4 +42,5 @@
 <li><a id="addchild" href="/cgi-bin/koha/members/memberentry.pl?op=add&amp;category_type=C">Child</a></li>
 <li><a id="addprofessional" href="/cgi-bin/koha/members/memberentry.pl?op=add&amp;category_type=P">Professional</a></li>
 <li><a id="addorganisation" href="/cgi-bin/koha/members/memberentry.pl?op=add&amp;category_type=I">Organisation</a></li>
+<li><a id="addstaff" href="/cgi-bin/koha/members/memberentry.pl?op=add&amp;category_type=S">Staff</a></li>
 </ul></div>
-- 
2.39.5