# 📊 Employee Hour Tracker > A badass web app to monitor employees entering their time, serve up real-time analytics, and automate your backups — so you can stop worrying and focus on getting sh*t done.      --- <details> <summary><i>Click to show screenshots</i></summary> ## Screenshots  [](./Screenshot_2025-08-08_at_4.03.27_PM.png) [](./Screenshot_2025-08-08_at_4.03.54_PM.png) [](./Screenshot_2025-08-08_at_4.05.46_PM.png) </details> --- ## ✨ Features ### 📅 **Time Tracking (A.K.A. Keeping Tabs on Your Squad)** - Weekly grid interface sharp enough to make spreadsheets cry - Click once? Log it. Twice? Flag it. Thrice? Fix-it mode, baby - Built-in calendar picker so you don't fat-finger the wrong week - Default week your way — past, present, or hell, even the future - No “Save” button needed — everything saves itself like grown-up software ### 📈 **Analytics Dashboard** - Sexy-ass charts courtesy of Chart.js - Date ranges? Yep. Choose from Last Week, Month, 90 Days, or freestyle - Pie charts of shame: See who's not entered a damn thing - Employee comparisons so you know who’s crushing it - Summary stats that slap you with truths at a glance ### 👥 **Employee Management** - Add, edit, and yeet employees in or out with full control - Inline editing — because popups can get bent - Confirmation dialogs keep you from rage-deleting poor Jim by mistake - Secure, session-based login — no freeloaders allowed ### 💾 **Data Export & Backup** - Export in: - Colored Excel (preserves all that green/yellow/red goodness) - JSON (for the nerds and the APIs) - CSV (because boring as hell = universal) - Auto-backups so you can sleep like a baby — configurable too ### 🎨 **Beautiful AF UI** - Responsive as heck — use it on a tablet, a phone, or a potato - A glorious purple gradient worth showing off to design nerds - Smooth transitions that don’t make you nauseous - Touch support that'll make any mobile user say “damn that’s clean” - You might actually enjoy navigating this one --- ## 🚀 Quick Start ### Prerequisites (Don’t Skip This, Ya Animal) - Node.js 18+ - OR Docker & Docker Compose (we’re fancy) --- ### 🧪 Option 1: Raw Node.js ```bash git clone https://github.com/tebwritescode/employee-hour-tracker.git cd employee-hour-tracker npm install npm start # Start like a regular ol' app npm run dev # If you want auto-reload magic ``` --- ### 🐳 Option 2: Docker Compose (Recommended as Hell) ```bash git clone https://github.com/tebwritescode/employee-hour-tracker.git cd employee-hour-tracker docker-compose up -d docker-compose logs -f # Because watching logs is oddly satisfying docker-compose down # When it’s time to kill it ``` --- ### 🔨 Option 3: Docker CLI (For Hardcore Terminal Nerds) ```bash docker build -t employee-hour-tracker . docker run -d \ --name employee-tracker \ -p 3000:3000 \ -v employee-tracker-data:/app/data \ employee-hour-tracker ``` App launches at `http://localhost:3000` Go ahead, open it. We dare you. --- ## 🔧 Configuration (Don't Screw These Up) | Variable | Default | Description | |----------|---------|-------------| | `PORT` | `3000` | Where the hell the server listens | | `NODE_ENV` | `development` | Pick your poison: `development` vs `production` | | `DB_PATH` | `./employee_tracker.db` | Where your crucial time data lives | | `SESSION_SECRET` | `employee-tracker-secret-key` | Hide this like it’s your banking password | | `DEFAULT_ADMIN_USERNAME` | `admin` | The overlord’s default login | | `DEFAULT_ADMIN_PASSWORD` | `admin123` | CHANGE THIS ASAP 🔥 | | `BACKUP_ENABLED` | `true` | Yeah, you want this on | | `BACKUP_INTERVAL` | `86400000` | How often to save your backside (MS) | | `BACKUP_RETENTION_DAYS` | `30` | How long to keep your safety net | --- ### 🐋 Docker Compose Config ```yaml version: '3.8' services: app: image: employee-hour-tracker environment: - NODE_ENV=production - SESSION_SECRET=your-secure-secret-here - DEFAULT_ADMIN_USERNAME=admin - DEFAULT_ADMIN_PASSWORD=change-this-password ports: - "3000:3000" volumes: - ./data:/app/data - ./backups:/app/backups ``` --- ## 📖 Usage Guide ### ⏱️ Time Tracking `/tracking` 1. Pick your week and start clicking grid cells like a god 2. Cycle statuses like a boss 3. Sit back — auto-save’s doing the work for you 4. Use arrows & selectors if you like jumping through time ### 📊 Analytics `/analytics` 1. Choose your dates 2. Interpret shame-slices in the pie chart 3. Compare your team’s hustle in bar form 4. Click Export and flex on your boss with pretty data ### 👨💼 Admin Stuff `/management` 1. Log in as admin (`admin` / `admin123`) — seriously, change that 2. Add new employees like it’s HR day 3. Click to edit names (typos won’t fix themselves) 4. Boot off old names thoughtfully (confirmation included) 5. Global settings & data export tools right at your manicured fingertips --- ## 🏗️ Project Architecture ``` employee-hour-tracker/ ├── 📄 server.js # RESTful backend engine of doom ├── 📄 backup.js # Makes sure your data doesn’t go *poof* ├── 📄 package.json # Clearly you’ve heard of this ├── 📄 docker-compose.yml # Container boyband orchestration ├── 📄 Dockerfile # Turns your app into deployable magic ├── 📁 public/ # Frontend good stuff │ ├── index.html # Your glorious entry point │ ├── style.css # Sharp purple swagger │ ├── script.js # Grid logic + admin finesse │ └── chart.js # Analytics eye-candy ├── 📁 backups/ # This folder saves asses └── 📗 employee_tracker.db # Don't delete this... seriously ``` --- ### ⚙️ Tech Stack - **Backend**: Node.js + Express - **Database**: SQLite3 + better-sqlite3 (the better part matters) - **Frontend**: Raw Vanilla JS (no extra calories) + Chart.js - **Auth**: express-session + bcryptjs (like a bouncer for your admin area) - **Containerization**: Docker & Docker Compose --- ## 🔐 Security - Hashed passwords (get rekt plain text) - Session-based login — no silly tokens - CORS-tight so outsiders can’t jack your data - SQL injection-proof — parameterized 'cause we’re not amateurs - Secrets optional but highly encouraged (you’ve been warned) --- ## 🔧 Dev Life ```bash npm run dev # Hot reload fixups npm start # Serious prod mode npm run install-deps # Just in case you skipped setup like a rebel ``` --- ### 🔌 API Endpoints | Method | URL | What-It-Does | Auth | |--------|-----|--------------|------| | GET | `/api/employees` | Fetch worker list | ❌ | | POST | `/api/employees` | Add a badass | ✅ | | PUT | `/api/employees/:id` | Update someone’s stuff | ✅ | | DELETE | `/api/employees/:id`| Boot 'em | ✅ | | GET | `/api/time-entries` | Fetch time logs | ❌ | | POST | `/api/time-entries` | Save/correct logs | ❌ | | GET | `/api/analytics` | Data candy | ❌ | | POST | `/api/login` | Get in | ❌ | | POST | `/api/logout` | Peace out | ✅ | | GET | `/api/export/:format` | Download your victory proof | ✅ | --- ## 🐞 Known WTFs - Week nav is a little moody if you click like a caffeinated squirrel - In rare cases, the status marker’s a lazy bastard and doesn’t update instantly (Fix coming soon. Or yell at us, that works too.) ## Support Issues? Questions? Praise-singing? File an issue on GitHub or yell at [teb](https://github.com/tebwritescode). --- 👑 Created by: [tebbydog0605](https://github.com/tebwritescode) 🐋 Docker Hub: [tebwritescode](https://hub.docker.com/u/tebwritescode) 💻 Website: [teb.codes](https://teb.codes)