Employee Attendance Tracker

A comprehensive attendance tracking system built with Hono, SQLite, and modern TypeScript.

• Employee Management: Add, edit, and manage employee records
• Attendance Tracking: Clock in/out functionality with timestamp tracking
• Reporting: View attendance reports and statistics
• Real-time Updates: Live attendance status updates

├── backend/
│   ├── database/
│   │   ├── migrations.ts    # Database schema setup
│   │   └── queries.ts       # Database query functions
│   ├── routes/
│   │   ├── employees.ts     # Employee CRUD operations
│   │   ├── attendance.ts    # Attendance tracking endpoints
│   │   └── reports.ts       # Reporting endpoints
│   └── index.ts             # Main Hono app entry point
├── frontend/
│   ├── components/
│   │   ├── App.tsx          # Main application component
│   │   ├── EmployeeList.tsx # Employee management
│   │   ├── AttendanceTracker.tsx # Clock in/out interface
│   │   └── Reports.tsx      # Attendance reports
│   ├── services/
│   │   └── api.ts           # API service layer
│   ├── types/
│   │   └── index.ts         # TypeScript interfaces
│   ├── index.html           # Main HTML template
│   └── index.tsx            # Frontend entry point
└── shared/
    └── types.ts             # Shared type definitions

• GET /api/employees - List all employees
• POST /api/employees - Create new employee
• PUT /api/employees/:id - Update employee
• DELETE /api/employees/:id - Delete employee

• POST /api/attendance/clock-in - Clock in employee
• POST /api/attendance/clock-out - Clock out employee
• GET /api/attendance/status/:employeeId - Get current status
• GET /api/attendance/history/:employeeId - Get attendance history

• GET /api/reports/daily - Daily attendance report
• GET /api/reports/employee/:id - Employee-specific report

1. The backend will automatically set up the database tables on first run
2. Navigate to the app to start managing employees and tracking attendance
3. Use the attendance tracker to clock employees in and out
4. View reports to analyze attendance patterns

• Backend: Hono (Express-like framework for Deno)
• Database: SQLite with automatic migrations
• Frontend: TypeScript with React-like components
• Styling: TailwindCSS for responsive design