water/server/plugin/saiadmin/db/20260822_seed_merchant_demo.sql

-- ============================================================
-- 商户功能演示数据（仅供本地测试）
-- 日期: 2026-08-22
-- 登录测试密码统一为: 123456
-- 测试手机号范围: 19000000001 - 19000000008
-- 本脚本可重复执行，不会重复插入未删除的相同测试手机号。
-- ============================================================

INSERT INTO `sa_merchant` (
    `agent_id`, `profit_user_id`, `name`, `store_phone`, `storefront_image`,
    `industry`, `region`, `address`, `description`, `products`,
    `profit_method`, `profit_rate`, `contact`, `phone`, `password`, `permissions`,
    `distributed`, `status`, `agent_type`, `total_amount`, `total_income`,
    `withdrawable_amount`, `order_count`, `device_count`,
    `yesterday_usage_rate`, `three_day_usage_rate`, `seven_day_usage_rate`,
    `yesterday_average_order`, `three_day_average_order`, `seven_day_average_order`,
    `created_by`, `updated_by`, `create_time`, `update_time`
)
SELECT demo.*
FROM (
    SELECT
        1 AS `agent_id`, 3 AS `profit_user_id`, '北京朝阳星光咖啡' AS `name`,
        '13910000001' AS `store_phone`, 'https://picsum.photos/seed/sai-merchant-01/160/160' AS `storefront_image`,
        '美食餐饮/咖啡厅' AS `industry`, '北京市 / 北京市 / 朝阳区' AS `region`,
        '北京市朝阳区望京街道阜通东大街 6 号' AS `address`, '【演示数据】工作日客流稳定的咖啡厅商户。' AS `description`,
        '["车载充电器"]' AS `products`, '比例分成' AS `profit_method`, 18.00 AS `profit_rate`,
        '林女士' AS `contact`, '19000000001' AS `phone`, '$2y$10$4m/HHtGkXi4k.8qHTgcT9e0A.aA9g.ZJNJ7k3A7n5NUY0pg81QAay' AS `password`,
        '["自营","查看订单"]' AS `permissions`, 1 AS `distributed`, 1 AS `status`, 'city-partner' AS `agent_type`,
        12890.50 AS `total_amount`, 2578.10 AS `total_income`, 1260.00 AS `withdrawable_amount`,
        358 AS `order_count`, 4 AS `device_count`, 66.50 AS `yesterday_usage_rate`, 61.20 AS `three_day_usage_rate`, 58.80 AS `seven_day_usage_rate`,
        35.80 AS `yesterday_average_order`, 34.20 AS `three_day_average_order`, 33.60 AS `seven_day_average_order`,
        1 AS `created_by`, 1 AS `updated_by`, DATE_SUB(NOW(), INTERVAL 45 DAY) AS `create_time`, NOW() AS `update_time`
    UNION ALL
    SELECT 1, 4, '深圳南山好邻居便利店', '13910000002', 'https://picsum.photos/seed/sai-merchant-02/160/160',
        '零售/便利店', '广东省 / 深圳市 / 南山区', '深圳市南山区科技园科苑路 15 号', '【演示数据】写字楼园区便利店。',
        '["充电宝","蓝牙线充"]', '比例分成', 22.50, '周先生', '19000000002', '$2y$10$4m/HHtGkXi4k.8qHTgcT9e0A.aA9g.ZJNJ7k3A7n5NUY0pg81QAay',
        '["查看订单","白名单"]', 1, 1, 'agent', 28650.00, 6446.25, 3180.50, 792, 8, 82.30, 79.80, 76.40, 41.20, 39.80, 38.60,
        1, 1, DATE_SUB(NOW(), INTERVAL 36 DAY), NOW()
    UNION ALL
    SELECT 2, 5, '上海静安麦浪K歌空间', '13910000003', 'https://picsum.photos/seed/sai-merchant-03/160/160',
        '休闲娱乐/KTV', '上海市 / 上海市 / 静安区', '上海市静安区南京西路 688 号', '【演示数据】尚未完成设备铺货的娱乐商户。',
        '["K霸宝"]', '入驻费', 0.00, '顾经理', '19000000003', '$2y$10$4m/HHtGkXi4k.8qHTgcT9e0A.aA9g.ZJNJ7k3A7n5NUY0pg81QAay',
        '["查看订单"]', 0, 1, 'salesperson', 0.00, 0.00, 0.00, 0, 0, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00,
        1, 1, DATE_SUB(NOW(), INTERVAL 20 DAY), NOW()
    UNION ALL
    SELECT 3, 1, '成都锦里蜀味餐厅', '13910000004', 'https://picsum.photos/seed/sai-merchant-04/160/160',
        '美食餐饮/川菜', '四川省 / 成都市 / 武侯区', '成都市武侯区武侯祠大街 231 号', '【演示数据】旅游区域餐饮商户。',
        '["密码蓝牙线充"]', '比例分成', 15.00, '何女士', '19000000004', '$2y$10$4m/HHtGkXi4k.8qHTgcT9e0A.aA9g.ZJNJ7k3A7n5NUY0pg81QAay',
        '["自营","查看订单"]', 1, 1, 'city-partner', 9350.80, 1402.62, 820.00, 271, 3, 51.20, 55.60, 49.80, 32.50, 34.10, 33.20,
        1, 1, DATE_SUB(NOW(), INTERVAL 18 DAY), NOW()
    UNION ALL
    SELECT 4, 2, '杭州西湖云栖民宿', '13910000005', 'https://picsum.photos/seed/sai-merchant-05/160/160',
        '酒店住宿/民宿', '浙江省 / 杭州市 / 西湖区', '杭州市西湖区梅灵南路 8 号', '【演示数据】待铺货民宿商户。',
        '["密码线充"]', '不分成', 0.00, '陈店长', '19000000005', '$2y$10$4m/HHtGkXi4k.8qHTgcT9e0A.aA9g.ZJNJ7k3A7n5NUY0pg81QAay',
        '["白名单"]', 0, 1, 'agent', 1680.00, 0.00, 0.00, 42, 1, 18.00, 20.50, 22.10, 40.00, 38.20, 37.50,
        1, 1, DATE_SUB(NOW(), INTERVAL 12 DAY), NOW()
    UNION ALL
    SELECT 5, 10, '广州天河跃动健身房', '13910000006', 'https://picsum.photos/seed/sai-merchant-06/160/160',
        '运动健身/健身房', '广东省 / 广州市 / 天河区', '广州市天河区体育西路 101 号', '【演示数据】设备使用率较高的健身商户。',
        '["车载充电器","充电宝"]', '比例分成', 20.00, '邹教练', '19000000006', '$2y$10$4m/HHtGkXi4k.8qHTgcT9e0A.aA9g.ZJNJ7k3A7n5NUY0pg81QAay',
        '["自营","查看订单","白名单"]', 1, 1, 'agent', 31880.40, 6376.08, 4980.20, 986, 12, 91.60, 88.40, 85.20, 45.60, 43.80, 42.70,
        1, 1, DATE_SUB(NOW(), INTERVAL 10 DAY), NOW()
    UNION ALL
    SELECT 10, 100, '武汉江汉悦读书店', '13910000007', 'https://picsum.photos/seed/sai-merchant-07/160/160',
        '文化教育/书店', '湖北省 / 武汉市 / 江汉区', '武汉市江汉区中山大道 818 号', '【演示数据】书店与阅读空间。',
        '["蓝牙线充"]', '比例分成', 12.00, '黎先生', '19000000007', '$2y$10$4m/HHtGkXi4k.8qHTgcT9e0A.aA9g.ZJNJ7k3A7n5NUY0pg81QAay',
        '["查看订单"]', 1, 2, 'salesperson', 4260.00, 511.20, 320.00, 118, 2, 35.00, 38.60, 40.10, 36.10, 35.80, 35.20,
        1, 1, DATE_SUB(NOW(), INTERVAL 6 DAY), NOW()
    UNION ALL
    SELECT 100, 101, '西安雁塔时光桌游馆', '13910000008', 'https://picsum.photos/seed/sai-merchant-08/160/160',
        '休闲娱乐/桌游', '陕西省 / 西安市 / 雁塔区', '西安市雁塔区小寨东路 126 号', '【演示数据】新开业桌游商户。',
        '["K霸宝","充电宝"]', '比例分成', 16.50, '许店长', '19000000008', '$2y$10$4m/HHtGkXi4k.8qHTgcT9e0A.aA9g.ZJNJ7k3A7n5NUY0pg81QAay',
        '["自营","查看订单"]', 1, 1, 'city-partner', 7620.60, 1257.40, 730.00, 229, 5, 62.00, 60.30, 57.90, 33.40, 32.80, 32.10,
        1, 1, DATE_SUB(NOW(), INTERVAL 2 DAY), NOW()
) AS demo
LEFT JOIN `sa_merchant` existing
       ON existing.`phone` = demo.`phone`
      AND existing.`delete_time` IS NULL
WHERE existing.`id` IS NULL;

-- 如需清理本文件生成的数据，可执行：
-- UPDATE sa_merchant SET delete_time = NOW()
-- WHERE phone BETWEEN '19000000001' AND '19000000008' AND description LIKE '【演示数据】%';