bot-28/app/Console/Commands/SyncPromotions.php

<?php

namespace App\Console\Commands;

use App\Services\PromotionAdminService;
use App\Services\PromotionService;
use App\Services\ActivityRewardService;
use App\Support\SyncCommandLock;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Schema;
use Illuminate\Support\Facades\Log;

class SyncPromotions extends Command
{
    protected $signature = 'promotions:sync';
    protected $description = '到期活动自动下架，补记转盘任务次数并解冻满足流水的新活动奖金';
    public function handle(PromotionService $service, SyncCommandLock $lock): int
    {
        $exit = $lock->run('promotions:sync', fn () => $this->synchronize($service));
        if ($exit === null) $this->info('活动同步已在运行，跳过本次执行');
        return $exit ?? self::SUCCESS;
    }

    private function synchronize(PromotionService $service): int
    {
        $errors = 0;
        $expired = 0;
        try {
            if (Schema::hasTable('activity_rewards')) $expired += ActivityRewardService::expire();
        } catch (\Throwable $e) { ++$errors; Log::error('activity_reward_expire_failed', ['exception' => $e]); }
        if (!Schema::hasTable('promotion_accounts')) {
            $this->info('活动同步完成，到期下架：' . $expired . '，失败数：' . $errors);
            return $errors ? self::FAILURE : self::SUCCESS;
        }
        try { $expired += PromotionAdminService::expire(); }
        catch (\Throwable $e) { ++$errors; Log::error('promotion_expire_failed', ['exception' => $e]); }
        DB::table('promotion_accounts as p')->join('promotion_activities as a', 'a.id', '=', 'p.activity_id')->where('a.type', 9)->where('a.status', 1)
            ->where('a.start_time', '<=', now()->timestamp)->where('a.end_time', '>=', now()->timestamp)->select('p.*')->orderBy('p.id')
            ->chunkById(100, function ($rows) use ($service, &$errors) {
                foreach ($rows as $row) try { $service->syncAccount($row->activity_id, $row->user_id); }
                catch (\Throwable $e) { ++$errors; Log::error('promotion_sync_failed', ['account_id' => $row->id, 'exception' => $e]); }
            }, 'p.id', 'id');
        foreach (DB::table('promotion_rewards')->where('status', 'locked')->distinct()->pluck('user_id') as $userId) {
            try { $service->unlock((int)$userId); } catch (\Throwable $e) { ++$errors; Log::error('promotion_unlock_failed', ['user_id' => $userId, 'exception' => $e]); }
        }
        $this->info('活动任务和奖金同步完成，到期下架：' . $expired . '，失败数：' . $errors);
        return $errors ? self::FAILURE : self::SUCCESS;
    }
}