37 lines
1.1 KiB
PHP
37 lines
1.1 KiB
PHP
<?php
|
|
// php/read_laporan.php
|
|
require_once 'koneksi.php';
|
|
header('Content-Type: application/json; charset=utf-8');
|
|
|
|
$statusFilter = trim($_GET['status'] ?? '');
|
|
$kemiskinanIdRaw = isset($_GET['kemiskinan_id']) ? intval($_GET['kemiskinan_id']) : 0;
|
|
$validStatus = ['menunggu','diproses','selesai','ditolak'];
|
|
|
|
$conditions = [];
|
|
|
|
if ($kemiskinanIdRaw > 0) {
|
|
$conditions[] = "lk.kemiskinan_id = {$kemiskinanIdRaw}";
|
|
}
|
|
if (in_array($statusFilter, $validStatus)) {
|
|
$esc = mysqli_real_escape_string($conn, $statusFilter);
|
|
$conditions[] = "lk.status_laporan = '{$esc}'";
|
|
}
|
|
|
|
$where = count($conditions) ? 'WHERE ' . implode(' AND ', $conditions) : '';
|
|
|
|
$sql = "SELECT lk.*, k.nama_kepala_keluarga, k.alamat AS alamat_kk,
|
|
DATE_FORMAT(lk.created_at, '%d/%m/%Y %H:%i') AS created_fmt
|
|
FROM laporan_kondisi lk
|
|
LEFT JOIN kemiskinan k ON lk.kemiskinan_id = k.id
|
|
{$where}
|
|
ORDER BY lk.created_at DESC
|
|
LIMIT 200";
|
|
|
|
$result = mysqli_query($conn, $sql);
|
|
$data = [];
|
|
if ($result) {
|
|
while ($row = mysqli_fetch_assoc($result)) { $data[] = $row; }
|
|
}
|
|
echo json_encode($data);
|
|
?>
|