6 [% INCLUDE 'doc-head-open.inc' %]
7 <title>Koha › Tools › Batch patron modification</title>
8 [% INCLUDE 'doc-head-close.inc' %]
9 [% Asset.css("css/datatables.css") %]
12 <body id="tools_modborrowers" class="tools">
13 [% INCLUDE 'header.inc' %]
14 [% INCLUDE 'cat-search.inc' %]
16 <div id="breadcrumbs">
17 <a href="/cgi-bin/koha/mainpage.pl">Home</a> ›
18 <a href="/cgi-bin/koha/tools/tools-home.pl">Tools</a> ›
19 <a href="/cgi-bin/koha/tools/modborrowers.pl">Batch patron modification</a>
22 <div id="doc3" class="yui-t2">
26 [% IF ( op == 'show_form' ) %]
27 <h1>Batch patron modification</h1>
28 <form method="post" enctype="multipart/form-data" action="/cgi-bin/koha/tools/modborrowers.pl">
29 <fieldset class="rows">
30 <legend>Use a file</legend>
32 <li><label for="uploadfile">File: </label> <input type="file" id="uploadfile" name="uploadfile" /></li>
37 <fieldset class="rows">
38 <legend>Or use a patron list</legend>
41 <label for="patron_list_id">Patron list: </label>
42 <select id="patron_list_id" name="patron_list_id">
43 <option value=""></option>
44 [% FOREACH pl IN patron_lists %]
45 <option value="[% pl.patron_list_id %]">[% pl.name %]</option>
53 <fieldset class="rows">
54 <legend>Or list cardnumbers one by one</legend>
57 <label for="cardnumberlist">Card number list (one cardnumber per line): </label>
58 <textarea rows="10" cols="30" id="cardnumberlist" name="cardnumberlist">[% cardnumberlist %]</textarea>
62 <input type="hidden" name="op" value="show" />
63 <fieldset class="action">
64 <input type="submit" value="Continue" class="button" />
65 <a class="cancel" href="/cgi-bin/koha/tools/tools-home.pl">Cancel</a>
70 [% IF ( op == 'show') && (!borrowers) && (!notfoundcardnumbers) # Alert if no patrons given%]
71 [% op = 'noshow' # Change op to prevent display in code below %]
72 <h1>Batch patrons modification</h1>
73 <div class="dialog alert">
74 <p>No patron card numbers given.</p>
75 <form action="/cgi-bin/koha/tools/modborrowers.pl" method="get">
76 <button type="submit" class="approve"><i class="fa fa-fw fa-check"></i> OK</button>
79 [% END #Alert if no patrons %]
81 [% IF ( op == 'show' or op == 'show_results' ) %]
82 [% IF ( op == 'show' ) %]
83 <h1>Batch patrons modification</h1>
85 <h1>Batch patrons results</h1>
87 [% IF ( notfoundcardnumbers ) %]
88 <div class="dialog alert"><p>Warning, the following cardnumbers were not found:</p></div>
89 <table style="margin:auto;">
91 <tr><th>Cardnumbers not found</th></tr>
94 [% FOREACH notfoundcardnumber IN notfoundcardnumbers %]
95 <tr><td>[% notfoundcardnumber.cardnumber %]</td></tr>
101 [% IF ( op == 'show_results' ) %]
103 <div class="dialog alert">
104 <h4>Errors occurred:</h4>
105 <ul class="warnings">
106 [% FOREACH error IN errors %]
107 [% IF ( error.error == 'can_not_update' ) %]
108 <li>Can not update patron.
109 [% IF ( error.cardnumber ) %] Cardnumber: [% error.cardnumber %] [% END %]
110 (Borrowernumber: [% error.borrowernumber %])
113 <li>[% error.error %]</li>
121 [% IF ( op == 'show' ) %]
122 <form name="f" action="modborrowers.pl" method="post">
123 <input type="hidden" name="op" value="do" />
124 [% IF ( borrowers ) %]
125 <div id="toolbar"><a id="selectallbutton" href="#"><i class="fa fa-check"></i> Select all</a> | <a id="clearallbutton" href="#"><i class="fa fa-remove"></i> Clear all</a></div>
129 <div id="cataloguing_additem_itemlist">
130 <div style="overflow:auto">
131 <table id="borrowerst">
134 [% IF ( op == 'show' ) %]
144 <th>ZIP/Postal code</th>
146 <th class="title-string">Registration date</th>
147 <th class="title-string">Expiry date</th>
148 <th>Circulation note</th>
150 [% FOREACH attrh IN attributes_header %]
151 <th>[% attrh.attribute %]</th>
156 [% FOREACH borrower IN borrowers %]
158 [% IF ( op == 'show' ) %]
159 <td><input type="checkbox" name="borrowernumber" value="[% borrower.borrowernumber %]" checked="checked" /></td>
161 <td><a href="/cgi-bin/koha/members/moremember.pl?borrowernumber=[% borrower.borrowernumber %]">[% borrower.cardnumber %]</a></td>
162 <td>[% borrower.surname %]</td>
163 <td>[% borrower.firstname %]</td>
164 <td>[% Branches.GetName( borrower.branchcode ) %]</td>
165 <td>[% borrower.category_description %]</td>
166 <td>[% borrower.city %]</td>
167 <td>[% borrower.state %]</td>
168 <td>[% borrower.zipcode %]</td>
169 <td>[% borrower.country %]</td>
170 <td><span title="[% borrower.dateenrolled %]">[% borrower.dateenrolled | $KohaDates %]</span></td>
171 <td><span title="[% borrower.dateexpiry %]">[% borrower.dateexpiry | $KohaDates %]</span></td>
172 <td>[% borrower.borrowernotes %]</td>
173 <td>[% borrower.opacnote %]</td>
174 [% FOREACH pa IN borrower.patron_attributes %]
176 <td>[% pa.code %]=[% pa.value %]</td>
188 [% IF ( op == 'show' ) %]
189 <div id="cataloguing_additem_newitem">
190 <h2>Edit patrons</h2>
191 <div class="hint">Checking the box right next to the label will disable the entry and delete the values of that field on all selected patrons</div>
192 <fieldset class="rows" id="fields_list">
194 [% FOREACH field IN fields %]
196 [% IF ( field.mandatory ) %]
197 <label for="[% field.name %]" class="required">
199 <label for="[% field.name %]">
201 [% SWITCH ( field.name ) %]
204 [% CASE 'firstname' %]
206 [% CASE 'branchcode' %]
208 [% CASE 'categorycode' %]
222 [% CASE 'dateenrolled' %]
224 [% CASE 'dateexpiry' %]
226 [% CASE 'borrowernotes' %]
228 [% CASE 'opacnote' %]
232 [% IF ( field.type == 'text' ) %]
233 <input type="text" name="[% field.name %]" value="" />
235 [% IF ( field.type == 'select' ) %]
236 [% IF field.option.size %]
237 <select name="[% field.name %]" >
238 [% FOREACH opt IN field.option %]
239 <option value="[% opt.value %]">[% opt.lib %]</option>
243 There is no value defined for [% field.name %]
246 [% IF ( field.type == 'date' ) %]
247 <input type="text" name="[% field.name %]" id="[% field.name %]" value="" size="10" maxlength="10" class="datepicker" />
248 <a href="#" class="clear-date" id="clear-date-[% field.name %]" ><i class="fa fa-fw fa-trash"></i> Clear</a>
250 [% IF field.mandatory %]
251 <input type="checkbox" title="This field is mandatory" name="disable_input" value="[% field.name %]" disabled="disabled" readonly="readonly" />
252 <span class="required">Required fields cannot be cleared</span>
254 <input type="checkbox" title="Check to delete this field" name="disable_input" value="[% field.name %]" />
258 [% IF ( patron_attributes_codes ) %]
259 <li class="attributes">
260 <label style="width:auto;">Attribute:
261 <select name="patron_attributes">
262 <option value=""></option>
263 [% FOREACH pac IN patron_attributes_codes %]
264 <option value="[% pac.attribute_code %]" data-type="[% pac.type %]" data-category="[% pac.category_lib %]">[% pac.attribute_lib %]</option>
268 <input type="checkbox" title="check to delete this field" name="disable_input" value="attr0_value" />
269 <span class="patron_attributes_value"></span>
270 <a href="#" class="add_attributes" title="Add an attribute"><i class="fa fa-fw fa-plus"></i> New</a>
271 <span class="information_category hint" style="width:25%;float:right;"></span>
276 <fieldset class="action">
277 <input type="submit" name="mainformsubmit" value="Save" />
278 <a href="/cgi-bin/koha/tools/modborrowers.pl" class="cancel">Cancel</a>
285 [% IF ( op == 'show_results' ) %]
287 <a href="/cgi-bin/koha/tools/modborrowers.pl" title="New batch patrons modification">New batch patron modification</a>
293 [% INCLUDE 'tools-menu.inc' %]
297 [% MACRO jsinclude BLOCK %]
298 [% INCLUDE 'calendar.inc' %]
299 [% INCLUDE 'datatables.inc' %]
300 [% Asset.js("js/tools-menu.js") %]
301 <script type="text/javascript">
302 var patron_attributes_lib = new Array();
303 var patron_attributes_values = new Array();
304 $(document).ready(function() {
306 $("#borrowerst").dataTable($.extend(true, {}, dataTablesDefaults, {
308 [% IF ( op == 'show_results' ) %]
310 { 'sType': "title-string", 'aTargets' : [ 'title-string'] }
314 { "aTargets": [ 0 ], "bSortable": false, "bSearchable": false },
315 { 'sType': "title-string", 'aTargets' : [ 'title-string'] }
320 $("#selectallbutton").click(function() {
321 $("#borrowerst").find("input:checkbox").each(function() {
322 $(this).prop("checked", true);
326 $("#clearallbutton").click(function() {
327 $("#borrowerst").find("input:checkbox").each(function() {
328 $(this).prop("checked", false);
334 var values = new Array();
335 var lib = new Array();
336 [% FOREACH pav IN patron_attributes_values %]
337 values = new Array();
339 [% FOREACH option IN pav.options %]
340 values.push("[% option.lib %]");
341 lib.push("[% option.authorised_value %]");
343 patron_attributes_lib["[% pav.attribute_code %]"] = values;
344 patron_attributes_values["[% pav.attribute_code %]"] = lib;
347 $('select[name="patron_attributes"]').change(function() {
348 updateAttrValues(this);
351 $('select[name="patron_attributes"]').change();
353 $(".clear-date").on("click",function(e){
355 var fieldID = this.id.replace("clear-date-","");
356 $("#" + fieldID).val("");
358 $("#cataloguing_additem_newitem").on("click",".add_attributes",function(e){
362 $("#cataloguing_additem_newitem").on("click",".del_attributes",function(e){
364 del_attributes(this);
368 function updateAttrValues (select_attr) {
369 var attr_code = $(select_attr).val();
370 var selected_option = $(select_attr).find("option:selected");
371 var type = $(selected_option).attr('data-type');
372 var category = $(selected_option).attr('data-category');
373 var li_node = $(select_attr).parent().parent();
374 var span = $(li_node).find('span.patron_attributes_value');
375 var information_category_node = $(li_node).find('span.information_category');
376 information_category_node.html("");
378 if ( category && category.length > 0 ) {
379 information_category_node.html(_("This attribute will be only applied to the patron's category %s").format(category));
381 var disable_input_node = $(li_node).find("input:checkbox[name='disable_input']");
382 if ( type == 'select' ) {
383 var options = '<option value = ""></option>';
384 for ( var i = 0 ; i < patron_attributes_values[attr_code].length ; i++ ) {
385 options += '<option value="'+patron_attributes_values[attr_code][i]+'">'+patron_attributes_lib[attr_code][i]+'</option>';
387 span.html('<select name="patron_attributes_value">' + options + '</select>');
388 $(disable_input_node).show();
389 } else if ( $(selected_option).val() != "" ) {
390 span.html('<input type="text" name="patron_attributes_value"/>');
391 $(disable_input_node).show();
394 $(disable_input_node).hide();
398 function add_attributes() {
399 var li_node = $("li.attributes:last");
400 var li_clone = $(li_node).clone();
401 if ( $(li_clone).find("a.del_attributes").length == 0 ) {
402 $(li_clone).append('<a href="#" title="' + _("Delete") + '" class="del_attributes"><i class="fa fa-fw fa-trash"></i> ' + _("Delete") + '</a>');
404 $(li_clone).find('select[name="patron_attributes"]').change(function() {
405 updateAttrValues(this);
408 $(li_clone).find('select[name="patron_attributes"]').change();
410 $("#fields_list>ol").append(li_clone);
411 update_attr_values();
414 function del_attributes(a_node) {
415 $(a_node).parent('li').remove();
416 update_attr_values();
419 function update_attr_values() {
420 $("li.attributes").each(function(i) {
421 $(this).find("input:checkbox").val("attr"+i+"_value");
424 function clearDate(nodeid) {
425 $("#"+nodeid).val("");
430 [% INCLUDE 'intranet-bottom.inc' %]