kknongchang_2506/app/Module/UrsPromotion/Databases/createsql/init_data.sql

-- URS推广模块初始化数据脚本
-- 创建时间: 2025-06-14
-- 版本: v1.0.0

-- 1. 初始化URS达人等级配置
INSERT INTO `kku_urs_promotion_talent_configs` (`level`, `name`, `direct_count_required`, `promotion_count_required`, `profit_rate`, `benefits`, `icon`, `description`, `sort_order`, `status`) VALUES
(0, '非URS达人', 0, 0, 0.000000, '{"description": "普通用户，无特殊权益"}', 'fa-user', '普通用户等级，无推广权益', 0, 1),
(1, 'URS初级达人', 5, 10, 0.010000, '{"description": "初级达人权益", "benefits": ["1%间推分成", "专属推荐码", "团队数据查看"]}', 'fa-star', '需要5个直推和10个团队成员，享受1%间推分成', 1, 1),
(2, 'URS中级达人', 10, 30, 0.015000, '{"description": "中级达人权益", "benefits": ["1.5%间推分成", "高级推荐码", "团队数据分析", "专属客服"]}', 'fa-star-half-alt', '需要10个直推和30个团队成员，享受1.5%间推分成', 2, 1),
(3, 'URS高级达人', 20, 100, 0.020000, '{"description": "高级达人权益", "benefits": ["2%间推分成", "自定义推荐码", "高级数据分析", "优先客服", "专属活动"]}', 'fa-crown', '需要20个直推和100个团队成员，享受2%间推分成', 3, 1),
(4, 'URS资深达人', 50, 300, 0.025000, '{"description": "资深达人权益", "benefits": ["2.5%间推分成", "多个推荐码", "全面数据分析", "VIP客服", "专属活动", "线下聚会"]}', 'fa-gem', '需要50个直推和300个团队成员，享受2.5%间推分成', 4, 1),
(5, 'URS顶级达人', 100, 1000, 0.030000, '{"description": "顶级达人权益", "benefits": ["3%间推分成", "无限推荐码", "实时数据监控", "专属客户经理", "所有活动", "合作伙伴资格"]}', 'fa-trophy', '需要100个直推和1000个团队成员，享受3%间推分成', 5, 1);

-- 2. 初始化URS收益分成规则
INSERT INTO `kku_urs_promotion_profit_rules` (`source_type`, `name`, `direct_profit_rate`, `max_indirect_level`, `min_amount`, `max_amount`, `rules`, `description`, `sort_order`, `status`) VALUES
('urs_farm_harvest', 'URS农场收获分成', 0.050000, 20, 1.0000000000, 0.0000000000, '{"min_harvest_amount": 10, "max_daily_profit": 1000, "excluded_crops": []}', 'URS用户农场收获时的团队分成规则，直推5%，间推根据达人等级', 1, 1),
('urs_task_complete', 'URS任务完成分成', 0.030000, 10, 0.5000000000, 500.0000000000, '{"min_task_reward": 5, "max_task_profit": 500, "excluded_tasks": []}', 'URS用户完成任务时的团队分成规则，直推3%，最多10层间推', 2, 1),
('urs_item_sell', 'URS物品出售分成', 0.020000, 5, 0.1000000000, 100.0000000000, '{"min_sell_amount": 1, "max_sell_profit": 100, "excluded_items": [1001, 1002]}', 'URS用户出售物品时的团队分成规则，直推2%，最多5层间推', 3, 1),
('urs_shop_purchase', 'URS商店购买分成', 0.015000, 3, 0.1000000000, 50.0000000000, '{"min_purchase_amount": 10, "max_purchase_profit": 50, "excluded_categories": []}', 'URS用户商店购买时的团队分成规则，直推1.5%，最多3层间推', 4, 1),
('urs_activity_reward', 'URS活动奖励分成', 0.025000, 15, 1.0000000000, 200.0000000000, '{"min_activity_reward": 20, "max_activity_profit": 200, "excluded_activities": []}', 'URS用户获得活动奖励时的团队分成规则，直推2.5%，最多15层间推', 5, 1);

-- 3. 创建系统默认推荐码（可选）
-- 注意：这里的user_id需要根据实际系统用户ID调整
-- INSERT INTO `kku_urs_promotion_referral_codes` (`user_id`, `code`, `type`, `max_usage`, `status`) VALUES
-- (1, 'URS_SYSTEM_001', 'system', 0, 1),
-- (1, 'URS_WELCOME_2025', 'system', 1000, 1);

-- 4. 创建示例邀请奖励配置（可选）
-- 这些数据可以根据实际业务需求进行调整
-- INSERT INTO `kku_urs_promotion_invite_rewards` (`user_id`, `invited_user_id`, `reward_type`, `reward_source`, `reward_amount`, `status`) VALUES
-- (1, 2, 'welcome_bonus', 'system', 100.0000000000, 1);

-- 验证数据插入
SELECT 'URS达人等级配置' as table_name, COUNT(*) as count FROM `kku_urs_promotion_talent_configs`
UNION ALL
SELECT 'URS收益分成规则' as table_name, COUNT(*) as count FROM `kku_urs_promotion_profit_rules`;

-- 显示插入的配置数据
SELECT 
    level,
    name,
    direct_count_required,
    promotion_count_required,
    profit_rate,
    status
FROM `kku_urs_promotion_talent_configs` 
ORDER BY level;

SELECT 
    source_type,
    name,
    direct_profit_rate,
    max_indirect_level,
    status
FROM `kku_urs_promotion_profit_rules` 
ORDER BY sort_order;