<?php 
include('../../koneksi.php');
$key=$_POST['key'];
if ($key=='approve') {
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$satuan_kerja_id=$_POST['satuan_kerja_id'];
$tenaga_id=$_POST['tenaga_id'];
$tenaga2_id=$_POST['tenaga2_id'];
$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 {
 		$r=pg_query("SELECT tenaga_id,tenaga2_id FROM data_pegawai WHERE id='$selected'");
 		while($rr=pg_fetch_array($r)) {$tenaga_id=$rr[0];$tenaga2_id=$rr[1];}
 		$ins_peserta = pg_query("INSERT into riwayat_peserta (
 			riwayat_kegiatan_id,
 			data_pegawai_id,
 			sebagai_id,
 			status,
 			tanggal_reg,
 			satuan_kerja_id,
 			tenaga_id,
 			tenaga2_id
 			) values(
 			'$riwayat_kegiatan_id',
 			'$selected',
 			'1',
 			'Pending',
 			NOW(),
 			'$satuan_kerja_id',
 			'$tenaga_id',
 			'$tenaga2_id'
 			)
 		");
	}	
}
} else
if ($key=='delete_peserta') {
	$id=$_POST['id'];
	$del=pg_query("DELETE FROM riwayat_peserta WHERE id='$id'");
}
?>