kknongchang_2506/app/Module/Shop/Commands/GenerateShopItemsJsonCommand.php

<?php

namespace App\Module\Shop\Commands;

use App\Module\Game\DCache\ShopItemsJsonConfig;
use App\Module\Game\Services\JsonConfigService;
use Carbon\Carbon;
use Illuminate\Console\Command;
use App\Module\Shop\Models\ShopItem;
use Illuminate\Support\Facades\Log;

/**
 * 生成商店商品配置表JSON数据命令
 *
 * 该命令用于从数据库中的商店商品表生成商品JSON数据文件，供客户端使用。
 * 生成的JSON文件包含商品的基本信息，如ID、名称、描述、消耗组、奖励组和展示属性等。
 * 该命令通常在商店商品数据更新后运行，以确保客户端获取最新的商品数据。
 */
class GenerateShopItemsJsonCommand extends Command
{

    /**
     * 命令名称和签名
     *
     * @var string
     */
    protected $signature = 'shop:generate-json';

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

    /**
     * 执行命令
     */
    /**
     * 生成商店商品JSON数据
     *
     * @return array|bool 生成的数据或失败标志
     */
    public static function generateJson()
    {
        try {
            // 查询ShopItem表中的激活商品数据，并预加载关联数据
            $shopItems = ShopItem::query()
                ->with([
                    'category',
                    'consumeGroup.consumeItems',
                    'rewardGroup.rewardItems',
                    'activePurchaseLimits'
                ])
                ->where('is_active', 1)
                ->where(function ($query) {
                    // 检查上架时间
                    $query->whereNull('start_time')
                        ->orWhere('start_time', '<=', now());
                })
                ->where(function ($query) {
                    // 检查下架时间
                    $query->whereNull('end_time')
                        ->orWhere('end_time', '>=', now());
                })
                ->orderBy('sort_order', 'desc')
                ->orderBy('id', 'asc')
                ->get()
                ->map(function ($item) {
                    // 构建商品数据
                    $itemData = [
                        'id' => $item->id,
                        'name' => $item->name,
                        'description' => $item->description,
                        'category_id' => $item->category_id,
                        'category_name' => $item->category_name,
                        'consume_group_id' => $item->consume_group_id,
                        'reward_group_id' => $item->reward_group_id,
                        'max_single_buy' => $item->max_single_buy,
                        'sort_order' => $item->sort_order,
                        'display_attributes' => $item->display_attributes,
                        'start_time' => $item->start_time ? $item->start_time->toDateTimeString() : null,
                        'end_time' => $item->end_time ? $item->end_time->toDateTimeString() : null,
                    ];

                    // 添加分类信息
                    if ($item->category) {
                        $itemData['category'] = [
                            'id' => $item->category->id,
                            'name' => $item->category->name,
                        ];
                    }

                    // 添加消耗组信息
                    if ($item->consumeGroup) {
                        $itemData['consume_group'] = [
                            'id' => $item->consumeGroup->id,
                            'name' => $item->consumeGroup->name,
                            'description' => $item->consumeGroup->description,
                            'items' => $item->consumeGroup->consumeItems->map(function ($consumeItem) {
                                return [
                                    'type' => $consumeItem->type,
                                    'target_id' => $consumeItem->target_id,
                                    'quantity' => $consumeItem->quantity,
                                    'name' => $consumeItem->name,
                                ];
                            })->toArray()
                        ];
                    }

                    // 添加奖励组信息
                    if ($item->rewardGroup) {
                        $itemData['reward_group'] = [
                            'id' => $item->rewardGroup->id,
                            'name' => $item->rewardGroup->name,
                            'description' => $item->rewardGroup->description,
                            'items' => $item->rewardGroup->rewardItems->map(function ($rewardItem) {
                                return [
                                    'type' => $rewardItem->type,
                                    'target_id' => $rewardItem->target_id,
                                    'min_quantity' => $rewardItem->min_quantity,
                                    'max_quantity' => $rewardItem->max_quantity,
                                    'probability' => $rewardItem->probability,
                                    'is_guaranteed' => $rewardItem->is_guaranteed,
                                    'name' => $rewardItem->name,
                                ];
                            })->toArray()
                        ];
                    }

                    // 添加限购信息
                    if ($item->activePurchaseLimits->isNotEmpty()) {
                        $itemData['purchase_limits'] = $item->activePurchaseLimits->map(function ($limit) {
                            return [
                                'id' => $limit->id,
                                'type' => $limit->type,
                                'period' => $limit->period,
                                'max_quantity' => $limit->max_quantity,
                                'description' => $limit->description,
                            ];
                        })->toArray();
                    }

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

            // 准备完整数据，包含生成时间
            $data = [
                'generated_ts' => time(),
                'generated_at' => now()->toDateTimeString(),
                'shop_items' => $shopItems
            ];

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

            return false;
        }
    }

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

}