<?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);
?>