.

. 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/public_html/app/Models/

Upload File :

Current File : /home/koperas1/public_html/app/Models/Galeri_model.php

<?php

namespace App\Models;

use CodeIgniter\Model;

class Galeri_model extends Model
{
    protected $table         = 'galeri';
    protected $primaryKey    = 'id_galeri';
    protected $allowedFields = [];

    // Listing
    public function listing()
    {
        $builder = $this->db->table('galeri');
        $builder->select('galeri.*, kategori_galeri.nama_kategori_galeri, kategori_galeri.slug_kategori_galeri, users.nama');
        $builder->join('kategori_galeri', 'kategori_galeri.id_kategori_galeri = galeri.id_kategori_galeri', 'LEFT');
        $builder->join('users', 'users.id_user = galeri.id_user', 'LEFT');
        $builder->orderBy('galeri.id_galeri', 'DESC');
        $query = $builder->get();

        return $query->getResultArray();
    }

    // total
    public function total()
    {
        $builder = $this->db->table('galeri');
        $query   = $builder->get();

        return $query->getNumRows();
    }

    // detail
    public function detail($id_galeri)
    {
        $builder = $this->db->table('galeri');
        $builder->select('galeri.*, kategori_galeri.nama_kategori_galeri, kategori_galeri.slug_kategori_galeri, users.nama');
        $builder->join('kategori_galeri', 'kategori_galeri.id_kategori_galeri = galeri.id_kategori_galeri', 'LEFT');
        $builder->join('users', 'users.id_user = galeri.id_user', 'LEFT');
        $builder->where('galeri.id_galeri', $id_galeri);
        $builder->orderBy('galeri.id_galeri', 'DESC');
        $query = $builder->get();

        return $query->getRowArray();
    }

    // tambah
    public function tambah($data)
    {
        $builder = $this->db->table('galeri');
        $builder->insert($data);
    }

    // tambah
    public function edit($data)
    {
        $builder = $this->db->table('galeri');
        $builder->where('id_galeri', $data['id_galeri']);
        $builder->update($data);
    }

    // slider
    public function slider()
    {
        $builder = $this->db->table('galeri');
        $builder->where('jenis_galeri', 'Homepage');
        $builder->orderBy('galeri.id_galeri', 'DESC');
        $query = $builder->get();

        return $query->getResultArray();
    }

    // galeri
    public function galeri()
    {
        $builder = $this->db->table('galeri');
        $builder->where('jenis_galeri', 'Galeri');
        $builder->orderBy('galeri.id_galeri', 'DESC');
        $query = $builder->get();

        return $query->getResultArray();
    }
}