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

if ($key=='simpan_peserta_luar') {
$id=$_POST['id'];
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$waktu_mulai=$_POST['waktu_mulai'];
$waktu_selesai=$_POST['waktu_selesai'];
$peserta_luar=$_POST['peserta_luar'];

$nama=$_POST['nama'];
$nipb=$_POST['nipb'];
$jenis_kelamin=$_POST['jenis_kelamin'];
$instansi=$_POST['instansi'];
$jabatan=$_POST['jabatan'];

$riwayat_peserta_id=$_POST['riwayat_peserta_id'];

/*
$cek_luar=pg_query("SELECT id FROM data_pegawai_luar WHERE id='$peserta_luar'");
 $row_luar = pg_fetch_row($cek_luar);
 if ($row_luar[0] > 0) {
 	$upd_lain=pg_query("UPDATE data_pegawai_luar SET nama='$nama',jenis_kelamin='$jenis_kelamin',instansi='$instansi',nipb='$nipb',jabatan='$jabatan'
 		WHERE id='$peserta_luar'");
 } else {
	$inp_lain=pg_query("INSERT INTO data_pegawai_luar (nama,jenis_kelamin,instansi,nipb,jabatan) 
		VALUES ('$nama','$jenis_kelamin','$instansi','$nipb','$jabatan')
		");
	$d=pg_query("SELECT l1.id FROM data_pegawai_luar l1 WHERE l1.id=(SELECT MAX(l2.id) FROM data_pegawai_luar l2)");
	while($rd=pg_fetch_array($d)) {$peserta_luar=$rd[0];}
 }
*/

$cek_luar=pg_query("SELECT id FROM data_pegawai_luar WHERE id='$peserta_luar'");
 $row_luar = pg_fetch_row($cek_luar);
 if ($row_luar[0] > 0) {
 	$upd_lain=pg_query("UPDATE data_pegawai_luar SET nama='$nama',instansi='$instansi',nipb='$nipb',jabatan='$jabatan'
 		WHERE id='$peserta_luar'");
 } else {
	$inp_lain=pg_query("INSERT INTO data_pegawai_luar (nama,instansi,nipb,jabatan) 
		VALUES ('$nama','$instansi','$nipb','$jabatan')
		");
	$d=pg_query("SELECT l1.id FROM data_pegawai_luar l1 WHERE l1.id=(SELECT MAX(l2.id) FROM data_pegawai_luar l2)");
	while($rd=pg_fetch_array($d)) {$peserta_luar=$rd[0];}
 }

$cek_peserta=pg_query("SELECT id FROM riwayat_peserta WHERE id=$riwayat_peserta_id");
 $row_peserta = pg_fetch_row($cek_peserta);
 if ($row_peserta[0] > 0) {
$upd_peserta = pg_query("UPDATE riwayat_peserta SET 
 	riwayat_kegiatan_id='$riwayat_kegiatan_id',
 	peserta_luar='$peserta_luar',
 	waktu_mulai='$waktu_mulai',
 	waktu_selesai='$waktu_selesai',
    st_terima=NULL,tgl_terima=NULL
 	WHERE id=$riwayat_peserta_id");
 } else {
 $urut=pg_query("SELECT COALESCE(MAX(penerimaan_undangan),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'");
 while($rurut=pg_fetch_array($urut)) {$no_urut=$rurut[0]+1;}

 $ins_peserta = pg_query("INSERT into riwayat_peserta (
 	riwayat_kegiatan_id,
 	peserta_luar,
 	waktu_mulai,
 	waktu_selesai,
 	penerimaan_undangan
 	) values(
 	'$riwayat_kegiatan_id',
 	'$peserta_luar',
 	'$waktu_mulai',
 	'$waktu_selesai',
 	'$no_urut'
 	)
 ");
 }
}  else

if ($key=='simpan_peserta') {
$id=$_POST['id'];
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$data_pegawai_id=$_POST['data_pegawai_id'];
$jabtim=$_POST['jabtim'];
$waktu_mulai=$_POST['waktu_mulai'];
$waktu_selesai=$_POST['waktu_selesai'];

$cek_peserta=pg_query("SELECT id FROM riwayat_peserta WHERE id='$id'");
 $row_peserta = pg_fetch_row($cek_peserta);
 if ($row_peserta[0] > 0) {
$upd_peserta = pg_query("UPDATE riwayat_peserta SET 
 	riwayat_kegiatan_id='$riwayat_kegiatan_id',
 	data_pegawai_id='$data_pegawai_id',
 	jabtim='$jabtim',
 	waktu_mulai='$waktu_mulai',
 	waktu_selesai='$waktu_selesai',
    st_terima=NULL,tgl_terima=NULL
 	WHERE id='$id'");
 } else {
$cek_peserta2=pg_query("SELECT data_pegawai_id FROM riwayat_peserta WHERE data_pegawai_id='$data_pegawai_id' AND riwayat_kegiatan_id='$riwayat_kegiatan_id'");
 $row_peserta2 = pg_fetch_row($cek_peserta2);
 if ($row_peserta2[0] > 0) {echo "vj";} else {
 
 $urut=pg_query("SELECT COALESCE(MAX(penerimaan_undangan),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'");
 while($rurut=pg_fetch_array($urut)) {$no_urut=$rurut[0]+1;}

 $ins_peserta = pg_query("INSERT into riwayat_peserta (
 	riwayat_kegiatan_id,
 	data_pegawai_id,
 	jabtim,
 	waktu_mulai,
 	waktu_selesai,
 	penerimaan_undangan
 	) values(
 	'$riwayat_kegiatan_id',
 	'$data_pegawai_id',
 	'$jabtim',
 	'$waktu_mulai',
 	'$waktu_selesai',
 	'$no_urut'
 	)
 ");
 }
 }
}  else
if ($key=="delete_peserta") {
$id=$_POST['id'];
$dl_peserta=pg_query("DELETE FROM riwayat_peserta WHERE id='$id'");  
} else
if ($key=='list_peserta') {
$data_pegawai_id=$_POST['data_pegawai_id'];
$list=pg_query("SELECT nipb,golongan,ruang,jenis_kelamin,
	(SELECT nama FROM satuan_kerja WHERE id=satuan_kerja),
	(SELECT nama FROM jabatan_pegawai WHERE id=jabatan_pegawai_id)
	FROM data_pegawai WHERE id='$data_pegawai_id'");
while($rlist=pg_fetch_array($list)) {
	$nipb=$rlist[0];
	$gol=$rlist[1].'/'.$rlist[2];
	$sex=$rlist[3];
	$kerja=$rlist[4];
	$jabmen=$rlist[5];
	echo $nipb.'$%^'.$gol.'$%^'.$sex.'$%^'.$kerja.'$%^'.$jabmen;
}
} else
if ($key=='kirim_permintaan') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$upd_kg = pg_query("UPDATE riwayat_kegiatan SET st_persiapan='Pending' WHERE id='$riwayat_kegiatan_id'");
$cek=pg_query("SELECT id FROM kirim_permintaan WHERE riwayat_kegiatan_id=$riwayat_kegiatan_id");
$row = pg_fetch_row($cek);
 if ($row[0] > 0) {
 	pg_query("UPDATE kirim_permintaan SET tanggal_kirim=NOW() WHERE riwayat_kegiatan_id=$riwayat_kegiatan_id");
 } else {
 	pg_query("INSERT INTO kirim_permintaan (riwayat_kegiatan_id,tanggal_kirim) VALUES ($riwayat_kegiatan_id,NOW())");
 }
}  else
if ($key=='list_peserta_luar') {
$peserta_luar=$_POST['peserta_luars'];
$list=pg_query("SELECT nama,jenis_kelamin,instansi,nipb,jabatan,id
	FROM data_pegawai_luar WHERE id='$peserta_luar'");
while($rlist=pg_fetch_array($list)) {
	$nama=$rlist[0];
	$jenis_kelamin=$rlist[1];
	$instansi=$rlist[2];
	$nipb=$rlist[3];
	$jabatan=$rlist[4];
	echo $nama.'$%^'.$jenis_kelamin.'$%^'.$instansi.'$%^'.$nipb.'$%^'.$jabatan.'$%^'.$id;
}
}  else
if ($key=='approve') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$data_pegawai_id=$_POST['data_pegawai_id'];
$waktu_mulai=$_POST['waktu_mulai'];
$waktu_selesai=$_POST['waktu_selesai'];
$a=$_POST['pegawai_id'];
$pecah=explode(',',$a);
foreach($pecah as $selected) {

$cek_peserta2=pg_query("SELECT data_pegawai_id FROM riwayat_peserta WHERE data_pegawai_id='$selected' AND riwayat_kegiatan_id='$riwayat_kegiatan_id'");
 $row_peserta2 = pg_fetch_row($cek_peserta2);
 if ($row_peserta2[0] > 0) {} else {
 $jab_peg=pg_query("SELECT j.nama FROM jabatan_pegawai j WHERE j.id=(SELECT p.jabatan_pegawai_id FROM data_pegawai p WHERE p.id='$selected')");
 while($rja=pg_fetch_array($jab_peg)) {$jabtim=$rja[0];}

 $urut=pg_query("SELECT COALESCE(MAX(penerimaan_undangan),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id='$riwayat_kegiatan_id'");
 while($rurut=pg_fetch_array($urut)) {$no_urut=$rurut[0]+1;}
 
 $ins_peserta = pg_query("INSERT into riwayat_peserta (
 	riwayat_kegiatan_id,
 	data_pegawai_id,
 	jabtim,
 	waktu_mulai,
 	waktu_selesai,
 	penerimaan_undangan
 	) values(
 	'$riwayat_kegiatan_id',
 	'$selected',
 	'$jabtim',
 	'$waktu_mulai',
 	'$waktu_selesai',
 	'$no_urut'
 	)
 ");
}
}
}
?>