<?php

header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Headers: Content-Type");
header("Access-Control-Allow-Methods: PUT, POST, OPTIONS");
header("Content-Type: application/json");

if ($_SERVER["REQUEST_METHOD"] === "OPTIONS") {
    exit;
}

require "../../config/database.php";
require "../../helpers/response.php";

$id = isset($_GET["id"]) ? (int) $_GET["id"] : 0;

if ($id <= 0) {
    response(false, "ID SPPG tidak valid", null);
}

$input = json_decode(file_get_contents("php://input"), true);

$nama = trim($input["nama"] ?? "");
$provinsi = trim($input["provinsi"] ?? "");
$kabupaten = trim($input["kabupaten"] ?? "");
$alamat = trim($input["alamat"] ?? "");
$total_dana = isset($input["total_dana"]) ? (int) $input["total_dana"] : 0;
$jumlah_siswa = isset($input["jumlah_siswa"]) ? (int) $input["jumlah_siswa"] : 0;
$status = trim($input["status"] ?? "Aktif");

if ($nama === "") {
    response(false, "Nama SPPG wajib diisi", null);
}

if ($total_dana < 0) {
    response(false, "Total dana tidak boleh negatif", null);
}

if ($jumlah_siswa < 0) {
    response(false, "Jumlah siswa tidak boleh negatif", null);
}

$checkSql = "SELECT id FROM sppg WHERE id = ? LIMIT 1";
$checkStmt = $conn->prepare($checkSql);
$checkStmt->bind_param("i", $id);
$checkStmt->execute();

$checkResult = $checkStmt->get_result();

if ($checkResult->num_rows === 0) {
    response(false, "Data SPPG tidak ditemukan", null);
}

$sql = "
    UPDATE sppg
    SET
        nama = ?,
        provinsi = ?,
        kabupaten = ?,
        alamat = ?,
        total_dana = ?,
        jumlah_siswa = ?,
        status = ?
    WHERE id = ?
";

$stmt = $conn->prepare($sql);

$stmt->bind_param(
    "ssssiisi",
    $nama,
    $provinsi,
    $kabupaten,
    $alamat,
    $total_dana,
    $jumlah_siswa,
    $status,
    $id
);

if ($stmt->execute()) {
    response(true, "Data SPPG berhasil diperbarui", [
        "id" => $id
    ]);
}

response(false, "Gagal memperbarui data SPPG", null);

?>