<?php 
include('../../koneksi.php');
$key=$_POST['key'];

if ($key=='simpan_user') {
$id=$_POST['id'];
$password=$_POST['password'];
$jenis=$_POST['jenis'];
$aktif=$_POST['aktif'];
$username=$_POST['username'];
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$data_pegawai_id=$_POST['data_pegawai_id'];

$cek_user=pg_query("SELECT id FROM data_user WHERE id='$id'");
 $row_user = pg_fetch_row($cek_user);
 if ($row_user[0] > 0) {
  if (($data_pegawai_id=='') || ($data_pegawai_id==NULL)) {
  	$upd_user = pg_query("UPDATE data_user SET
 	nama='$username', 
 	password='$password',
 	jenis_user='$jenis',
 	aktif='$aktif',
 	satuan_kerja_id='$satuan_kerja_id',
 	modified_at=NOW()
 	WHERE id='$id'");
  } else {
    $upd_user = pg_query("UPDATE data_user SET
 	nama='$username', 
 	password='$password',
 	jenis_user='$jenis',
 	aktif='$aktif',
 	modified_at=NOW()
 	WHERE id='$id'");
  }
 } else {
    if (($data_pegawai_id=='') || ($data_pegawai_id==NULL)) {
    $ins_user = pg_query("INSERT into data_user (
 	nama,
 	password,
 	jenis_user,
 	aktif,
 	created_at,
 	modified_at,
 	satuan_kerja_id
 	) values(
 	'$username',
 	'$password',
 	'$jenis',
 	'$aktif',
 	NOW(),
 	NOW(),
 	'$satuan_kerja_id'
 	)");
    } else {
    $ins_user = pg_query("INSERT into data_user (
 	nama,
 	password,
 	jenis_user,
 	aktif,
 	created_at,
 	modified_at,
    data_pegawai_id
 	) values(
 	'$username',
 	'$password',
 	'$jenis',
 	'$aktif',
 	NOW(),
 	NOW(),
    $data_pegawai_id
 	)");
    }
 }
} else
if ($key=='list_peserta') {
$id_ms_pegawai=$_POST['id_ms_pegawai'];
$list=pg_query("SELECT p.nipb,s.nama FROM data_pegawai p INNER JOIN satuan_kerja s ON (s.id=p.satuan_kerja) WHERE p.id='$id_ms_pegawai'");
while($rlist=pg_fetch_array($list)) {
	$nipb=$rlist[0];
	$satuan_kerja=$rlist[1];
	echo $nipb.'$%^'.$satuan_kerja;
}
} else
if ($key=='delete_user') {
$id=$_POST['id'];
 $del_user = pg_query("DELETE FROM data_user WHERE id='$id'");
}  else
if ($key=='nonaktif_user') {
 $id=$_POST['id'];
 $upd_user = pg_query("UPDATE data_user SET aktif='f' WHERE id='$id'");
} else 
if ($key=='aktif_user') {
 $id=$_POST['id'];
 $upd_user = pg_query("UPDATE data_user SET aktif='t' WHERE id='$id'");
} else
if ($key=='ganti_password') {
 $nampeg=$_POST['nampeg'];
 $d=pg_query("SELECT id FROM data_pegawai WHERE nama='$nampeg'");
 while($r=pg_fetch_array($d)) {$data_pegawai_id=$r[0];}
 $baru=$_POST['baru'];
 $gp=pg_query("UPDATE data_user SET password='$baru' WHERE data_pegawai_id='$data_pegawai_id'");
} else
if ($key=='ganti_userlogin') {
 $nampeg=$_POST['nampeg'];
  $d=pg_query("SELECT id FROM data_pegawai WHERE nama='$nampeg'");
 while($r=pg_fetch_array($d)) {$data_pegawai_id=$r[0];}
 $baru=$_POST['baru'];
 $gp=pg_query("UPDATE data_user SET nama='$baru' WHERE data_pegawai_id='$data_pegawai_id'");
}


?>