You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 lines
662 B
22 lines
662 B
<?php |
|
|
|
namespace App\Models; |
|
|
|
use CodeIgniter\Model; |
|
|
|
class Mauth extends Model |
|
{ |
|
|
|
function cekuser($username) |
|
{ |
|
$builder = $this->db->table('PEGAWAI'); |
|
$builder->select('PEGAWAI.*,DIM_KANTOR.TP_KANTOR,DIM_KANTOR.KD_KANWIL'); |
|
$builder->join('DIM_KANTOR', 'PEGAWAI.KD_KANTOR = DIM_KANTOR.KD_KANTOR'); |
|
$builder->where('PEGAWAI.NIP9', $username); |
|
return $builder->get(); |
|
|
|
/* $query = $this->db->query("SELECT A.*,B.TP_KANTOR,B.KD_KANWIL FROM PEGAWAI A |
|
LEFT JOIN DIM_KANTOR B ON A.KD_KANTOR = B.KD_KANTOR WHERE A.NIP9 = '" . $username . "'"); |
|
return $query; */ |
|
} |
|
}
|
|
|