I'm having doubts about how to use render in data table. I have a status column, which in the database is saved as values 1,2 and 3. What I want to show me in my status column is that if the value is equal to 1, it shows pending, 2 In process, and 3 finished. But I can't figure out how to implement the case. I hope you can guide me.
tablaReportes = $('#tablaReportes').DataTable({
"ajax":{
"url": "bd/reportes.php",
"method": 'POST',
"data":{opcion:opcion},
"dataSrc": ""
},
"columns":[
{"data": "id"},
{"data": "folio"},
{"data": "nombre"},
{"data": "apellido"},
{"data": "direccion"},
{"data": "descripcion_domicilio"},
{"data": "telefono"},
{"data": "num_contrato"},
{"data": "fecha_inicio"},
{"data": "fecha_final"},
{"data": "cuadrilla"},
{"data": "estatus",
"render": function(data){
var status_name = '';
switch(data)
{
case 1: status_name = 'Pendiente'; break;
case 2: status_name = 'En proceso'; break;
case 3: status_name = 'Terminado'; break;
default : status_name = 'Desconocido'; break;
}
return status_name;
}
},
{"data": "observaciones"},
{"data": "encargado_cuadrilla"},
{"defaultContent": "<div class='text-center'><div class='btn-group'><button class='btn btn-primary btnEditar'>Editar</button><button class='btn btn-danger btnBorrar'>Borrar</button></div></div>"}
]
What I want to do is something similar to this example
<td>
<?php
switch ($dat['estado']) {
case 1:
$dat['estado'] == '1';
echo '<span class="badge badge-danger">Pendiente</span>';
break;
case 2:
$dat['estado'] == '2';
echo '<span class="badge badge-warning">En proceso</span>';
break;
case 3:
$dat['estado'] == '3';
echo '<span class="badge badge-success">Terminado</span>';
break;
}
?>
</td>
I found this solution, I don't know if it is the most viable but I haven't been able to implement it with a switch