model.php

private function _get_datatables_query()
    {

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


        $i = 0;

        foreach ($this->column as $item) // loop column 'kd_barang','nm_barang','harga_Laundry','harga_Dryclean'
        {
            if($_POST['columns']['1']['search']['value'])
            {
                if($i===0) // first loop
                {

                    $this->db->group_start();
                    $this->db->like($item, $_POST['columns']['1']['search']['value']);
                }
                else
                {
                    $this->db->or_like($item, $_POST['columns']['1']['search']['value']);
                }

                    if(count($this->column) - 1 == $i) //last loop
                    $this->db->group_end(); //close bracket

            }



            if($_POST['search']['value']) // if datatable send POST for search
            {
            //  for($i = 0, $i <  count($this->column), $i++
                if($i===0) // first loop
                {
                    $this->db->group_start();
                    $this->db->like($item, $_POST['search']['value']);
                }
                else
                {
                    $this->db->or_like($item, $_POST['search']['value']);
                }
 if(count($this->column) - 1 == $i) //last loop
                    $this->db->group_end(); //close bracket

            }

            $column[$i] = $item; // set column array variable to order processing
            $i++;
        }
        if(isset($_POST['order'])) // here order processing
        {
            $this->db->order_by($column[$_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();
    }

    public function delete_by_id($id)
    {
        $this->db->where('kd_barang', $id);
        $this->db->delete($this->table);
    }

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