Created
September 24, 2013 01:35
-
-
Save dealproc/6679280 to your computer and use it in GitHub Desktop.
jQuery Data Tables - Bootstrap UI with OData Parsing for reading/loading Data.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* Default class modification */ | |
$.extend($.fn.dataTableExt.oStdClasses, { | |
"sWrapper": "dataTables_wrapper form-inline" | |
}); | |
/* API method to get paging information */ | |
$.fn.dataTableExt.oApi.fnPagingInfo = function (oSettings) { | |
return { | |
"iStart": oSettings._iDisplayStart, | |
"iEnd": oSettings.fnDisplayEnd(), | |
"iLength": oSettings._iDisplayLength, | |
"iTotal": oSettings.fnRecordsTotal(), | |
"iFilteredTotal": oSettings.fnRecordsDisplay(), | |
"iPage": oSettings._iDisplayLength === -1 ? | |
0 : Math.ceil(oSettings._iDisplayStart / oSettings._iDisplayLength), | |
"iTotalPages": oSettings._iDisplayLength === -1 ? | |
0 : Math.ceil(oSettings.fnRecordsDisplay() / oSettings._iDisplayLength) | |
}; | |
}; | |
/* Bootstrap style pagination control */ | |
$.extend($.fn.dataTableExt.oPagination, { | |
bootstrap: { | |
fnInit: function (oSettings, nPaging, fnDraw) { | |
var oLang = oSettings.oLanguage.oPaginate; | |
var fnClickHandler = function (e) { | |
e.preventDefault(); | |
if (oSettings.oApi._fnPageChange(oSettings, e.data.action)) { | |
fnDraw(oSettings); | |
} | |
}; | |
$(nPaging).addClass('pagination').append( | |
'<ul>' + | |
'<li class="prev disabled"><a href="#">← ' + oLang.sPrevious + '</a></li>' + | |
'<li class="next disabled"><a href="#">' + oLang.sNext + ' → </a></li>' + | |
'</ul>' | |
); | |
var els = $('a', nPaging); | |
$(els[0]).bind('click.DT', { action: "previous" }, fnClickHandler); | |
$(els[1]).bind('click.DT', { action: "next" }, fnClickHandler); | |
}, | |
fnUpdate: function (oSettings, fnDraw) { | |
var iListLength = 5; | |
var oPaging = oSettings.oInstance.fnPagingInfo(); | |
var an = oSettings.aanFeatures.p; | |
var i, ien, j, sClass, iStart, iEnd, iHalf = Math.floor(iListLength / 2); | |
if (oPaging.iTotalPages < iListLength) { | |
iStart = 1; | |
iEnd = oPaging.iTotalPages; | |
} | |
else if (oPaging.iPage <= iHalf) { | |
iStart = 1; | |
iEnd = iListLength; | |
} else if (oPaging.iPage >= (oPaging.iTotalPages - iHalf)) { | |
iStart = oPaging.iTotalPages - iListLength + 1; | |
iEnd = oPaging.iTotalPages; | |
} else { | |
iStart = oPaging.iPage - iHalf + 1; | |
iEnd = iStart + iListLength - 1; | |
} | |
for (i = 0, ien = an.length ; i < ien ; i++) { | |
// Remove the middle elements | |
$('li:gt(0)', an[i]).filter(':not(:last)').remove(); | |
// Add the new list items and their event handlers | |
for (j = iStart ; j <= iEnd ; j++) { | |
sClass = (j === oPaging.iPage + 1) ? 'class="active"' : ''; | |
$('<li ' + sClass + '><a href="#">' + j + '</a></li>') | |
.insertBefore($('li:last', an[i])[0]) | |
.bind('click', function (e) { | |
e.preventDefault(); | |
oSettings._iDisplayStart = (parseInt($('a', this).text(), 10) - 1) * oPaging.iLength; | |
fnDraw(oSettings); | |
}); | |
} | |
// Add / remove disabled classes from the static elements | |
if (oPaging.iPage === 0) { | |
$('li:first', an[i]).addClass('disabled'); | |
} else { | |
$('li:first', an[i]).removeClass('disabled'); | |
} | |
if (oPaging.iPage === oPaging.iTotalPages - 1 || oPaging.iTotalPages === 0) { | |
$('li:last', an[i]).addClass('disabled'); | |
} else { | |
$('li:last', an[i]).removeClass('disabled'); | |
} | |
} | |
} | |
} | |
}); | |
/* | |
* TableTools Bootstrap compatibility | |
* Required TableTools 2.1+ | |
*/ | |
if ($.fn.DataTable.TableTools) { | |
// Set the classes that TableTools uses to something suitable for Bootstrap | |
$.extend(true, $.fn.DataTable.TableTools.classes, { | |
"container": "DTTT btn-group", | |
"buttons": { | |
"normal": "btn", | |
"disabled": "disabled" | |
}, | |
"collection": { | |
"container": "DTTT_dropdown dropdown-menu", | |
"buttons": { | |
"normal": "", | |
"disabled": "disabled" | |
} | |
}, | |
"print": { | |
"info": "DTTT_print_info modal" | |
}, | |
"select": { | |
"row": "active" | |
} | |
}); | |
// Have the collection use a bootstrap compatible dropdown | |
$.extend(true, $.fn.DataTable.TableTools.DEFAULTS.oTags, { | |
"collection": { | |
"container": "ul", | |
"button": "li", | |
"liner": "a" | |
} | |
}); | |
} | |
var resultsCallback = function (data) { | |
return { | |
iTotalRecords: data.Count || 0, | |
iTotalDisplayRecords: data.Items.length || 0, | |
aaData: data.Items || [] | |
}; | |
}; | |
var readDataTableValue = function (propertyName, aoData) { | |
var properties = $.grep(aoData, function (elem, idx) { | |
return elem.name === propertyName; | |
}); | |
if (properties.length) { | |
return properties[0].value; | |
} else { | |
return undefined; | |
} | |
}; | |
/* Set the defaults for DataTables initialisation */ | |
$.extend(true, $.fn.dataTable.defaults, { | |
sDom: "<'row-fluid'<'span6'l><'span6'f>r>t<'row-fluid'<'span6'i><'span6'p>>", | |
bPaginate: true, | |
sPaginationType: "bootstrap", | |
oLanguage: { | |
sLengthMenu: "_MENU_ records per page" | |
}, | |
/// Translate grid's API to be OData calls. | |
fnServerData: function (sUrl, aoData, fnCallback, oSettings) { | |
oDataOptions = { | |
$inlinecount: "allpages", | |
$skip: readDataTableValue("iDisplayStart", aoData), | |
$top: readDataTableValue("iDisplayLength", aoData) | |
}; | |
oSettings.jqXHR = $.ajax({ | |
url: sUrl, | |
data: oDataOptions, | |
dataType: "json", | |
success: function (data) { | |
var result = resultsCallback(data); | |
fnCallback(result); | |
}, | |
error: function (xhr, textStatus, errorThrown) { | |
app.showMessage(errorThrown); | |
} | |
}); | |
} | |
}); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment