0) {
$upd_add = pg_query("UPDATE riwayat_kegiatan SET
tempat='$tempat',
tgl_acara='$t-$b-$h',
waktu_mulai='$waktu_mulai',
waktu_selesai='$waktu_selesai',
tujuan='$tujuan',
perencana_rapat='$perencana_rapat',
penanggungjawab='$penanggungjawab',
tanggal_pesan=NOW(),
st_pesan='PJ',
st_persiapan='PJ'
WHERE id='$id'");
} else {
$ins_add = pg_query("INSERT into riwayat_kegiatan (
tempat,
tgl_acara,
waktu_mulai,
waktu_selesai,
tujuan,
perencana_rapat,
penanggungjawab,
tanggal_pesan,
st_pesan,
st_persiapan
) values(
'$tempat',
'$t-$b-$h',
'$waktu_mulai',
'$waktu_selesai',
'$tujuan',
'$perencana_rapat',
'$penanggungjawab',
NOW(),
'PJ',
'PJ'
)
");
}
} else
if ($key=='cari_ruangan') {
$tgl_mulai=$_POST['tgl_mulai'];
$tgl_selesai=$_POST['tgl_selesai'];
$tgl_mulai=$_POST['tgl_mulai'];
$tgl_mulai=str_replace('/','-',$tgl_mulai);
$tm=date('Y',strtotime($tgl_mulai));
$bm=date('m',strtotime($tgl_mulai));
$hm=date('d',strtotime($tgl_mulai));
$tgl_selesai=$_POST['tgl_selesai'];
$tgl_selesai=str_replace('/','-',$tgl_selesai);
$ts=date('Y',strtotime($tgl_selesai));
$bs=date('m',strtotime($tgl_selesai));
$hs=date('d',strtotime($tgl_selesai));
/*$load_ruangan=pg_query("SELECT DISTINCT tempat,(SELECT nama FROM data_ruangan WHERE id=tempat)
FROM riwayat_kegiatan
WHERE (tgl_acara BETWEEN '$tm-$bm-$hm' AND '$ts-$bs-$hs')
ORDER BY tempat ASC
");*/
$load_ruangan=pg_query("SELECT nama,id FROM data_ruangan");
echo "";
while($rlm=pg_fetch_array($load_ruangan)) {
echo "";
}
} else
if ($key=='tampil') {
$tgl_mulai=$_POST['tgl_mulai'];
$tgl_selesai=$_POST['tgl_selesai'];
$cari_ruangan=$_POST['cari_ruangan'];
$tgl_mulai=$_POST['tgl_mulai'];
$tgl_mulai=str_replace('/','-',$tgl_mulai);
$tm=date('Y',strtotime($tgl_mulai));
$bm=date('m',strtotime($tgl_mulai));
$hm=date('d',strtotime($tgl_mulai));
$tgl_selesai=$_POST['tgl_selesai'];
$tgl_selesai=str_replace('/','-',$tgl_selesai);
$ts=date('Y',strtotime($tgl_selesai));
$bs=date('m',strtotime($tgl_selesai));
$hs=date('d',strtotime($tgl_selesai));
$load_tampil=pg_query("SELECT *
FROM riwayat_kegiatan
WHERE (tgl_mulai BETWEEN '$tm-$bm-$hm' AND '$ts-$bs-$hs') AND st_pesan='PJ'
AND tempat='$cari_ruangan'
");
$num_rows = pg_num_rows($load_tampil);
echo $num_rows;
} else
if ($key=="batal_add") {
$id=$_POST['id'];
$dl_add=pg_query("DELETE FROM riwayat_kegiatan WHERE id='$id' AND st_pesan='PJ'");
}
?>