Mewujudkan Generasi Qur'ani, Mandiri, dan Berdaya Saing Global di Bumi Serasan Sekate

<?php
// backend/save_content.php
header('Content-Type: application/json; charset=utf-8');
header('Access-Control-Allow-Origin: *');

$raw = file_get_contents('php://input');
$payload = json_decode($raw, true);

if (!$payload) {
    http_response_code(400);
    echo json_encode(['status' => 'error', 'message' => 'Invalid JSON']);
    exit;
}

// 1. Simpan ke Flat File Cache
file_put_contents('../data/content.json', json_encode($payload, JSON_PRETTY_PRINT));

// 2. Simpan ke Database SQLite3 Assyifa
$db = new SQLite3('../database/assyifa.sqlite3');
$stmt = $db->prepare('INSERT OR REPLACE INTO site_content (element_id, content_html, updated_at) VALUES (:id, :val, CURRENT_TIMESTAMP)');

foreach ($payload as $key => $val) {
    $stmt->bindValue(':id', $key, SQLITE3_TEXT);
    $stmt->bindValue(':val', $val, SQLITE3_TEXT);
    $stmt->execute();
}

echo json_encode(['status' => 'success', 'sync_time' => date('Y-m-d H:i:s')]);
          

CREATE TABLE IF NOT EXISTS site_content (
    element_id VARCHAR(100) PRIMARY KEY,
    content_html TEXT NOT NULL,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS donations (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    donor_name VARCHAR(150),
    amount DECIMAL(15,2),
    type VARCHAR(50) CHECK(type IN ('zakat', 'infaq', 'wakaf')),
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);