a8cdc763cb
chore(brand): 统一将品牌名从雄戈小酒更改为橙虎小酒 - 更新alisms插件配置中的签名值 - 修改shopro插件中所有SQL脚本的品牌名称引用 - 更新商城配置、商品分类、演示数据中的品牌名称 - 替换后台登录页面的品牌标识 - 更新汇付分账配置中的媒介名称 - 修改登录预览生成脚本中的品牌显示 ```
165 行
8.8 KiB
SQL
165 行
8.8 KiB
SQL
-- 橙虎小酒演示数据 | 数据库 xgsc.gynhc.com | 表前缀 fa_
|
||
-- 【请先执行】seed_liquor_categories.sql（商城名 + 酒类分类 + 首页宫格）
|
||
-- 执行前：将演示图片上传到 public/uploads/demo/xiongge/
|
||
-- 商品：xg-box-main / xg-product-bottle / xg-product-gift / xg-product-tasting / xg-product-banquet
|
||
-- 分类：icon-cat-*.png（见 update_xiongge_images.sql）
|
||
-- 回滚：取消注释末尾 DELETE 段
|
||
|
||
SET @now = UNIX_TIMESTAMP();
|
||
SET @img_main = '/uploads/demo/xiongge/xg-box-main.png';
|
||
SET @img_bottle = '/uploads/demo/xiongge/xg-product-bottle.png';
|
||
SET @img_gift = '/uploads/demo/xiongge/xg-product-gift.png';
|
||
SET @img_tasting = '/uploads/demo/xiongge/xg-product-tasting.png';
|
||
SET @img_banquet = '/uploads/demo/xiongge/xg-product-banquet.png';
|
||
SET @img_bag = '/uploads/demo/xiongge/xg-product-bag.png';
|
||
SET @photo_box = '/uploads/demo/xiongge/xg-photo-gift-box.jpg';
|
||
SET @photo_bag = '/uploads/demo/xiongge/xg-photo-gift-bag.jpg';
|
||
|
||
-- ========== 运费模板（若无则创建包邮） ==========
|
||
INSERT INTO `fa_shopro_dispatch_express` (`type`, `weigh`, `first_num`, `first_price`, `additional_num`, `additional_price`, `province_ids`, `createtime`, `updatetime`)
|
||
SELECT 'number', 100, 1, 0.00, 0, 0.00, '520000', @now, @now FROM DUAL
|
||
WHERE NOT EXISTS (SELECT 1 FROM `fa_shopro_dispatch_express` LIMIT 1);
|
||
|
||
-- 已有运费规则但未配置区域时，默认覆盖贵州省（含测试地址 520102 南明区）
|
||
UPDATE `fa_shopro_dispatch_express`
|
||
SET `province_ids` = '520000', `updatetime` = @now
|
||
WHERE (`province_ids` IS NULL OR `province_ids` = '')
|
||
AND (`city_ids` IS NULL OR `city_ids` = '')
|
||
AND (`area_ids` IS NULL OR `area_ids` = '')
|
||
AND (`deletetime` IS NULL OR `deletetime` = 0);
|
||
|
||
SET @express_id = (SELECT id FROM `fa_shopro_dispatch_express` ORDER BY id ASC LIMIT 1);
|
||
|
||
INSERT INTO `fa_shopro_dispatch` (`name`, `type`, `type_ids`, `createtime`, `updatetime`)
|
||
SELECT '雄戈演示包邮', 'express', CAST(@express_id AS CHAR), @now, @now FROM DUAL
|
||
WHERE NOT EXISTS (
|
||
SELECT 1 FROM `fa_shopro_dispatch` WHERE `type` = 'express' AND deletetime IS NULL LIMIT 1
|
||
);
|
||
|
||
SET @dispatch_id = (
|
||
SELECT id FROM `fa_shopro_dispatch` WHERE `type` = 'express' AND deletetime IS NULL ORDER BY id ASC LIMIT 1
|
||
);
|
||
|
||
-- ========== 清理旧演示数据 ==========
|
||
DELETE FROM `fa_shopro_goods_sku_price` WHERE `sn` LIKE 'XG-DEMO-%';
|
||
DELETE FROM `fa_shopro_goods` WHERE `title` LIKE '【演示】橙虎小酒%';
|
||
|
||
-- ========== 分类（依赖 seed_liquor_categories.sql 已创建子分类） ==========
|
||
SET @cat_root = (SELECT id FROM `fa_shopro_category` WHERE `name` = '橙虎小酒' AND `pid` = 0 LIMIT 1);
|
||
SET @cat_gift = (SELECT id FROM `fa_shopro_category` WHERE `name` = '礼盒装' AND `type` = 'shop' ORDER BY id DESC LIMIT 1);
|
||
SET @cat_series = (SELECT id FROM `fa_shopro_category` WHERE `name` = '雄戈系列' AND `type` = 'shop' ORDER BY id DESC LIMIT 1);
|
||
SET @cat_single = (SELECT id FROM `fa_shopro_category` WHERE `name` = '单瓶装' AND `type` = 'shop' ORDER BY id DESC LIMIT 1);
|
||
SET @cat_banquet = (SELECT id FROM `fa_shopro_category` WHERE `name` = '商务宴请' AND `type` = 'shop' ORDER BY id DESC LIMIT 1);
|
||
|
||
-- 若分类不存在则先执行 seed_liquor_categories.sql
|
||
|
||
-- ========== 商品 1：礼盒装 ==========
|
||
INSERT INTO `fa_shopro_goods` (
|
||
`type`, `title`, `subtitle`, `status`, `weigh`, `category_ids`, `image`, `images`, `params`, `content`,
|
||
`price`, `original_price`, `is_sku`, `likes`, `views`, `sales`, `show_sales`,
|
||
`dispatch_type`, `dispatch_ids`, `createtime`, `updatetime`
|
||
) VALUES (
|
||
'normal', '【演示】橙虎小酒 礼盒装', '一男人的朋友一', 'up', 400, CAST(@cat_gift AS CHAR),
|
||
@img_main, CONCAT(@img_main, ',', @img_gift, ',', @photo_box, ',', @photo_bag), '[]',
|
||
CONCAT(
|
||
'<p>贵州雄戈酒业有限公司出品</p>',
|
||
'<p>净含量：120ml×5 酒精度：49%vol</p>',
|
||
'<p><img src=\"', @photo_box, '\"></p>',
|
||
'<p><img src=\"', @img_gift, '\"></p>',
|
||
'<p><img src=\"', @photo_bag, '\"></p>'
|
||
),
|
||
'298.00', 368.00, 0, 0, 0, 0, 520, 'express', CAST(@dispatch_id AS CHAR), @now, @now
|
||
);
|
||
|
||
SET @g1 = LAST_INSERT_ID();
|
||
|
||
INSERT INTO `fa_shopro_goods_sku_price` (`goods_sku_ids`, `goods_id`, `stock`, `sn`, `weight`, `price`, `status`, `createtime`, `updatetime`)
|
||
VALUES (NULL, @g1, 999, 'XG-DEMO-001', 1, 298.00, 'up', @now, @now);
|
||
|
||
-- ========== 商品 2：品鉴装 ==========
|
||
INSERT INTO `fa_shopro_goods` (
|
||
`type`, `title`, `subtitle`, `status`, `weigh`, `category_ids`, `image`, `images`, `params`, `content`,
|
||
`price`, `original_price`, `is_sku`, `show_sales`, `dispatch_type`, `dispatch_ids`, `createtime`, `updatetime`
|
||
) VALUES (
|
||
'normal', '【演示】橙虎小酒 品鉴装', '一男人的朋友一', 'up', 300, CAST(@cat_series AS CHAR),
|
||
@img_tasting, CONCAT(@img_tasting, ',', @photo_box), '[]', CONCAT('<p>120ml×2 / 49%vol</p><p><img src=\"', @photo_box, '\"></p>'), '128.00', 158.00, 0, 188,
|
||
'express', CAST(@dispatch_id AS CHAR), @now, @now
|
||
);
|
||
|
||
SET @g2 = LAST_INSERT_ID();
|
||
|
||
INSERT INTO `fa_shopro_goods_sku_price` (`goods_sku_ids`, `goods_id`, `stock`, `sn`, `weight`, `price`, `status`, `createtime`, `updatetime`)
|
||
VALUES (NULL, @g2, 999, 'XG-DEMO-002', 1, 128.00, 'up', @now, @now);
|
||
|
||
-- ========== 商品 3：单瓶装 ==========
|
||
INSERT INTO `fa_shopro_goods` (
|
||
`type`, `title`, `subtitle`, `status`, `weigh`, `category_ids`, `image`, `images`, `params`, `content`,
|
||
`price`, `original_price`, `is_sku`, `show_sales`, `dispatch_type`, `dispatch_ids`, `createtime`, `updatetime`
|
||
) VALUES (
|
||
'normal', '【演示】橙虎小酒 单瓶装', '一男人的朋友一', 'up', 200, CAST(@cat_single AS CHAR),
|
||
@img_bottle, CONCAT(@img_bottle, ',', @photo_box), '[]', CONCAT('<p>120ml / 49%vol</p><p><img src=\"', @photo_box, '\"></p>'), '68.00', 88.00, 0, 99,
|
||
'express', CAST(@dispatch_id AS CHAR), @now, @now
|
||
);
|
||
|
||
SET @g3 = LAST_INSERT_ID();
|
||
|
||
INSERT INTO `fa_shopro_goods_sku_price` (`goods_sku_ids`, `goods_id`, `stock`, `sn`, `weight`, `price`, `status`, `createtime`, `updatetime`)
|
||
VALUES (NULL, @g3, 999, 'XG-DEMO-003', 1, 68.00, 'up', @now, @now);
|
||
|
||
-- ========== 商品 4：商务宴请装 ==========
|
||
INSERT INTO `fa_shopro_goods` (
|
||
`type`, `title`, `subtitle`, `status`, `weigh`, `category_ids`, `image`, `images`, `params`, `content`,
|
||
`price`, `original_price`, `is_sku`, `show_sales`, `dispatch_type`, `dispatch_ids`, `createtime`, `updatetime`
|
||
) VALUES (
|
||
'normal', '【演示】橙虎小酒 商务宴请装', '一男人的朋友一', 'up', 100, CAST(@cat_banquet AS CHAR),
|
||
@img_banquet, CONCAT(@img_banquet, ',', @img_bag, ',', @photo_bag), '[]', CONCAT('<p>120ml×10 / 49%vol</p><p><img src=\"', @photo_bag, '\"></p>'), '528.00', 628.00, 0, 66,
|
||
'express', CAST(@dispatch_id AS CHAR), @now, @now
|
||
);
|
||
|
||
SET @g4 = LAST_INSERT_ID();
|
||
|
||
INSERT INTO `fa_shopro_goods_sku_price` (`goods_sku_ids`, `goods_id`, `stock`, `sn`, `weight`, `price`, `status`, `createtime`, `updatetime`)
|
||
VALUES (NULL, @g4, 999, 'XG-DEMO-004', 1, 528.00, 'up', @now, @now);
|
||
|
||
-- ========== 首页轮播 ==========
|
||
UPDATE `fa_shopro_decorate_content`
|
||
SET `content` = JSON_SET(
|
||
IFNULL(`content`, '{}'),
|
||
'$.list', JSON_ARRAY(
|
||
JSON_OBJECT('image', @img_main, 'path', CONCAT('/pages/goods/detail?id=', @g1), 'path_type', 1, 'path_name', '橙虎小酒礼盒', 'name', '', 'bgcolor', '#FAFAF8'),
|
||
JSON_OBJECT('image', @img_bag, 'path', CONCAT('/pages/goods/detail?id=', @g4), 'path_type', 1, 'path_name', '橙虎小酒礼袋', 'name', '', 'bgcolor', '#FAFAF8'),
|
||
JSON_OBJECT('image', @img_tasting, 'path', CONCAT('/pages/goods/detail?id=', @g2), 'path_type', 1, 'path_name', '品鉴装', 'name', '', 'bgcolor', '#FAFAF8')
|
||
),
|
||
'$.radius', 16,
|
||
'$.height', 530
|
||
)
|
||
WHERE `type` = 'banner' AND `category` = 'home' AND JSON_VALID(IFNULL(`content`, '{}')) = 1;
|
||
|
||
-- ========== 首页商品列表 ==========
|
||
UPDATE `fa_shopro_decorate_content`
|
||
SET `content` = JSON_SET(
|
||
IFNULL(`content`, '{}'),
|
||
'$.ids', CONCAT(@g1, ',', @g2, ',', @g3, ',', @g4),
|
||
'$.name', '精选好酒'
|
||
)
|
||
WHERE `type` = 'goods-list' AND `category` = 'home' AND JSON_VALID(IFNULL(`content`, '{}')) = 1;
|
||
|
||
-- ========== TabBar 浅色主题 ==========
|
||
UPDATE `fa_shopro_decorate_content`
|
||
SET `content` = JSON_SET(
|
||
IFNULL(`content`, '{}'),
|
||
'$.color', '#BBBBBB',
|
||
'$.activeColor', '#C4A574',
|
||
'$.bgcolor', '#FFFFFF'
|
||
)
|
||
WHERE `category` = 'tabbar' AND JSON_VALID(IFNULL(`content`, '{}')) = 1;
|
||
|
||
-- ========== 个人中心头图 ==========
|
||
UPDATE `fa_shopro_decorate_content`
|
||
SET `content` = JSON_SET(IFNULL(`content`, '{}'), '$.color', '#F5EFE4')
|
||
WHERE `category` = 'user' AND JSON_VALID(IFNULL(`content`, '{}')) = 1;
|
||
|
||
-- ========== 回滚（需要时取消注释） ==========
|
||
-- DELETE FROM fa_shopro_goods_sku_price WHERE sn LIKE 'XG-DEMO-%';
|
||
-- DELETE FROM fa_shopro_goods WHERE title LIKE '【演示】橙虎小酒%';
|