-- 补充更新剩余的药品类商品数据

-- 白酒类商品 (goods_class_id = 9) - 剩余商品
UPDATE ls_retail_goods SET 
    goods_name = '泸州老窖 52度 500ml',
    retail_price = 199.00,
    purchase_price = 160.00,
    goods_number = 'LZLJ002',
    goods_code = '6901234567920',
    specifications = '500ml/瓶',
    details = '泸州老窖，浓香鼻祖，中国四大名酒之一，口感甘美，回味悠长。'
WHERE id = 4003;

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

-- 红酒类商品 (goods_class_id = 21) - 剩余商品
UPDATE ls_retail_goods SET 
    goods_name = '楼兰干红葡萄酒 750ml',
    retail_price = 118.00,
    purchase_price = 88.00,
    goods_number = 'LL002',
    goods_code = '6901234567922',
    specifications = '750ml/瓶',
    details = '楼兰干红葡萄酒，新疆吐鲁番产区，沙漠气候造就独特风味，口感醇厚甘美。'
WHERE id = 4001;

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

-- 啤酒类商品 (goods_class_id = 22) - 剩余商品
UPDATE ls_retail_goods SET 
    goods_name = '金威啤酒 500ml',
    retail_price = 9.00,
    purchase_price = 6.50,
    goods_number = 'JW002',
    goods_code = '6901234567924',
    specifications = '500ml/瓶',
    details = '金威啤酒，深圳本土品牌，口感醇厚，泡沫持久，是华南地区的优质啤酒。'
WHERE id = 3999;

-- 更新商品状态和库存
UPDATE ls_retail_goods SET status = 0, goods_num = 100.000, add_time = UNIX_TIMESTAMP() WHERE id IN (4003, 4004, 4001, 4002, 3999);