Model

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

class Model extends CI_Model
{
    public function simpan($tabel, $data)
    {
        return $this->db->insert($tabel, $data);
    }
    public function update($tabel, $date, $where)
    {
        return $this->db->update($tabel, $date, $where);
    }
    public function getusers($where = '')
    {
        return $this->db->query("SELECT * FROM users".$where);
    }
    public function getLogin($username, $password)
    {
        return $this->db->query("SELECT * FROM users WHERE username = '$username' AND password = '".md5($password)."'");
    }

    function nomor()
    {
        $this->db->select('nomor');
        $this->db->order_by('nomor DESC');
        $query = $this->db->get('data');
        return $query->result_array();
    }

    function ambil_data($nomor)
    {
        $this->db->where('nomor', $nomor);
        $query = $this->db->get('data');
        return $query->result_array();
    }

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

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

    function ubah($nomor, $data)
    {
        $this->db->where('nomor', $nomor);
        $query = $this->db->update('data', $data);
        return $query;
    }

    function hapus($nomor)
    {
        $this->db->where('nomor', $nomor);
        $query = $this->db->delete('data');
        return $query;
    }

    function row_harian($tanggal){
        $this->db->where('tanggal', $tanggal);
        $query = $this->db->get('data');
        return $query->num_rows();
    }

    function laporan_harian($tanggal, $number, $offset)
    {
        $this->db->where('tanggal', $tanggal);
        $this->db->order_by('nomor DESC');
        $query = $this->db->get('data', $number, $offset);
        return $query->result();
    }

    function row_periode($mulai, $sampai)
    {
        $this->db->where('tanggal >=', $mulai);
        $this->db->where('tanggal <=', $sampai);
        $query = $this->db->get('data');
        return $query->num_rows();
    }

    function laporan_periode($mulai, $sampai, $number, $offset)
    {
        $this->db->where('tanggal >=', $mulai);
        $this->db->where('tanggal <=', $sampai);
        $this->db->order_by('nomor DESC');
        $query = $this->db->get('data', $number, $offset);
        return $query->result();
    }

    function row_masuk(){
        $this->db->where('jenis', 'masuk');
        $query = $this->db->get('data');
        return $query->num_rows();
    }

    function masuk($number, $offset){
        $this->db->where('jenis', 'masuk');
        $this->db->order_by('nomor DESC');
        $query = $this->db->get('data',$number,$offset);
        return $query->result();
    }

    function row_keluar(){
        $this->db->where('jenis', 'keluar');
        $query = $this->db->get('data');
        return $query->num_rows();
    }

    function keluar($number, $offset){
        $this->db->where('jenis', 'keluar');
        $this->db->order_by('nomor DESC');
        $query = $this->db->get('data', $number, $offset);
        return $query->result();
    }

    function row_cari($search)
    {
        $this->db->from('data');
        $this->db->or_like($search);
        $query = $this->db->get();
        return $query->num_rows();
    }

    function cari($batas=null, $offset=null, $search=null)
    {
        $this->db->from('data');
        if($batas != null){
            $this->db->limit($batas, $offset);
        }
        if ($search != null) {
            $this->db->or_like($search);
        }
        $this->db->order_by('nomor DESC');
        $query = $this->db->get();

        if ($query->num_rows() > 0) {
            return $query->result();
        }
    }

    function total_masuk()
    {
        $this->db->select('jumlah');
        $this->db->from('data');
        $this->db->where('jenis', 'masuk');
        $query = $this->db->get();
        return $query->result();
    }

    function total_keluar()
    {
        $this->db->select('jumlah');
        $this->db->from('data');
        $this->db->where('jenis', 'keluar');
        $query = $this->db->get();
        return $query->result();
    }

    function total_harian_masuk($tanggal)
    {
        $this->db->select('jumlah');
        $this->db->from('data');
        $this->db->where('tanggal', $tanggal);
        $this->db->where('jenis','masuk');
        $query = $this->db->get();
        return $query->result();
    }

    function total_harian_keluar($tanggal)
    {
        $this->db->select('jumlah');
        $this->db->from('data');
        $this->db->where('tanggal', $tanggal);
        $this->db->where('jenis','keluar');
        $query = $this->db->get();
        return $query->result();
    }

    function total_periode_masuk($mulai, $sampai)
    {
        $this->db->select('jumlah');
        $this->db->from('data');
        $this->db->where('tanggal >=', $mulai);
        $this->db->where('tanggal <=', $sampai);
        $this->db->where('jenis', 'masuk');
        $query = $this->db->get();
        return $query->result();
    }

    function total_periode_keluar($mulai, $sampai)
    {
        $this->db->select('jumlah');
        $this->db->from('data');
        $this->db->where('tanggal >=', $mulai);
        $this->db->where('tanggal <=', $sampai);
        $this->db->where('jenis', 'keluar');
        $query = $this->db->get();
        return $query->result();
    }

    function clean()
    {
        $query = $this->db->truncate('data');
        return $query;
    }
}
?>