-- 酒类商品demo数据更新脚本
-- 将药品类商品替换为酒类商品

-- 白酒类商品 (goods_class_id = 9)
UPDATE ls_retail_goods SET 
    goods_name = '五粮液 52度 500ml',
    retail_price = 899.00,
    purchase_price = 750.00,
    goods_number = 'WLY001',
    goods_code = '6901234567890',
    specifications = '500ml/瓶',
    details = '五粮液是中国著名白酒品牌，采用五种粮食酿造，口感醇厚，香味浓郁。'
WHERE goods_class_id = 9 AND id = 3985;

UPDATE ls_retail_goods SET 
    goods_name = '茅台酒 53度 500ml',
    retail_price = 2699.00,
    purchase_price = 2200.00,
    goods_number = 'MT001',
    goods_code = '6901234567891',
    specifications = '500ml/瓶',
    details = '贵州茅台酒，中国国酒，酱香型白酒的典型代表，历史悠久，品质卓越。'
WHERE goods_class_id = 9 AND id = 3986;

UPDATE ls_retail_goods SET 
    goods_name = '剑南春 52度 500ml',
    retail_price = 459.00,
    purchase_price = 380.00,
    goods_number = 'JNC001',
    goods_code = '6901234567892',
    specifications = '500ml/瓶',
    details = '剑南春，浓香型白酒，口感绵甜，回味悠长，是四川名酒的代表。'
WHERE goods_class_id = 9 AND id = 3987;

UPDATE ls_retail_goods SET 
    goods_name = '水井坊 52度 500ml',
    retail_price = 688.00,
    purchase_price = 580.00,
    goods_number = 'SJF001',
    goods_code = '6901234567893',
    specifications = '500ml/瓶',
    details = '水井坊，中国白酒鼻祖，传承千年酿酒工艺，口感醇和，香气优雅。'
WHERE goods_class_id = 9 AND id = 3994;

UPDATE ls_retail_goods SET 
    goods_name = '洋河蓝色经典 52度 500ml',
    retail_price = 368.00,
    purchase_price = 300.00,
    goods_number = 'YH001',
    goods_code = '6901234567894',
    specifications = '500ml/瓶',
    details = '洋河蓝色经典，绵柔型白酒开创者，口感绵柔甘甜，深受消费者喜爱。'
WHERE goods_class_id = 9 AND id = 3995;

UPDATE ls_retail_goods SET 
    goods_name = '郎酒 53度 500ml',
    retail_price = 299.00,
    purchase_price = 240.00,
    goods_number = 'LJ001',
    goods_code = '6901234567895',
    specifications = '500ml/瓶',
    details = '郎酒，酱香型白酒，产自四川古蔺，酒体醇厚，香味独特。'
WHERE goods_class_id = 9 AND id = 3996;

UPDATE ls_retail_goods SET 
    goods_name = '泸州老窖 52度 500ml',
    retail_price = 199.00,
    purchase_price = 160.00,
    goods_number = 'LZLJ001',
    goods_code = '6901234567896',
    specifications = '500ml/瓶',
    details = '泸州老窖，浓香鼻祖，中国四大名酒之一，口感甘美，回味悠长。'
WHERE goods_class_id = 9 AND id = 3997;

UPDATE ls_retail_goods SET 
    goods_name = '西凤酒 45度 500ml',
    retail_price = 158.00,
    purchase_price = 130.00,
    goods_number = 'XF001',
    goods_code = '6901234567897',
    specifications = '500ml/瓶',
    details = '西凤酒，凤香型白酒代表，陕西名酒，口感清香甘润，风味独特。'
WHERE goods_class_id = 9 AND id = 3998;

-- 红酒类商品 (goods_class_id = 21)
UPDATE ls_retail_goods SET 
    goods_name = '长城干红葡萄酒 750ml',
    retail_price = 88.00,
    purchase_price = 65.00,
    goods_number = 'CC001',
    goods_code = '6901234567898',
    specifications = '750ml/瓶',
    details = '长城干红葡萄酒，选用优质葡萄酿造，口感醇厚，果香浓郁，是国产红酒的代表品牌。'
WHERE goods_class_id = 21 AND id = 3982;

UPDATE ls_retail_goods SET 
    goods_name = '张裕解百纳干红 750ml',
    retail_price = 128.00,
    purchase_price = 95.00,
    goods_number = 'ZY001',
    goods_code = '6901234567899',
    specifications = '750ml/瓶',
    details = '张裕解百纳，中国葡萄酒知名品牌，口感平衡，单宁柔和，适合配餐饮用。'
WHERE goods_class_id = 21 AND id = 3983;

UPDATE ls_retail_goods SET 
    goods_name = '王朝干红葡萄酒 750ml',
    retail_price = 68.00,
    purchase_price = 50.00,
    goods_number = 'WC001',
    goods_code = '6901234567900',
    specifications = '750ml/瓶',
    details = '王朝干红葡萄酒，口感柔顺，果香清新，性价比高，适合日常饮用。'
WHERE goods_class_id = 21 AND id = 3984;

UPDATE ls_retail_goods SET 
    goods_name = '威龙干红葡萄酒 750ml',
    retail_price = 58.00,
    purchase_price = 42.00,
    goods_number = 'WL001',
    goods_code = '6901234567901',
    specifications = '750ml/瓶',
    details = '威龙干红葡萄酒，来自山东烟台，口感清爽，酸度适中，是入门级红酒的好选择。'
WHERE goods_class_id = 21 AND id = 3988;

UPDATE ls_retail_goods SET 
    goods_name = '通化红酒 750ml',
    retail_price = 45.00,
    purchase_price = 32.00,
    goods_number = 'TH001',
    goods_code = '6901234567902',
    specifications = '750ml/瓶',
    details = '通化红酒，东北特色葡萄酒，口感甜润，适合不常饮酒的消费者。'
WHERE goods_class_id = 21 AND id = 3991;

UPDATE ls_retail_goods SET 
    goods_name = '新天干红葡萄酒 750ml',
    retail_price = 78.00,
    purchase_price = 58.00,
    goods_number = 'XT001',
    goods_code = '6901234567903',
    specifications = '750ml/瓶',
    details = '新天干红葡萄酒，来自新疆天山北麓，日照充足，葡萄品质优良，酒体饱满。'
WHERE goods_class_id = 21 AND id = 3992;

UPDATE ls_retail_goods SET 
    goods_name = '尼雅干红葡萄酒 750ml',
    retail_price = 98.00,
    purchase_price = 75.00,
    goods_number = 'NY001',
    goods_code = '6901234567904',
    specifications = '750ml/瓶',
    details = '尼雅干红葡萄酒，新疆特色红酒，口感浓郁，层次丰富，具有独特的地域风味。'
WHERE goods_class_id = 21 AND id = 3993;

UPDATE ls_retail_goods SET 
    goods_name = '楼兰干红葡萄酒 750ml',
    retail_price = 118.00,
    purchase_price = 88.00,
    goods_number = 'LL001',
    goods_code = '6901234567905',
    specifications = '750ml/瓶',
    details = '楼兰干红葡萄酒，新疆吐鲁番产区，沙漠气候造就独特风味，口感醇厚甘美。'
WHERE goods_class_id = 21 AND id = 3997;

-- 啤酒类商品 (goods_class_id = 22)
UPDATE ls_retail_goods SET 
    goods_name = '青岛啤酒 500ml',
    retail_price = 8.00,
    purchase_price = 5.50,
    goods_number = 'QD001',
    goods_code = '6901234567906',
    specifications = '500ml/瓶',
    details = '青岛啤酒，中国啤酒知名品牌，口感清爽，泡沫丰富，是夏日消暑的好选择。'
WHERE goods_class_id = 22 AND id = 3979;

UPDATE ls_retail_goods SET 
    goods_name = '雪花啤酒 500ml',
    retail_price = 6.00,
    purchase_price = 4.20,
    goods_number = 'XH001',
    goods_code = '6901234567907',
    specifications = '500ml/瓶',
    details = '雪花啤酒，中国销量领先的啤酒品牌，口感淡爽，适合大众消费。'
WHERE goods_class_id = 22 AND id = 3980;

UPDATE ls_retail_goods SET 
    goods_name = '燕京啤酒 500ml',
    retail_price = 7.00,
    purchase_price = 4.80,
    goods_number = 'YJ001',
    goods_code = '6901234567908',
    specifications = '500ml/瓶',
    details = '燕京啤酒，北京本土品牌，口感醇和，麦香浓郁，深受北方消费者喜爱。'
WHERE goods_class_id = 22 AND id = 3981;

UPDATE ls_retail_goods SET 
    goods_name = '哈尔滨啤酒 500ml',
    retail_price = 7.50,
    purchase_price = 5.20,
    goods_number = 'HEB001',
    goods_code = '6901234567909',
    specifications = '500ml/瓶',
    details = '哈尔滨啤酒，东北老牌啤酒，口感清冽，具有浓郁的麦芽香味。'
WHERE goods_class_id = 22 AND id = 3988;

UPDATE ls_retail_goods SET 
    goods_name = '珠江啤酒 500ml',
    retail_price = 6.50,
    purchase_price = 4.50,
    goods_number = 'ZJ001',
    goods_code = '6901234567910',
    specifications = '500ml/瓶',
    details = '珠江啤酒，广东本土品牌，口感清淡，适合南方气候，是广东人的首选啤酒。'
WHERE goods_class_id = 22 AND id = 3989;

UPDATE ls_retail_goods SET 
    goods_name = '重庆啤酒 500ml',
    retail_price = 8.50,
    purchase_price = 6.00,
    goods_number = 'CQ001',
    goods_code = '6901234567911',
    specifications = '500ml/瓶',
    details = '重庆啤酒，西南地区知名品牌，口感浓郁，具有独特的山城风味。'
WHERE goods_class_id = 22 AND id = 3990;

UPDATE ls_retail_goods SET 
    goods_name = '金威啤酒 500ml',
    retail_price = 9.00,
    purchase_price = 6.50,
    goods_number = 'JW001',
    goods_code = '6901234567912',
    specifications = '500ml/瓶',
    details = '金威啤酒，深圳本土品牌，口感醇厚，泡沫持久，是华南地区的优质啤酒。'
WHERE goods_class_id = 22 AND id = 3991;

UPDATE ls_retail_goods SET 
    goods_name = '百威啤酒 500ml',
    retail_price = 12.00,
    purchase_price = 8.50,
    goods_number = 'BW001',
    goods_code = '6901234567913',
    specifications = '500ml/瓶',
    details = '百威啤酒，国际知名品牌，口感纯正，品质稳定，是进口啤酒的代表。'
WHERE goods_class_id = 22 AND id = 3997;

UPDATE ls_retail_goods SET 
    goods_name = '喜力啤酒 500ml',
    retail_price = 15.00,
    purchase_price = 11.00,
    goods_number = 'XL001',
    goods_code = '6901234567914',
    specifications = '500ml/瓶',
    details = '喜力啤酒，荷兰进口，口感清爽，具有独特的苦味和香味，是高端啤酒的选择。'
WHERE goods_class_id = 22 AND id = 3998;

-- 更新商品状态为正常
UPDATE ls_retail_goods SET status = 0 WHERE goods_class_id IN (9, 21, 22) AND status != 2;

-- 更新库存数量
UPDATE ls_retail_goods SET goods_num = 100.000 WHERE goods_class_id IN (9, 21, 22) AND status != 2;

-- 更新添加时间为当前时间
UPDATE ls_retail_goods SET add_time = UNIX_TIMESTAMP() WHERE goods_class_id IN (9, 21, 22) AND status != 2;