Laravel Blade中使用模型Scope判断优惠券有效性异常问题

Let's break down why your coupon status is always displaying as "有效" (valid) and fix this step by step:

1. Check Your Blade Conditional Logic #

It sounds like you're manually checking the value_from and value_to fields in your Blade loop—but odds are your conditional logic is incorrect. Let's align it with the logic in your scopeValid:

Replace your current Blade check with this explicit comparison (make sure your model casts value_from and value_to to datetime so Laravel returns them as Carbon objects):

@foreach($coupons as $coupon)
    @php
        $currentTime = Carbon\Carbon::now();
        $isValid = $coupon->value_from <= $currentTime && $coupon->value_to >= $currentTime;
    @endphp
    <span>{{ $isValid ? '有效' : '过期' }}</span>
@endforeach

If you weren't using Carbon instances for the comparison (e.g., comparing strings directly), this could be causing unexpected true results.

2. Fix Timezone Mismatches #

A super common hidden issue is timezone differences between your app and database. For example:

• Your app uses Asia/Shanghai but your database stores times in UTC
• You're using Carbon::now() (app timezone) to compare against UTC-stored database dates

To resolve this, either:

• Sync your app's timezone in config/app.php with your database's timezone
• Or use UTC consistently in both your scope and Blade check:

  // Update your scope
  public function scopeValid($query){
      return $query->where('value_from', '<=', Carbon::now()->utc()->toDateTimeString())
                   ->where('value_to', '>=', Carbon::now()->utc()->toDateTimeString());
  }
  

  And in Blade:

  @php
      $currentTime = Carbon\Carbon::now()->utc();
      $isValid = $coupon->value_from->utc() <= $currentTime && $coupon->value_to->utc() >= $currentTime;
  @endphp
  

3. Verify Field Names & Data #

Double-check for typos in your field references—make sure you're using value_from and value_to (not valid_from, start_date, etc.) in both your database table and Blade code.

You can also debug by dumping raw values to see exactly what's being compared:

@foreach($coupons as $coupon)
    <p>
        Current Time: {{ Carbon\Carbon::now() }}<br>
        Coupon Start: {{ $coupon->value_from }}<br>
        Coupon End: {{ $coupon->value_to }}<br>
        Is Valid? {{ $coupon->value_from <= Carbon\Carbon::now() && $coupon->value_to >= Carbon\Carbon::now() ? 'Yes' : 'No' }}
    </p>
@endforeach

This will reveal if all coupons actually have future value_to dates, or if the timezone mismatch is skewing the results.

内容的提问来源于stack exchange，提问作者mafortis