"use strict";
// Class definition
var KTDatatableColumnRenderingDemo = function() {
// Private functions
// basic demo
var demo = function() {
var datatable = $('#kt_datatable').KTDatatable({
// datasource definition
data: {
type: 'remote',
source: {
read: {
url: HOST_URL + '/api/datatables/demos/default.php',
},
},
pageSize: 10, // display 20 records per page
serverPaging: true,
serverFiltering: true,
serverSorting: true,
},
// layout definition
layout: {
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: $('#kt_datatable_search_query'),
delay: 400,
key: 'generalSearch'
},
// columns definition
columns: [
{
field: 'RecordID',
title: '#',
sortable: 'asc',
width: 40,
type: 'number',
selector: false,
textAlign: 'center',
}, {
field: 'OrderID',
title: 'Customer',
width: 250,
template: function(data) {
var number = KTUtil.getRandomInt(1, 14);
var user_img = 'background-image:url(\'assets/media/users/100_' + number + '.jpg\')';
var output = '';
if (number > 8) {
output = '
';
}
else {
var stateNo = KTUtil.getRandomInt(0, 7);
var states = [
'success',
'primary',
'danger',
'success',
'warning',
'dark',
'primary',
'info'];
var state = states[stateNo];
output = '\
\
' + data.CompanyAgent.substring(0, 1) + '
\
\
\
';
}
return output;
},
}, {
field: 'Country',
title: 'Country',
template: function(row) {
return row.Country + ' ' + row.ShipCountry;
},
}, {
field: 'ShipDate',
title: 'Ship Date',
type: 'date',
format: 'MM/DD/YYYY',
}, {
field: 'CompanyName',
title: 'Company Name',
}, {
field: 'Status',
title: 'Status',
// callback function support for column rendering
template: function(row) {
var status = {
1: {'title': 'Pending', 'class': ' label-light-primary'},
2: {'title': 'Delivered', 'class': ' label-light-danger'},
3: {'title': 'Canceled', 'class': ' label-light-primary'},
4: {'title': 'Success', 'class': ' label-light-success'},
5: {'title': 'Info', 'class': ' label-light-info'},
6: {'title': 'Danger', 'class': ' label-light-danger'},
7: {'title': 'Warning', 'class': ' label-light-warning'},
};
return '' + status[row.Status].title + '';
},
}, {
field: 'Type',
title: 'Type',
autoHide: false,
// callback function support for column rendering
template: function(row) {
var status = {
1: {'title': 'Online', 'state': 'danger'},
2: {'title': 'Retail', 'state': 'primary'},
3: {'title': 'Direct', 'state': 'success'},
};
return '' +
status[row.Type].title + '';
},
}, {
field: 'Actions',
title: 'Actions',
sortable: false,
width: 125,
overflow: 'visible',
autoHide: false,
template: function() {
return '\
\
\
\
\
\
\
\
\
\
\
\
';
},
}],
});
$('#kt_datatable_search_status').on('change', function() {
datatable.search($(this).val().toLowerCase(), 'Status');
});
$('#kt_datatable_search_type').on('change', function() {
datatable.search($(this).val().toLowerCase(), 'Type');
});
$('#kt_datatable_search_status, #kt_datatable_search_type').selectpicker();
};
return {
// public functions
init: function() {
demo();
},
};
}();
jQuery(document).ready(function() {
KTDatatableColumnRenderingDemo.init();
});