FileMgr

📂 FileMgr

📍 /home/mien4214/public_html/webcp-lama/app/Models

✏️ /home/mien4214/public_html/webcp-lama/app/Models/Karir_model.php

✕ Tutup

<?php

namespace App\Models;

use CodeIgniter\Model;

class Karir_model extends Model
{
    protected $table         = 'karir';
    protected $primaryKey    = 'id_karir';
    protected $allowedFields = [];

// Listing
    public function listing()
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*,users.nama');
        $builder->join('kategori', 'kategori.id_kategori = karir.id_kategori', 'LEFT');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->orderBy('karir.id_karir', 'DESC');
        $query = $builder->get();

return $query->getResultArray();
    }

public function listing1()
    {
        $builder = $this->db->table('tabel_lamaran');
        $builder->select('*');
        $builder->join('karir', 'karir.id_karir = tabel_lamaran.karir_id');
        $query = $builder->get();

return $query->getResultArray();
    }

public function cari($posisi)
    {
        $builder = $this->db->table('tabel_lamaran');
        $builder->select('*');
        $builder->join('karir', 'karir.id_karir = tabel_lamaran.karir_id')->where('tabel_lamaran.karir_id', $posisi);
        $query = $builder->get();

return $query->getResultArray();
    }

public function unduh($id_lamar)
    {
        $builder = $this->db->table('tabel_lamaran');
        $builder->select('*');
        $builder->where('id_lamar', $id_lamar);
        $query = $builder->get();

return $query->getResultArray();
    }

public function posisi()
    {
        $builder = $this->db->table('karir');
        $builder->select('judul_karir,id_karir')->where('status_karir', 'Publish');
        $builder->orderBy('karir.id_karir', 'DESC');
        $query = $builder->get();

return $query->getResultArray();
    }

// home
    public function beranda()
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*, kategori.nama_kategori, kategori.slug_kategori, users.nama');
        $builder->join('kategori', 'kategori.id_kategori = karir.id_kategori', 'LEFT');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->where([
            'status_karir' => 'Publish',
            'jenis_karir'               => 'karir',
        ]);
        $builder->orderBy('karir.tanggal_publish', 'DESC');
        $builder->limit(3);
        $query = $builder->get();

return $query->getResultArray();
    }

// home
    public function sidebar()
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*, users.nama');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->where('status_karir', 'Publish');
        $builder->orderBy('karir.tanggal_publish', 'DESC');
        $builder->limit(10);
        $query = $builder->get();

return $query->getResultArray();
    }

// home
    public function home()
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*, users.nama');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->where('status_karir', 'Publish');
        $builder->orderBy('karir.tanggal_publish', 'DESC');
        $query = $builder->get();

return $query->getResultArray();
    }

// total
    public function total_kategori($id_kategori)
    {
        $builder = $this->db->table('karir')->where('id_kategori', $id_kategori);
        $query   = $builder->get();

return $query->getNumRows();
    }

// author
    public function author_all($id_user)
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*, kategori.nama_kategori, kategori.slug_kategori, users.nama');
        $builder->join('kategori', 'kategori.id_kategori = karir.id_kategori', 'LEFT');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->where(['karir.id_user' => $id_user]);
        $builder->orderBy('karir.id_karir', 'DESC');
        $query = $builder->get();

return $query->getResultArray();
    }

// total
    public function total_author($id_user)
    {
        $builder = $this->db->table('karir')->where('id_user', $id_user);
        $query   = $builder->get();

return $query->getNumRows();
    }

// kategori
    public function jenis_karir_all($jenis_karir)
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*, kategori.nama_kategori, kategori.slug_kategori, users.nama');
        $builder->join('kategori', 'kategori.id_kategori = karir.id_kategori', 'LEFT');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->where(['karir.jenis_karir' => $jenis_karir]);
        $builder->orderBy('karir.id_karir', 'DESC');
        $query = $builder->get();

return $query->getResultArray();
    }

// total
    public function total_jenis_karir($jenis_karir)
    {
        $builder = $this->db->table('karir')->where('jenis_karir', $jenis_karir);
        $query   = $builder->get();

return $query->getNumRows();
    }

// status_karir
    public function status_karir_all($status_karir)
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*, kategori.nama_kategori, kategori.slug_kategori, users.nama');
        $builder->join('kategori', 'kategori.id_kategori = karir.id_kategori', 'LEFT');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->where(['karir.status_karir' => $status_karir]);
        $builder->orderBy('karir.id_karir', 'DESC');
        $query = $builder->get();

return $query->getResultArray();
    }

// status_karir
    public function total_status_karir($status_karir)
    {
        $builder = $this->db->table('karir')->where('status_karir', $status_karir);
        $query   = $builder->get();

return $query->getNumRows();
    }

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

return $query->getNumRows();
    }

public function total1()
    {
        $builder = $this->db->table('tabel_lamaran');
        $query   = $builder->get();

return $query->getNumRows();
    }

public function totalcari($posisi)
    {
        $builder = $this->db->table('tabel_lamaran');
        $builder->where('karir_id', $posisi);
        $query   = $builder->get();

return $query->getNumRows();
    }

// detail
    public function detail($id_karir)
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*, users.nama');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->where('karir.id_karir', $id_karir);
        $builder->orderBy('karir.id_karir', 'DESC');
        $query = $builder->get();

return $query->getRowArray();
    }

// read
    public function read($slug_karir)
    {
        $builder = $this->db->table('karir');
        $builder->select('karir.*, users.nama');
        $builder->join('users', 'users.id_user = karir.id_user', 'LEFT');
        $builder->where('karir.slug_karir', $slug_karir);
        $builder->where('karir.status_karir', 'Publish');
        $builder->orderBy('karir.id_karir', 'DESC');
        $query = $builder->get();

return $query->getRowArray();
    }

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

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

public function insertlamar($data)
    {
        $builder = $this->db->table('tabel_lamaran');
        $builder->insert($data);
    }
}

Batal

⬅ app 26 item

Nama	Tipe	Ukuran	Diubah	Perm	Aksi
📄 .gitkeep	gitkeep	0 B	20/11/21 14:46	0644	✏️ ⬇
🐘 Berita_model.php	php	13.7 KB	27/02/26 11:40	0644	✏️ ⬇
🐘 Client_model.php	php	2.8 KB	09/01/23 13:10	0644	✏️ ⬇
🐘 Dasbor_model.php	php	1.9 KB	20/11/21 14:46	0644	✏️ ⬇
🐘 Download_model.php	php	2.9 KB	20/11/21 14:46	0644	✏️ ⬇
🐘 Galeri_model.php	php	2.6 KB	27/02/26 14:48	0644	✏️ ⬇
🐘 Karir_model.php	php	8.2 KB	10/01/23 09:08	0644	✏️ ⬇
🐘 Kategori_download_model.php	php	2 KB	20/11/21 14:46	0644	✏️ ⬇
🐘 Kategori_galeri_model.php	php	2 KB	20/11/21 14:46	0644	✏️ ⬇
🐘 Kategori_karir_model.php	php	2.9 KB	06/01/23 09:38	0644	✏️ ⬇
🐘 Kategori_model.php	php	2 KB	20/11/21 14:46	0644	✏️ ⬇
🐘 Kategori_produk_model.php	php	3.4 KB	22/12/22 10:54	0644	✏️ ⬇
🐘 Kategori_staff_model.php	php	1.9 KB	20/11/21 14:46	0644	✏️ ⬇
🐘 Kemitraan_model.php	php	365 B	21/12/22 12:16	0644	✏️ ⬇
🐘 Konfigurasi_model.php	php	551 B	20/11/21 14:46	0644	✏️ ⬇
🐘 Makanan_model.php	php	15.4 KB	25/02/26 11:04	0644	✏️ ⬇
🐘 Menu_model.php	php	2.4 KB	25/02/26 10:55	0644	✏️ ⬇
🐘 Pmodel.php	php	628 B	20/11/21 14:46	0644	✏️ ⬇
🐘 Produk_model.php	php	3.6 KB	09/01/23 09:00	0644	✏️ ⬇
🐘 Saran_model.php	php	647 B	05/01/23 14:13	0644	✏️ ⬇
🐘 Staff_model.php	php	3.3 KB	20/11/21 14:46	0644	✏️ ⬇
🐘 Tentang_model.php	php	460 B	27/02/26 08:13	0644	✏️ ⬇
🐘 Tiktok_model.php	php	1.3 KB	28/02/26 09:31	0644	✏️ ⬇
🐘 Toko_model.php	php	478 B	24/02/26 10:58	0644	✏️ ⬇
🐘 User_model.php	php	1.9 KB	20/11/21 14:46	0644	✏️ ⬇
🐘 Video_model.php	php	1.7 KB	20/11/21 14:46	0644	✏️ ⬇