Salve a tutti ho una tabella :
codice:
<div class='table-responsive'>
<table id='datatable' class='table table-striped table-bordered table-advance table-hover'>
<thead>
<tr>
<th>Cliente</th>
<th>Data</th>
<th>Ora Partenza</th>
<th>Ora Arrivo</th>
<th>Luogo Partenza</th>
<th>Luogo Arrivo</th>
<th>Note</th>
</tr>
</thead>
<tbody>
<tr>
<td>
Hotel Baglioni
</td>
<td> 13-02-2017</td>
<td> 04:00</td>
<td> 04:30</td>
<td> Barberino Di Mugello</td>
<td> Trani</td>
<td> pto</td>
</tr>
<tr>
<td>
Hotel Baglioni
</td>
<td> 28-02-2017</td>
<td> 00:45</td>
<td> 02:00</td>
<td> Campobasso</td>
<td> Pescara</td>
<td>Viaggio a </td>
</tr>
<tr>
<td>
Hotel Baglioni
</td>
<td> 02-03-2017</td>
<td> 03:45</td>
<td> 04:00</td>
<td> Pisa</td>
<td> Napoli</td>
<td> </td>
</tr>
<tr>
<td>
Hotel Excelsior
</td>
<td> 03-03-2017</td>
<td> 00:45</td>
<td> 03:45</td>
<td> Catania</td>
<td> Palermo</td>
<td> 25</td>
</tr>
<tr>
<td>
Hotel Astor
</td>
<td>
</td>
<td> 03-03-2017</td>
<td> 00:00</td>
<td> 00:45</td>
<td> Barberino Di Mugello</td>
<td> Palermo</td>
<td> </td>
</tr>
<tr>
<td>
Hotel Baglioni
</td>
<td> 07-03-2017</td>
<td> 04:45</td>
<td> 09:00</td>
<td> Trani</td>
<td> Caltanissetta</td>
<td> aaa</td>
</tr>
<tr>
<td>
Hotel Baglioni
</td>
<td> 27-02-2017</td>
<td> 05:15</td>
<td> 08:45</td>
<td> Piazza Armerina</td>
<td> Enna</td>
<td> </td>
</tr>
<tr>
<td>
Hotel Baglioni
</td>
<td> 17-03-2017</td>
<td> 04:30</td>
<td> 05:15</td>
<td> Catania</td>
<td> Trani</td>
<td> prova nota </td>
</tr>
</tbody>
</table>
questo il js :
codice:
<script>
$(document).ready(function() {
var handleDataTableButtons = function() {
if ($('#datatable-buttons').length) {
$('#datatable-buttons').DataTable({
dom: 'Bfrtip',
buttons: [
{
extend: 'copy',
className: 'btn-sm'
},
{
extend: 'csv',
className: 'btn-sm'
},
{
extend: 'excel',
className: 'btn-sm'
},
{
extend: 'pdfHtml5',
className: 'btn-sm'
},
{
extend: 'print',
className: 'btn-sm'
},
],
responsive: true
});
}
};
TableManageButtons = function() {
'use strict';
return {
init: function() {
handleDataTableButtons();
}
};
}();
$('#datatable').DataTable( {
"order": [[ 0, "desc" ]]
} );
$('#datatable-keytable').DataTable({
keys: true
});
$('#datatable-responsive').DataTable();
$('#datatable-scroller').DataTable({
ajax: 'js/datatables/json/scroller-demo.json',
deferRender: true,
scrollY: 380,
scrollCollapse: true,
scroller: true
});
$('#datatable-fixed-header').DataTable({
fixedHeader: true
});
var $datatable = $('#datatable-checkbox');
$datatable.on('draw.dt', function() {
$('input').iCheck({
checkboxClass: 'icheckbox_flat-green'
});
});
TableManageButtons.init();
});
</script>
E possibile ordinarla tramite la data in italiano , ho trovato una soluzione un pò barbara cioè di mettere la data nel formato uk all'inizio e cancellare il campo ma però non ho l'utilità di premere sul campo per ordinare.