<?php

namespace App\Models;

use CodeIgniter\Model;

class Menu_model extends Model
{
    // Menu berita
    public function berita()
    {
        $builder = $this->db->table('berita');
        $builder->select('berita.id_kategori,berita.icon, berita.ringkasan, berita.gambar, kategori.nama_kategori, kategori.slug_kategori');
        $builder->join('kategori', 'kategori.id_kategori = berita.id_kategori');
        $builder->where(['status_berita' => 'Publish', 'jenis_berita' => 'Berita']);
        $builder->groupBy('berita.id_kategori');
        $query = $builder->get();

        return $query->getResultArray();
    }

    // Menu profil
    public function profil()
    {   
        // $this->load->database('db2');
        $builder = $this->db->table('berita');
        $builder->select('berita.judul_berita, berita.icon, berita.ringkasan, berita.gambar, berita.slug_berita, berita.id_berita');
        $builder->where(['status_berita' => 'Publish', 'jenis_berita' => 'Profil']);
        $query = $builder->get();

        return $query->getResultArray();
    }

    // Menu layanan
    public function layanan()
    {
        $builder = $this->db->table('berita');
        $builder->select('berita.judul_berita, berita.icon, berita.ringkasan, berita.gambar, berita.slug_berita, berita.id_berita');
        $builder->where(['status_berita' => 'Publish', 'jenis_berita' => 'Layanan']);
        $query = $builder->get();

        return $query->getResultArray();
    }
    
    // Menu Menu
    public function makanan()
    {   
        $db = \Config\Database::connect('db2', false); 
        $builder = $db->table('jenismenu');
        $builder->select('*')
        ->where('kdjenis !=','JP1')
        ->where('kdjenis !=','J05')
        ->where('kdjenis !=','J06')
        ->where('kdjenis !=','J05')
        ->where('kdjenis !=','J81')
        ->where('kdjenis !=','J82')
        ->where('kdjenis !=','J84')
        ->where('kdjenis !=','J85')
        ->where('kdjenis !=','J91')
        ->where('kdjenis !=','J92')
        ->where('kdjenis !=','J94')
        ->where('kdjenis !=','J95')
        ->where('kdjenis !=','JP2');
        $query = $builder->get();

        return $query->getResultArray();
    }
    
    public function getTiktokVideos()
    {
        return $this->db->table('tiktok_videos')
                        ->where('status', 1)
                        ->orderBy('id', 'DESC')
                        ->get()
                        ->getResultArray();
    }
    
    
}