Server IP : 173.249.157.85 / Your IP : 216.73.216.232 Web Server : Apache System : Linux server.frogzhost.com 3.10.0-1127.19.1.el7.x86_64 #1 SMP Tue Aug 25 17:23:54 UTC 2020 x86_64 User : econtech ( 1005) PHP Version : 7.3.33 Disable Function : NONE MySQL : OFF | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/econtech/www/public/back/assets/js/demo4/pages/crud/metronic-datatable/api/ |
Upload File : |
"use strict"; // Class definition var KTDefaultDatatableDemo = function() { // Private functions // basic demo var demo = function() { var options = { // datasource definition data: { type: 'remote', source: { read: { url: 'https://keenthemes.com/metronic/themes/themes/metronic/dist/preview/inc/api/datatables/demos/default.php', }, }, pageSize: 20, // display 20 records per page serverPaging: true, serverFiltering: true, serverSorting: true, }, // layout definition layout: { scroll: true, // enable/disable datatable scroll both horizontal and vertical when needed. height: 550, // datatable's body's fixed height footer: false, // display/hide footer }, // column sorting sortable: true, pagination: true, search: { input: $('#generalSearch'), }, // columns definition columns: [ { field: 'RecordID', title: '#', sortable: false, width: 30, type: 'number', selector: {class: 'kt-checkbox--solid'}, textAlign: 'center', }, { field: 'ID', title: 'ID', width: 30, type: 'number', template: function(row) { return row.RecordID; }, }, { field: 'OrderID', title: 'Order ID', }, { 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': 'kt-badge--brand'}, 2: {'title': 'Delivered', 'class': ' kt-badge--danger'}, 3: {'title': 'Canceled', 'class': ' kt-badge--primary'}, 4: {'title': 'Success', 'class': ' kt-badge--success'}, 5: {'title': 'Info', 'class': ' kt-badge--info'}, 6: {'title': 'Danger', 'class': ' kt-badge--danger'}, 7: {'title': 'Warning', 'class': ' kt-badge--warning'}, }; return '<span class="kt-badge ' + status[row.Status].class + ' kt-badge--inline kt-badge--pill">' + status[row.Status].title + '</span>'; }, }, { 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 '<span class="kt-badge kt-badge--' + status[row.Type].state + ' kt-badge--dot"></span> <span class="kt-font-bold kt-font-' + status[row.Type].state + '">' + status[row.Type].title + '</span>'; }, }, { field: 'Actions', title: 'Actions', sortable: false, width: 110, overflow: 'visible', autoHide: false, template: function() { return '\ <div class="dropdown">\ <a href="javascript:;" class="btn btn-sm btn-clean btn-icon btn-icon-md" data-toggle="dropdown">\ <i class="la la-ellipsis-h"></i>\ </a>\ <div class="dropdown-menu dropdown-menu-right">\ <a class="dropdown-item" href="#"><i class="la la-edit"></i> Edit Details</a>\ <a class="dropdown-item" href="#"><i class="la la-leaf"></i> Update Status</a>\ <a class="dropdown-item" href="#"><i class="la la-print"></i> Generate Report</a>\ </div>\ </div>\ <a href="javascript:;" class="btn btn-sm btn-clean btn-icon btn-icon-md" title="Edit details">\ <i class="la la-edit"></i>\ </a>\ <a href="javascript:;" class="btn btn-sm btn-clean btn-icon btn-icon-md" title="Delete">\ <i class="la la-trash"></i>\ </a>\ '; }, }], }; var datatable = $('.kt-datatable').KTDatatable(options); // both methods are supported // datatable.methodName(args); or $(datatable).KTDatatable(methodName, args); $('#kt_datatable_destroy').on('click', function() { // datatable.destroy(); $('.kt-datatable').KTDatatable('destroy'); }); $('#kt_datatable_init').on('click', function() { datatable = $('.kt-datatable').KTDatatable(options); }); $('#kt_datatable_reload').on('click', function() { // datatable.reload(); $('.kt-datatable').KTDatatable('reload'); }); $('#kt_datatable_sort_asc').on('click', function() { datatable.sort('Status', 'asc'); }); $('#kt_datatable_sort_desc').on('click', function() { datatable.sort('Status', 'desc'); }); // get checked record and get value by column name $('#kt_datatable_get').on('click', function() { // select active rows datatable.rows('.kt-datatable__row--active'); // check selected nodes if (datatable.nodes().length > 0) { // get column by field name and get the column nodes var value = datatable.columns('CompanyName').nodes().text(); console.log(value); } }); // record selection $('#kt_datatable_check').on('click', function() { var input = $('#kt_datatable_check_input').val(); datatable.setActive(input); }); $('#kt_datatable_check_all').on('click', function() { // datatable.setActiveAll(true); $('.kt-datatable').KTDatatable('setActiveAll', true); }); $('#kt_datatable_uncheck_all').on('click', function() { // datatable.setActiveAll(false); $('.kt-datatable').KTDatatable('setActiveAll', false); }); $('#kt_datatable_hide_column').on('click', function() { datatable.columns('ShipDate').visible(false); }); $('#kt_datatable_show_column').on('click', function() { datatable.columns('ShipDate').visible(true); }); $('#kt_datatable_remove_row').on('click', function() { datatable.rows('.kt-datatable__row--active').remove(); }); $('#kt_form_status,#kt_form_type').selectpicker(); }; return { // public functions init: function() { demo(); }, }; }(); jQuery(document).ready(function() { KTDefaultDatatableDemo.init(); });