<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Support\Facades\Auth;

class Client extends Model
{
    use HasFactory;

    protected $table = 'clients';

    protected $fillable = [
        'comment',
        'co_name',
        'person_in_charge',
        'balance',
        'status',
        'remark',
        'memo',
        'contact_1',
        'contact_2',
        'secretary',
        'sec_status',
        'ar_due_date',
        'dcr_due_date',
        'spc_updated',
        'acc_staff',
        'accye',
        'acc_status',
        'auditor',
        'aud_fye',
        'aud_status',
        'tax_agent',
        'tax_ya',
        'tax_file',
        'tax_cp204_due',
        'tax_cp204a_6',
        'tax_cp204a_9',
        'tax_status',
        'tax_remark',
        'sst_staff',
        'sst_status',
        'address_1',
        'address_2',
        'post_code',
        'city',
        'state',
        'country',
        'co_website',
        'co_email',
        'co_no',
        'incorp_date',
        'month_of',
        'company_type',
        'group',
        'referral',
        'dob', // Added dob
    ];

    /**
     * Scope to filter clients by member's country.
     * Members can only access clients from the same country.
     */
    public function scopeByMemberCountry(Builder $query): Builder
    {
        if (Auth::check()) {
            $user = Auth::user();
            
            // Superadmin sees everything
            if ($user->role === 'superadmin') {
                return $query;
            }

            // Everyone else (admin, staff, etc.) is restricted to their country
            return $query->where('country', $user->country);
        }
        return $query;
    }
}