M_materi

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

class M_materi extends CI_Model {

    var $table = 'materi';

    public function json() {
        $link = base_url('assets/materi/');
        $this->datatables->select("materi.id,materi.nama,materi.jenis,mata_pelajaran.nama as mata_pelajaran,`user`.nama as nama_user,
            IF(materi.file = '', '','<a target=\"_blank\" class=\"btn btn-default btn-rounded btn-sm\" href=\"$link %materi.file%\" title=\"View\">Download <i class=\"fa fa-download\"></i></a>' ) as file_materi
            ");
        $this->datatables->from($this->table);
        $this->datatables->join('mata_pelajaran', 'materi.id_mata_pelajaran = mata_pelajaran.id');
        $this->datatables->join('`user`', 'materi.id_user = `user`.id');
        $this->datatables->add_column('view', '<div align="center">
            <a class="btn btn-default btn-rounded btn-sm" href="javascript:void(0)" title="Edit" onclick="edit($1)"><i class="fa fa-edit"></i></a>
            <a class="btn btn-default btn-rounded btn-sm" href="javascript:void(0)" title="Hapus" onclick="hapus($1)" ><i class="fa fa-trash"></i></a>
            </div>', 'id');
        return $this->datatables->generate();
    }

}

/* End of file M_materi.php */
/* Location: ./application/models/admin/M_materi.php */