Rails多时区适配问题：美国客户停车时长验证功能异常解决

It looks like your core issue is inconsistent timezone handling—you're mixing server-local time, UTC-stored data, and user-selected timezones, which leads to mismatches when users are in different regions like the US. Let's break down the problems with your current code and fix it step by step.

Key Issues in Your Modified Code #

1. Inconsistent Timezone Reference: Using ValidatedVehicle.last.time_zone pulls the timezone of the last vehicle in your database, not the user's selected timezone. Both sides of your date comparison should use the same timezone (the one the user chose).
2. Mixed Variables: You switch between @vehicle and validated_vehicle in your conditions—this is likely a typo that would cause errors.
3. Separate Date/Time Columns: Handling arrival date and time as separate fields makes timezone conversions more error-prone, since dates in UTC don't always align with dates in the user's timezone.

Correct Approach #

The goal is to:

• Combine your arrival date and time into a single UTC datetime (if you can't merge the columns in your schema).
• Convert all timestamps to the user's selected timezone for comparisons.
• Use consistent timezone references throughout your logic.

Option 1: If You Keep Separate Date/Time Columns #

First, combine the UTC date and time into a single datetime object, then convert it to the user's timezone. Compare that to the current time in the same timezone:

<%
  # Combine arrival date (UTC) and time (UTC) into a single UTC datetime
  arrival_utc = DateTime.new(
    @vehicle.arrival_date.year,
    @vehicle.arrival_date.month,
    @vehicle.arrival_date.day,
    @vehicle.arrival_time.hour,
    @vehicle.arrival_time.min,
    @vehicle.arrival_time.sec,
    '+00:00' # Explicit UTC offset
  )

  # Convert to the user's selected timezone
  arrival_user_tz = arrival_utc.in_time_zone(@vehicle.time_zone)
  now_user_tz = Time.current.in_time_zone(@vehicle.time_zone)

  # Check if parking duration is under 4 hours (add date check if needed)
  if (now_user_tz - arrival_user_tz) < 4.hours
%>
  <%= @vehicle.license_plate %>
<% end %>

If you still want to filter for vehicles that arrived on the same day (in the user's timezone), add a date check:

if arrival_user_tz.to_date == now_user_tz.to_date && (now_user_tz - arrival_user_tz) < 4.hours

Option 2: Use a Single Datetime Column (Recommended) #

For cleaner code and fewer errors, modify your schema to store arrival time as a single arrived_at datetime column (stored in UTC). This simplifies timezone conversions:

<%
  arrival_user_tz = @vehicle.arrived_at.in_time_zone(@vehicle.time_zone)
  now_user_tz = Time.current.in_time_zone(@vehicle.time_zone)
%>
<% if (now_user_tz - arrival_user_tz) < 4.hours %>
  <%= @vehicle.license_plate %>
<% end %>

Best Practices to Avoid Future Timezone Issues #

• Always store timestamps in UTC: This is Rails' default and ensures consistency across regions.
• Convert to user timezone only for display/user-specific logic: Never convert stored UTC times to user timezones in database queries (unless using timezone-aware databases).
• Use Time.current instead of Time.now: Time.current respects Rails' timezone configuration (which should be UTC) and is safer than server-local Time.now.
• Consistent timezone usage: Every time you compare times, ensure both are in the same timezone (the user's selected one, in this case).

The in_time_zone('Central Time (US & Canada)') method works exactly as you expect—just make sure you're passing a valid timezone name (which your select dropdown does, since ActiveSupport::TimeZone.us_zones.map(&:name) returns valid Rails timezone strings).

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