Datatables Server Side

var $table = 'account';

var $column_order = array(null, 'nama_akun','no_akun','sub_no_akun', 'status_akun', 'level_akun', 'nama_user', 'saldo_awal', 'created_at', 'users.nama_user');

var $column_search = array('nama_akun','no_akun','sub_no_akun', 'status_akun', 'level_akun', 'nama_user', 'saldo_awal', 'created_at', 'users.nama_user'); //field yang diizin untuk pencarian

var $order = array('no_akun' => 'asc'); // default order

// Datatable

private function _get_datatables_query()

{

$this->db->from($this->table);

$this->db->join('users', 'account.created_by = users.id', 'left');

$i = 0;

foreach ($this->column_search as $item) // looping awal

{

if($_POST['search']['value']) // jika datatable mengirimkan pencarian dengan metode POST

{

if($i===0) // looping awal

{

$this->db->group_start();

$this->db->like($item, $_POST['search']['value']);

}

else

{

$this->db->or_like($item, $_POST['search']['value']);

}

if(count($this->column_search) - 1 == $i)

$this->db->group_end();

}

$i++;

}

if(isset($_POST['order']))

{

$this->db->order_by($this->column_order[$_POST['order']['0']['column']], $_POST['order']['0']['dir']);

}

else if(isset($this->order))

{

$order = $this->order;

$this->db->order_by(key($order), $order[key($order)]);

}

// $this->db->select('account.*, users.id as idUser, users.nama_user');

// $this->db->from('account');

// $this->db->join('users', 'account.created_by = users.id', 'left');

// // $this->db->join('users', 'users.id = account.created_by', 'left');

// return $this->db->get()->result();

}

function get_datatables()

{

$this->_get_datatables_query();

if($_POST['length'] != -1)

$this->db->limit($_POST['length'], $_POST['start']);

$query = $this->db->get();

return $query->result();

}

function count_filtered()

{

$this->_get_datatables_query();

$query = $this->db->get();

return $query->num_rows();

}

public function count_all()

{

$this->db->from($this->table);

return $this->db->count_all_results();

}