/* ------------------------------------------------------------------------------
*
* # Fixed Columns extension for Datatables
*
* Specific JS code additions for datatable_extension_fixed_columns.html page
*
* Version: 1.0
* Latest update: Aug 1, 2015
*
* ---------------------------------------------------------------------------- */
$(function() {
// Table setup
// ------------------------------
// Setting datatable defaults
$.extend( $.fn.dataTable.defaults, {
columnDefs: [{
orderable: false,
width: '100px',
targets: [ 5 ]
}],
dom: '<"datatable-header"fl><"datatable-scroll datatable-scroll-wrap"t><"datatable-footer"ip>',
language: {
search: 'Filter: _INPUT_',
lengthMenu: 'Show: _MENU_',
paginate: { 'first': 'First', 'last': 'Last', 'next': '→', 'previous': '←' }
}
});
// Left fixed column example
$('.datatable-fixed-left').DataTable({
columnDefs: [
{
orderable: false,
targets: [5]
},
{
width: "200px",
targets: [0]
},
{
width: "300px",
targets: [1]
},
{
width: "200px",
targets: [5, 6]
},
{
width: "100px",
targets: [4]
}
],
scrollX: true,
scrollY: '350px',
scrollCollapse: true,
fixedColumns: true
});
// Right fixed column example
$('.datatable-fixed-right').DataTable({
columnDefs: [
{
orderable: false,
targets: [5]
},
{
width: "300px",
targets: [0]
},
{
width: "300px",
targets: [1]
},
{
width: "200px",
targets: [5, 6]
},
{
width: "100px",
targets: [3, 4]
}
],
scrollX: true,
scrollY: '350px',
scrollCollapse: true,
fixedColumns: {
leftColumns: 0,
rightColumns: 1
}
});
// Left and right fixed columns
$('.datatable-fixed-both').DataTable({
columnDefs: [
{
orderable: false,
targets: [ 5 ]
},
{
width: "200px",
targets: [0]
},
{
width: "100px",
targets: [1]
},
{
width: "200px",
targets: [5, 6]
},
{
width: "100px",
targets: [4]
}
],
scrollX: true,
scrollY: '350px',
scrollCollapse: true,
fixedColumns: {
leftColumns: 1,
rightColumns: 1
}
});
//
// Fixed column with complex headers
//
// Initialize
var table = $('.datatable-fixed-complex').DataTable({
autoWidth: false,
columnDefs: [
{
orderable: false,
targets: [5]
},
{
width: "250px",
targets: [0]
},
{
width: "250px",
targets: [1]
},
{
width: "200px",
targets: [5, 6]
},
{
width: "100px",
targets: [4]
}
],
scrollX: true,
scrollY: '350px',
scrollCollapse: true,
fixedColumns: true
});
// Adjust columns on window resize
setTimeout(function() {
$(window).on('resize', function () {
table.columns.adjust();
});
}, 100);
// External table additions
// ------------------------------
// Add placeholder to the datatable filter option
$('.dataTables_filter input[type=search]').attr('placeholder','Type to filter...');
// Enable Select2 select for the length option
$('.dataTables_length select').select2({
minimumResultsForSearch: Infinity,
width: 'auto'
});
});