16 lines
533 B
PHP
16 lines
533 B
PHP
<?php
|
|
$satker = $_POST['satker'];
|
|
|
|
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='$satker' AND (s.satuan_kerja_id <> k.satuan_kerja_tujuan) AND COALESCE(s.tahun,'') <> 'batal'
|
|
AND k.proses_tu IS NULL
|
|
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;
|