VIT Bhopal FFCS Timetable Maker 🚀

A high-performance, automated timetable planner designed specifically for VIT Bhopal students under the Fully Flexible Credit System (FFCS).

✨ New Features (v2.0)

🧞‍♂️ Smart Auto-Generator

• Algorithmic Scheduling: Automatically generates valid timetables based on your selected courses.
• Custom Preferences:
  • Time Mode: Prioritize Morning, Afternoon, or Middle slots.
  • Avoidance: Set strict rules to avoid 8:30 AM or 7:30 PM classes.
  • Teacher Ranking: Rank your preferred faculties to ensure you get the best teachers.
• Unified Strategy: Uses advanced tiered generation to balance teacher quality with time preferences.

💾 Saved Timetables

• Save Configurations: Save your perfect timetable drafts to viewing later.
• Preview & Apply: View detailed previews of saved timetables and apply them with one click.
• Management: Delete old drafts or load them back into the main view.

📥 Advanced Import Options

• HTML Import: Directly upload the HTML file from the VIT Registration Page (VTOP).
• CSV Import: Power user? Upload a structured CSV file with course data.
• AI/OCR Import: Use AI to extract the data automatically from screenshots.
• Manual Entry: flexible form for single course additions.

🌟 Core Features

• Automated Clash Detection: Instantly checks if a new course conflicts with your existing schedule (Parallel Processing).
• Google Login: Secure authentication for students to save their timetables across devices.
• PDF Export: One-click download of your finalized timetable.
• Interactive UI:
  • Visual Legend: Courses color-coded for distinct visibility.
  • Optimized Performance: GZIP compression and parallel fetching for instant loads.
  • Mobile Friendly: Responsive design for planning on the go.
• Cloud Sync: Data persists in CockroachDB (Serverless Postgres), ensuring you never lose your plan.

🛠️ Technology Stack

• Backend: Flask (Python) with SQLAlchemy ORM.
• Database: CockroachDB (PostgreSQL compatible) - chosen for serverless scalability.
• Frontend: Vanilla JavaScript (ES6+), CSS3 (Custom Design), HTML5.
• Hosting: Vercel (Serverless Function adapter).
• Analytics: Google Analytics 4 (GA4).

🚀 Speed Optimizations Provided

This project has been heavily optimized for "F1-level" speed:

1. Parallel Imports: Uploading multiple HTML files happens concurrently via Promise.all.
2. Database Indexing: ownership fields (user_id, guest_id) are indexed for O(1) lookups.
3. GZIP Compression: JSON responses are compressed (reducing size by ~70%).
4. Static Caching: Assets are cached by the browser to minimize network requests.
5. Connection Pooling: Robust pool_pre_ping prevents serverless timeout errors.

📥 Installation & Local Setup

1. Clone the Repository

   git clone https://github.com/yourusername/ffcs-timetable.git
   cd ffcs-timetable

2. Install Dependencies

   pip install -r requirements.txt

3. Environment Variables Create a .env file in the root directory:

   # Database (CockroachDB or Local Postgres)
   DATABASE_URL="postgresql://user:pass@host:port/dbname?sslmode=require"
   
   # Google OAuth
   GOOGLE_CLIENT_ID="your-google-client-id"
   GOOGLE_CLIENT_SECRET="your-google-client-secret"
   SECRET_KEY="your-flask-secret-key"

4. Run the App

   python app.py

   Access at http://localhost:5000.

☁️ Deployment (Vercel)

This project is configured for Vercel out-of-the-box using vercel.json.

1. Install Vercel CLI: npm i -g vercel
2. Deploy:

   vercel

3. Add Environment Variables in Vercel Dashboard (Settings > Environment Variables).

📊 Analytics

Google Analytics 4 is integrated. To enable it:

1. Update templates/base.html with your Measurement ID (G-XXXXXXXX).
2. Current ID: G-F03ZLSX9P7.

🎨 Color Palette

The app uses a carefully curated palette to distinguish courses:

• Core: Light Green, Sky Blue, Light Pink, Plum.
• Distinct: Coral, Dark Turquoise, Orchid (Added to prevent confusion).

🤝 Contributing

1. Fork the repo.
2. Create a feature branch.
3. Submit a Pull Request.

---

Made with ❤️ by Mehul K. Patel