codice:
/*APERTURA DOCUMENTO CONFIGRAZIONE TABELLA*/
$('#datatable').DataTable({
/*APERTURA DOCUMENTO CONFIGRAZIONE FILTRI*/
"scrollY": "560px",
"scrollCollapse": true,
"paging": false,
/* PULSANTI TABELLA E IMPOSTAZIONI TABELLA*/
dom: 'Bfrtip',
buttons: {
dom: {
button: {
tag: 'button',
className: ''
}
},
buttons: [
{
extend: 'copy',
className: 'btn btn-outline-warning',
titleAttr: 'Copia Tabella',
text: '<span class="btn-label"><i class="fa fa-copy"></i></span> Copia',
exportOption:{columns:[1,2,3]}
},
{
extend: 'excel',
className: 'btn btn-outline-success',
titleAttr: 'Esporta Tabella su Excel',
text: '<span class="btn-label"><i class="fa fa-file-excel-o"></i></span> Excel',
filename: 'Progetti-Pianificazione-Export',
sheetEmptyCells:'Pagina1',
messageTop: 'message',
extension: '.xlsx',
orientation : 'landscape',
exportOption:{ columns:[1,2,3]}
}
]
},
/* CARICAMENTO DATI */
"responsive":true,
"bProcessing":true,
"fnRowCallback": function( nRow, aData, iDisplayIndex, iDisplayIndexFull ) {
if ( aData.id_update == 0)
{
$('td', nRow).css('background-color', '#FFFF00');
}
},
"sAjaxSource": "../php/ajax_allsel.php",
"fnServerParams": function ( aoData ) {
aoData.push( { "name": "Tipo_Sel", "value": "PROG" } );
},
"sServerMethod": "POST",
"aoColumns": [
{
sortable:false,
className: 'dt-body-nowrap',
"render" : function(data,type,row){
$btn='';
if (row.id_status==1)
{
$btn= $btn + '<button type="button" name="status" id="'+row.id+'" value="0" class="btn btn-outline-success btn-sm flg" data-toggle="tooltip" data-placement="right" title="Nascondi" data-dismiss="modal"><i class="fa fa-eye fa-lg" style="color:green"></i></button>';
}
else
{
$btn= $btn + '<button type="button" name="status" id="'+row.id+'" value="1" class="btn btn-outline-danger btn-sm flg" data-toggle="tooltip" data-placement="right" title="Visualizza" data-dismiss="modal"><i class="fa fa-eye-slash fa-lg" style="color:red"></i></button>';
}
if (row.id_blocco==1)
{
$btn= $btn + '<button type="button" name="lock" id="'+row.id+'" value="0" class="btn btn-outline-success btn-sm flg" data-toggle="tooltip" data-placement="right" title="Sblocca" data-dismiss="modal"><i class="fa fa-lock fa-lg" style="color:green"></i></button>';
}
else
{
$btn= $btn + '<button type="button" name="lock" id="'+row.id+'" value="1" class="btn btn-outline-danger btn-sm flg" data-toggle="tooltip" data-placement="right" title="Blocca" data-dismiss="modal"><i class="fa fa-unlock-alt fa-lg" style="color:red"></i></button>';
}
if (row.id_statistic==1)
{
$btn= $btn + '<button type="button" name="statistic" id="'+row.id+'" value="0" class="btn btn-outline-success btn-sm flg" data-toggle="tooltip" data-placement="right" title="Nascondi" data-dismiss="modal"><i class="fa fa-bar-chart fa-lg" style="color:green"></i></button>';
}
else
{
$btn= $btn + '<button type="button" name="statistic" id="'+row.id+'" value="1" class="btn btn-outline-danger btn-sm flg" data-toggle="tooltip" data-placement="right" title="Visualizza" data-dismiss="modal"><i class="fa fa-bar-chart fa-lg" style="color:red"></i></button>';
}
$btn= $btn + '<button type="button" name="edit" id="'+row.id+'" class="btn btn-outline-warning btn-sm edit_data" data-toggle="tooltip" data-placement="right" title="Modifica" data-dismiss="modal"><i class="fa fa-pencil fa-lg"></i></button>';
if (row.status_gruppo==1)
{
if (row.n_gruppo==0){
return $btn;
}
else {
if (row.collega==1){
return '';
}
else {
return $btn;
}
}
}
else {
return $btn;
}
}
},
{
sortable:false,
className: 'dt-body-nowrap',
"render" : function(data,type,row){
if (row.n_gruppo==null)
{
return '';
}
else {
if (row.status_gruppo==1)
{
if (row.collega==1){
return '<i class="fa fa-object-group fa-lg"><span class="badge badge-success">'+row.n_gruppo+'</span></i>';
}
else {
return '<i class="fa fa-object-group fa-lg"><span class="badge badge-danger">'+row.n_gruppo+'</span></i>';
}
}
else {
return '';
}
}
}
},
{"className": "text-center",data: 'cod_npp'},
{"className": "text-left dt-body-nowrap",data: 'wbs'},
{"className": "text-left",data: 'intervento'},
{"className": "text-left",data: 'desc_st'},
{"className": "text-left",data: 'nome_pm'}
],
"order":[[2,'asc'],[3,'asc']],
});