.

. BSA HACKER

Server : Apache
System : Linux nusantara.hosteko.com 4.18.0-553.16.1.lve.el8.x86_64 #1 SMP Tue Aug 13 17:45:03 UTC 2024 x86_64
User : koperas1 ( 1254)
PHP Version : 7.4.33
Disable Function : NONE
Directory : /home/koperas1/www/app/Models/

Upload File :

Current File : /home/koperas1/www/app/Models/Menu_model.php

<?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()
    {
        $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();
    }
}