borrowers.borrowernotes, borrowers.branchcode, borrowers.email,
borrowers.userid, borrowers.dateofbirth, borrowers.categorycode,
categories.description AS category_description, categories.category_type,
- branches.branchname";
+ branches.branchname, borrowers.phone";
my $from = "FROM borrowers
LEFT JOIN branches ON borrowers.branchcode = branches.branchcode
LEFT JOIN categories ON borrowers.categorycode = categories.categorycode";
columnname: export
cannot_be_toggled: 1
cannot_be_modified: 1
-
+ table_borrowers:
+ -
+ columnname: name
+ cannot_be_toggled: 1
+ cannot_be_modified: 1
+ -
+ columnname: cardnumber
+ -
+ columnname: date_of_birth
+ -
+ columnname: category
+ -
+ columnname: library
+ -
+ columnname: address
+ -
+ columnname: phone
+ is_hidden: 1
returns:
checkedintable:
-
<th>Category</th>
<th>Library</th>
<th>Address</th>
+ <th>Primary phone</th>
</tr>
</thead>
<tbody>
<td>[% Categories.GetName( borrower.categorycode ) | html %]</td>
<td>[% Branches.GetName( borrower.branchcode ) | html %]</td>
<td>[% borrower.address | html %]</td>
+ <td>[% borrower.phone | html %]</td>
</tr>
[% END %]
</tbody>
var MSG_EXPORT_SELECT_CHECKOUTS = _("You must select checkout(s) to export");
var MSG_CONFIRM_DELETE_MESSAGE = _("Are you sure you want to delete this message? This cannot be undone.");
- columns_settings = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'issues-table', 'json' ) | $raw %]
+ columns_settings_issues_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'issues-table', 'json' ) | $raw %]
+ columns_settings_borrowers_table = [% ColumnsSettings.GetColumns( 'circ', 'circulation', 'table_borrowers', 'json' ) | $raw %]
[% IF borrowernumber and patron %]
if($.cookie("holdfor") != [% patron.borrowernumber | html %]){
.append(ul)
.insertBefore(oSettings.nTableWrapper)
},
- }, columns_settings).rowGrouping(
+ }, columns_settings_issues_table).rowGrouping(
{
iGroupingColumnIndex: 1,
iGroupingOrderByColumnIndex: 0,
$(".clickable").click(function() {
window.document.location = $(this).data('url');
});
- var table = $("#table_borrowers").dataTable($.extend(true, {}, dataTablesDefaults, {
- "aaSorting": [ 0, "asc" ],
- "sDom": "t",
- "iDisplayLength": -1
- }));
-});
\ No newline at end of file
+ var table = KohaTable("table_borrowers",
+ {
+ "aaSorting": [ 0, "asc" ],
+ "sDom": "t",
+ "iDisplayLength": -1
+ },
+ columns_settings_borrowers_table, null);
+});