226 lines
7.8 KiB
PHP
226 lines
7.8 KiB
PHP
<?php
|
|
include("../koneksi.php");
|
|
$thn=$_POST['thn_count'];
|
|
$satker=$_POST['satker_count'];
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='1'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b1=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='2'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b2=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='3'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b3=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='4'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b4=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='5'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b5=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='6'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b6=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='7'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b7=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='8'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b8=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='9'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b9=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='10'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b10=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='11'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b11=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT
|
|
COUNT(1)
|
|
FROM (SELECT COUNT(s.id) as sid
|
|
FROM surat s
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 LEFT OUTER JOIN surat s3 ON (s3.id=k3.surat_id)
|
|
WHERE s3.jenis_disposisi_id=1) k ON (s.id=k.surat_id)
|
|
LEFT OUTER JOIN (SELECT k3.* FROM kirim k3 WHERE k3.id IS NOT NULL) kx ON (s.id=kx.surat_id)
|
|
LEFT OUTER JOIN arsip a ON (a.surat_id=s.id)
|
|
WHERE k.satuan_kerja_tujuan=$satker AND a.id IS NULL
|
|
AND s.jenis_disposisi_id='1'
|
|
AND EXTRACT(YEAR FROM DATE(s.tgl_diterima))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(s.tgl_diterima))='12'
|
|
GROUP BY
|
|
s.id
|
|
HAVING COUNT(kx.kepada)=0) a
|
|
GROUP BY sid");
|
|
while($r1=pg_fetch_array($d1)) {$b12=$r1[0];}
|
|
|
|
echo $b1.'^'.$b2.'^'.$b3.'^'.$b4.'^'.$b5.'^'.$b6.'^'.$b7.'^'.$b8.'^'.$b9.'^'.$b10.'^'.$b11.'^'.$b12;
|
|
?>
|
|
|