javascript - 数据表columndef渲染没有被命中并且没有错误

Question

我的目标是从数据库更改为红色或绿色圆圈的每个“OUT”或“IN”，但没有任何变化，也没有错误。在IN和OUT列中将包含值“IN”和值“OUT”，我想转换为绿色圆圈或红色圆圈。

我不知道我做错了什么。

查看

                <th scope="col">Name</th>
            <th scope="col" id="IN">IN</th>
            <th scope="col" id="OUT">OUT</th>
            <th scope="col">Comments</th>

js

    <script>
       $('table').DataTable({
   searching: false, paging: false,
    "ajax": {
        url : "<?php echo site_url("getStatu") ?>",
        type : 'GET', 
             },
        "columnDefs": [
        {
                "data" : "OUT", "orderable" : false,  "defaultContent" : "", 
            "render": function ( data, type, full, meta) {
                  if  (data=="OUT")
                  {    
                                return data ='<i class="fa fa-circle" style="font-size:36px; color:red"></i>'

                   } 
            },

        },  ]         
});

Controller

public function getStatu(){

     $draw = intval($this->input->get("draw"));
      $start = intval($this->input->get("start"));
      $length = intval($this->input->get("length"));


    $this->load->model('Status_Board_Model');

    $status = $this->Status_Board_Model->getStatu();

   $data = array();

      foreach($status->result() as $r) {

           $data[] = array(
                $r->firstName,
                $r->online,
                $r->offline,
                $r->comment,

           );
      }

      $output = array(
           "draw" => $draw,
             "recordsTotal" => $status->num_rows(),
             "recordsFiltered" => $status->num_rows(),
             "data" => $data
        );
      echo json_encode($output);

}

Answer 1

试试这个:-

public function getStatu(){

 $draw = intval($this->input->get("draw"));
  $start = intval($this->input->get("start"));
  $length = intval($this->input->get("length"));


$this->load->model('Status_Board_Model');

$status = $this->Status_Board_Model->getStatu();



$data = array();

  foreach($status->result() as $r) {
    $in = $out = '';
    if($r->online == 'IN'){
    $in = '<i class="fa fa-circle" style="font-size:36px; color:green"></i>';
     }
    if($r->offline== 'OUT'){
    $out = '<i class="fa fa-circle" style="font-size:36px; color:red"></i>';
     }
       $data[] = array(
            $r->firstName,
            $in,
            $out,
            $r->comment,

       );
  }

  $output = array(
       "draw" => $draw,
         "recordsTotal" => $status->num_rows(),
         "recordsFiltered" => $status->num_rows(),
         "data" => $data
    );
  echo json_encode($output);

}

和js:-

<script>
   $('table').DataTable({


searching: false, paging: false,
    "ajax": {
        url : "<?php echo site_url("getStatu") ?>",
        type : 'GET', 
             },
        "columnDefs": [
        {
        "render": function ( data, type, full, meta) {
        },

    },  ]         
});
</script>