$date) { $sessions_array[] = array( 'id' => $id, 'date' => $date, 'time' => $open_wu_times[$id] ); } // Sort sessions by date and time usort($sessions_array, function($a, $b) { $date_compare = strtotime($a['date']) - strtotime($b['date']); if ($date_compare == 0) { return strtotime($a['time']) - strtotime($b['time']); } return $date_compare; }); // Assign new session numbers based on sorted order $session_num = 1; foreach ($sessions_array as $session) { $id = $session['id']; $session_num = mysqli_real_escape_string($conn, $_POST['session_num'][$id]); // Use the provided session number // Update each session with new values and session number $update_query = "UPDATE sessions SET session_num = ?, session_date = ?, open_wu_time = ?, march_in_time = ?, timd_wu_time = ?, awards_time = ?, type = ?, flights = ? WHERE id = ?"; $stmt = mysqli_prepare($conn, $update_query); mysqli_stmt_bind_param($stmt, "sssssssii", $session_num, // Use the string value of session_num $session_dates[$id], $open_wu_times[$id], $march_in_times[$id], $timd_wu_times[$id], $awards_times[$id], $types[$id], $flights[$id], $id ); if (!mysqli_stmt_execute($stmt)) { die("Error updating session: " . mysqli_error($conn)); } mysqli_stmt_close($stmt); $session_num++; } $success = "
Sessions updated successfully!
"; } //delete session if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['delete_session'])) { $session_id = intval($_POST['delete_session']); // Delete the session $query = "DELETE FROM sessions WHERE id = ? AND meet_number = ?"; $stmt = mysqli_prepare($conn, $query); if ($stmt) { mysqli_stmt_bind_param($stmt, "ii", $session_id, $_SESSION['selected_meet']); if (mysqli_stmt_execute($stmt)) { $success = "
Session deleted successfully!
"; } else { $success = "
Error deleting session: " . mysqli_error($conn) . "
"; } mysqli_stmt_close($stmt); } } //insert session if ($_SERVER['REQUEST_METHOD'] == 'POST' && $_POST['action'] == "create_session") { // First get the meet name from MeetInfo table $meet_query = "SELECT meet_name FROM MeetInfo WHERE meet_number = ?"; $meet_stmt = mysqli_prepare($conn, $meet_query); mysqli_stmt_bind_param($meet_stmt, "i", $_SESSION['selected_meet']); mysqli_stmt_execute($meet_stmt); mysqli_stmt_bind_result($meet_stmt, $meet_name); mysqli_stmt_fetch($meet_stmt); mysqli_stmt_close($meet_stmt); // Parse the combined levels, gyms, and age_groups string $combined = explode('###', $_POST['levels_clubs']); $levels = $combined[0]; $gyms = $combined[1]; $age_groups = isset($combined[2]) ? $combined[2] : ''; // Validate and sanitize inputs $session_num = mysqli_real_escape_string($conn, $_POST['session_num']); $total_gymnasts = intval($_POST['total_gymnasts']); $session_date = mysqli_real_escape_string($conn, $_POST['session_date']); $open_wu_time = mysqli_real_escape_string($conn, $_POST['open_wu_time']); $march_in_time = mysqli_real_escape_string($conn, $_POST['march_in_time']); $timd_wu_time = mysqli_real_escape_string($conn, $_POST['timd_wu_time']); $awards_time = mysqli_real_escape_string($conn, $_POST['awards_time']); $type = mysqli_real_escape_string($conn, $_POST['type']); $flights = intval($_POST['flights']); // Insert the new session $query = "INSERT INTO sessions ( meet_number, meet, session_num, levels, gyms, age_groups, session_date, open_wu_time, march_in_time, timd_wu_time, awards_time, type, flights ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; $stmt = mysqli_prepare($conn, $query); if ($stmt) { mysqli_stmt_bind_param($stmt, "isssssssssssi", $_SESSION['selected_meet'], $meet_name, $session_num, $levels, $gyms, $age_groups, $session_date, $open_wu_time, $march_in_time, $timd_wu_time, $awards_time, $type, $flights ); if (mysqli_stmt_execute($stmt)) { $success = "
Session created successfully!
"; } else { $success = "
Error creating session: " . mysqli_error($conn) . "
"; } mysqli_stmt_close($stmt); } } if (isset($_SESSION['selected_meet'])){ // Handle meet selection if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['selected_meet'])) { $_SESSION['selected_meet'] = $_POST['selected_meet']; } if (isset($_POST['selected_meet'])) { // Meet just selected, set up session variables $selected_meet = $_POST['selected_meet']; $query = "SELECT meet_name, table_name FROM MeetInfo WHERE meet_number = ?"; $stmt = mysqli_prepare($conn, $query); mysqli_stmt_bind_param($stmt, "i", $selected_meet); mysqli_stmt_execute($stmt); mysqli_stmt_store_result($stmt); if (mysqli_stmt_num_rows($stmt) > 0) { mysqli_stmt_bind_result($stmt, $meet_name, $table_name); mysqli_stmt_fetch($stmt); $_SESSION['selected_meet'] = $selected_meet; $_SESSION['table_name'] = $table_name; $_SESSION['meet_name'] = $meet_name; $show_meet_selection = false; } mysqli_stmt_close($stmt); } // Use the session variable if it exists, otherwise use the default $selectedMeet = isset($_SESSION['selected_meet']) ? $_SESSION['selected_meet'] : $defaultMeetID; // Fetch MeetIDs for the logged-in user $username = $_SESSION['username']; $query = "SELECT MeetIDs FROM login WHERE user = ?"; $stmt = $conn->prepare($query); if ($stmt === false) { die("Prepare failed: " . $conn->error); } $stmt->bind_param("s", $username); $stmt->execute(); $stmt->bind_result($meetID); $stmt->fetch(); $meetIDs = explode(',', $meetID); $stmt->close(); // Fetch meet names for the user's MeetIDs $meetOptions = array(); foreach ($meetIDs as $meetID) { $query = "SELECT meet_name FROM MeetInfo WHERE meet_number = ?"; $stmt = $conn->prepare($query); $stmt->bind_param("s", $meetID); $stmt->execute(); $stmt->bind_result($meetName); if ($stmt->fetch()) { $meetOptions[$meetID] = $meetName; } $stmt->close(); } // Check if there's only one meet if (count($meetOptions) == 1) { reset($meetOptions); $defaultMeetID = key($meetOptions); } else { $defaultMeetID = ''; } //var_dump($_SESSION); $query = "SELECT level, COUNT(id) as gymnast_count FROM {$_SESSION['table_name']} GROUP BY level"; //echo $query; $result = mysqli_query($conn, $query); if (!$result) { die("Database query failed: " . mysqli_error($conn)); } } // Add this with your other POST action handlers if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Add this in your existing PHP code where you handle the age groups response if ($_POST['action'] == 'check_age_groups') { $level = mysqli_real_escape_string($conn, $_POST['level']); // Get all sessions that use this level $assignedGroups = array(); $sessionsQuery = "SELECT age_groups FROM sessions WHERE meet_number = {$_SESSION['selected_meet']} AND levels LIKE '%$level%'"; $sessionsRes = mysqli_query($conn, $sessionsQuery); if ($sessionsRes) { while ($row = mysqli_fetch_assoc($sessionsRes)) { if (!empty($row['age_groups'])) { $groups = explode('^', $row['age_groups']); foreach ($groups as $group) { if (!empty($group)) { $ranges = explode(',', $group); foreach ($ranges as $range) { $assignedGroups[$range] = true; } } } } } } $query = "SELECT * FROM splitGroups WHERE meet_id = {$_SESSION['selected_meet']} AND level = '$level' AND session = 0 ORDER BY min_birth_date"; $result = mysqli_query($conn, $query); $response = [ 'hasAgeGroups' => false, 'groups' => [], 'hasGymAssignments' => false ]; if (mysqli_num_rows($result) > 0) { $response['hasAgeGroups'] = true; while ($row = mysqli_fetch_assoc($result)) { $dateRange = date('m/d/Y', strtotime($row['min_birth_date'])) . '|' . date('m/d/Y', strtotime($row['max_birth_date'])); $count = getGymnastCount($conn, $_SESSION['table_name'], $level, $row['min_birth_date'], $row['max_birth_date']); $response['groups'][] = [ 'min_date' => date('m/d/Y', strtotime($row['min_birth_date'])), 'max_date' => date('m/d/Y', strtotime($row['max_birth_date'])), 'count' => $count, 'isAssigned' => isset($assignedGroups[$dateRange]) ]; } } echo json_encode($response); exit; } if ($_POST['action'] == 'create_age_groups') { $level = mysqli_real_escape_string($conn, $_POST['level']); $groupCount = intval($_POST['groupCount']); // Get birth date range for level $query = "SELECT MIN(birth_date) as min_date, MAX(birth_date) as max_date FROM {$_SESSION['table_name']} WHERE level = '$level'"; $result = mysqli_query($conn, $query); $dates = mysqli_fetch_assoc($result); // Calculate equal groups $query = "SELECT birth_date FROM {$_SESSION['table_name']} WHERE level = '$level' ORDER BY birth_date"; $result = mysqli_query($conn, $query); $birthDates = []; while ($row = mysqli_fetch_assoc($result)) { $birthDates[] = $row['birth_date']; } $totalGymnasts = count($birthDates); $gymnastsPerGroup = ceil($totalGymnasts / $groupCount); // Clear existing groups mysqli_query($conn, "DELETE FROM splitGroups WHERE meet_id = {$_SESSION['selected_meet']} AND level = '$level' AND session = 0"); // Create new groups for ($i = 0; $i < $groupCount; $i++) { $startIdx = $i * $gymnastsPerGroup; $endIdx = min(($i + 1) * $gymnastsPerGroup - 1, $totalGymnasts - 1); if (isset($birthDates[$startIdx]) && isset($birthDates[$endIdx])) { $query = "INSERT INTO splitGroups (meet_id, session, level, age, min_birth_date, max_birth_date) VALUES ({$_SESSION['selected_meet']}, 0, '$level', $i, '{$birthDates[$startIdx]}', '{$birthDates[$endIdx]}')"; mysqli_query($conn, $query); } } echo json_encode(['success' => true]); exit; } if ($_POST['action'] == 'delete_age_groups') { $level = mysqli_real_escape_string($conn, $_POST['level']); mysqli_query($conn, "DELETE FROM splitGroups WHERE meet_id = {$_SESSION['selected_meet']} AND level = '$level' AND session = 0"); echo json_encode(['success' => true]); exit; } } // Add this helper function function getGymnastCount($conn, $table, $level, $minDate, $maxDate) { $query = "SELECT COUNT(*) as count FROM $table WHERE level = '$level' AND birth_date BETWEEN '$minDate' AND '$maxDate'"; $result = mysqli_query($conn, $query); $row = mysqli_fetch_assoc($result); return $row['count']; } ?> Leap Scores

- Session Manager

" . $success . ""; echo ""; } // 1) Gather which levels/clubs are already assigned (optional cross-out logic). $assigned = array(); $sessionsQuery = "SELECT levels, gyms FROM sessions WHERE meet_number = " . intval($_SESSION['selected_meet']); $sessionsRes = mysqli_query($conn, $sessionsQuery); if ($sessionsRes) { while ($rowSesh = mysqli_fetch_assoc($sessionsRes)) { $levelsList = explode(',', $rowSesh['levels']); $levelsList = array_map('trim', $levelsList); $gymsList = explode('^', $rowSesh['gyms']); // Now we can match each level with its corresponding gyms foreach ($levelsList as $index => $lvl) { if (isset($gymsList[$index])) { if (trim($gymsList[$index]) === '%') { $assigned[$lvl] = '%'; } else { if (!isset($assigned[$lvl])) { $assigned[$lvl] = array(); } $levelGyms = explode(',', $gymsList[$index]); foreach ($levelGyms as $gym) { $assigned[$lvl][trim($gym)] = true; } } } } } } // 2) Fetch levels and clubs $queryLevels = " SELECT level, COUNT(*) AS total_gymnasts FROM {$_SESSION['table_name']} GROUP BY level ORDER BY FIELD( level, 'Bronze','Silver','Gold','Platinum','Diamond','Sapphire', 'Level 1','Level 2','Level 3','Level 4','Level 5','Level 6','Level 7','Level 8','Level 9','Level 10', '1','2','3','4','5','6','7','8','9','10' ) "; $resultLevels = mysqli_query($conn, $queryLevels); if (!$resultLevels) { die("Database query (levels) failed: " . mysqli_error($conn)); } $levelsData = array(); while ($levelRow = mysqli_fetch_assoc($resultLevels)) { $lvl = $levelRow['level']; $levelsData[$lvl] = array( 'total' => $levelRow['total_gymnasts'], 'clubs' => array() ); // Fetch clubs $clubsQuery = " SELECT club_abbrev, COUNT(*) AS club_count FROM {$_SESSION['table_name']} WHERE level = '" . mysqli_real_escape_string($conn, $lvl) . "' GROUP BY club_abbrev ORDER BY club_abbrev "; $clubsRes = mysqli_query($conn, $clubsQuery); if (!$clubsRes) { die("Database query (clubs) failed: " . mysqli_error($conn)); } while ($cRow = mysqli_fetch_assoc($clubsRes)) { $levelsData[$lvl]['clubs'][] = array( 'club' => $cRow['club_abbrev'], 'count' => $cRow['club_count'] ); } } ?>
In the list below you can build your sessions by selecting the level(s) and then either the box next to "Total Gymnasts" or the individual boxes next to each club. Down below the selection table you'll see your selections populate the "Create a Session" box where you can label your session # however you like and set the date, times, and other information, then push the "Create Session" box. Sessions that have been successfully created appear all the way at the bottom under the "Created Sessions" box.

Levels & Clubs/Birth Date Groups


in the Levels & Clubs table echo ""; foreach ($levelsData as $lvl => $info) { $gymTotal = intval($info['total']); $clubCountTotal = count($info['clubs']); // Check if entire level is assigned $isLevelAssignedAll = (isset($assigned[$lvl]) && $assigned[$lvl] === '%'); // Find how many clubs are assigned individually $clubCountAssigned = 0; foreach ($info['clubs'] as $cInfo) { if (isset($assigned[$lvl]) && is_array($assigned[$lvl]) && isset($assigned[$lvl][$cInfo['club']])) { $clubCountAssigned++; } } $shouldCrossOutRow = $isLevelAssignedAll || ($clubCountAssigned > 0 && $clubCountAssigned == $clubCountTotal); echo "\n"; // Column 1: level name + level checkbox in one cell echo ""; // Column 2: total gymnasts + entire-level checkbox echo ""; // Column 3: individual clubs, comma-separated echo ""; echo "\n"; } ?>
Level Total Gymnasts Individual Clubs
"; echo " "; echo htmlspecialchars($lvl); echo ""; // Calculate remaining gymnasts if clubs are selected $remaining = $gymTotal; if (isset($assigned[$lvl]) && is_array($assigned[$lvl])) { foreach ($info['clubs'] as $cInfo) { if (isset($assigned[$lvl][$cInfo['club']])) { $remaining -= $cInfo['count']; } } } // Show original total crossed out with remaining count if clubs are selected if ($clubCountAssigned > 0 && !$isLevelAssignedAll) { echo "$gymTotal
"; echo "$remaining"; } else { echo $gymTotal; } echo "  "; echo " 0 && !$isLevelAssignedAll) ? "disabled" : "") // Disable if any clubs selected . ($shouldCrossOutRow ? "disabled" : "") . ">"; echo "		"; $clubSep = ''; foreach ($info['clubs'] as $cRow) { $clubAbbrev = htmlspecialchars($cRow['club'], ENT_QUOTES); $clubGymCount = intval($cRow['count']); $isAssignedIndiv = (isset($assigned[$lvl]) && is_array($assigned[$lvl]) && isset($assigned[$lvl][$cRow['club']])); $clubLabel = ($shouldCrossOutRow || $isAssignedIndiv) ? "{$clubAbbrev} ({$clubGymCount})" : "{$clubAbbrev} ({$clubGymCount})"; echo $clubSep . ""; $clubSep = ", "; } echo "

Create a session

Session # Levels/clubs Total Gymnasts Session Date Open Warm Up March In Timed Warm Up Awards Type Flights

Created Sessions

$level) { $level = mysqli_real_escape_string($conn, trim($level)); if (isset($gyms[$index])) { $gym_part = trim($gyms[$index]); if ($gym_part === '%') { // For levels with "All" selected, count all gymnasts in the level. $query_parts[] = "(level = '$level')"; } elseif (strpos($gym_part, '$$$') === 0) { // For levels using age groups if (isset($age_groups[$index]) && !empty($age_groups[$index])) { $date_ranges = explode(',', $age_groups[$index]); foreach ($date_ranges as $range) { // Split the birth date range (format expected: mm/dd/YYYY|mm/dd/YYYY) list($min_date, $max_date) = explode('|', $range); // Convert each date from mm/dd/YYYY to yyyy-mm-dd using strtotime and date $min_date_converted = date('Y-m-d', strtotime(trim($min_date))); $max_date_converted = date('Y-m-d', strtotime(trim($max_date))); // Escape the converted dates before using in query $min_date_converted = mysqli_real_escape_string($conn, $min_date_converted); $max_date_converted = mysqli_real_escape_string($conn, $max_date_converted); $query_parts[] = "(level = '$level' AND birth_date BETWEEN '$min_date_converted' AND '$max_date_converted')"; } } } else { // For levels with specific gym selections (e.g., club abbreviations) $gym_list = implode("','", array_map(function($gym) use ($conn) { return mysqli_real_escape_string($conn, trim($gym)); }, explode(',', $gym_part))); $query_parts[] = "(level = '$level' AND club_abbrev IN ('$gym_list'))"; } } } if (!empty($query_parts)) { $query = "SELECT COUNT(*) as count FROM {$_SESSION['table_name']} WHERE " . implode(' OR ', $query_parts); $count_result = mysqli_query($conn, $query); if ($count_result) { $count_row = mysqli_fetch_assoc($count_result); $total_gymnasts = $count_row['count']; } } // Then output the session's data: echo ""; echo ""; echo ""; echo ""; // Other session fields (date, times, etc.) echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
Session # Levels/clubs Total Gymnasts Session Date Open Warm Up March In Timed Warm Up Awards Type Flights Delete
"; echo ""; echo ""; // Build combined display string $combined = array(); foreach ($levels as $index => $level) { $gym_part = isset($gyms[$index]) ? trim($gyms[$index]) : ''; if ($gym_part === '%') { $combined[] = "" . htmlspecialchars($level) . " (All)"; } elseif (strpos($gym_part, '$$$') === 0) { if (isset($age_groups[$index]) && !empty($age_groups[$index])) { $date_ranges = explode(',', $age_groups[$index]); $formatted_ranges = array(); foreach ($date_ranges as $range) { list($min_date, $max_date) = explode('|', $range); // Convert for display using date() and strtotime() $formatted_min = date('m/d/Y', strtotime(trim($min_date))); $formatted_max = date('m/d/Y', strtotime(trim($max_date))); $formatted_ranges[] = $formatted_min . " to " . $formatted_max; } $combined[] = "" . htmlspecialchars($level) . " (Age Groups: " . implode(', ', $formatted_ranges) . ")"; } } else { $combined[] = "" . htmlspecialchars($level) . " (" . htmlspecialchars($gym_part) . ")"; } } echo implode(", ", $combined); echo "" . htmlspecialchars($total_gymnasts) . ""; echo ""; echo "