model new.php

<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Content_model extends CI_Model{

    public function __construct(){
        parent::__construct();
    }

    function list_content($ref){
        return $this->db->query("SELECT * FROM tbl_asset a, tbl_asset_category c, tbl_asset_subcategory s WHERE a.id_category=c.id_category AND a.id_subcategory=s.id_subcategory AND s.subcategory=?", $ref)->result();
    }

    function list_ebook($ref){
        return $this->db->query("SELECT * FROM tbl_asset join tbl_asset_subcategory ON tbl_asset.id_subcategory = tbl_asset_subcategory.id_subcategory WHERE tbl_asset_subcategory.subcategory = ? ORDER BY tbl_asset.subtitle", $ref)->result();
    }

    function cek_ebook($ref){
        $data = $this->db->query("SELECT subtitle FROM tbl_asset WHERE filename LIKE '%$ref%' LIMIT 1");
        if($data->num_rows() > 0){
            return true;
        }else{
            return false;
        }
    }
    function judul_ebook($ref){
        return $this->db->query("SELECT subtitle FROM tbl_asset WHERE filename LIKE '%$ref%' LIMIT 1", $ref)->row();
    }

    function list_taplai(){
        return $this->db->query("SELECT * FROM taplai WHERE tampil = '1' ORDER BY  urut ASC")->result();
    }

    function cek_taplai($ref){
        $data = $this->db->query("SELECT * FROM taplai WHERE judul = ? LIMIT 1", $ref);
        if($data->num_rows() > 0){
            return true;
        }else{
            return false;
        }
    }

    function link_taplai($ref){
        return $this->db->query("SELECT link FROM taplai WHERE judul = ? LIMIT 1", $ref)->row();
    }

    function list_film_antikorupsi(){
        return $this->db->query("SELECT * FROM beta_lists WHERE item_cat='voucher/fitur/antikorupsi'")->result();
    }

    function list_animasi_pembelajaran_subjek(){
        return $this->db->query("SELECT DISTINCT subjek FROM tbl_animasi_pembelajaran")->result();
    }

    function list_animasi_pembelajaran($subjek = NULL){
        if ($subjek != NULL) {
            return $this->db->query("SELECT * FROM tbl_animasi_pembelajaran WHERE subjek = ?", $subjek)->result();
        }
        else{
            return $this->db->query("SELECT * FROM tbl_animasi_pembelajaran")->result();
        }
    }

    function cek_animasi_pembelajaran($ref){
        $data = $this->db->query("SELECT * FROM tbl_animasi_pembelajaran WHERE judul = ? LIMIT 1", $ref);
        if($data->num_rows() > 0){
            return $data;
        }else{
            return false;
        }
    }

    function link_animasi_pembelajaran($ref){
        return $this->db->query("SELECT link, sumber FROM tbl_animasi_pembelajaran WHERE judul = ? LIMIT 1", $ref)->row();
    }

    function list_edugames_multiplayer(){
        return $this->db->query("SELECT * FROM  ilmcidb_gamesgames g WHERE g.Category = '6' AND g.Sub = 'All' ORDER BY g.ID")->result();
    }

    function list_edugames_timemanagement(){
        return $this->db->query("SELECT * FROM  ilmcidb_gamesgames g WHERE g.Category = '12' AND g.Sub = 'All' ORDER BY g.ID")->result();
    }

    function list_edugames_adventure(){
        return $this->db->query("SELECT * FROM  ilmcidb_gamesgames g WHERE g.Category = '9' AND g.Sub = 'All' ORDER BY g.ID")->result();
    }

    function list_edugames_action(){
        return $this->db->query("SELECT * FROM  ilmcidb_gamesgames g WHERE g.Category = '7' AND g.Sub = 'All' ORDER BY g.ID")->result();
    }

    function list_kategori_videopembelajaran($tingkat_id = NULL, $kelas_id = NULL){
        return $this->db->query("SELECT tbl_videopembelajaran_kategori.*, tbl_videopembelajaran.kelas_id FROM tbl_videopembelajaran_kategori JOIN tbl_videopembelajaran ON tbl_videopembelajaran.kategori_id = tbl_videopembelajaran_kategori.id WHERE tbl_videopembelajaran_kategori.tampil = '1' AND tbl_videopembelajaran.kelas_id = ? GROUP BY kategori ORDER BY kategori ASC", $kelas_id)->result();
    }


    //list Kelas

    function list_kelas_videopembelajaran($tingkat_id = NULL){
        return $this->db->query("SELECT tbl_videopembelajaran_kelas.*, tbl_videopembelajaran.tingkat_id FROM tbl_videopembelajaran_kelas JOIN tbl_videopembelajaran ON tbl_videopembelajaran.kelas_id = tbl_videopembelajaran_kelas.id WHERE
            tbl_videopembelajaran_kelas.tampil = '1' AND tbl_videopembelajaran.tingkat_id = ? GROUP BY kelas ORDER BY kelas ASC", $tingkat_id)->result();
    }



    function list_videopembelajaran($tingkat_id = NULL, $kelas_id = NULL, $kategori_id = NULL){
        return $this->db->query("SELECT * FROM tbl_videopembelajaran WHERE tampil = 1 AND tingkat_id =? AND kelas_id = ? AND kategori_id = ? ORDER BY  judul ASC", array($tingkat_id, $kelas_id, $kategori_id))->result();
    }

    function detail_videopembelajaran($tingkat_id = NULL, $kelas_id = NULL, $kategori_id = NULL,$id = NULL){
        $data = $this->db->query("SELECT tbl_videopembelajaran.*, tbl_videopembelajaran_kategori.kategori, tbl_videopembelajaran_kelas.kelas FROM tbl_videopembelajaran RIGHT JOIN tbl_videopembelajaran_kategori, ON tbl_videopembelajaran.kategori_id = tbl_videopembelajaran_kategori.id WHERE tingkat_id = ? AND kategori_id = ? AND tbl_videopembelajaran.tampil = 1 AND tbl_videopembelajaran.id = ? LIMIT 1", array($tingkat_id,$kelas_id, $kategori_id, $id));
        return $data->row();
    }

    function detail_tingkat($id){
        return $this->db->where('id', $id)->get('tbl_videopembelajaran_tingkat')->row()->tingkat;
    }

    function detail_kategori($id){
        return $this->db->where('id', $id)->get('tbl_videopembelajaran_kategori')->row()->kategori;
    }

    function detail_kelas($id){
        return $this->db->where('id', $id)->get('tbl_videopembelajaran_kelas')->row()->kelas;
    }

    //join table tbl_videopembelajaran & tbl_videopembelajaran_kategori & tbl_videopembelajaran_kelas & tbl_videopembelajaran_tingkat

    function get_detail_video_with_all_data($id_video = NULL) {
        return $this->db->query("SELECT tbl_videopembelajaran.*, tbl_videopembelajaran_kategori.kategori,  tbl_videopembelajaran_kelas.kelas, tbl_videopembelajaran_tingkat.tingkat FROM tbl_videopembelajaran INNER JOIN tbl_videopembelajaran_kategori ON tbl_videopembelajaran.kategori_id = tbl_videopembelajaran_kategori.id INNER JOIN tbl_videopembelajaran_kelas ON tbl_videopembelajaran_kelas.id = tbl_videopembelajaran.kelas_id INNER JOIN tbl_videopembelajaran_tingkat ON tbl_videopembelajaran_tingkat.id = tbl_videopembelajaran.tingkat_id WHERE tbl_videopembelajaran.tampil = 1 AND tbl_videopembelajaran_kategori.tampil = 1 AND tbl_videopembelajaran_kelas.tampil = 1 AND WHERE tbl_videopembelajaran.id = ? ORDER BY tbl_videopembelajaran_kelas.kelas ASC", $id_video)->result();
    }


}