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];}
*/
?>