<?php
namespace App\Models;
use CodeIgniter\Model;

class PelamarModel extends Model {
    protected $table = 'data_pelamar';
    protected $primaryKey = 'id';
    protected $allowedFields = ['lowongan_id', 'nama', 'email', 'telepon', 'berkas', 'status', 'tgl_apply'];

    public function getPelamarLengkap() {
        return $this->select('data_pelamar.*, lowongan_karir.title as posisi')
                    ->join('lowongan_karir', 'lowongan_karir.id = data_pelamar.lowongan_id')
                    ->orderBy('data_pelamar.tgl_apply', 'DESC')
                    ->findAll();
    }
}