53 lines
2.0 KiB
PHP
53 lines
2.0 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use CodeIgniter\Model;
|
|
|
|
class PersonelModel extends Model
|
|
{
|
|
protected $table = 'kta_digital.personel';
|
|
protected $primaryKey = 'id';
|
|
|
|
protected $useAutoIncrement = true;
|
|
|
|
protected $returnType = 'array';
|
|
protected $useSoftDeletes = false;
|
|
|
|
protected $allowedFields = [
|
|
'nrp', 'nama', 'pangkat', 'jabatan', 'satuan', 'foto_url',
|
|
'tmt_jabatan', 'lama_jabatan', 'tempat_lahir', 'tanggal_lahir',
|
|
'agama', 'suku', 'status_personel'
|
|
];
|
|
|
|
protected $useTimestamps = true;
|
|
protected $createdField = 'created_at';
|
|
protected $updatedField = 'updated_at';
|
|
|
|
/**
|
|
* Get full profile including all DRH related data
|
|
*/
|
|
public function getFullDRH($nrp)
|
|
{
|
|
$personel = $this->where('nrp', $nrp)->first();
|
|
|
|
if (!$personel) {
|
|
return null;
|
|
}
|
|
|
|
$db = \Config\Database::connect();
|
|
|
|
return [
|
|
'personel' => $personel,
|
|
'pendidikan_kepolisian' => $db->table('kta_digital.pendidikan_kepolisian')->where('nrp', $nrp)->get()->getResultArray(),
|
|
'pendidikan_umum' => $db->table('kta_digital.pendidikan_umum')->where('nrp', $nrp)->get()->getResultArray(),
|
|
'riwayat_pangkat' => $db->table('kta_digital.riwayat_pangkat')->where('nrp', $nrp)->get()->getResultArray(),
|
|
'riwayat_jabatan' => $db->table('kta_digital.riwayat_jabatan')->where('nrp', $nrp)->get()->getResultArray(),
|
|
'pendidikan_pengembangan' => $db->table('kta_digital.pendidikan_pengembangan')->where('nrp', $nrp)->get()->getResultArray(),
|
|
'tanda_kehormatan' => $db->table('kta_digital.tanda_kehormatan')->where('nrp', $nrp)->get()->getResultArray(),
|
|
'kemampuan_bahasa' => $db->table('kta_digital.kemampuan_bahasa')->where('nrp', $nrp)->get()->getResultArray(),
|
|
'penugasan_luar_struktur' => $db->table('kta_digital.penugasan_luar_struktur')->where('nrp', $nrp)->get()->getResultArray(),
|
|
];
|
|
}
|
|
}
|