Transaksi_Model.php

<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Transaksi_Model extends MY_model
{
    private $primary_key = 'kode';
    private $table_name = 'barang';
    public function __construct()
    {
        parent::__construct();
    }
    public function get()
    {

        $this->db->select('kode,nama');

        return $this->db->get($this->table_name)->result();

    }
    public function get_by_id($id)
    {
        $this->db->where($this->primary_key,$id);

        return $this->db->get($this->table_name)->row();

    }
    public function addBarang($barang)
    {
        $this->db->insert('transaksi', $barang);
    }
    public function nomaksimum()
    {
        $maxid = 0;
        $row = $this->db->query('SELECT MAX(no) AS `maxid` FROM `transaksi`')->row();
        if ($row) {
            $maxid = $row->maxid;
        }
        return $maxid;
    }
    public function pemasukkan()
    {
        $pemasukkan = 0;
        $row = $this->db->query('SELECT SUM(total) AS `pemasukkan` FROM `transaksi`')->row();
        if ($row) {
            $pemasukkan = $row->pemasukkan;
        }
        return $pemasukkan;
    }
    function destroy() {
        $this->cart->destroy();
    }
}