🚀 Fiber Ops Dashboard

A comprehensive construction operations dashboard for fiber optic ISP projects with real-time Google Sheets integration, cost tracking, and productivity monitoring.

✨ Features

• 📊 Real-time Dashboard - Live metrics and project status updates
• 🔄 Google Sheets Integration - Automatic data synchronization
• 💰 Cost Tracking - Monitor material and labor expenses
• 📈 Progress Monitoring - Track footage completion across projects
• 🐳 Docker Deployment - Easy setup with containerization
• 📱 Mobile Responsive - Works on all devices
• 🔒 Secure - Service account authentication
• 📝 SQLite Database - Historical data storage

🎯 Quick Start

Prerequisites

• Docker & Docker Compose
• Google Cloud Service Account with Sheets API access
• Google Sheet with project data

Installation

1. Clone the repository

git clone https://github.com/CamoRageaholic1/fiber-ops-dashboard.git
cd fiber-ops-dashboard

2. Run the installer (Ubuntu/Linux)

chmod +x scripts/install.sh
./scripts/install.sh

3. Configure environment

# Edit .env with your settings
cp .env.example .env
nano .env

4. Add Google credentials

# Place your service account JSON in credentials/
cp /path/to/your/credentials.json credentials/credentials.json

5. Start the application

docker-compose up -d

6. Access the dashboard

http://localhost:5000

📖 Documentation

• Installation Guide
• Configuration Guide
• API Documentation
• Google Sheets Setup
• Deployment Guide
• Troubleshooting

🏗️ Architecture

fiber-ops-dashboard/
├── app/
│   ├── app.py              # Flask application
│   ├── requirements.txt    # Python dependencies
│   └── templates/
│       └── index.html      # Dashboard UI
├── scripts/
│   ├── install.sh          # Automated installer
│   ├── start.sh            # Start script
│   ├── stop.sh             # Stop script
│   └── backup.sh           # Backup script
├── docs/                   # Documentation
├── Dockerfile
├── docker-compose.yml
└── .env.example

🔧 Configuration

Environment Variables

GOOGLE_SHEET_ID=your_sheet_id_here
FLASK_SECRET_KEY=your_secret_key_here
FLASK_ENV=production
PROJECT_NAME=Your-Project-Name

Google Sheets Format

Your Google Sheet should have these columns:

Project Name	Total Footage	Completed Footage	Material Cost	Labor Cost	Total Cost	Date

📊 API Endpoints

• GET / - Main dashboard
• GET /api/health - Health check
• POST /api/sync - Trigger data sync
• GET /api/stats - Get statistics
• GET /api/projects - Get all projects
• GET /api/history - Get sync history

🚀 Deployment

Docker Compose (Recommended)

docker-compose up -d

Manual Deployment

cd app
pip install -r requirements.txt
python app.py

🛠️ Development

Development Mode

docker-compose -f docker-compose.dev.yml up

Running Tests

# Tests coming soon

📝 License

This project is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

For Individual Use Only - Commercial use is prohibited.

See the LICENSE file for details.

🤝 Contributing

Contributions are welcome! Please read CONTRIBUTING.md for details.

📧 Contact

• GitHub: @CamoRageaholic1
• Issues: GitHub Issues

🙏 Acknowledgments

• Built with Flask and Bootstrap
• Google Sheets API integration
• Docker for containerization

---

⭐ If you find this project helpful, please star it!