//== Class definition
var DatatableColumnRenderingDemo = function() {
//== Private functions
// basic demo
var demo = function() {
var datatable = $('.m_datatable').mDatatable({
// datasource definition
data: {
type: 'remote',
source: {
read: {
url: 'http://keenthemes.com/metronic/preview/inc/api/datatables/demos/default.php',
},
},
pageSize: 10, // display 20 records per page
serverPaging: true,
serverFiltering: true,
serverSorting: true,
},
// layout definition
layout: {
theme: 'default', // datatable theme
class: '', // custom wrapper class
scroll: false, // enable/disable datatable scroll both horizontal and vertical when needed.
footer: false // display/hide footer
},
// column sorting
sortable: true,
pagination: true,
search: {
input: $('#generalSearch'),
delay: 400,
},
rows: {
callback: function(row, data, index) {
},
},
// columns definition
columns: [
{
field: 'RecordID',
title: '#',
sortable: false, // disable sort for this column
width: 40,
textAlign: 'center',
selector: {class: 'm-checkbox--solid m-checkbox--brand'},
}, {
width: 200,
field: 'CompanyAgent',
title: 'Agent',
template: function(data) {
var number = mUtil.getRandomInt(1, 14);
var user_img = '100_' + number + '.jpg';
if (number > 8) {
output = '
\
\

\
\
\
';
} else {
var stateNo = mUtil.getRandomInt(0, 7);
var states = [
'success',
'brand',
'danger',
'accent',
'warning',
'metal',
'primary',
'info'];
var state = states[stateNo];
output = '\
\
' + data.CompanyAgent.substring(0, 1) + '
\
\
\
';
}
return output;
},
}, {
field: 'ShipCountry',
title: 'Ship Country',
width: 150,
// callback function support for column rendering
template: function(data) {
return data.ShipCountry + ' - ' + data.ShipCity;
},
}, {
field: 'ShipAddress',
title: 'Ship Address',
width: 200,
}, {
field: 'CompanyEmail',
title: 'Email',
width: 150,
template: function(data) {
return '' +
data.CompanyEmail + '';
},
}, {
field: 'Status',
title: 'Status',
// callback function support for column rendering
template: function(data) {
var status = {
1: {'title': 'Pending', 'class': 'm-badge--brand'},
2: {'title': 'Delivered', 'class': ' m-badge--metal'},
3: {'title': 'Canceled', 'class': ' m-badge--primary'},
4: {'title': 'Success', 'class': ' m-badge--success'},
5: {'title': 'Info', 'class': ' m-badge--info'},
6: {'title': 'Danger', 'class': ' m-badge--danger'},
7: {'title': 'Warning', 'class': ' m-badge--warning'},
};
return '' + status[data.Status].title + '';
},
}, {
field: 'Type',
title: 'Type',
// callback function support for column rendering
template: function(data) {
var status = {
1: {'title': 'Online', 'state': 'danger'},
2: {'title': 'Retail', 'state': 'primary'},
3: {'title': 'Direct', 'state': 'accent'},
};
return ' ' + status[data.Type].title +
'';
},
}, {
field: 'Actions',
width: 110,
title: 'Actions',
sortable: false,
overflow: 'visible',
template: function (row, index, datatable) {
var dropup = (datatable.getPageSize() - index) <= 4 ? 'dropup' : '';
return '\
\
\
\
\
\
\
\
';
},
}],
});
var query = datatable.getDataSourceQuery();
$('#m_form_status').on('change', function() {
// shortcode to datatable.getDataSourceParam('query');
var query = datatable.getDataSourceQuery();
query.Status = $(this).val().toLowerCase();
// shortcode to datatable.setDataSourceParam('query', query);
datatable.setDataSourceQuery(query);
datatable.load();
}).val(typeof query.Status !== 'undefined' ? query.Status : '');
$('#m_form_type').on('change', function() {
// shortcode to datatable.getDataSourceParam('query');
var query = datatable.getDataSourceQuery();
query.Type = $(this).val().toLowerCase();
// shortcode to datatable.setDataSourceParam('query', query);
datatable.setDataSourceQuery(query);
datatable.load();
}).val(typeof query.Type !== 'undefined' ? query.Type : '');
$('#m_form_status, #m_form_type').selectpicker();
};
return {
// public functions
init: function() {
demo();
},
};
}();
jQuery(document).ready(function() {
DatatableColumnRenderingDemo.init();
});