<?php
session_start();
include '../inc/connect.php';
header('Content-Type: application/json');

$action = isset($_GET['action']) ? $_GET['action'] : (isset($_POST['action']) ? $_POST['action'] : '');
$res = array('status'=>'error','message'=>'ไม่สามารถดำเนินการได้');

switch($action){
    case 'fetch':
        $stmt = $pdo->prepare("SELECT id,title,status FROM typeServiceSuccess ORDER BY id DESC");
        $stmt->execute();
        $data = $stmt->fetchAll(PDO::FETCH_ASSOC);
        echo json_encode(array("data"=>$data));
        exit;

    case 'add':
        $title = isset($_POST['title']) ? trim($_POST['title']) : '';
        if($title===''){ $res['message']='กรุณากรอกผลการจัดกิจกรรม'; echo json_encode($res); exit; }
        $stmt = $pdo->prepare("INSERT INTO typeServiceSuccess (title,status) VALUES (?,1)");
        if($stmt->execute(array($title))){
            $res['status']='success'; $res['message']='เพิ่มสำเร็จ';
        }
        echo json_encode($res); exit;

    case 'edit':
        $id = intval($_POST['id']); $title = trim($_POST['title']);
        if($id<=0 || $title===''){ $res['message']='ข้อมูลไม่ถูกต้อง'; echo json_encode($res); exit; }
        $stmt = $pdo->prepare("UPDATE typeServiceSuccess SET title=? WHERE id=?");
        if($stmt->execute(array($title,$id))){ $res['status']='success'; $res['message']='แก้ไขสำเร็จ'; }
        echo json_encode($res); exit;

    case 'delete':
        $id = intval($_POST['id']);
        if($id<=0){ echo json_encode($res); exit; }
        $stmt = $pdo->prepare("DELETE FROM typeServiceSuccess WHERE id=?");
        if($stmt->execute(array($id))){ $res['status']='success'; $res['message']='ลบสำเร็จ'; }
        echo json_encode($res); exit;

    case 'toggle':
        $id = intval($_POST['id']); $status = intval($_POST['status']);
        if($id<=0){ echo json_encode($res); exit; }
        $stmt = $pdo->prepare("UPDATE typeServiceSuccess SET status=? WHERE id=?");
        if($stmt->execute(array($status,$id))){ $res['status']='success'; $res['message']='อัปเดตสถานะสำเร็จ'; }
        echo json_encode($res); exit;

    default:
        echo json_encode($res);
        exit;
}
?>