'PJ') ".($thn2 == '' ? "" : "AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn2'")." ".($bln2 == '' ? "" : "AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='$bln2'")." ".($r1 == null ? "" : "AND lower(k.tujuan) LIKE '%$r1%'")." ".($p1 == null ? "" : "AND lower((SELECT s.nama FROM satuan_kerja s WHERE s.id=k.penanggungjawab)) LIKE '%$p1%'")." ".($s1 == null ? "" : "AND lower(k.no_undangan) LIKE '%$s1%'")." ".($na1 == null ? "" : "AND n.riwayat_kegiatan_id IS NOT NULL")." ".($nb1 == null ? "" : "AND n.riwayat_kegiatan_id IS NULL")." GROUP BY (SELECT r.nama FROM data_ruangan r WHERE r.id=k.tempat), k.tgl_acara,k.waktu_mulai,k.waktu_selesai,k.tujuan,k.st_persiapan, k.no_undangan,k.id, (SELECT s.nama FROM satuan_kerja s WHERE s.id=k.penanggungjawab), k.st_batal,n.riwayat_kegiatan_id ORDER BY tgl_acara DESC"); while($row=pg_fetch_array($data)) { ?> >

Ruangan	Tgl Acara	Acara	Penanggungjawab	Status	No Undangan	U	M	A	N	Tools
	'. ''.date('H:i',strtotime($row['waktu_mulai'])).' - '.date('H:i',strtotime($row['waktu_selesai'])).'' ; ?>					";} ?>	";} ?>	";} ?>	";} ?>	> > > > > Dokumen Lampiran Undangan