szkp-map-service/app/Console/Commands/SeedReservationsForDateCommand.php

<?php

namespace App\Console\Commands;

use App\Models\Activity;
use App\Models\ActivityDay;
use App\Models\Reservation;
use Carbon\Carbon;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Str;

/**
 * 在指定活动日的场次下批量生成测试预约（默认「今天」，用于核销端「今日报名」联调）。
 */
class SeedReservationsForDateCommand extends Command
{
    protected $signature = 'reservations:seed-for-date
                            {activity_id=1 : 活动 ID}
                            {date? : 活动日 Y-m-d，默认今天}
                            {--count=20 : 生成条数}
                            {--dry-run : 只打印计划，不写入}';

    protected $description = '在某一活动日生成若干条待核销预约（用于今日报名列表等测试）';

    public function handle(): int
    {
        $activityId = (int) $this->argument('activity_id');
        $dateStr = $this->argument('date')
            ? Carbon::parse((string) $this->argument('date'))->toDateString()
            : now()->toDateString();
        $count = max(1, (int) $this->option('count'));
        $dryRun = (bool) $this->option('dry-run');

        $activity = Activity::query()->find($activityId);
        if (!$activity) {
            $this->error("未找到活动 id={$activityId}");

            return self::FAILURE;
        }

        $this->info("活动 #{$activity->id} {$activity->title}");
        $this->line("活动日：{$dateStr}，生成 {$count} 条".($dryRun ? '（dry-run）' : ''));

        if ($dryRun) {
            return self::SUCCESS;
        }

        $created = 0;
        DB::transaction(function () use ($activity, $dateStr, $count, &$created) {
            $day = Carbon::parse($dateStr)->startOfDay();

            $activityDay = ActivityDay::query()
                ->where('activity_id', $activity->id)
                ->whereDate('activity_date', $dateStr)
                ->first();

            if (!$activityDay) {
                $opensAt = $day->copy()->subDays(7)->setTime(9, 0, 0);
                $activityDay = ActivityDay::create([
                    'activity_id' => $activity->id,
                    'activity_date' => $dateStr,
                    'day_quota' => max($count + 20, 50),
                    'booked_count' => 0,
                    'opens_at' => $opensAt,
                ]);
                $this->line("已创建活动日场次 activity_day_id={$activityDay->id}");
            }

            $ticketEach = 1;
            $needBooked = $activityDay->booked_count + ($count * $ticketEach);
            if ($activityDay->day_quota < $needBooked) {
                $activityDay->day_quota = $needBooked + 10;
                $activityDay->save();
                $this->line("已调高放票数至 {$activityDay->day_quota}");
            }

            for ($i = 1; $i <= $count; $i++) {
                $phone = $this->makeUniquePhone($activity->id, $activityDay->id, $i);
                $res = Reservation::create([
                    'venue_id' => $activity->venue_id,
                    'activity_id' => $activity->id,
                    'activity_day_id' => $activityDay->id,
                    'visitor_name' => "报名用户{$dateStr}-{$i}",
                    'visitor_phone' => $phone,
                    'qr_token' => (string) Str::uuid(),
                    'status' => 'pending',
                    'ticket_count' => $ticketEach,
                    'reservation_source' => 'legacy',
                ]);
                $created++;
                $activityDay->increment('booked_count', $ticketEach);
                $this->line("  + #{$res->id} {$phone}");
            }

            Activity::refreshRegisteredCountFromReservations($activity->id);
        });

        $this->info("完成：新建 {$created} 条待核销预约；registered_count 已按已预约人数合计更新。");

        return self::SUCCESS;
    }

    private function makeUniquePhone(int $activityId, int $activityDayId, int $i): string
    {
        $n = ($activityId * 100000 + $activityDayId * 1000 + $i) % 100000000;

        return '139'.str_pad((string) $n, 8, '0', STR_PAD_LEFT);
    }
}