<?php
require_once "../config/db.php";

$caseTypeId = $_POST['CaseTypeId'] ?? 0;
$eventId = $_POST['EventId'] ?? 0;
$status = $_POST['Status'] ?? 0;

if ($caseTypeId == 0 || $eventId == 0) {
    exit("Invalid Parameter");
}

if ($status == 1) {
    // ✔ เพิ่ม mapping
    $sql = "
        INSERT IGNORE INTO ct_master_case_type_event (CaseTypeId, EventId)
        VALUES (?, ?)
    ";
    $stmt = $con->prepare($sql);
    $stmt->bind_param("ii", $caseTypeId, $eventId);
    $stmt->execute();

    echo "Added";
} else {
    // ✔ ลบ mapping
    $sql = "
        DELETE FROM ct_master_case_type_event 
        WHERE CaseTypeId = ? AND EventId = ?
    ";
    $stmt = $con->prepare($sql);
    $stmt->bind_param("ii", $caseTypeId, $eventId);
    $stmt->execute();

    echo "Removed";
}