-- 修复底部导航选中图标 404（activeImage 文件已丢失）
-- 图标文件已放到: public/uploads/demo/xiongge/tabbar/
-- 执行后: 清除 Shopro 缓存 → 小程序清缓存重编译

UPDATE `fa_shopro_decorate_content`
SET `content` = JSON_SET(
    IFNULL(`content`, '{}'),
    '$.list', JSON_ARRAY(
        JSON_OBJECT(
            'name', '推荐',
            'path', '/pages/index/index',
            'path_name', '首页',
            'path_type', 1,
            'image', '/uploads/demo/xiongge/tabbar/tabbar_home.png',
            'activeImage', '/uploads/demo/xiongge/tabbar/tabbar_home1.png'
        ),
        JSON_OBJECT(
            'name', '分类',
            'path', '/pages/index/category',
            'path_name', '全部分类',
            'path_type', 1,
            'image', '/uploads/demo/xiongge/tabbar/tabbar_category.png',
            'activeImage', '/uploads/demo/xiongge/tabbar/tabbar_category1.png'
        ),
        JSON_OBJECT(
            'name', '购物车',
            'path', '/pages/index/cart',
            'path_name', '购物车',
            'path_type', 1,
            'image', '/uploads/demo/xiongge/tabbar/tabbar_cart.png',
            'activeImage', '/uploads/demo/xiongge/tabbar/tabbar_cart1.png'
        ),
        JSON_OBJECT(
            'name', '我的',
            'path', '/pages/index/user',
            'path_name', '我的',
            'path_type', 1,
            'image', '/uploads/demo/xiongge/tabbar/tabbar_personal.png',
            'activeImage', '/uploads/demo/xiongge/tabbar/tabbar_personal1.png'
        )
    ),
    '$.color', '#BBBBBB',
    '$.activeColor', '#C4A574',
    '$.bgcolor', '#FFFFFF',
    '$.style', 1
)
WHERE `category` = 'tabbar'
  AND JSON_VALID(IFNULL(`content`, '{}')) = 1;