kknongchang_2506/app/Console/Commands/FixMenuUris.php

<?php

namespace App\Console\Commands;

use App\Module\System\Models\AdminMenu;
use Illuminate\Console\Command;
use Illuminate\Support\Str;

class FixMenuUris extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'admin:fix-menu-uris {--remove-duplicates : 删除重复的菜单项，保留中文的}';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = '修复菜单项的URI，移除开头的斜杠，并可选择删除重复的菜单项';

    /**
     * Execute the console command.
     *
     * @return int
     */
    public function handle()
    {
        $this->info("开始修复菜单项的URI...");

        // 获取所有菜单项
        $menus = AdminMenu::all();

        $fixedCount = 0;

        foreach ($menus as $menu) {
            // 跳过空URI的菜单项（父菜单）
            if (empty($menu->uri)) {
                continue;
            }

            // 移除URI开头的斜杠
            $uri = ltrim($menu->uri, '/');

            if ($uri !== $menu->uri) {
                $menu->uri = $uri;
                $menu->save();
                $this->info("  - 修复菜单项: ID = {$menu->id}, 标题 = {$menu->title}, URI = {$menu->uri}");
                $fixedCount++;
            }
        }

        $this->info("\n已修复 {$fixedCount} 个菜单项的URI");

        // 删除重复的菜单项
        if ($this->option('remove-duplicates')) {
            $this->info("\n开始查找和删除重复的菜单项...");

            // 按URI和父ID分组
            $menusByUriAndParent = [];

            foreach (AdminMenu::all() as $menu) {
                if (!empty($menu->uri)) {
                    $key = $menu->uri . '_' . $menu->parent_id;
                    if (!isset($menusByUriAndParent[$key])) {
                        $menusByUriAndParent[$key] = [];
                    }
                    $menusByUriAndParent[$key][] = $menu;
                }
            }

            $duplicateCount = 0;

            foreach ($menusByUriAndParent as $key => $menus) {
                $parts = explode('_', $key);
                $uri = $parts[0];
                if (count($menus) > 1) {
                    $this->info("发现重复的菜单项: URI = {$uri}");

                    // 查找中文菜单项
                    $chineseMenu = null;
                    $englishMenus = [];

                    foreach ($menus as $menu) {
                        // 检查标题是否包含中文字符
                        if (preg_match('/[\x{4e00}-\x{9fa5}]/u', $menu->title)) {
                            $chineseMenu = $menu;
                        } else {
                            $englishMenus[] = $menu;
                        }
                    }

                    if ($chineseMenu) {
                        $this->info("  - 保留中文菜单项: ID = {$chineseMenu->id}, 标题 = {$chineseMenu->title}");

                        foreach ($englishMenus as $menu) {
                            // 获取子菜单
                            $childMenus = AdminMenu::where('parent_id', $menu->id)->get();

                            // 更新子菜单的父ID
                            foreach ($childMenus as $childMenu) {
                                $childMenu->parent_id = $chineseMenu->id;
                                $childMenu->save();
                                $this->info("    - 更新子菜单: ID = {$childMenu->id}, 标题 = {$childMenu->title}, 新父ID = {$chineseMenu->id}");
                            }

                            // 删除菜单项
                            $menu->delete();
                            $this->info("    - 删除英文菜单项: ID = {$menu->id}, 标题 = {$menu->title}");
                            $duplicateCount++;
                        }
                    } else {
                        $this->info("  - 未找到中文菜单项，保留第一个菜单项: ID = {$menus[0]->id}, 标题 = {$menus[0]->title}");

                        for ($i = 1; $i < count($menus); $i++) {
                            // 获取子菜单
                            $childMenus = AdminMenu::where('parent_id', $menus[$i]->id)->get();

                            // 更新子菜单的父ID
                            foreach ($childMenus as $childMenu) {
                                $childMenu->parent_id = $menus[0]->id;
                                $childMenu->save();
                                $this->info("    - 更新子菜单: ID = {$childMenu->id}, 标题 = {$childMenu->title}, 新父ID = {$menus[0]->id}");
                            }

                            // 删除菜单项
                            $menus[$i]->delete();
                            $this->info("    - 删除重复菜单项: ID = {$menus[$i]->id}, 标题 = {$menus[$i]->title}");
                            $duplicateCount++;
                        }
                    }
                }
            }

            $this->info("\n已删除 {$duplicateCount} 个重复的菜单项");
        }

        return 0;
    }
}