v2.0.0-alpha.3-Holidays & Attendance Modules

[Devnawjesh]

Release: Add Holidays Management + Attendance Management (with API & Import/Export)

Summary

This release introduces two major HR modules:

• Holidays Module

  • Holiday CRUD
  • Year-wise holiday filtering
  • Table view + Calendar view
  • Clickable holiday details on calendar
  • Weekend highlighting (configurable from Settings)
  • CSV export for holiday data

• Attendance Module

  • Manual attendance entry (check-in/check-out)
  • Datepicker + time picker with consistent formats
  • Multiple same-day punch entries supported
  • Daily summary with first check-in, last check-out, and duration
  • Full raw punch-history CSV export
  • CSV template download + CSV import
  • Role-based data access:
    • Employee: own history
    • Supervisor: own + subordinates
    • HR/Admin roles: all records
  • Secure external Attendance API ingestion (bulk rows)
  • Attendance API Integration documentation UI

Database / Migration Changes

• Added/updated attendance behavior to allow multiple entries per day
• Added API client table for secure external integrations
• Removed unused time_change_requests table (new migration)

Security / Access Control

• Added attendance permission set for:
  • attendance.export
  • attendance.import
  • attendance.api-integration
• API uses Bearer token authentication with hashed token storage
• Optional IP allowlist per API client
• API usage timestamp tracking (last_used_at)

API Added

• POST /api/v1/attendance/logs/bulk
• Accepts bulk entries from external devices/systems
• Validates date/time formats and blocks future dates

UI Added / Updated

• Holidays pages integrated into admin template style
• Attendance pages integrated into admin template style
• New Attendance API Integration page in menu
• Updated README screenshots for both modules

Notes for QA

• Verify holiday calendar/year filters/export
• Verify weekend day configuration from Settings reflects in holiday calendar
• Verify attendance manual add, import, export, duration, and filters
• Verify API token generation, enable/disable, and Postman ingestion
• Verify role-based attendance visibility rules
• Verify future-date attendance is blocked for manual/API/import

Post-release Commands

php artisan migrate
php artisan db:seed --class=Database\\Seeders\\PermissionSeeder
php artisan db:seed --class=Database\\Seeders\\RolePermissionSeeder

---

This discussion was created from the release v2.0.0-alpha.3-Holidays & Attendance Modules.

[psblitbackup]

What is the correct verification order for permissions, role scope,import/API validation and holiday calendar settings?

[Devnawjesh]

Use this order:

1. Run upgrade commands:

php artisan migrate
php artisan db:seed --class=Database\\Seeders\\PermissionSeeder
php artisan db:seed --class=Database\\Seeders\\RolePermissionSeeder

2. Confirm attendance permissions are assigned:

attendance.view, 
attendance.export, 
attendance.import, 
attendance.api-integration.

3. Check role visibility rules:

• Employee: own records only
• Supervisor: own + subordinates
• HR/Admin: all records

4. Test future-date blocking in all entry paths:

• Manual attendance form
• CSV import
• POST /api/v1/attendance/logs/bulk

5. Verify API client setup:

• Bearer token is valid
• Client is enabled
• IP allowlist (if configured) includes source IP
• last_used_at updates on success

6. Verify Holidays:

• Year filter works in list/calendar
• Weekend highlighting follows Settings
• CSV export matches selected filters

Most “missing record” issues come from permission/role scope mismatch, missing seed run, rejected future dates, or API client token/IP restrictions.