models/Keahlian.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
use Illuminate\Database\Eloquent\Model as Eloquent;

class Keahlian extends Eloquent
{
    protected $table = 'ms_keahlian';
    public $timestamps = false;

     // start datatables
    var $column_order = array(null, 'nama_keahlian', 'created_at', 'updated_at'); //set column field database for datatable orderable
    var $column_search = array('nama_keahlian'); //set column field database for datatable searchable

    private function _get_datatables_query() {
        $i = 0;

        $this->db = Keahlian::select(['ms_keahlian.*'])->where('ms_keahlian.is_deleted','0');
        foreach ($this->column_search as $item) { // loop column
            if(@$_POST['search']['value']) { // if datatable send POST for search
                if($i===0) {
                   $this->db =  $this->db->where($item, 'like', '%'.$_POST['search']['value'].'%');
                } else {
                   $this->db =  $this->db->orWhere($item, 'like', '%'.$_POST['search']['value'].'%');
                }
            }
            $i++;
        }

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

    function get_datatables() {
        $this->_get_datatables_query();
        if(@$_POST['length'] != -1){
            $this->db = $this->db->skip(@$_POST['start'])->take(@$_POST['length']);
            $query    = $this->db->get();
            return $query;
        }
    }
    function count_filtered() {
        $this->_get_datatables_query();
        $query = $this->db->get();
        return count($query);
    }
    function count_all() {
        $count = Keahlian::where('ms_keahlian.is_deleted','0')->count();
        return $count;
    }
    // end datatables
}