/home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/Manager/Inc/Update_Group.php (8905B)
query($querys);
$rows = $results->fetch_assoc();
$Admin_ID = $rows['Admin_ID'];
$Master_ID = $rows['Master_ID'];
$Manager_ID = $rows['Manager_ID'];
$query = "SELECT Time_Slot_Programs_ID, Time_Slot_ID, Time_Slot, Time_From, Time_To
FROM Time_Slot_Programs WHERE Time_Slot_Programs_ID IN ($id_list)";
$result = $mysqli->query($query);
$time_slots = [];
while ($row = $result->fetch_assoc()) {
$time_slots[] = $row;
}
if (empty($time_slots)) {
echo "No matching time slots found.";
exit();
}
$earliest_time = null;
$latest_time = null;
$time_slot_values = [];
foreach ($time_slots as $slot) {
$time_slot_values[] = $slot['Time_Slot'];
if ($earliest_time === null || strtotime($slot['Time_From']) < strtotime($earliest_time)) {
$earliest_time = $slot['Time_From'];
}
if ($latest_time === null || strtotime($slot['Time_To']) > strtotime($latest_time)) {
$latest_time = $slot['Time_To'];
}
}
$time_slot_combined = implode(",", $time_slot_values);
$Register_Time = date("Y/m/d H:i:s");
$weekendClass = isset($_POST['weekendClass']) ? 1 : 0;
if (isset($_POST['enableCustomDays']) && $_POST['enableCustomDays'] == "1") {
$class_days = isset($_POST['class_days']) ? $_POST['class_days'] : [];
$class_days_combined = !empty($class_days) ? implode(",", $class_days) : "Monday,Tuesday,Wednesday,Thursday,Friday";
if ($weekendClass == 1 && strpos($class_days_combined, 'Saturday') === false) {
$class_days_combined .= ",Saturday";
}
} else {
$class_days_combined = "Monday,Tuesday,Wednesday,Thursday,Friday";
if ($weekendClass == 1) {
$class_days_combined .= ",Saturday";
}
}
if ($update_stmt = $mysqli->prepare("UPDATE Manager_Group_Name
SET Weekend_Class = ?, Group_Name = ?, Group_Year = ?, Time_Slot = ?, Time_From = ?, Time_To = ?, Date_Time = ?, class_days = ?
WHERE Group_ID = ? AND Admin_ID = ? AND Master_ID = ? AND Manager_ID = ?")) {
$update_stmt->bind_param(
'ssssssssssss', // ✅ 13 "s" now
$weekendClass,
$Group_Name,
$Group_Year,
$time_slot_combined,
$earliest_time,
$latest_time,
$Register_Time,
$class_days_combined,
$Group_ID,
$Admin_ID,
$Master_ID,
$Manager_ID
);
if (!$update_stmt->execute()) {
error_log("❌ Update error: " . $update_stmt->error);
header('Location: addgroup.php?error=Failed to update Group Name!');
exit();
}
}
$mysqli->query("DELETE FROM Group_Slot_Mapping WHERE Group_ID = '$Group_ID'");
foreach ($time_slots as $slot) {
$Time_Slot_Programs_ID = $slot['Time_Slot_Programs_ID'];
$Time_Slot_ID = $slot['Time_Slot_ID'];
$Time_Slot = $slot['Time_Slot'];
$Time_From = $slot['Time_From'];
$Time_To = $slot['Time_To'];
if ($insert_stmt = $mysqli->prepare("INSERT INTO Group_Slot_Mapping (Group_ID, Time_Slot_ID, Time_Slot_Programs_ID, Time_Slot, Time_From, Time_To) VALUES (?, ?, ?, ?, ?, ?)")) {
$insert_stmt->bind_param('ssssss', $Group_ID, $Time_Slot_ID, $Time_Slot_Programs_ID, $Time_Slot, $Time_From, $Time_To);
if (!$insert_stmt->execute()) {
error_log("❌ Insert mapping error: " . $insert_stmt->error);
}
}
}
header('Location: addgroup.php?error=Group updated successfully!');
exit();
} else {
header('Location: addgroup.php?error=Missing Group Information.');
exit();
}
}
/*
if (isset($_POST["submit"]) && $_POST["submit"] != "") {
if (isset($_POST['G_ID'], $_POST['Group_Name'])) {
$Group_ID = $_POST['G_ID'];
$Group_Name = $_POST['Group_Name'];
$Group_Year = $_POST['Group_Year'];
// Handle Time_Slot as an array and convert it to a comma-separated string
$Time_Slot = isset($_POST['Time_Slot']) ? $_POST['Time_Slot'] : [];
$time_slot_combined = implode(",", $Time_Slot);
$Time_From = htmlspecialchars(trim($_POST['Time_From']));
$Time_To = htmlspecialchars(trim($_POST['Time_To']));
// Get the value of the weekendClass checkbox
$weekendClass = isset($_POST['weekendClass']) ? 1 : 0; // 1 if checked, 0 if not
// Custom Class Days processing (same as in add_group.php)
if (isset($_POST['enableCustomDays']) && $_POST['enableCustomDays'] == "1") {
$class_days = isset($_POST['class_days']) ? $_POST['class_days'] : [];
if (!empty($class_days)) {
$class_days_combined = implode(",", $class_days);
} else {
$class_days_combined = "Monday,Tuesday,Wednesday,Thursday,Friday";
if ($weekendClass == 1) {
$class_days_combined .= ",Saturday";
}
}
} else {
$class_days_combined = "Monday,Tuesday,Wednesday,Thursday,Friday";
if ($weekendClass == 1) {
$class_days_combined .= ",Saturday";
}
}
// Get Manager information
$user_n = $_SESSION['user_id'];
$querys = "SELECT * FROM Manager_Profile WHERE Manager_ID=?";
$stmt = $mysqli->prepare($querys);
$stmt->bind_param("s", $user_n);
$stmt->execute();
$results = $stmt->get_result();
$rows = $results->fetch_assoc();
if (!$rows) {
header('Location: addgroup.php?error=Manager profile not found!');
exit();
}
$Admin_ID = $rows['Admin_ID'];
$Master_ID = $rows['Master_ID'];
$Manager_ID = $rows['Manager_ID'];
$datetime = date("Y/m/d") . ' ' . date('H:i:s');
// Check if Group_ID exists
$prep_stmt = "SELECT Group_ID FROM Manager_Group_Name WHERE Manager_ID = ? AND Group_ID = ? LIMIT 1";
$stmt = $mysqli->prepare($prep_stmt);
if ($stmt) {
$stmt->bind_param('ss', $Manager_ID, $Group_ID);
$stmt->execute();
$stmt->store_result();
if ($stmt->num_rows == 1) {
// Update the existing group information using a prepared statement
$update_stmt = "UPDATE Manager_Group_Name
SET Weekend_Class = ?, Group_Name = ?, Group_Year = ?, Time_Slot = ?, Time_From = ?, Time_To = ?, class_days = ?
WHERE Manager_ID = ? AND Group_ID = ?";
$stmt = $mysqli->prepare($update_stmt);
if ($stmt) {
$stmt->bind_param("sssssssss", $weekendClass, $Group_Name, $Group_Year, $time_slot_combined, $Time_From, $Time_To, $class_days_combined, $Manager_ID, $Group_ID);
if ($stmt->execute()) {
header('Location: addgroup.php?error=Group update successfully. Thanks!');
exit();
} else {
header('Location: addgroup.php?error=Group update failure!');
exit();
}
} else {
header('Location: addgroup.php?error=Database update error!');
exit();
}
} else {
header('Location: addgroup.php?error=Group not found!');
exit();
}
} else {
header('Location: addgroup.php?error=Database query error!');
exit();
}
} else {
header('Location: addgroup.php?error=All information is required!');
exit();
}
}
*/
?>