# Supernova 2.0 - Fest Platform Changes & Documentation

This readme document outlines the list of updates, redesigned components, and database configurations implemented in the **Supernova 2.0** National Tech Paradigm Fest platform.

---

## 🛠️ Modules Discussed & Refactored

### 1. Navigation Bar & Global Header
* **Custom Typography Loading:** Integrated the **Rajdhani** (modern tech sans-serif) and **Orbitron** (cyberpunk futuristic) fonts directly into the Google Fonts loader in `header.php`. This resolves the browser fallback issue and ensures the fonts load dynamically on all visitors' devices without manual installation.
* **Layout Sizing & Spacing:**
  * Increased the navigation link size from `text-sm` to `text-base` (16px) to match the Rajdhani font structure.
  * Enlarged Lucide navigation icons to `w-5 h-5` to align with the larger text.
  * Widened the link distribution gap to `gap-8` to fill the navbar properly on desktop screens.

### 2. Homepage Hero Section
* **Tagline & Badge Refinements:**
  * Removed the redundant top date status badge (`sn-hero-badge`).
  * Removed the sub-tagline description paragraph (`sn-hero-tagline`).
* **Date Subtitle:**
  * Positioned the dates `"4 & 5 September 2026"` centered directly under the main title in `'Black Ops One'` font styling.
* **Redesigned Stats Cards:**
  * Made the cards more compact by reducing width to `sm:w-68` and padding to `p-5 sm:p-6`.
  * Replaced standard borders with glowing custom **`cyber-corner`** brackets (scaled to `22px` size and `4px` thickness).
  * Styled with a default neon drop-shadow glow that amplifies to full brightness (`filter: drop-shadow(0 0 12px)`) on hover.
  * Maximized typography sizes inside the cards using the `'Bebas Neue'` font.

### 3. Content Sections (Headers & Spacing)
* **Tagline Removals:** Cleaned up the landing page by removing description paragraphs from the headers of:
  * *Featured Competitions & Workshops*
  * *Festival Chronology & Timeline (Schedule)*
  * *Organizing Committee*
  * *Festival Gallery*
* **Vertical Spacing:**
  * Adjusted the margin-top spacing on section headers (`h2`) from `mt-3` to `mt-6` to create clean visual breathing space under the pill badges.
  * Increased margin-bottom on the Gallery header to `mb-24` and set the Carousel top margin to `24px` to push the coverflow photos downwards.

### 4. Excel Registration & Attendance Importer
* **Automated Duplicate Handling:**
  * Integrates database checks using Email + Event ID to prevent duplicate check-ins.
* **Smart ID Overwriting:**
  * Added logic that updates the database `registrationId` for existing entries if the incoming Excel sheet has a new, actual registration number. This allows overwriting previous generated/temporary IDs with the real registration IDs from Excel.
* **Removed Auto-Attendance:**
  * Excised automatic check-in inserts and statistics updates from the Excel file upload endpoint to prevent marking registrants as "Present" before the fest begins.

### 5. Importer Dashboard Portal
* **Horizontal Statistics Cards:**
  * Re-aligned the upload status statistics (Total Rows, Imported, Existed) horizontally in columns using inline flex layouts instead of vertical blocks.
* **Compact preview table:**
  * Limited the imported data preview table height to `220px` with vertical scrollbars (`overflow-y: auto`).
  * Styled table headers with `sticky top-0 z-10 bg-slate-900` so columns remain visible while scrolling.
* **Dynamic Modal Collapsing:**
  * Hides the dropzone container and setup instructions banner once the upload completes to save vertical screen space.
  * Added a `max-h-[90vh]` scroll safety ceiling on the modal container to prevent browser viewport overflows.

### 6. Venue Attendance Scan Route
* **Placeholder Updates:**
  * Swapped out the old alpha-numeric example placeholder `e.g. SN-CB-4892` for the new numeric layout `e.g. 16853166` in the registration check-in field.

---

## 📂 File-by-File Changes Summary

| File Path | Description of Changes |
| :--- | :--- |
| **[index.php](file:///c:/Users/Sushant/Desktop/Supernova%202.0/Supernova%202.0/Supernova%202026/public_html/index.php)** | Removed badges/taglines, redesigned cyber-corners/margins/sizes, and centered subtitles. |
| **[header.php](file:///c:/Users/Sushant/Desktop/Supernova%202.0/Supernova%202.0/Supernova%202026/public_html/includes/header.php)** | Added Orbitron and Rajdhani Google Font dependencies. |
| **[navbar.php](file:///c:/Users/Sushant/Desktop/Supernova%202.0/Supernova%202.0/Supernova%202026/public_html/includes/navbar.php)** | Increased typography size to `text-base`, icons to `w-5`, and item gaps to `gap-8`. |
| **[import_attendance.php](file:///c:/Users/Sushant/Desktop/Supernova%202.0/Supernova%202.0/Supernova%202026/public_html/organizer/import_attendance.php)** | Added existing record ID updates and removed auto-attendance flags. |
| **[dashboard.php](file:///c:/Users/Sushant/Desktop/Supernova%202.0/Supernova%202.0/Supernova%202026/public_html/organizer/dashboard.php)** | Collapsed results window, added scroll previews, horizontal stats, and modal limit. |
| **[venue-scan.php](file:///c:/Users/Sushant/Desktop/Supernova%202.0/Supernova%202.0/Supernova%202026/public_html/attendance/venue-scan.php)** | Swapped ID placeholder example to numeric. |

---

## 👤 Git Configuration & Signatures
The repository's local Git configuration has been updated so that all future commits are signed under your credentials:
* **Commit Name:** `Sushant Wankhade`
* **Commit Email:** `sushantw3124@gmail.com`
* **Commit Author:** Verified and force-pushed to main branch.