49 lines
1.2 KiB
PHP
49 lines
1.2 KiB
PHP
<?php
|
|
include('../../koneksi.php');
|
|
$key=$_POST['key'];
|
|
|
|
if ($key=='simpan_pejabat') {
|
|
$id=$_POST['id'];
|
|
$data_pegawai_id=$_POST['data_pegawai_id'];
|
|
$pangkat=$_POST['pangkat'];
|
|
$sp_jenis_pejabat_id=$_POST['sp_jenis_pejabat_id'];
|
|
$aktif=$_POST['aktif'];
|
|
|
|
|
|
$cek_user=pg_query("SELECT id FROM sp_pejabat WHERE id='$id'");
|
|
$row_user = pg_fetch_row($cek_user);
|
|
if ($row_user[0] > 0) {
|
|
$upd_user = pg_query("UPDATE sp_pejabat SET
|
|
data_pegawai_id='$data_pegawai_id',
|
|
pangkat='$pangkat',
|
|
sp_jenis_pejabat_id='$sp_jenis_pejabat_id',
|
|
aktif='$aktif'
|
|
WHERE id='$id'");
|
|
} else {
|
|
$ins_user = pg_query("INSERT into sp_pejabat (
|
|
data_pegawai_id,
|
|
pangkat,
|
|
sp_jenis_pejabat_id,
|
|
aktif
|
|
) values(
|
|
'$data_pegawai_id',
|
|
'$pangkat',
|
|
'$sp_jenis_pejabat_id',
|
|
'$aktif'
|
|
)
|
|
");
|
|
}
|
|
} else
|
|
if ($key=='list_peserta') {
|
|
$id_ms_pegawai=$_POST['id_ms_pegawai'];
|
|
$list=pg_query("SELECT p.nipb FROM data_pegawai p WHERE p.id='$id_ms_pegawai'");
|
|
while($rlist=pg_fetch_array($list)) {
|
|
$nipb=$rlist[0];
|
|
echo $nipb;
|
|
}
|
|
} else
|
|
if ($key=='delete_pejabat') {
|
|
$id=$_POST['id'];
|
|
$del_user = pg_query("DELETE FROM sp_pejabat WHERE id='$id'");
|
|
}
|
|
?>
|