How could I change value of a cell using fnRowCallback ?

fernandopaiva

I'm trying change a cell value using fnRowCallback but still haven't success.

how could I do this ?

I'm trying this.

$(document).ready(function() {
    $('#dataTables-example').DataTable({
        "processing": true,
        "serverSide": true,
        "ajax":{
            url: "<?php echo $this->Html->url("/Empresas/indexAjax.json");?>",
            dataSrc:""
        },
        "columns": [
            {"data": "Empresa.id", sortable:false},
            {"data": "Empresa.nomeFantasia"},
            {"data": "Empresa.cnpj"},
            {"data": "Empresa.telefone1"},
            {"data": "Empresa.telefone2"},
            {"data": "Empresa.celular"},
            {"data": "Empresa.aberto", "fnRowCallback":function(nRow, aData, iDisplayIndex){
                if(aData["Empresa"] === 1){
                    $('td', nRow).html("Aberto");
                }else{
                    $('td', nRow).html("Fechado");
                }
                return nRow;
            }}
    ]

fernandopaiva

I solved the problem.

I did.

$(document).ready(function() {
    $('#dataTables-example').DataTable({
        "processing": true,
        "serverSide": true,
        "ajax":{
            url: "<?php echo $this->Html->url("/Empresas/indexAjax.json");?>",
            dataSrc:""
        },
        "columns": [
            {"data": "Empresa.id", sortable:false},
            {"data": "Empresa.nomeFantasia"},
            {"data": "Empresa.cnpj"},
            {"data": "Empresa.telefone1"},
            {"data": "Empresa.telefone2"},
            {"data": "Empresa.celular"},
            {"data": "Empresa.aberto"}
    ],
   "fnRowCallback": function (nRow, aData, iDisplayIndex, iDisplayIndexFull) {            
            if(aData["Empresa"].aberto == 1){
                $("td:eq(6)", nRow).text("Aberto");
            }else{
                $("td:eq(6)", nRow).text("Fechado");
            }
            return nRow;
        },

jLinux

Nice job