ALTER TABLE `kx_user` 
ADD COLUMN `invite_code` varchar(10) NULL COMMENT '邀请码' AFTER `gender`;


INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1944765043400839169, '分销管理', 0, 11, 'promoter', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'fenxiao', 'admin', '2025-07-14 22:24:53', 'admin', '2025-07-14 22:24:53', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1944765454224527361, '分销配置', 1944765043400839169, 1, 'promoterConfig', 'system/promoter/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-14 22:26:31', 'admin', '2025-07-14 22:26:31', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1947443659049816066, '分销记录', 1944765043400839169, 2, 'promoterBill', 'promoter/userBill/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-22 07:48:45', 'admin', '2025-07-22 07:49:34', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1947652092055375873, '提现管理', 1944765043400839169, 3, 'promoterUserExtract', 'promoter/userExtract/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-22 21:36:59', 'admin', '2025-07-22 21:37:05', '');



DROP TABLE IF EXISTS `kx_user_extract`;
CREATE TABLE `kx_user_extract` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) unsigned DEFAULT NULL,
  `real_name` varchar(64) DEFAULT NULL COMMENT '名称',
  `extract_type` varchar(32) DEFAULT 'bank' COMMENT 'bank = 银行卡 alipay = 支付宝wx=微信',
  `bank_code` varchar(32) DEFAULT '0' COMMENT '银行卡',
  `bank_address` varchar(256) DEFAULT '' COMMENT '开户地址',
  `alipay_code` varchar(64) DEFAULT '' COMMENT '支付宝账号',
  `extract_price` decimal(8,2) unsigned DEFAULT '0.00' COMMENT '提现金额',
  `mark` varchar(512) DEFAULT NULL,
  `balance` decimal(8,2) unsigned DEFAULT '0.00',
  `fail_msg` varchar(128) DEFAULT NULL COMMENT '无效原因',
  `fail_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `update_time` datetime DEFAULT NULL,
  `status` tinyint(2) DEFAULT '0' COMMENT '-1 未通过 0 审核中 1 已提现',
  `wechat` varchar(15) DEFAULT NULL COMMENT '微信号',
  `is_del` tinyint(1) DEFAULT '0',
  `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `extract_type` (`extract_type`) USING BTREE,
  KEY `status` (`status`) USING BTREE,
  KEY `add_time` (`create_time`) USING BTREE,
  KEY `openid` (`uid`) USING BTREE,
  KEY `fail_time` (`fail_time`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1946954803066183682 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户提现表';

INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948736717477502977, '报表管理', 0, 12, '/report', NULL, NULL, 1, 0, 'M', '0', '0', NULL, 'chart', 'admin', '2025-07-25 21:26:54', 'admin', '2025-07-25 21:30:02', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948737465342877698, '报表设计器', 1948736717477502977, 1, 'jimu-report', 'report/jmreport', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 21:29:52', 'admin', '2025-07-25 21:53:44', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948737802288095233, '大屏设计器', 1948736717477502977, 2, 'jimu-view', 'report/drag', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 21:31:13', 'admin', '2025-07-25 21:53:56', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948741975154888706, '销售报表', 1948736717477502977, 3, '/jmreport/view/542152544408129536', 'report/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 21:47:47', 'admin', '2025-07-25 22:18:33', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948750395111116801, '报表示例', 1948736717477502977, 4, '/jmreport/view/590812531803901952', 'report/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 22:21:15', 'admin', '2025-07-25 22:21:15', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948750774431387650, '大屏示例', 1948736717477502977, 5, '/drag/share/view/1016994272231608320', 'report/newWindow', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 22:22:45', 'admin', '2025-07-25 22:29:14', '');
INSERT INTO `sys_menu`(`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query_param`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES (1948751110395138050, '看板示例', 1948736717477502977, 6, '/drag/share/view/910475721247866880', 'report/index', NULL, 1, 0, 'C', '0', '0', NULL, '#', 'admin', '2025-07-25 22:24:05', 'admin', '2025-07-25 22:24:05', '');
