kknongchang_2506/app/Module/GameItems/Commands/GenerateRecipeJsonCommand.php

<?php

namespace App\Module\GameItems\Commands;

use App\Module\Game\DCache\RecipeJsonConfig;
use App\Module\GameItems\Config\NumericAttributesWhitelist;
use Illuminate\Console\Command;
use App\Module\GameItems\Models\ItemRecipe;

use Illuminate\Support\Facades\Log;

/**
 * 生成物品合成配方配置表JSON数据命令
 *
 * 该命令用于从数据库中的物品合成配方表生成JSON数据文件，供客户端使用。
 * 生成的JSON文件包含合成配方的基本信息，如ID、名称、产出物品、所需材料等。
 * 该命令通常在合成配方数据更新后运行，以确保客户端获取最新的配方数据。
 */
class GenerateRecipeJsonCommand extends Command
{
    /**
     * 命令名称和签名
     *
     * @var string
     */
    protected $signature = 'gameitems:generate-recipe-json';

    /**
     * 命令描述
     *
     * @var string
     */
    protected $description = 'Generate recipe.json from ItemRecipe table';

    /**
     * 生成合成配方JSON数据
     *
     * @return array|bool 生成的数据或失败标志
     */
    public static function generateJson()
    {
        try {
            // 查询ItemRecipe表中的数据，并预加载关联数据
            $recipes = ItemRecipe::query()
                ->with([
                    'resultItem' => function ($query) {
                        $query->select(['id', 'name', 'numeric_attributes']);
                    },
                    'materials.item'
                ])
                ->where('is_active', 1)
                ->get()
                ->map(function ($recipe) {
                    // 处理材料数据
                    $materials = $recipe->materials->map(function ($material) {
                        return [
                            'item_id' => $material->item_id,
                            'item_name' => $material->item->name ?? '未知物品',
                            'quantity' => $material->quantity,
                            'is_consumed' => $material->is_consumed,
                        ];
                    })->toArray();

                    // 构建配方数据
                    $recipeData = [
                        'id' => $recipe->id,
                        'name' => $recipe->name,
                        'result_item_id' => $recipe->result_item_id,
                        'result_item_name' => $recipe->resultItem->name ?? '未知物品',
                        'result_min_quantity' => $recipe->result_min_quantity,
                        'result_max_quantity' => $recipe->result_max_quantity,
                        'success_rate' => $recipe->success_rate,
                        'coin_cost' => $recipe->coin_cost,
                        'level_required' => $recipe->level_required,
                        'is_default_unlocked' => $recipe->is_default_unlocked,
                        'unlock_condition' => $recipe->unlock_condition,
                        'cooldown_seconds' => $recipe->cooldown_seconds,
                        'category_id' => $recipe->category_id,
                        'materials' => $materials,
                    ];

                    // 如果结果物品有数值属性，使用白名单过滤
                    if ($recipe->resultItem && $recipe->resultItem->numeric_attributes) {
                        $numericAttributes = NumericAttributesWhitelist::filter($recipe->resultItem->numeric_attributes);
                        if (!empty($numericAttributes)) {
                            $recipeData['result_numeric_attributes'] = $numericAttributes;
                        }
                    }

                    return $recipeData;
                })
                ->toArray();

            // 准备完整数据，包含生成时间
            $data = [
                'generated_ts' => time(),
                'recipes' => $recipes
            ];

            return $data;
        } catch (\Exception $e) {
            Log::error('Generate recipe.json failed: ' . $e->getMessage());
            return false;
        }
    }



    /**
     * 执行命令
     */
    public function handle()
    {
        $this->info('Generating recipe JSON data...');

        if (RecipeJsonConfig::getData([], true)) {
            $this->info('Successfully generated recipe.json with timestamp');
        } else {
            $this->error('Failed to generate recipe.json');
        }
    }
}