From 916a14f5fb98a52af8bdf957f4099073e6e37664 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Wed, 21 Aug 2013 10:53:20 -0400 Subject: [PATCH] Bug 2693 - Tagging: Add filter by name Content-Type: text/plain; charset="utf-8" If you want to filter results on the tags management page by the reviewer you have to know their borrowernumber. It would be better to be able to search by name, but in the meantime this patch adds an autocomplete widget to the form field so that you can do a name search and populate the field with the borrowernumber. To test you must have approved or rejected tags. From the tags review page (tags/review.pl), view all, approved, or rejected tags. Type a name in the "reviewer" form field in the left sidebar filter. You should get an autocomplete dropdown with names matching your search. When you select one the form field should be populated by the borrowernumber. --- circ/ysearch.pl | 5 +++-- .../intranet-tmpl/prog/en/modules/tags/review.tt | 15 +++++++++++++++ 2 files changed, 18 insertions(+), 2 deletions(-) diff --git a/circ/ysearch.pl b/circ/ysearch.pl index 8a48c51..c57bb38 100755 --- a/circ/ysearch.pl +++ b/circ/ysearch.pl @@ -44,7 +44,7 @@ if ($auth_status ne "ok") { } my $dbh = C4::Context->dbh; -my $sql = qq(SELECT surname, firstname, cardnumber, address, city, zipcode, country +my $sql = qq(SELECT borrowernumber, surname, firstname, cardnumber, address, city, zipcode, country FROM borrowers WHERE surname LIKE ? OR firstname LIKE ? @@ -58,7 +58,8 @@ print "["; my $i = 0; while ( my $rec = $sth->fetchrow_hashref ) { if($i > 0){ print ","; } - print "{\"surname\":\"" . $rec->{surname} . "\",\"" . + print "{\"borrowernumber\":\"" . $rec->{borrowernumber} . "\",\"" . + "surname\":\"".$rec->{surname} . "\",\"" . "firstname\":\"".$rec->{firstname} . "\",\"" . "cardnumber\":\"".$rec->{cardnumber} . "\",\"" . "address\":\"".$rec->{address} . "\",\"" . diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/tags/review.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/tags/review.tt index 89c998a..19f3e49 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/tags/review.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/tags/review.tt @@ -121,6 +121,21 @@ td input,td input[type="submit"] { font-size: 85%; padding: 1px; } $("*").ajaxError(function(evt, request, settings){ if ((alerted +=1) <= 1){ window.alert(_("AJAX error")+" (" + alerted + " alert)"); } }); + var reviewerField = $("#approver"); + reviewerField.autocomplete({ + source: "/cgi-bin/koha/circ/ysearch.pl", + minLength: 3, + select: function( event, ui ) { + reviewerField.val( ui.item.borrowernumber ); + return false; + } + }) + .data( "autocomplete" )._renderItem = function( ul, item ) { + return $( "
  • " ) + .data( "item.autocomplete", item ) + .append( "" + item.surname + ", " + item.firstname + " (" + item.cardnumber + ") " + item.address + " " + item.city + " " + item.zipcode + " " + item.country + "" ) + .appendTo( ul ); + }; }); //]]> -- 1.7.9.5