SatyaSaiBabaAutoElectricalWorks

📂 Project Structure

satya_sai_auto/
├── 📄 app.py                    # Main Flask application
├── 📄 requirements.txt          # Python dependencies
├── 📄 .env.example              # Environment variable template
├── 📁 database/
│   └── 📄 schema.sql            # MySQL database schema + seed data
├── 📁 static/
│   ├── 📁 css/main.css          # Main stylesheet (dark automotive theme)
│   └── 📁 js/main.js            # JavaScript (SocketIO, search, animations)
└── 📁 templates/
    ├── 📄 base.html             # Base template (navbar, footer, WhatsApp)
    ├── 📄 index.html            # Home page
    ├── 📄 about.html            # About Us
    ├── 📄 products.html         # Spare Parts catalog
    ├── 📄 batteries.html        # Battery section
    ├── 📄 services.html         # Services
    ├── 📄 brands.html           # Brands
    ├── 📄 booking.html          # Service booking form
    ├── 📄 contact.html          # Contact page
    └── 📁 admin/
        ├── 📄 dashboard.html    # Admin dashboard
        └── ...                  # Other admin templates

🚀 Setup Instructions

1️⃣ Install Dependencies

# Create virtual environment
python -m venv venv

# Activate (Linux/Mac)
source venv/bin/activate
# Activate (Windows)
venv\Scripts\activate

# Install packages
pip install -r requirements.txt

2️⃣ Setup MySQL Database

# Login to MySQL
mysql -u root -p

# Run schema
source database/schema.sql

Or import directly:

mysql -u root -p < database/schema.sql

3️⃣ Configure Environment

Create a .env file or set environment variables:

export MYSQL_HOST=localhost
export MYSQL_USER=root
export MYSQL_PASSWORD=your_password
export MYSQL_DB=satya_sai_auto
export SECRET_KEY=your-secret-key-here

4️⃣ Initialize Admin User

The first time you run the app, it creates a default admin:

• 👤 Username: admin
• 🔑 Password: admin123

⚠️ IMPORTANT: Change this password immediately after first login!

5️⃣ Run the Application

python app.py

🌐 Visit: http://localhost:5000

🗺️ Pages Overview

🗄️ Database Tables

🌐 Deployment (Production)

Using Gunicorn + Nginx

# Install gunicorn
pip install gunicorn

# Run with eventlet worker (required for SocketIO)
gunicorn --worker-class eventlet -w 1 -b 0.0.0.0:5000 app:app

Nginx Config Example

server {
    listen 80;
    server_name yourdomain.com;

    location / {
        proxy_pass http://127.0.0.1:5000;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
    }
}

🎨 Design Theme

• 🎨 Colors: Dark (#0A0A0A) + Yellow (#FFD600) automotive theme
• 🔤 Typography: Rajdhani (headings), Exo 2 (body), Share Tech Mono (code/prices)
• ⚙️ Style: Industrial/Automotive — dark, bold, technical

📞 Support

• 🛠️ For technical issues or customization, contact the developer.
• 📞 For shop inquiries: +91 954256****