2 [% USE ColumnsSettings %]
5 [% INCLUDE 'doc-head-open.inc' %]
6 <title>Koha › Patrons [% IF ( searching ) %]› Search results[% END %]</title>
7 [% INCLUDE 'doc-head-close.inc' %]
8 <link rel="stylesheet" type="text/css" href="[% interface %]/[% theme %]/css/datatables.css" />
9 [% INCLUDE 'datatables.inc' %]
10 [% INCLUDE 'columns_settings.inc' %]
11 <script type="text/javascript">
13 $(document).ready(function() {
14 $('#add_to_patron_list_submit').prop('disabled', true);
15 $('#new_patron_list').hide();
17 $('#add_to_patron_list').change(function() {
18 var value = $('#add_to_patron_list').val();
19 if ( value == 'new' ) {
20 $('#new_patron_list').val('')
21 $('#new_patron_list').show();
22 $('#new_patron_list').focus();
24 $('#new_patron_list').hide();
25 $('#add_to_patron_list_submit').prop('disabled', false);
27 $('#new_patron_list').hide();
28 $('#add_to_patron_list_submit').prop('disabled', true);
32 $('#new_patron_list').on('input', function() {
33 if ( $('#new_patron_list').val() ) {
34 $('#add_to_patron_list_submit').prop('disabled', false);
36 $('#add_to_patron_list_submit').prop('disabled', true);
40 $("#patron_list_dialog").hide();
41 $("#add_to_patron_list_submit").on('click', function(e){
42 if ( $('#add_to_patron_list').val() == 'new' ) {
43 if ( $('#new_patron_list').val() ) {
44 $("#add_to_patron_list option").each(function() {
45 if ( $(this).text() == $('#new_patron_list').val() ) {
46 alert( _("You already have a list with that name!") );
51 alert( _("You must give your new patron list a name!") );
56 if ( $("#memberresultst input:checkbox:checked").length == 0 ) {
57 alert( _("You have not selected any patrons to add to a list!") );
61 var borrowernumbers = [];
62 $("#memberresultst").find("input:checkbox:checked").each(function(){
63 borrowernumbers.push($(this).val());
66 add_to_patron_list: $("#add_to_patron_list").val(),
67 new_patron_list: $("#new_patron_list").val(),
68 borrowernumbers: borrowernumbers
73 url: '/cgi-bin/koha/svc/members/add_to_list',
74 success: function(data) {
75 $("#patron_list_dialog").show();
76 $("#patron_list_dialog > span.patrons-length").html(data.patrons_added_to_list);
77 $("#patron_list_dialog > a").attr("href", "/cgi-bin/koha/patron_lists/list.pl?patron_list_id=" + data.patron_list.patron_list_id);
78 $("#patron_list_dialog > a").html(data.patron_list.name);
79 if ( $('#add_to_patron_list').val() == 'new' ) {
80 var new_patron_list_added = $("<option>", {
81 value: data.patron_list.patron_list_id,
82 text: data.patron_list.name
84 $("#add_to_patron_list optgroup").append(new_patron_list_added);
85 $("#add_to_patron_list").val(data.patron_list.patron_list_id);
86 $("#new_patron_list").val('');
87 $('#add_to_patron_list').change();
91 alert("an error occurred");
96 $(".filterByLetter").on("click",function(e){
98 filterByFirstLetterSurname($(this).text());
100 $("#select_all").on("click",function(e){
102 $(".selection").prop("checked", true);
104 $("#clear_all").on("click",function(e){
106 $(".selection").prop("checked", false);
108 $("#clear_search").on("click",function(e){
112 $("#searchform").on("submit", filter);
117 $(document).ready(function() {
118 [% IF searchmember %]
119 $("#searchmember_filter").val("[% searchmember %]");
121 [% IF searchfieldstype %]
122 $("searchfieldstype_filter").val("[% searchfieldstype %]");
125 $("#searchtype_filter").val("[% searchtype %]");
127 [% IF categorycode %]
128 $("#categorycode_filter").val("[% categorycode_filter %]");
131 $("#branchcode_filter").val("[% branchcode_filter %]");
134 [% IF view != "show_results" %]
135 $("#searchresults").hide();
139 // Build the aLengthMenu
141 [%PatronsPerPage %], 10, 20, 50, 100, -1
143 jQuery.unique(aLengthMenu);
144 aLengthMenu.sort(function( a, b ){
145 // Put "All" at the end
148 } else if ( b == -1 ) {
151 return parseInt(a) < parseInt(b) ? -1 : 1;}
153 var aLengthMenuLabel = [];
154 $(aLengthMenu).each(function(){
156 // Label for -1 is "All"
157 aLengthMenuLabel.push("All");
159 aLengthMenuLabel.push(this);
163 // Apply DataTables on the results table
164 var columns_settings = [% ColumnsSettings.GetColumns( 'members', 'member', 'memberresultst', 'json' ) %];
165 dtMemberResults = KohaTable("#memberresultst", {
167 'sAjaxSource': "/cgi-bin/koha/svc/members/search",
168 'fnServerData': function(sSource, aoData, fnCallback) {
173 'name': 'searchmember',
174 'value': $("#searchmember_filter").val()
176 'name': 'firstletter',
177 'value': $("#firstletter_filter").val()
179 'name': 'searchfieldstype',
180 'value': $("#searchfieldstype_filter").val()
182 'name': 'searchtype',
183 'value': $("#searchtype_filter").val()
185 'name': 'categorycode',
186 'value': $("#categorycode_filter").val()
188 'name': 'branchcode',
189 'value': $("#branchcode_filter").val()
191 'name': 'name_sorton',
192 'value': 'borrowers.surname borrowers.firstname'
194 'name': 'dateofbirth',
195 'value': 'borrowers.dateofbirth',
197 'name': 'category_sorton',
198 'value': 'categories.description',
200 'name': 'branch_sorton',
201 'value': 'branches.branchname'
203 'name': 'template_path',
204 'value': 'members/tables/members_results.tt',
211 'success': function(json){
212 // redirect if there is only 1 result.
213 if ( json.aaData.length == 1 ) {
214 var borrowernumber = json.aaData[0].borrowernumber;
215 document.location.href="/cgi-bin/koha/members/moremember.pl?borrowernumber="+borrowernumber;
223 [% IF CAN_user_tools_manage_patron_lists %]
224 { 'mDataProp': 'dt_borrowernumber', 'bSortable': false },
226 { 'mDataProp': 'dt_cardnumber' },
227 { 'mDataProp': 'dt_name' },
228 { 'mDataProp': 'dt_dateofbirth' },
229 { 'mDataProp': 'dt_category' },
230 { 'mDataProp': 'dt_branch' },
231 { 'mDataProp': 'dt_dateexpiry' },
232 { 'mDataProp': 'dt_od_checkouts', 'bSortable': false },
233 { 'mDataProp': 'dt_fines', 'bSortable': false },
234 { 'mDataProp': 'dt_borrowernotes' },
235 { 'mDataProp': 'dt_action', 'bSortable': false, 'sClass': 'actions' }
237 'fnRowCallback': function(nRow, aData, iDisplayIndex, iDisplayIndexFull) {
238 /* Center text for 6th column */
239 $("td:eq(5)", nRow).css("text-align", "center");
245 [% IF CAN_user_tools_manage_patron_lists %]
246 'aaSorting': [[2, 'asc']],
248 'aaSorting': [[1, 'asc']],
250 "aLengthMenu": [aLengthMenu, aLengthMenuLabel],
251 'sPaginationType': 'full_numbers',
252 "iDisplayLength": [% PatronsPerPage %],
254 }, columns_settings);
258 // Update the string "Results found ..."
259 function update_searched(){
260 var searched = $("#searchfieldstype_filter").find("option:selected").text();
261 if ( $("#searchmember_filter").val() ) {
262 if ( $("#searchtype_filter").val() == 'start_with' ) {
263 searched += _(" starting with ");
265 searched += _(" containing ");
267 searched += "'" + $("#searchmember_filter").val() + "'";
269 if ( $("#firstletter_filter").val() ) {
270 searched += _(" begins with ") + "'" + $("#firstletter_filter").val() +"'";
272 if ( $("#categorycode_filter").val() ) {
273 searched += _(" with category ") + "'" + $("#categorycode_filter").find("option:selected").text() + "'";
275 if ( $("#branchcode_filter").val() ) {
276 searched += _(" in library ") + $("#branchcode_filter").find("option:selected").text();
278 $("#searchpattern").text(searched);
283 $("#firstletter_filter").val('');
286 $("#searchresults").show();
287 dtMemberResults.fnDraw();
291 // User has clicked on the Clear button
292 function clearFilters(redraw) {
293 $("#searchform select").val('');
294 $("#firstletter_filter").val('');
295 $("#searchmember_filter").val('');
298 $("#searchresults").show();
299 dtMemberResults.fnDraw();
303 // User has clicked on a letter
304 function filterByFirstLetterSurname(letter) {
306 $("#firstletter_filter").val(letter);
309 $("#searchresults").show();
310 dtMemberResults.fnDraw();
315 <body id="pat_member" class="pat">
316 [% INCLUDE 'header.inc' %]
317 [% INCLUDE 'patron-search.inc' %]
319 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › [% IF ( searching ) %]<a href="/cgi-bin/koha/members/members-home.pl">Patrons</a> › Search results[% ELSE %]Patrons[% END %]</div>
321 <div id="doc3" class="yui-t2">
326 [% IF CAN_user_tools_manage_patron_lists %]
327 <div id="patron_list_dialog" class="dialog alert">
328 Added <span class="patrons-length"></span> patrons to <a></a>.
332 [% IF Koha.Preference( 'NorwegianPatronDBEnable' ) == 1 %]
333 [% SET nl_search_form_title='Search the Norwegian national patron database' %]
334 [% INCLUDE 'nl-search-form.tt' %]
337 [% INCLUDE 'patron-toolbar.inc' %]
338 [% INCLUDE 'noadd-warnings.inc' %]
342 [% FOREACH letter IN alphabet.split(' ') %]
343 <a href="#" class="filterByLetter">[% letter %]</a>
347 [% IF ( CAN_user_borrowers && pending_borrower_modifications ) %]
348 <div class="pending-info" id="patron_updates_pending">
349 <a href="/cgi-bin/koha/members/members-update.pl">Patrons requesting modifications</a>:
350 <span class="number_box"><a href="/cgi-bin/koha/members/members-update.pl">[% pending_borrower_modifications %]</a></span>
354 <div id="searchresults">
355 <div id="searchheader">
356 <h3>Patrons found for: <span id="searchpattern">[% IF searchmember %] for '[% searchmember %]'[% END %]</span></h3>
358 [% IF CAN_user_tools_manage_patron_lists %]
359 <div id="searchheader">
361 <a href="#" id="select_all"><i class="fa fa-check"></i> Select all</a>
363 <a href="#" id="clear_all"><i class="fa fa-remove"></i> Clear all</a>
366 <label for="add_to_patron_list">Add selected patrons to:</label>
367 <select id="add_to_patron_list" name="add_to_patron_list">
368 <option value=""></option>
369 [% IF patron_lists %]
370 <optgroup label="Patron lists:">
371 [% FOREACH pl IN patron_lists %]
372 <option value="[% pl.patron_list_id %]">[% pl.name %]</option>
377 <option value="new">[ New list ]</option>
380 <input type="text" id="new_patron_list" name="new_patron_list" id="new_patron_list" />
382 <input id="add_to_patron_list_submit" type="submit" class="submit" value="Save">
388 <table id="memberresultst">
391 [% IF CAN_user_tools_manage_patron_lists %]
396 <th>Date of birth</th>
400 <th>OD/Checkouts</th>
413 <form method="get" id="searchform">
414 <input type="hidden" id="firstletter_filter" value="" />
415 <fieldset class="brief">
419 <label for="searchmember_filter">Search:</label>
420 <input type="text" id="searchmember_filter" value="[% searchmember %]"/>
423 <label for="searchfieldstype_filter">Search fields:</label>
424 <select name="searchfieldstype" id="searchfieldstype_filter">
425 [% IF searchfieldstype == "standard" %]
426 <option selected="selected" value='standard'>Standard</option>
428 <option value='standard'>Standard</option>
430 [% IF searchfieldstype == "surname" %]
431 <option selected="selected" value='surname'>Surname</option>
433 <option value='surname'>Surname</option>
435 [% IF searchfieldstype == "email" %]
436 <option selected="selected" value='email'>Email</option>
438 <option value='email'>Email</option>
440 [% IF searchfieldstype == "borrowernumber" %]
441 <option selected="selected" value='borrowernumber'>Borrower number</option>
443 <option value='borrowernumber'>Borrower number</option>
445 [% IF searchfieldstype == "userid" %]
446 <option selected="selected" value='userid'>Username</option>
448 <option value='userid'>Username</option>
450 [% IF searchfieldstype == "phone" %]
451 <option selected="selected" value='phone'>Phone number</option>
453 <option value='phone'>Phone number</option>
455 [% IF searchfieldstype == "address" %]
456 <option selected="selected" value='address'>Street address</option>
458 <option value='address'>Street address</option>
460 [% IF searchfieldstype == "dateofbirth" %]
461 <option selected="selected" value='dateofbirth'>Date of birth</option>
463 <option value='dateofbirth'>Date of birth</option>
465 [% IF searchfieldstype == "sort1" %]
466 <option selected="selected" value='sort1'>Sort field 1</option>
468 <option value='sort1'>Sort field 1</option>
470 [% IF searchfieldstype == "sort2" %]
471 <option selected="selected" value='sort2'>Sort field 2</option>
473 <option value='sort2'>Sort field 2</option>
478 <label for="searchtype_filter">Search type:</label>
479 <select name="searchtype" id="searchtype_filter">
480 [% IF searchtype == "start_with" %]
481 <option value='start_with' selected="selected">Starts with</option>
482 <option value="contain">Contains</option>
484 <option value='start_with'>Starts with</option>
485 <option value="contain" selected="selected">Contains</option>
490 <label for="categorycode_filter">Category:</label>
491 [% SET categories = Categories.all() %]
492 <select id="categorycode_filter">
493 <option value="">Any</option>
494 [% FOREACH cat IN categories %]
495 [% IF cat.categorycode == categorycode_filter %]
496 <option selected="selected" value="[% cat.categorycode %]">[% cat.description %]</option>
498 <option value="[% cat.categorycode %]">[% cat.description %]</option>
504 <label for="branchcode_filter">Library:</label>
505 [% SET branches = Branches.all( selected => branchcode_filter ) %]
506 <select id="branchcode_filter">
507 [% IF branches.size != 1 %]
508 <option value="">Any</option>
510 [% PROCESS options_for_libraries libraries => branches %]
514 <fieldset class="action">
515 <input type="submit" value="Search" />
516 <input type="button" value="Clear" id="clear_search" />
523 [% INCLUDE 'members-menu.inc' %]
526 [% INCLUDE 'intranet-bottom.inc' %]