-- 修复首页分类宫格 menu.list 为空
-- 根因：装修表里 menu 组件存在，但 content.list 为 []，首页 sh-grid-swiper 不渲染
-- 执行后清除 Shopro 缓存，重新进入小程序即可

SET @root_id = (
    SELECT id FROM `fa_shopro_category`
    WHERE `pid` = 0 AND `status` = 'normal'
    ORDER BY `weigh` DESC, `id` DESC
    LIMIT 1
);

SET @menu_json = (
    SELECT CONCAT(
        '{"name":"","style":5,"list":[',
        IFNULL(GROUP_CONCAT(
            JSON_OBJECT(
                'name', `name`,
                'image', `image`,
                'path', CONCAT('/pages/goods/list?id=', `id`),
                'path_name', `name`,
                'path_type', 1
            )
            ORDER BY `weigh` DESC, `id` ASC
            SEPARATOR ','
        ), ''),
        ']}'
    )
    FROM `fa_shopro_category`
    WHERE `pid` = @root_id AND `type` = 'shop' AND `status` = 'normal'
);

UPDATE `fa_shopro_decorate_content`
SET `content` = @menu_json
WHERE `category` = 'home'
  AND `type` = 'menu'
  AND @root_id IS NOT NULL
  AND @menu_json IS NOT NULL
  AND @menu_json LIKE '%"list":[{%';

-- 验证（应返回 list 含 10 项）：
-- SELECT id, type, JSON_LENGTH(JSON_EXTRACT(content, '$.list')) AS cnt, LEFT(content, 200)
-- FROM fa_shopro_decorate_content WHERE category='home' AND type='menu';