Wage History

'employee_id'              // Foreign key to Employee
'hourly_rate'              // Decimal(10,2), must be > 0
'weekly_scheduled_hours'   // Decimal(5,2), must be > 0
'effective_from'           // Required date - when wage starts
'effective_to'             // Nullable date - when wage ends (null = current)

const RULES = [
    'hourly_rate' => ['required', 'numeric', 'gt:0'],
    'weekly_scheduled_hours' => ['required', 'numeric', 'gt:0'],
    'effective_from' => ['required', 'date'],
    'effective_to' => ['nullable', 'date', 'after_or_equal:effective_from'],
];

$currentWage = WageHistory::where('employee_id', $employee->id)
    ->effective(now())
    ->first();

public function scopeEffective(Builder $query, DateTimeInterface|string $date): Builder
{
    return $query
        ->where('effective_from', '<=', $date)
        ->where(function (Builder $q) use ($date) {
            $q->whereNull('effective_to')
              ->orWhere('effective_to', '>=', $date);
        });
}

$wageHistory = $employee->wageHistories()
    ->orderBy('effective_from', 'desc')
    ->get();

public function wageHistories(): HasMany
{
    return $this->hasMany(WageHistory::class)
        ->orderBy('effective_from', 'desc');
}

public function minuteRate(): float
{
    return (float) $this->hourly_rate / 60;
}

$wage = $employee->wageHistories()->effective(now())->first();
$perMinute = $wage->minuteRate();

// Example: $125/hr ÷ 60 = $2.0833.../minute

$weeklyPay = $wage->hourly_rate * $wage->weekly_scheduled_hours;

// Example: $125/hr × 48 hours = $6,000/week

$workingDaysPerWeek = 6; // From employee schedule
$dailyRate = ($wage->hourly_rate * $wage->weekly_scheduled_hours) / $workingDaysPerWeek;

// Example: ($125 × 48) ÷ 6 = $1,000/day