55 lines
1.4 KiB
PHP
55 lines
1.4 KiB
PHP
<?php
|
|
include("koneksi.php");
|
|
$d=pg_query("SELECT table_name FROM information_schema.tables WHERE table_schema='public'");
|
|
while($r=pg_fetch_array($d)) {
|
|
echo $r[0].'<br>';
|
|
}
|
|
?>
|
|
<br>
|
|
|
|
<?php
|
|
|
|
$d1=pg_query("SELECT column_name
|
|
FROM information_schema.columns
|
|
WHERE table_schema = 'public'
|
|
AND table_name = 'kirim'
|
|
ORDER BY column_name ASC;");
|
|
while($r1=pg_fetch_array($d1)) {
|
|
echo $r1[0].'<br>';
|
|
}
|
|
|
|
// pg_query("DELETE FROM teruskan");
|
|
$dg=pg_query("SELECT surat_id,komen_id,jabatan_dari,kirim_id_untuk,jabatan_untuk FROM teruskan");
|
|
while($rdg=pg_fetch_array($dg)) {
|
|
echo $rdg[0].'<br>';
|
|
echo $rdg[1].'<br>';
|
|
echo $rdg[2].'<br>';
|
|
echo $rdg[3].'<br>';
|
|
echo $rdg[4].'<br>';
|
|
echo $rdg[5].'<br>';
|
|
echo $rdg[6].'<br>';
|
|
}
|
|
echo '<br>';
|
|
|
|
$dg=pg_query("SELECT k.id,k.jabatan_pegawai_id,k.tanggal,k.komen,k.induk_id,j.nama as nama_jabatan,t.jabatan_untuk,j1.nama as jabuntuk
|
|
FROM komen k
|
|
INNER JOIN teruskan t ON (k.id=t.komen_id)
|
|
INNER JOIN jabatan_pegawai j ON (j.id=k.jabatan_pegawai_id)
|
|
INNER JOIN jabatan_pegawai j1 ON (j1.id=t.jabatan_untuk)");
|
|
while($rdg=pg_fetch_array($dg)) {
|
|
echo $rdg[0].'<br>';
|
|
echo $rdg[1].'<br>';
|
|
echo $rdg[2].'<br>';
|
|
echo $rdg[3].'<br>';
|
|
echo $rdg[4].'<br>';
|
|
echo $rdg[5].'<br>';
|
|
echo $rdg[6].'<br>';
|
|
echo $rdg[7].'<br>';
|
|
}
|
|
echo '<br>';
|
|
|
|
$dg=pg_query("SELECT proses_sekretariat FROM kirim ORDER BY id DESC LIMIT 200");
|
|
while($rdg=pg_fetch_array($dg)) {
|
|
echo $rdg[0].'<br>';
|
|
}
|
|
?>
|