16 lines
500 B
PHP
16 lines
500 B
PHP
<?php
|
|
$satker = 172;
|
|
|
|
include('../koneksi.php');
|
|
$data = pg_query($koneksi,"SELECT COUNT(*)
|
|
FROM surat s
|
|
INNER JOIN kirim k ON (s.id=k.surat_id)
|
|
WHERE k.satuan_kerja_tujuan=172 AND (s.satuan_kerja_id <> k.satuan_kerja_tujuan)
|
|
AND k.proses_tu IS NULL AND COALESCE(s.tahun,'') <> 'batal'
|
|
AND s.jenis_surat_id='3' AND s.jenis_disposisi_id='3' AND k.lama IS NOT NULL
|
|
");
|
|
while ($r = pg_fetch_array($data)) {
|
|
$j = $r[0];
|
|
}
|
|
echo $j;
|