<?php
include('../../koneksi.php');
$key=$_POST['key'];
if ($key=='nama_satker') {
$riwayat_peserta_id=$_POST['riwayat_peserta_id'];
$s=pg_query("SELECT p.nama,s.nama FROM data_pegawai p 
INNER JOIN riwayat_peserta r ON (p.id=r.data_pegawai_id)
INNER JOIN sebagai s ON (s.id=r.sebagai_id) 
WHERE r.id='$riwayat_peserta_id'");
while($rs=pg_fetch_array($s)) {$n=$rs[0];$m=$rs[1];}
echo $n.' - '.$m;
} else
if ($key=='simpan_nd1') {
$id=$_POST['id'];
$no_nd=$_POST['no_nd'];
$tgl_nd=$_POST['tgl_nd'];
$tgl_nd=str_replace('/','-',$tgl_nd);
$tm=date('Y',strtotime($tgl_nd));
$bm=date('m',strtotime($tgl_nd));
$hm=date('d',strtotime($tgl_nd));
$upd=pg_query("UPDATE riwayat_peserta SET no_nd='$no_nd',tgl_nd='$tm-$bm-$hm' WHERE id='$id'");
} else
if ($key=='simpan_mentor') {
  $id=$_POST['id'];
  $riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
  $data_pegawai_id=$_POST['data_pegawai_id'];
  $sebagai_id=$_POST['sebagai_id'];
  $r=pg_query("SELECT tenaga_id,tenaga2_id FROM data_pegawai WHERE id='$data_pegawai_id'");
  while($rr=pg_fetch_array($r)) {$tenaga_id=$rr[0];$tenaga2_id=$rr[1];}

$i=pg_query("SELECT satuan_kerja FROM data_pegawai WHERE id='$data_pegawai_id'");
while($ri=pg_fetch_array($i)) {$satuan_kerja_id=$ri[0];}

$cek_add=pg_query("SELECT id FROM riwayat_peserta WHERE id='$id'");
 $row_add = pg_fetch_row($cek_add);
 if ($row_add[0] > 0) {
	$upd_add = pg_query("UPDATE riwayat_peserta SET 
 		data_pegawai_id='$data_pegawai_id',
 		sebagai_id='$sebagai_id',
 		satuan_kerja_id='$satuan_kerja_id',
 		status_mentor='Pending',
 		tenaga_id='$tenaga_id',
 		tenaga2_id='$tenaga2_id'
 		WHERE id='$id'");
 	} else {
 	$ins_add = pg_query("INSERT into riwayat_peserta (
 		riwayat_kegiatan_id,
 		data_pegawai_id,
 		sebagai_id,
 		satuan_kerja_id,
 		status_mentor,
 		tenaga_id,
 		tenaga2_id
 		) values(
 		'$riwayat_kegiatan_id',
 		'$data_pegawai_id',
 		'$sebagai_id',
 		'$satuan_kerja_id',
 		'Pending',
 		'$tenaga_id',
 		'$tenaga2_id'
 		)
 	");
 }
} else
if ($key=='hapus_data') {
	$id=$_POST['id'];
	$del=pg_query("DELETE FROM riwayat_peserta WHERE id='$id'");
}
?>