<?php 
include('../../koneksi.php');
$key=$_POST['key'];
if ($key=='close_absensi') {
$riwayat_kegiatan_id_lama=$_POST['riwayat_kegiatan_id_lama'];
$riwayat_kegiatan_id=$_POST['riwayat_kegiatan_id'];
$a=$_POST['pegawai_id'];

$cv=pg_query("SELECT waktu_mulai,waktu_selesai FROM riwayat_kegiatan WHERE id=$riwayat_kegiatan_id");
while($rcv=pg_fetch_array($cv)) {$mulai=$rcv[0];$selesai=$rcv[1];}

$cu=pg_query("SELECT COALESCE(MAX(penerimaan_undangan),0) FROM riwayat_peserta WHERE riwayat_kegiatan_id=$riwayat_kegiatan_id");
while($rcu=pg_fetch_array($cu)) {$mx=$rcu[0];}
$urut=$mx+1; 

$pecah=explode(',',$a);
foreach($pecah as $selected) {
 $kerek=substr($selected, 0, 1);
  if ($kerek=='L') {
    $asu=explode("L",$selected);
  	$peserta_luar=$asu[1];
    $cek_peserta2=pg_query("SELECT peserta_luar FROM riwayat_peserta WHERE peserta_luar=$peserta_luar AND riwayat_kegiatan_id='$riwayat_kegiatan_id'");
 	$row_peserta2 = pg_fetch_row($cek_peserta2);
 	if ($row_peserta2[0] > 0) {} else {
 		pg_query("INSERT INTO riwayat_peserta (riwayat_kegiatan_id,peserta_luar,penerimaan_undangan,waktu_mulai,waktu_selesai) VALUES ($riwayat_kegiatan_id,$peserta_luar,$urut,'$mulai','$selesai')");
 		$urut++;
 	}
  } else {
 	$cjb=pg_query("SELECT j.nama FROM data_pegawai p INNER JOIN jabatan_pegawai j ON (j.id=p.jabatan_pegawai_id) WHERE p.id=$selected");
 	while($rcjb=pg_fetch_array($cjb)) {$jabtim=$rcjb[0];}
	$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 {
 		pg_query("INSERT INTO riwayat_peserta (riwayat_kegiatan_id,data_pegawai_id,penerimaan_undangan,jabtim,waktu_mulai,waktu_selesai) VALUES ($riwayat_kegiatan_id,$selected,$urut,'$jabtim','$mulai','$selesai')");
 		$urut++;
 	}
  }
} 
}
?>