40 lines
1.8 KiB
PHP
40 lines
1.8 KiB
PHP
<?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++;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
?>
|