Edit File - assign_wellness.php

<?php

include '../database/config.php';

session_start();
if(isset($_SESSION['user_id']) && $_SESSION['user_id']){
    $created_by = $_SESSION['user_id'];
}
else{
    $created_by = 'System';
}

if (isset($_POST['memberId'], $_POST['wellnessType'], $_POST['name'], $_POST['price'], $_POST['validityDays'], $_POST['duration'])) {
    $member_id = $_POST['memberId'];
    $wellness_type = $_POST['wellnessType'];
    $package_name = $_POST['name'];
    $price = $_POST['price'];
    $session_duration = $_POST['duration'];
    $validity_days = $_POST['validityDays'];
    $startDate = date('Y-m-d');
    $endDate = date('Y-m-d', strtotime("+$validity_days days"));
    if($validity_days == 1) {
        $endDate = $startDate;
    }

$sql = "INSERT INTO member_wellness (`member_id`, `wellness_type`, `session_name`, `session_duration`, `session_amount`, `session_start`, `session_end`, `validity_days`, `pay_ref`, `created_by`) 
   VALUES ('$member_id', '$wellness_type', '$package_name', '$session_duration', '$price', '$startDate', '$endDate', '$validity_days', NULL, '$created_by')";
   $read = mysqli_query($conn, $sql);

$lastID = mysqli_insert_id($conn);

if ($read) {
       echo json_encode(["status" => "success", "message" => "Wellness package assigned successfully.", "id" => $lastID]);
   } else {
       echo json_encode(["status" => "error", "message" => "Error assigning wellness package: " . mysqli_error($conn)]);
   }

}

$conn->close();

Kembali