Loyalty

// app/Models/LoyaltyProgram.php
protected $fillable = [
    'name',
    'earn_ratio',        // Spend this many currency units to earn 1 point
    'redemption_ratio',  // This many points = 1 currency unit
    'expiry_days',       // null = points never expire
    'is_active',
];

// app/Models/LoyaltyProgram.php

// Points earned for a given order total
public function calculatePoints(float|string $orderTotal): int
{
    if (!$this->is_active || $this->earn_ratio <= 0) return 0;
    return (int) floor((float) $orderTotal / $this->earn_ratio);
}

// Currency value of a given point balance
public function calculateRedemptionValue(int $points): float
{
    if ($this->redemption_ratio <= 0) return 0.0;
    return round($points / $this->redemption_ratio, 2);
}

// app/Models/LoyaltyReward.php
protected $fillable = [
    'name',
    'description',
    'points_cost',  // Points required for redemption
    'stock',        // -1 = unlimited
    'is_active',
];

// app/Models/LoyaltyReward.php
public function isAvailable(): bool
{
    if (!$this->is_active) return false;
    if ($this->stock === -1) return true;  // Unlimited
    return $this->stock > 0;
}

// app/Models/LoyaltyReward.php
public function decrementStock(): void
{
    if ($this->stock > 0) {
        $this->decrement('stock');
    }
}

LoyaltyReward::available()->get();
// WHERE is_active = 1 AND (stock = -1 OR stock > 0)

// app/Models/LoyaltyLedger.php
public const TYPE_EARN       = 'earn';       // Points from order completion
public const TYPE_REDEEM     = 'redeem';     // Points spent on a reward
public const TYPE_EXPIRE     = 'expire';     // Points that have lapsed
public const TYPE_ADJUSTMENT = 'adjustment'; // Manual admin correction

protected $fillable = [
    'user_id',
    'order_id',      // For earn transactions
    'type',
    'amount',        // Integer (positive = credit, negative = debit)
    'description',
    'expires_at',
];

// app/Models/LoyaltyLedger.php

// Active (non-expired) points
public function scopeActive($query)
{
    return $query->where(function ($q) {
        $q->whereNull('expires_at')->orWhere('expires_at', '>', now());
    });
}

// Earned points that have since expired (for expiry processing)
public function scopeExpired($query)
{
    return $query->where('type', self::TYPE_EARN)
        ->whereNotNull('expires_at')
        ->where('expires_at', '<=', now());
}