Attendance Tracking

'employee_id'              // Foreign key to Employee
'date'                     // Calendar date (date only, no time)
'check_in'                 // DateTime: arrival time
'check_out'                // DateTime: departure time
'lunch_start'              // DateTime: lunch break start (optional)
'lunch_end'                // DateTime: return from lunch (optional)
'entry_late_seconds'       // Integer: lateness at check-in (0 if on time)
'lunch_late_seconds'       // Integer: lateness returning from lunch
'net_worked_minutes'       // Integer: total minutes worked (excluding lunch)
'overtime_minutes'         // Integer: minutes worked beyond schedule
'overtime_authorized'      // Boolean: manager approved overtime for payment
'overtime_authorized_by'   // Foreign key to User who authorized
'overtime_authorized_at'   // DateTime: when authorization occurred
'day_status'               // Enum: WORKED, DAY_OFF, LEAVE, etc.
'confirmed_by'             // Foreign key to User who confirmed/validated
'meta'                     // JSON: additional metadata

public function isEntryLateDeductible(): bool
{
    return $this->entry_late_seconds > 1800; // > 30 minutes
}

public function isLunchLateDeductible(): bool
{
    return $this->lunch_late_seconds > 1800; // > 30 minutes
}

// Convert seconds to whole minutes (floor)
public function entryLateMinutes(): int
{
    return (int) floor($this->entry_late_seconds / 60);
}

public function lunchLateMinutes(): int
{
    return (int) floor($this->lunch_late_seconds / 60);
}

net_worked_minutes = (check_out - check_in) - (lunch_end - lunch_start)

overtime_minutes = net_worked_minutes - scheduled_minutes

'overtime_authorized'      // Boolean: true if authorized for payment
'overtime_authorized_by'   // User ID of manager who authorized
'overtime_authorized_at'   // Timestamp of authorization

daily_bonus = (weekly_base ÷ working_days) × punctuality_percentage

Example ($100 group, 6 days, 0:00-9:59 late):
daily_bonus = ($100 ÷ 6) × 100% = $16.67

'attendance_id'      // Link to Attendance record
'type'               // arrive_late | leave_early | take_time
'start_time'         // DateTime: when leave started
'end_time'           // DateTime: when leave ended
'duration_minutes'   // Integer: calculated duration
'is_paid'            // Boolean: paid or unpaid
'reason'             // Text: explanation
'approved_by'        // User ID of approver

$wage = $employee->wageHistories()->effective($date)->first();
$perMinuteRate = $wage->minuteRate(); // hourly_rate ÷ 60
$deduction = $lateMinutes × $perMinuteRate;

$employees = Employee::whereHas('employmentPeriods', function($q) use ($branchId) {
    $q->where('branch_id', $branchId)
      ->where('is_active', true);
});

'confirmed_by'  // User ID of manager/admin who confirmed

use App\Models\Concerns\Auditable;