Bedi Attendance System

Complete employee attendance tracking system with GPS verification, audio monitoring, and real-time location tracking.

🚀 Quick Start

Prerequisites

• Node.js 18+
• PostgreSQL database (we use Neon)
• Google OAuth credentials

Installation

# Clone and install
git clone <your-repo>
cd attendance-system
npm install

# Configure environment
cp .env.example .env
# Edit .env with your credentials

# Setup database
npm run db:push

# Start development
npm run dev

Access

• Admin Dashboard: http://localhost:5000 (password: admin123)
• Mobile App: cd mobile-app && npm start

📱 System Architecture

Admin Website (Web)

• Real-time employee monitoring
• Attendance records with audio playback
• Live location tracking with maps
• Advanced filtering and reporting
• Desktop-optimized interface

Mobile App (React Native)

• Employee check-in/check-out
• GPS location verification (150m radius)
• Hidden audio recording during work
• Automatic location tracking
• Offline capability

Backend API (Express.js)

• RESTful API for all operations
• PostgreSQL database with Drizzle ORM
• Google OAuth authentication
• Real-time location updates
• Audio file management

🛠️ Key Features

Location Tracking

• GPS Verification: Employees must be within 150m of shop location
• Real-time Updates: Location tracked every 30 seconds during work
• Geofencing: Automatic alerts when employees leave work area
• Map Integration: View exact employee locations on Google Maps

Audio Monitoring

• Work Session Recording: Continuous audio during check-in to check-out
• Admin Playback: Listen to recordings in admin dashboard
• Download Support: Export audio files for records
• Privacy Compliant: Clear disclosure to employees

Authentication & Security

• Google OAuth: Secure employee login
• Admin Access Control: Password-protected admin interface
• Session Management: Secure token-based authentication
• Data Encryption: All sensitive data encrypted

Real-time Dashboard

• Live Employee Status: See who's currently working
• Location Monitoring: Real-time employee positions
• Attendance Analytics: Work hours, patterns, and reports
• Audio Management: Centralized recording access

📋 Deployment Options

1. Vercel (Recommended)

npm install -g vercel
vercel login
vercel

2. Railway

npm install -g @railway/cli
railway login
railway up

3. Self-hosted

npm run build
npm start

📊 Database Schema

Users Table

• Employee profiles with Google OAuth
• Role-based access control
• Personal information and settings

Attendance Records

• Check-in/check-out timestamps
• GPS coordinates for verification
• Work session duration
• Audio recording references

Live Locations

• Real-time employee positions
• Location history and tracking
• Accuracy and timestamp data
• Online/offline status

🔧 Configuration

Environment Variables

DATABASE_URL=postgresql://...
GOOGLE_CLIENT_ID=...
GOOGLE_CLIENT_SECRET=...
SESSION_SECRET=...
SHOP_LATITUDE=29.394155353241377
SHOP_LONGITUDE=76.96982203495648
SHOP_RADIUS=150

Shop Location

Update coordinates in:

• Backend: Environment variables
• Mobile app: mobile-app/src/screens/DashboardScreen.tsx

📱 Mobile App Distribution

Development Testing

cd mobile-app
npm install
expo start
# Scan QR with Expo Go app

Production Build

# Android APK
expo build:android

# iOS IPA  
expo build:ios

# App Store builds
expo build:android -t app-bundle
expo build:ios -t archive

📈 Monitoring & Analytics

Built-in Features

• Employee work hour tracking
• Location history and patterns
• Audio session management
• Real-time status monitoring

External Integrations

• Google Maps for location viewing
• Export capabilities for payroll
• Real-time notifications
• Performance analytics

🛡️ Security Features

Data Protection

• HTTPS enforcement
• Encrypted database connections
• Secure token storage
• Regular security updates

Privacy Compliance

• Clear audio recording disclosure
• Employee consent management
• Data retention policies
• Access control logging

📞 Support & Maintenance

Common Tasks

• Database backups (automated with Neon)
• Dependency updates
• Performance monitoring
• User access management

Troubleshooting

• Check deployment logs
• Verify environment variables
• Test database connectivity
• Validate OAuth configuration

📄 Documentation

• Complete Deployment Guide - Step-by-step deployment
• Fedora Setup Guide - Linux-specific instructions
• Vercel Deployment - Vercel-specific setup
• Mobile App Setup - Mobile development guide

🏢 About Bedi Enterprises

This system was built specifically for Bedi Enterprises clothing shop in Panipat, Haryana, to provide comprehensive employee attendance tracking with location verification and work session monitoring.

Business Requirements Met

• ✅ GPS-verified attendance (150m radius from shop)
• ✅ Continuous work session monitoring
• ✅ Real-time employee location tracking
• ✅ Audio recording for productivity monitoring
• ✅ Comprehensive admin dashboard
• ✅ Mobile-first employee experience
• ✅ Secure authentication and data management

---

© 2025 Bedi Enterprises - Employee Attendance Management System