152 lines
4.6 KiB
PHP
152 lines
4.6 KiB
PHP
<?php
|
|
include('../koneksi.php');
|
|
$key=$_POST['key'];
|
|
if ($key=='list_peserta_luar_und') {
|
|
$peserta_luar=$_POST['peserta_luars'];
|
|
$list=pg_query("SELECT instansi,id
|
|
FROM data_pegawai_luar WHERE id='$peserta_luar'");
|
|
while($rlist=pg_fetch_array($list)) {
|
|
$instansi=$rlist[0];
|
|
$id=$rlist[1];
|
|
echo $instansi.'$%^'.$id;
|
|
}
|
|
} else
|
|
if ($key=='cek_jam') {
|
|
$id=$_POST['id'];
|
|
$j=pg_query("SELECT DISTINCT waktu_mulai,waktu_selesai FROM riwayat_peserta WHERE riwayat_kegiatan_id='$id' ORDER BY waktu_mulai ASC");
|
|
while($rj=pg_fetch_array($j)) {
|
|
$waktu_mulai=$rj[0];
|
|
$waktu_selesai=$rj[1];
|
|
echo '<option value="'.date('H:i',strtotime($waktu_mulai)).' - '.date('H:i',strtotime($waktu_selesai)).'">'.date('H:i',strtotime($waktu_mulai)).' - '.date('H:i',strtotime($waktu_selesai)).'</option>';
|
|
}
|
|
} else
|
|
if ($key=='simpan_tambah') {
|
|
$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'
|
|
WHERE id='$id'");
|
|
} else { */
|
|
$ins_peserta = pg_query("INSERT into riwayat_peserta (
|
|
riwayat_kegiatan_id,
|
|
data_pegawai_id,
|
|
jabtim,
|
|
waktu_mulai,
|
|
waktu_selesai
|
|
) values(
|
|
'$riwayat_kegiatan_id',
|
|
'$data_pegawai_id',
|
|
'$jabtim',
|
|
'$waktu_mulai',
|
|
'$waktu_selesai'
|
|
)
|
|
");
|
|
// }
|
|
} else
|
|
if ($key=='simpan_undtu') {
|
|
$id=$_POST['id'];
|
|
$no_undangan=$_POST['no_undangan'];
|
|
$sifat_undangan_id=$_POST['sifat_undangan_id'];
|
|
$lampiran=$_POST['lampiran'];
|
|
//$tanggal_undangan=$_POST['tanggal_undangan'];
|
|
$tanggal_undangan=$_POST['tanggal_undangan'];
|
|
$tanggal_undangan=str_replace('/','-',$tanggal_undangan);
|
|
$t=date('Y',strtotime($tanggal_undangan));
|
|
$b=date('m',strtotime($tanggal_undangan));
|
|
$h=date('d',strtotime($tanggal_undangan));
|
|
$tempat=$_POST['tempat'];
|
|
$upd_undtu = pg_query("UPDATE riwayat_kegiatan SET
|
|
no_undangan='$no_undangan',
|
|
sifat_undangan_id='$sifat_undangan_id',
|
|
lampiran='$lampiran',
|
|
tanggal_undangan='$t-$b-$h',
|
|
tempat='$tempat'
|
|
WHERE id='$id'");
|
|
} else
|
|
if ($key=='kirim_undtu') {
|
|
$id=$_POST['id'];
|
|
$upd_undtu = pg_query("UPDATE riwayat_kegiatan SET
|
|
st_persiapan='Ready'
|
|
WHERE id='$id'");
|
|
} else
|
|
if ($key=='hapus_peserta') {
|
|
$id=$_POST['id'];
|
|
$hps=pg_query("DELETE FROM riwayat_peserta WHERE id='$id'");
|
|
} else
|
|
if ($key=="batal_undtu") {
|
|
$id=$_POST['id'];
|
|
$dl_torsatker=pg_query("UPDATE riwayat_kegiatan SET st_batal='Batal' WHERE id='$id'");
|
|
} else
|
|
if ($key=='hapus_peserta_luar') {
|
|
$id=$_POST['id'];
|
|
$hps=pg_query("DELETE FROM riwayat_peserta WHERE id='$id'");
|
|
} else
|
|
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'];
|
|
|
|
|
|
|
|
$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_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',
|
|
peserta_luar='$peserta_luar',
|
|
waktu_mulai='$waktu_mulai',
|
|
waktu_selesai='$waktu_selesai'
|
|
WHERE id='$id'");
|
|
} else {
|
|
$ins_peserta = pg_query("INSERT into riwayat_peserta (
|
|
riwayat_kegiatan_id,
|
|
peserta_luar,
|
|
waktu_mulai,
|
|
waktu_selesai
|
|
) values(
|
|
'$riwayat_kegiatan_id',
|
|
'$peserta_luar',
|
|
'$waktu_mulai',
|
|
'$waktu_selesai'
|
|
)
|
|
");
|
|
}
|
|
} else
|
|
if ($key=='batal_artu') {
|
|
$id=$_POST['id'];
|
|
pg_query("UPDATE riwayat_kegiatan SET st_persiapan='Ready' WHERE id='$id'");
|
|
}
|
|
?>
|