73 lines
2.7 KiB
PHP
73 lines
2.7 KiB
PHP
<?php
|
|
include 'koneksi.php';
|
|
|
|
$id = (int)$_GET['id'];
|
|
$tipe = $_GET['tipe'] ?? '';
|
|
|
|
header('Content-Type: application/json');
|
|
|
|
if ($tipe === 'ibadah') {
|
|
$stmt = $conn->prepare("SELECT ri.*, u.nama_lengkap AS pengurus FROM rumah_ibadah ri LEFT JOIN user u ON ri.user_id=u.id WHERE ri.id=?");
|
|
$stmt->bind_param("i", $id);
|
|
$stmt->execute();
|
|
$data = $stmt->get_result()->fetch_assoc();
|
|
|
|
// Jumlah penduduk terdaftar
|
|
$s2 = $conn->prepare("SELECT COUNT(*) AS total, SUM(status_ekonomi='miskin') AS miskin, SUM(status_ekonomi='rentan') AS rentan FROM penduduk WHERE rumah_ibadah_id=? AND status_hidup='hidup'");
|
|
$s2->bind_param("i", $id);
|
|
$s2->execute();
|
|
$data['statistik'] = $s2->get_result()->fetch_assoc();
|
|
|
|
echo json_encode($data, JSON_UNESCAPED_UNICODE);
|
|
|
|
} elseif ($tipe === 'penduduk') {
|
|
$stmt = $conn->prepare("
|
|
SELECT p.*,
|
|
TIMESTAMPDIFF(YEAR, p.tanggal_lahir, CURDATE()) AS umur,
|
|
k.no_kk, r.nama AS nama_ibadah
|
|
FROM penduduk p
|
|
LEFT JOIN keluarga k ON p.keluarga_id = k.id
|
|
LEFT JOIN rumah_ibadah r ON p.rumah_ibadah_id = r.id
|
|
WHERE p.id=?
|
|
");
|
|
$stmt->bind_param("i", $id);
|
|
$stmt->execute();
|
|
$data = $stmt->get_result()->fetch_assoc();
|
|
|
|
// Anggota keluarga (sesama KK)
|
|
if ($data['keluarga_id']) {
|
|
$s2 = $conn->prepare("SELECT id, nama, jenis_kelamin, TIMESTAMPDIFF(YEAR, tanggal_lahir, CURDATE()) AS umur, status_keluarga FROM penduduk WHERE keluarga_id=? AND id!=? AND status_hidup='hidup'");
|
|
$s2->bind_param("ii", $data['keluarga_id'], $id);
|
|
$s2->execute();
|
|
$data['anggota_keluarga'] = $s2->get_result()->fetch_all(MYSQLI_ASSOC);
|
|
} else {
|
|
$data['anggota_keluarga'] = [];
|
|
}
|
|
|
|
// Histori bantuan
|
|
$s3 = $conn->prepare("
|
|
SELECT hb.*, jb.nama AS nama_bantuan, jb.kategori
|
|
FROM histori_bantuan hb
|
|
JOIN jenis_bantuan jb ON hb.jenis_bantuan_id = jb.id
|
|
WHERE hb.penduduk_id=?
|
|
ORDER BY hb.tanggal DESC
|
|
");
|
|
$s3->bind_param("i", $id);
|
|
$s3->execute();
|
|
$data['histori_bantuan'] = $s3->get_result()->fetch_all(MYSQLI_ASSOC);
|
|
|
|
// Pelatihan
|
|
$s4 = $conn->prepare("SELECT * FROM pelatihan WHERE penduduk_id=?");
|
|
$s4->bind_param("i", $id);
|
|
$s4->execute();
|
|
$data['pelatihan'] = $s4->get_result()->fetch_all(MYSQLI_ASSOC);
|
|
|
|
echo json_encode($data, JSON_UNESCAPED_UNICODE);
|
|
|
|
} elseif ($tipe === 'laporan') {
|
|
$stmt = $conn->prepare("SELECT l.*, p.nama AS nama_penduduk FROM laporan l LEFT JOIN penduduk p ON l.penduduk_id=p.id WHERE l.id=?");
|
|
$stmt->bind_param("i", $id);
|
|
$stmt->execute();
|
|
echo json_encode($stmt->get_result()->fetch_assoc(), JSON_UNESCAPED_UNICODE);
|
|
}
|