49 行
1.7 KiB
SQL
49 行
1.7 KiB
SQL
-- 修复底部导航选中图标 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;
|