Features

• Dual-tab dashboard —two dedicated views accessible from a top tab bar:

  • Attendance tab — a scrollable monthly calendar grid showing every employee as a row and every calendar day as a column. Each cell is colour-coded by status.
  • Leave Summary tab — a paginated table listing all leave requests per employee, with columns for Leave Type, From, To, Days, Reason, and a colour-coded Status badge.

• Five attendance status indicators —each cell in the calendar grid is assigned one of:

  • P —Present (green): employee has an attendance check-in record for that day.
  • A —Absent (red): working day with no attendance record and no approved leave.
  • L —Leave (yellow): employee has a validated leave request covering that day.
  • H —Holiday (teal): public holiday defined in the company's resource calendar.
  • W —Weekend (grey): non-working day per the employee's individual work schedule.

• Role-based access control —three tiers:

  • Administrator —sees all departments and all employees; can create, edit, and delete attendance records.
  • Own / Team Access –Edit —sees their own team (subordinates); can edit attendance records.
  • Own / Team Access –View —sees their own team in read-only mode.

• Flexible filtering panel —a collapsible filter bar provides:

  • Month / Year stepper —navigate to any month from 2023 to the current date using left/right chevron buttons.
  • Custom date range —optional From/To date pickers that override the month stepper and display an arbitrary date window.
  • Department search —live-search dropdown with auto-lock: non-admin users who belong to a single department have it pre-selected and locked.
  • Employee search —live-search dropdown filtered by the active department, respecting access-level restrictions.

• Status legend filters and per-employee row filters — clicking a legend badge (Present / Absent / Leave / Holiday / Weekend) at the top of the attendance tab highlights only cells of that status across all employees, dimming the rest. Clicking the summary badges (P-A-L-H-W) on a specific employee row highlights only that employee's days of that status, independent of the global filter.

• Clickable cells with detail dialogs:

  • Present cell →Attendance Details Dialog: shows check-in time, check-out time, worked hours, and validated overtime. Authorised users can edit, check out, or delete the record directly from the dialog.
  • Leave cell →Leave Details Dialog: shows leave type, date range, number of days, reason, and approval status. A button opens the full leave form (editable if authorised).
  • Holiday cell →Holiday Details Dialog: shows the public holiday name, date range, and the resource calendar it belongs to.
  • Weekend cell →Week Off popup: displays the employee name and date as a simple confirmation.
  • Absent cell (admin/edit only) →opens a blank Attendance form pre-filled with the employee and the clicked date, with check-in defaulting to 08:00.

• Inline attendance record management —create, edit, and delete attendance records without leaving the dashboard. All create/edit operations enforce a month-boundary validation: check-in and check-out dates must fall within the currently selected month, preventing accidental cross-month entries. The dashboard refreshes automatically after any change.

• Export to Excel —the Export button generates a styled .xlsx file that mirrors the current dashboard view:

  • Title row with period label (month/year or custom date range).
  • Header row with day-number and short weekday name for each date column.
  • Per-employee data rows with colour-coded status cells (green, red, yellow, teal, grey).
  • Summary columns (P / A / L / H counts) appended at the right.
  • Frozen panes for comfortable horizontal scrolling on large date ranges.
  • Respects all active filters: department, employee, status filter, and date range.

• Work-calendar-aware logic —the dashboard reads each employee's individual resource work calendar (falling back to the company default) to correctly distinguish working days from weekends. Public holidays are sourced from resource.calendar.leaves and can be calendar-specific or global.

• Timezone-aware date handling —all UTC datetime values (attendance check-ins, leave dates, holiday boundaries) are converted to the logged-in user's configured timezone before being assigned to calendar days, ensuring correct display for globally distributed teams.

• Pagination on both tabs —both the Attendance grid and the Leave Summary table display 15 employees per page with smart pagination controls (previous / next buttons, numbered pages, ellipsis for large sets).

• Employee profile quick-view —clicking any employee's avatar or name in either tab opens the employee form in a read-only dialog, without navigating away from the dashboard.

• Leave Summary —click-through to leave form —each row in the Leave Summary table is clickable and opens the full hr.leave form. Administrators and editors open it in edit mode; viewers open it read-only. The Leave Summary refreshes automatically after the form is closed.

• Responsive design —a dedicated responsive.css stylesheet adapts the dashboard layout for tablet and mobile screen sizes.