r.satuan_kerja_tujuan)
AND s.jenis_surat_id='3' AND s.jenis_disposisi_id='3' AND r.lama IS NOT NULL AND r.dis_baca IS NULL AND COALESCE(s.tahun,'') <> 'batal'
".($thn2 == '' ? "" : "AND EXTRACT(YEAR FROM DATE(r.lama))='$thn2'")."
".($bln2 == '0' ? "" : "AND EXTRACT(MONTH FROM DATE(r.lama))='$bln2'")."
GROUP BY r.lama,s.perihal,s.satuan_kerja_id,s.id,j.nama,r.proses_tu,r.id
ORDER BY r.lama DESC
");
while($r=pg_fetch_array($data)) {
$dsa=$r['id'];
$tj=$r[6];
$tk=$r[7];
$isi=$r['isi'];
$surat_id=$r[3];
/*
$l=pg_query("SELECT COUNT(*)
FROM scan k INNER JOIN surat s ON (k.surat_id=s.id)
WHERE k.surat_id='$dsa' AND LOWER(k.file) LIKE '%jpg'");
while($rl=pg_fetch_array($l)) {$tj=$rl[0];}
$m=pg_query("SELECT COUNT(*)
FROM scan k INNER JOIN surat s ON (k.surat_id=s.id)
WHERE k.surat_id='$dsa' AND LOWER(k.file) NOT LIKE '%jpg'");
while($rm=pg_fetch_array($m)) {$tk=$rm[0];}
*/
?>