mp_audio_manage/app/Console/Anime/AnimeCheckImgUrlCommand.php

<?php

namespace App\Console\Anime;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;

class AnimeCheckImgUrlCommand extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'Anime:checkImgUrl';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '检查动漫对话角色和场景图片生成状态';

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        dLog('generate')->info('====================开始检查动漫对话角色和场景图片生成状态====================');
        $time_start = microtime(true);

        // 获取待执行的动漫对话数据
        $data = DB::table('mp_animes')->where('status', '执行中')->select('roles', 'scenes')->get();
        
        // foreach ($data as $val) {
        //     $roles = json_decode($val->roles, true);
        //     $scenes = json_decode($val->scenes, true);
        //     $role_count = count($roles);
        //     $scene_count = count($scenes);
        //     $role_success_count = 0;
        //     $scene_success_count = 0;
        //     for ($i=0; $i < $role_count; $i++) { 
        //         if (isset($roles[$i]['url']) && !empty($roles[$i]['url'])) {
        //             $role_success_count++;
        //         }
        //     }
        //     for ($i=0; $i < $scene_count; $i++) { 
        //         if (isset($scenes[$i]['url']) && !empty($scenes[$i]['url'])) {
        //             $scene_success_count++;
        //         }
        //     }

        //     if ($role_success_count == $role_count && $scene_success_count == $scene_count) {
        //         // 更新状态为已完成
        //         DB::table('mp_animes')->where('status', '执行中')->update(['status' => '已完成']);
        //         dLog('generate')->info('动漫对话图片已生成完成');
        //     }
        // }
        // $this->info('检查完成');

        $time_end = microtime(true);
        dLog('generate')->info('脚本执行时间: '.round($time_end-$time_start, 2).'秒');
        dLog('generate')->info('====================结束检查动漫对话角色和场景图片生成状态====================');
    }
}