startOfDay(); $target = $day ? now('UTC')->parse($day)->startOfDay() : $today; if ($target->gt($today) || $target->lt($today->copy()->subDays(self::BACKFILL_DAYS))) { throw ValidationException::withMessages(['day' => __('messages.reading_time_day_out_of_range')]); } $isToday = $target->equalTo($today); return DB::transaction(function () use ($userUid, $seconds, $target, $isToday) { ReadingDaily::createOrFirst(['user_uid' => $userUid, 'day' => $target->toDateString()]); $row = ReadingDaily::where('user_uid', $userUid)->where('day', $target->toDateString()) ->lockForUpdate()->firstOrFail(); $allowed = $seconds; if ($isToday && $row->last_report_at) { $elapsed = (int) $row->last_report_at->diffInSeconds(now(), true); $allowed = min($allowed, $elapsed + self::SLACK_SECONDS); } $allowed = max(0, min($allowed, 86400 - (int) $row->seconds)); $row->seconds_reported = (int) $row->seconds_reported + $seconds; $row->seconds = (int) $row->seconds + $allowed; if ($isToday) { $row->last_report_at = now(); } $row->save(); return $row; }); } }