15 lines
721 B
PHP
15 lines
721 B
PHP
<?php
|
|
$satker=172;
|
|
|
|
include('../koneksi.php');
|
|
$data = pg_query("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;
|
|
?>
|
|
|