<?php
class Dashboard_model extends CI_Model {
    function __construct() {
        parent::__construct();
    }

    function group_transaksi(){
        $this->db->from('transaksi')
                ->select("concat(year(tanggal),'-',month(tanggal)) yt,status,count(id_transaksi) n")
                ->where('status','Selsai')
                ->or_where('status','Di Batalkan')
                ->group_by('yt,status');
//                ->order_by('tgl','asc');
        $table=$this->db->get();
        return $table->result_array();
    }
}
?>