37 lines
827 B
PHP
37 lines
827 B
PHP
<?php
|
|
include("../koneksi.php");
|
|
$thn=$_POST['thn_count'];
|
|
$bln=$_POST['bln_count'];
|
|
|
|
$d1=pg_query("SELECT COUNT(*)
|
|
FROM riwayat_kegiatan k
|
|
WHERE
|
|
k.st_persiapan IN ('Ready')
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='$bln'
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b1=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(*)
|
|
FROM riwayat_kegiatan k
|
|
WHERE
|
|
k.st_persiapan IN ('Pending')
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='$bln'
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b2=$r1[0];}
|
|
|
|
$d1=pg_query("SELECT COUNT(*)
|
|
FROM riwayat_kegiatan k
|
|
WHERE
|
|
k.st_persiapan IN ('Close')
|
|
AND EXTRACT(YEAR FROM DATE(k.tgl_acara))='$thn'
|
|
AND EXTRACT(MONTH FROM DATE(k.tgl_acara))='$bln'
|
|
");
|
|
while($r1=pg_fetch_array($d1)) {$b3=$r1[0];}
|
|
|
|
|
|
echo $b1.'^'.$b2.'^'.$b3;
|
|
?>
|
|
|