require("./global.php");
if (isset($_POST['create_package'])) {
$timeAdded = time();
$actionId = escape(($_POST['actionId']));
$title = escape($_POST['title']);
$category = escape($_POST['category']);
$start_time = date("Y-m-d H:i:s", strtotime($_POST["start_time"]));
$end_time = date("Y-m-d H:i:s", strtotime($_POST["end_time"]));
$linked_ticket = !empty($_POST['linked_ticket']) ? mysqli_real_escape_string($con, $_POST['linked_ticket']) : NULL;
$assigned_users = isset($_POST['assigned_users']) ? $_POST['assigned_users'] : [];
$assigned_users_json = json_encode($assigned_users); // Store assigned users as JSON
if ($actionId == "") {
$id = generateRandomString();
$actionId = $id;
$query = "insert into " . $g_projectSlug . "_calendar_reminders set id='$id' , title='$title', apptTime='$start_time',endTime='$end_time', color='$category', timeAdded='$timeAdded', userId='$session_userId', linked_ticket='$linked_ticket', assigned_users='$assigned_users_json' ";
} else {
$query = "update " . $g_projectSlug . "_calendar_reminders set id='$actionId' , title='$title', apptTime='$start_time',endTime='$end_time', color='$category',linked_ticket='$linked_ticket', assigned_users='$assigned_users_json' where id='$actionId'";
}
$stmt = $con->prepare($query);
if (!$stmt) {
echo "err: $query";
}
if (!$stmt->execute()) {
echo "err: $query";
}
$rStr = "";
if (isset($_GET['id'])) {
$rStr .= "&id=" . $_GET['id'];
}
header("Location: ?m=Data was saved successfully!" . $rStr);
}
if (isset($_GET['delete-record'])) {
$id = mb_htmlentities($_GET['delete-record']);
$stmt = $con->prepare("delete from " . $g_projectSlug . "_calendar_reminders where id=?");
$stmt->bind_param("s", $id);
if (!$stmt->execute()) {
echo "err";
}
}
?>