Ignited DataTables

[eluser]Pegasus275[/eluser]
Ok
This is solution

the new function (old replace on line 313)

Code:

/**
    * Builds a JSON encoded string data
    *
    * @param string $columns
    * @param string $iTotal
    * @param string $iFilteredTotal
    * @param string $rResult
    * @return string
    */
    protected function produce_output($columns, $iTotal, $iFilteredTotal, $rResult, $custom_columns = '')
    {
      $aaData = array();
      $sColumnOrder = '';

      foreach($rResult->result_array() as $row_key => $row_val)
      {
        foreach($row_val as $col_key => $col_val)
        {
          if($row_val[$col_key] == 'version')
            $aaData[$row_key][$col_key] = ($aaData[$row_key][$col_key] == 0)? '-' : $col_val;
          else
            $aaData[$row_key][$col_key] = $col_val;
        }

        if(isset($custom_columns) && is_array($custom_columns))
        {
          foreach($custom_columns as $cus_col_key => $cus_col_val)
          {
            if(isset($cus_col_val[1]) && is_array($cus_col_val[1]))
            {
              foreach($cus_col_val[1] as $cus_colr_key => $cus_colr_val)
                $cus_col_val[0] = str_ireplace('$' . ($cus_colr_key + 1), $aaData[$row_key][$cus_colr_val], $cus_col_val[0]);

              $aaData[$row_key][$cus_col_key] = $cus_col_val[0];
            }
            else
              $aaData[$row_key][$cus_col_key] = $cus_col_val[0];
          }
        }
      }

      foreach($columns as $col_key => $col_val)
        $sColumnOrder .= $col_val . ',';

      if(isset($custom_columns) && is_array($custom_columns))
        foreach($custom_columns as $cus_col_key => $cus_col_val)
          $sColumnOrder .= $cus_col_key . ',';

      $sColumnOrder = substr_replace($sColumnOrder, '', -1);

      $sOutput = array
      (
        'sEcho'                => intval($this->ci->input->post('sEcho')),
        'iTotalRecords'        => $iTotal,
        'iTotalDisplayRecords' => $iFilteredTotal,
        'aaData'               => $aaData,
        'sColumns'             => $sColumnOrder
      );
     // echo "<div>".json_encode($aaData)."</div>";
      return json_encode($sOutput);
    }

controller

Code:

$table = 'users';
      $columns = array('id', 'username','email','created_on');
      $index = 'id';
      $joins['groups']['columns'] = array('description');
      $joins['groups']['fk'] = 'users.group_id = groups.id';
      $joins['meta']['columns'] = array('first_name','last_name');
      $joins['meta']['fk'] = 'users.id = meta.user_id';
      $custom_columns['delete'] = array('jeda$1', array('id')); // this is also change
      $options['custom_columns'] = $custom_columns;    
      $options['joins'] = $joins;
      $this->load->library('Datatables');
      $data['result'] = $this->datatables->generate($table, $columns, $index,$options);
      echo $data['result'];

and now the view

Code:

$('#test').dataTable
    ({
      'bServerSide'    : true,
      'bAutoWidth'     : false,
      'sPaginationType': 'full_numbers',
      'sAjaxSource'    : 'http://localhost/wepu/admin.php/user/user_listener',
      "aoColumns": [
              { "mDataProp": "id" },
            { "mDataProp": "username" },
            { "mDataProp": "username" } and so on
        ],
        'fnServerData': function(sSource, aoData, fnCallback)
      {
        $.ajax
        ({
          'dataType': 'json',
          'type'    : 'POST',
          'url'     : sSource,
          'data'    : aoData,
          'success' : fnCallback
        });
        datatables_show_search($(this).attr('id'));
      }
    });