﻿﻿<?php
header("Content-Type: application/json");
// Database connection
include('../include/config.php');

// Handle CRUD operations
$action = $_GET['action'] ?? '';

switch ($action) {
    case 'read':
        $id = $_GET['id'] ?? null;
        if ($id) {
            // Fetch a single record by ID
            $query = "SELECT id, title, date, time, description FROM upcoming_pooja WHERE id = ? AND deleted_at IS NULL";
            $stmt = $con->prepare($query);
            $stmt->bind_param("i", $id);
        } else {
            // Fetch all records
            $query = "SELECT id, title, date, time, description FROM upcoming_pooja WHERE deleted_at IS NULL";
            $stmt = $con->prepare($query);
        }
        $stmt->execute();
        $result = $stmt->get_result();
        $data = $result->fetch_all(MYSQLI_ASSOC);
        echo json_encode(['success' => true, 'data' => $id ? $data[0] : $data]);
        break;

    case 'create':
        $title = $_POST['title'] ?? '';
        $date = $_POST['date'] ?? '';
        $time = $_POST['time'] ?? '';
        $description = $_POST['description'] ?? '';
		///error_log("Received data - Title: $title, Date: $date, Time: $time, Description: $description");

        $query = "INSERT INTO upcoming_pooja (title, date, time, description) VALUES (?, ?, ?, ?)";
        $stmt = $con->prepare($query);
        $stmt->bind_param("ssss", $title, $date, $time, $description);

        if ($stmt->execute()) {
            echo json_encode(['success' => true, 'message' => 'Record added successfully']);
        } else {
            echo json_encode(['success' => false, 'error' => $stmt->error]);
        }
        break;

    case 'update':
        $id = $_POST['id'] ?? 0;
        $title = $_POST['title'] ?? '';
        $date = $_POST['date'] ?? '';
        $time = $_POST['time'] ?? '';
        $description = $_POST['description'] ?? '';

        $query = "UPDATE upcoming_pooja SET title=?, date=?, time=?, description=?, updated_at=NOW() WHERE id=?";
        $stmt = $con->prepare($query);
        $stmt->bind_param("ssssi", $title, $date, $time, $description, $id);

        if ($stmt->execute()) {
            echo json_encode(['success' => true, 'message' => 'Record updated successfully']);
        } else {
            echo json_encode(['success' => false, 'error' => $stmt->error]);
        }
        break;

    case 'delete':
        $id = $_GET['id'] ?? 0;
        $query = "UPDATE upcoming_pooja SET deleted_at=NOW() WHERE id=?";
        $stmt = $con->prepare($query);
        $stmt->bind_param("i", $id);

        if ($stmt->execute()) {
            echo json_encode(['success' => true, 'message' => 'Record deleted successfully']);
        } else {
            echo json_encode(['success' => false, 'error' => $stmt->error]);
        }
        break;

    default:
        echo json_encode(['success' => false, 'error' => 'Invalid action']);
}

?>