70 lines
2.0 KiB
PHP
70 lines
2.0 KiB
PHP
<?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'");
|
|
}
|
|
?>
|