wecom-dashboards/excel-handle/sql/wecom_menu.sql

INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2000, ''企业微信统计'', 0, 5, ''wecom'', NULL, NULL, '''', 1, 0, ''M'', ''0 '', ''0 '', '''', ''chart'', ''admin'',
        ''2026 - 02 - 07 15:39:03'', '''', NULL, ''企业微信统计管理目录'');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2001, ''客户列表数据'', 2000, 4, ''customerExport'', ''wecom/customerExport/index'', NULL, '''', 1, 0, ''C'', ''0 '',
        ''0 '', ''wecom:customerExport:list'', ''download'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL,
        ''客户导出数据菜单'');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2002, ''客户联系统计'', 2000, 2, ''customerContact'', ''wecom/customerContact/index'', NULL, '''', 1, 0, ''C'',
        ''0 '', ''0 '', ''wecom:customerContact:list'', ''peoples'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL,
        ''客户联系统计数据菜单'');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2003, ''流量看板数据'', 2000, 1, ''customerStatistics'', ''wecom/customerStatistics/index'', NULL, '''', 1, 0, ''C'',
        ''0 '', ''0 '', ''wecom:customerStatistics:list'', ''table'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''',
        NULL, ''流量看板数据菜单'');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2004, ''销售看板数据'', 2000, 3, ''departmentStatistics'', ''wecom/departmentStatistics/index'', NULL, '''', 1, 0,
        ''C'', ''0 '', ''0 '', ''wecom:departmentStatistics:list'', ''tree-table'', ''admin'',
        ''2026 - 02 - 07 15:39:03'', '''', NULL, ''销售看板数据菜单'');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2005, ''流量看板数据查询'', 2003, 1, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '',
        ''wecom:customerStatistics:query'', ''#'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2006, ''流量看板数据导出'', 2003, 2, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '',
        ''wecom:customerStatistics:export'', ''#'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2007, ''客户联系统计查询'', 2002, 1, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '',
        ''wecom:customerContact:query'', ''#'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2008, ''客户联系统计导出'', 2002, 2, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '',
        ''wecom:customerContact:export'', ''#'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2009, ''销售看板数据查询'', 2004, 1, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '',
        ''wecom:departmentStatistics:query'', ''#'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2010, ''销售看板数据导出'', 2004, 2, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '',
        ''wecom:departmentStatistics:export'', ''#'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2011, ''客户列表数据查询'', 2001, 1, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '',
        ''wecom:customerExport:query'', ''#'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (2012, ''客户列表数据导出'', 2001, 2, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '',
        ''wecom:customerExport:export'', ''#'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (3000, ''企业信息'', 2000, 4, ''corpInfo'', ''wecom/corpInfo/index'', NULL, '''', 1, 0, ''C'', ''0 '', ''0 '',
        ''wecom:corpInfo:list'', ''download'', ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, ''企业信息'');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (3008, ''企业信息新增'', 3000, 2, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '', ''wecom:corp:add'', ''#'',
        ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (3009, ''企业信息查看'', 3000, 2, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '', ''wecom:corp:query'', ''#'',
        ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (3010, ''企业信息编辑'', 3000, 2, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '', ''wecom:corp:edit'', ''#'',
        ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');
INSERT INTO `excel-handle`.`sys_menu` (`menu_id`, `menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`,
                                       `route_name`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`,
                                       `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`)
VALUES (3011, ''企业信息删除'', 3000, 2, ''#'', '''', NULL, '''', 1, 0, ''F'', ''0 '', ''0 '', ''wecom:corp:remove'', ''#'',
        ''admin'', ''2026 - 02 - 07 15:39:03'', '''', NULL, '''');