Users_model.php

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

// Deklarasi pembuatan class Users_model
class Users_model extends CI_Model {
    // Property yang bersifat public
    public $table   = 'users';
    public $id      = 'username';
    public $order   = 'DESC';

    // Konstruktor
    function __construct() {
        parent::__construct();
    }

    // Tabel data dengan nama users
    function json() {
        $this->datatables->select('username, password, email, level, blokir, id_sessions');
        $this->datatables->from('users');
        $this->datatables->add_column('action', anchor(site_url('users/update/$1'),'<button type="button" class="btn btn-warning"><i class="fa fa-pencil" area-hidden="true"></i></button>')." ".anchor(site_url('users/delete/$1'), '<button type="button" class="btn btn-danger"><i class="fa fa-trash" area-hidden="true"></i></button>', 'onclick="javascript: return confirm(\'Are You Sure?\')"'), 'username');

        return $this->datatables->generate();
    }

    // Menampilkan semua data
    function get_all() {
        $this->db->order_by($this->id, $this->order);
        return $this->db->get($this->table)->result();
    }

    // Menampilkan semua data berdasarkan id - nya
    function get_by_id($id) {
        $this->db->where($this->id, $id);
        return $this->db->get($this->table)->row();
    }

    // Menampilkan jumlah data
    function total_rows($q = NULL) {
        $this->db->like('username', $q);
        $this->db->or_like('username', $q);
        $this->db->or_like('password', $q);
        $this->db->or_like('email', $q);
        $this->db->or_like('level', $q);
        $this->db->or_like('blokir', $q);
        $this->db->or_like('id_sessions', $q);
        $this->db->from($this->table);

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

    // Menampilkan data dengan jumlah limit
    function get_limit_data($limit, $start = 0, $q = NULL) {
        $this->db->order_by($this->id, $this->order);
        $this->db->like('username', $q);
        $this->db->or_like('username', $q);
        $this->db->or_like('password', $q);
        $this->db->or_like('email', $q);
        $this->db->or_like('level', $q);
        $this->db->or_like('blokir', $q);
        $this->db->or_like('id_sessions', $q);
        $this->db->limit($limit, $start);

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

    // Menambahkan data kedalam database
    function insert($data) {
        $this->db->insert($this->table, $data);
    }

    // Merubah data di dalam database
    function update($id, $data) {
        $this->db->where($this->id, $id);
        $this->db->update($this->table, $data);
    }

    // Menghapus data di dalam database
    function delete($id) {
        $this->db->where($this->id, $id);
        $this->db->delete($this->table);
    }
}