models/Resis.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Resis extends CI_Model {

   var $table = 't_resis';
   var $column_order = array(null, 'nama','no_resi','Pengiriman', null); //set column field database for datatable orderable
   var $column_search = array('nama','no_resi','Pengiriman'); //set column field database for datatable searchable
   var $order = array('id_resi' => 'asc'); // default order

   public function __construct()
   {
      parent::__construct();
   }

   private function _get_datatables_query()
   {

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

      $i = 0;

      foreach ($this->column_search as $resi) // loop column
      {
         if($_POST['search']['value']) // if datatable send POST for search
         {

            if( $i === 0 ) // first loop
            {
               $this->db->group_start(); // open bracket. query Where with OR clause better with bracket. because maybe can combine with other WHERE with AND.
               $this->db->like($resi, $_POST['search']['value']);
            } else {
               $this->db->or_like($resi, $_POST['search']['value']);
            }

            if(count($this->column_search) - 1 == $i) {//last loop
               $this->db->group_end(); //close bracket
            }
         }
         $i++;
      }

      if(isset($_POST['order'])) // here order processing
      {

         $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)]);

      }
   }

   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();
   }

   function count_all()
   {
      $this->db->from($this->table);
      return $this->db->count_all_results();
   }

   function insert($table = '', $data = '')
   {
      $this->db->insert($table, $data);
   }

    function insert_last($table = '', $data = '')
   {
      $this->db->insert($table, $data);

        return $this->db->insert_id();
   }

    function get_all($table)
    {
        $this->db->from($table);

        return $this->db->get();
    }

    function get_where($table = null, $where = null)
    {
        $this->db->from($table);
        $this->db->where($where);

        return $this->db->get();
    }

   function update($table = null, $data = null, $where = null)
   {
    $this->db->update($table, $data, $where);
   }

   function delete($table = null, $where = null)
   {
    $this->db->where($where);
    $this->db->delete($table);
   }
}