a8cdc763cb
chore(brand): 统一将品牌名从雄戈小酒更改为橙虎小酒 - 更新alisms插件配置中的签名值 - 修改shopro插件中所有SQL脚本的品牌名称引用 - 更新商城配置、商品分类、演示数据中的品牌名称 - 替换后台登录页面的品牌标识 - 更新汇付分账配置中的媒介名称 - 修改登录预览生成脚本中的品牌显示 ```
53 行
4.0 KiB
SQL
53 行
4.0 KiB
SQL
-- 橙虎小酒：更新分类图标 + 商品主图（不重建分类树，适合已上线环境）
|
||
-- 前提：public/uploads/demo/xiongge/ 下图片已上传
|
||
-- 完整包装图更新请执行 update_demo_packaging_images.sql
|
||
|
||
SET @now = UNIX_TIMESTAMP();
|
||
|
||
SET @img_box = '/uploads/demo/xiongge/xg-box-main.png';
|
||
SET @img_gift = '/uploads/demo/xiongge/xg-product-gift.png';
|
||
SET @img_bag = '/uploads/demo/xiongge/xg-product-bag.png';
|
||
SET @img_bottle = '/uploads/demo/xiongge/xg-product-bottle.png';
|
||
SET @img_taste = '/uploads/demo/xiongge/xg-product-tasting.png';
|
||
SET @img_banquet = '/uploads/demo/xiongge/xg-product-banquet.png';
|
||
|
||
-- ========== 分类图标（各分类独立图片） ==========
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-series.png', `updatetime` = @now WHERE `name` = '雄戈系列' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-bottle.png', `updatetime` = @now WHERE `name` = '白酒' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-gift.png', `updatetime` = @now WHERE `name` = '礼盒装' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = @img_bottle, `updatetime` = @now WHERE `name` = '单瓶装' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-tasting.png', `updatetime` = @now WHERE `name` = '品鉴装' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-jiang.png', `updatetime` = @now WHERE `name` = '酱香型' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-nong.png', `updatetime` = @now WHERE `name` = '浓香型' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-banquet.png', `updatetime` = @now WHERE `name` = '商务宴请' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-new.png', `updatetime` = @now WHERE `name` = '新品上市' AND `type` = 'shop';
|
||
UPDATE `fa_shopro_category` SET `image` = '/uploads/demo/xiongge/icon-cat-hot.png', `updatetime` = @now WHERE `name` = '热销推荐' AND `type` = 'shop';
|
||
|
||
UPDATE `fa_shopro_category` SET `image` = @img_box, `updatetime` = @now WHERE `name` = '橙虎小酒' AND `pid` = 0;
|
||
|
||
-- ========== 演示商品主图（4 款各不同） ==========
|
||
UPDATE `fa_shopro_goods` SET `image` = @img_box, `images` = CONCAT(@img_box, ',', @img_gift), `updatetime` = @now WHERE `title` LIKE '%礼盒装%';
|
||
UPDATE `fa_shopro_goods` SET `image` = @img_taste, `images` = @img_taste, `updatetime` = @now WHERE `title` LIKE '%品鉴装%';
|
||
UPDATE `fa_shopro_goods` SET `image` = @img_bottle, `images` = @img_bottle, `updatetime` = @now WHERE `title` LIKE '%单瓶装%';
|
||
UPDATE `fa_shopro_goods` SET `image` = @img_banquet, `images` = CONCAT(@img_banquet, ',', @img_bag), `updatetime` = @now WHERE `title` LIKE '%商务宴请%';
|
||
|
||
-- ========== 轮播图（礼盒 + 礼袋） ==========
|
||
SET @g1 = (SELECT id FROM `fa_shopro_goods` WHERE `title` LIKE '%礼盒装%' ORDER BY id DESC LIMIT 1);
|
||
SET @g2 = (SELECT id FROM `fa_shopro_goods` WHERE `title` LIKE '%商务宴请%' ORDER BY id DESC LIMIT 1);
|
||
|
||
UPDATE `fa_shopro_decorate_content`
|
||
SET `content` = CAST(JSON_SET(
|
||
IFNULL(CAST(`content` AS JSON), JSON_OBJECT('name', '', 'style', 1, 'height', 530, 'radius', 16)),
|
||
'$.list', JSON_ARRAY(
|
||
JSON_OBJECT('image', @img_box, 'path', CONCAT('/pages/goods/detail?id=', IFNULL(@g1, 0)), 'path_type', 1, 'path_name', '橙虎小酒礼盒', 'name', '', 'bgcolor', '#FAFAF8'),
|
||
JSON_OBJECT('image', @img_bag, 'path', CONCAT('/pages/goods/detail?id=', IFNULL(@g2, 0)), 'path_type', 1, 'path_name', '橙虎小酒礼袋', 'name', '', 'bgcolor', '#FAFAF8')
|
||
),
|
||
'$.radius', 16,
|
||
'$.height', 530
|
||
) AS CHAR)
|
||
WHERE `type` = 'banner' AND `category` = 'home';
|
||
|
||
-- 验证：
|
||
-- SELECT name, image FROM fa_shopro_category WHERE type='shop' ORDER BY weigh DESC;
|
||
-- SELECT title, image FROM fa_shopro_goods WHERE title LIKE '【演示】橙虎小酒%';
|