165 lines
5.2 KiB
PHP
165 lines
5.2 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$thn=$_POST['thn_count'];
|
|
$satker=$_POST['satker_count'];
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='1'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b1=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='2'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b2=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='3'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b3=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='4'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b4=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='5'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b5=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='6'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b6=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='7'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b7=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='8'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b8=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='9'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b9=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='10'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b10=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='11'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b11=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(DISTINCT p.id)
|
|
FROM riwayat_kegiatan k
|
|
INNER JOIN riwayat_peserta p ON (p.riwayat_kegiatan_id=k.id)
|
|
INNER JOIN data_pegawai w ON (w.id=p.data_pegawai_id)
|
|
WHERE k.st_persiapan='Ready'
|
|
AND w.satuan_kerja='$satker'
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='12'
|
|
AND p.st_terima IS NULL
|
|
AND k.st_batal IS NULL
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b12=$r1[0];}
|
|
|
|
echo $b1.'^'.$b2.'^'.$b3.'^'.$b4.'^'.$b5.'^'.$b6.'^'.$b7.'^'.$b8.'^'.$b9.'^'.$b10.'^'.$b11.'^'.$b12;
|
|
?>
|
|
|