wuguolin
/
smartbi2
1
0
Fork 1
Code Issues Pull Requests Releases Wiki Activity
You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
master
dev
package
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'dev'
${ noResults }
smartbi2/README.md

4.4 KiB
Raw Permalink Blame History

准备

  • 创建数据库
create database smartbi
  • 修改配置文件
1.在/opt下创建smartbi文件夹
2.将conf文件复制到/opt/smartbi下
3.修改/opt/smartbi/conf/smartbi.properties文件
  • 运行起来后，到数据源页面修改默认数据源信息

20211112 变更

//变更系统管理菜单显示权限
update  sys_menu set hidden=1  where menu_id=40;
update  sys_menu set hidden=1  where menu_id=58;
update  sys_menu set title='数据源'  where menu_id=34;
update  sys_menu set title='Dashboard'  where menu_id=30;

INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (41, 1, 0, 1, '权限管理', 'system-auth', 'system/authority/index', 4, 'password', 'system-auth', b'0', b'0', b'0', 'auth:read', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (4, 1, 3, 1, '组织管理', 'system-dept', 'system/dept/index', 3, 'dept', 'dept', b'0', b'0', b'0', 'dept:read', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (18, 4, 0, 2, '创建组织', NULL, NULL, 999, NULL, NULL, NULL, b'0', b'0', 'dept:add', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (19, 4, 0, 2, '删除组织', NULL, NULL, 999, NULL, NULL, NULL, b'0', b'0', 'dept:del', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (20, 4, 0, 2, '编辑组织', NULL, NULL, 999, NULL, NULL, NULL, b'0', b'0', 'dept:edit', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (37, 1, 0, 1, '组织表单', 'system-dept-form', 'system/dept/form', 999, NULL, 'dept-form', NULL, b'0', b'1', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (5, 1, 3, 1, '角色管理', 'system-role', 'system/role/index', 2, 'role', 'role', b'0', b'0', b'0', 'role:read', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (23, 5, 0, 2, '编辑角色', NULL, NULL, 999, NULL, NULL, NULL, b'0', b'0', 'role:edit', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (22, 5, 0, 2, '删除角色', NULL, NULL, 999, NULL, NULL, NULL, b'0', b'0', 'role:del', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (21, 5, 0, 2, '创建角色', NULL, NULL, 999, NULL, NULL, NULL, b'0', b'0', 'role:add', NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`menu_id`, `pid`, `sub_count`, `type`, `title`, `name`, `component`, `menu_sort`, `icon`, `path`, `i_frame`, `cache`, `hidden`, `permission`, `create_by`, `update_by`, `create_time`, `update_time`) VALUES (38, 1, 0, 1, '角色表单', 'system-role-form', 'system/role/form', 999, NULL, 'role-form', NULL, b'0', b'1', NULL, NULL, NULL, NULL, NULL);