-- 橙虎小酒：更新演示商品包装图（含用户实拍礼盒 + 礼袋）
-- 前提：已上传 public/uploads/demo/xiongge/ 下全部图片
-- 执行顺序：rename_brand_xiongge.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';
SET @photo_box = '/uploads/demo/xiongge/xg-photo-gift-box.jpg';
SET @photo_bag = '/uploads/demo/xiongge/xg-photo-gift-bag.jpg';

-- ========== 分类图标 ==========
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;

-- ========== 演示商品主图 + 相册（含两张实拍图） ==========
UPDATE `fa_shopro_goods`
SET `image` = @img_box,
    `images` = CONCAT(@img_box, ',', @img_gift, ',', @photo_box, ',', @photo_bag),
    `content` = CONCAT(
        '<p>贵州雄戈酒业有限公司出品</p>',
        '<p>净含量：120ml×5 &nbsp; 酒精度：49%vol</p>',
        '<p><img src=\"', @photo_box, '\"></p>',
        '<p><img src=\"', @img_gift, '\"></p>',
        '<p><img src=\"', @photo_bag, '\"></p>'
    ),
    `updatetime` = @now
WHERE `title` LIKE '%礼盒装%';

UPDATE `fa_shopro_goods`
SET `image` = @img_taste,
    `images` = CONCAT(@img_taste, ',', @photo_box),
    `content` = CONCAT('<p>120ml×2 / 49%vol</p><p><img src=\"', @photo_box, '\"></p>'),
    `updatetime` = @now
WHERE `title` LIKE '%品鉴装%';

UPDATE `fa_shopro_goods`
SET `image` = @img_bottle,
    `images` = CONCAT(@img_bottle, ',', @photo_box),
    `content` = CONCAT('<p>120ml / 49%vol</p><p><img src=\"', @photo_box, '\"></p>'),
    `updatetime` = @now
WHERE `title` LIKE '%单瓶装%';

UPDATE `fa_shopro_goods`
SET `image` = @img_banquet,
    `images` = CONCAT(@img_banquet, ',', @img_bag, ',', @photo_bag),
    `content` = CONCAT('<p>120ml×10 / 49%vol</p><p><img src=\"', @photo_bag, '\"></p>'),
    `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);
SET @g3 = (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'),
        JSON_OBJECT('image', @img_taste, 'path', CONCAT('/pages/goods/detail?id=', IFNULL(@g3, 0)), 'path_type', 1, 'path_name', '品鉴装', 'name', '', 'bgcolor', '#FAFAF8')
    ),
    '$.radius', 16,
    '$.height', 530
) AS CHAR)
WHERE `type` = 'banner' AND `category` = 'home';
-- 注：fa_shopro_decorate_content 无 updatetime 字段

-- 验证：
-- SELECT title, image, images FROM fa_shopro_goods WHERE title LIKE '【演示】橙虎小酒%';
-- SELECT type, LEFT(content, 500) FROM fa_shopro_decorate_content WHERE category='home' AND type='banner';