Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var columns = [
- {name: 'graphics', data: 'graphics', className: 'body-graph', searchable: false, orderable: false},
- {name: 'idErp', data: 'idErp', orderable: false},
- {name: 'name', data: 'name'},
- {name: 'user', data: 'user', orderable: false},
- {name: 'abc', data: 'abc'},
- {name: 'city', data: 'city', orderable: false},
- {name: 'uf', data: 'uf', orderable: false},
- {name: 'industry', data: 'industry', orderable: false},
- {name: 'segment', data: 'segment', orderable: false},
- {name: 'ticket', data: 'ticket', orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'right');
- }
- },
- {name: 'ticketMonth', data: 'ticketMonth', orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'right');
- }
- },
- {name: 'evolution', data: 'evolution',
- createdCell: function (td, cellData) {
- var evolution = cellData.match(/\-?[0-9]+/g)[0];
- if (evolution > 0) {
- $(td).addClass('text-success');
- } else if (evolution < 0) {
- $(td).addClass('text-danger');
- }
- }
- },
- {name: 'calls', data: 'calls', searchable: false, orderable: false},
- {name: 'lastProductiveCall', data: 'lastProductiveCall', orderable: false},
- {name: 'nextCall', data: 'nextCall', orderable: false},
- ];
- columns.push({name: 'freqTotal', data: 'freqTotal', searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'center');
- }
- });
- columns.push({name: 'freqCurrent', data: 'freqCurrent', searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'center');
- }
- });
- for (var i = 1; i <= 12; i++) {
- columns.push({name: 'freqCurrent' + i, data: 'freqCurrent' + i, searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'center');
- }
- });
- }
- columns.push({name: 'freqPast', data: 'freqPast', searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'center');
- }
- });
- for (var i = 1; i <= 12; i++) {
- columns.push({name: 'freqPast' + i, data: 'freqPast' + i, searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'center');
- }
- });
- }
- columns.push({name: 'valTotal', data: 'valTotal', searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'right');
- }
- });
- columns.push({name: 'valCurrent', data: 'valCurrent', searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'right');
- }
- });
- for (var i = 1; i <= 12; i++) {
- columns.push({name: 'valCurrent' + i, data: 'valCurrent' + i, searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'right');
- }
- });
- }
- columns.push({name: 'valPast', data: 'valPast', searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'right');
- }
- });
- for (var i = 1; i <= 12; i++) {
- columns.push({name: 'valPast' + i, data: 'valPast' + i, searchable: false, orderable: false,
- createdCell: function (td) {
- $(td).css('text-align', 'right');
- }
- });
- }
- var dataTable = $('#table-abc')
- .on('processing.dt', function (e, settings, processing) {
- $(this).css('display', processing ? 'none' : 'table');
- if (!processing) {
- $('[data-toggle="tooltip"]').tooltipster();
- }
- })
- .DataTable({
- oLanguage: {
- sEmptyTable: 'Nenhum registro encontrado',
- sInfo: 'Mostrando de _START_ até _END_ de _TOTAL_ registros',
- sInfoEmpty: 'Mostrando 0 até 0 de 0 registros',
- sInfoFiltered: '(Filtrados de _MAX_ registros)',
- sInfoPostFix: '',
- sInfoThousands: '.',
- sLengthMenu: '_MENU_ resultados por página',
- sLoadingRecords: 'Carregando',
- sProcessing: 'Carregando',
- sZeroRecords: 'Nenhum registro encontrado',
- sSearch: 'Pesquisar',
- oPaginate: {
- sNext: 'Próximo',
- sPrevious: 'Anterior',
- sFirst: 'Primeiro',
- sLast: 'Último'
- },
- oAria: {
- sSortAscending: ': Ordenar colunas de forma ascendente',
- sSortDescending: ': Ordenar colunas de forma descendente'
- }
- },
- autoWidth: false,
- scrollY: 500,
- scrollX: true,
- scrollCollapse: true,
- fixedColumns: {
- leftColumns: 2,
- },
- searching: true,
- ordering: true,
- order: [4, 'asc'],
- paging: true,
- pageLength: 20,
- lengthChange: false,
- processing: true,
- serverSide: true,
- ajax: {
- url: 'index.php?componente=Abc&acao=DataTableAtendente',
- type: 'POST',
- data: {
- year: <?php echo $year; ?>,
- userId: '<?php echo $selectedUser['id']; ?>',
- },
- },
- columns: columns,
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement