若依集成Flowable工作流二 (代码集成)

前言:

        代码是基于若依框架集成,直接copy前后端代码就能用,这篇文章是记录怎么移植代码

若依集成Flowable源码地址:

RuoYi-Flowable-Plus: 本项目基于 RuoYi-Vue-Plus 进行二次开发扩展Flowable工作流功能,支持在线表单设计和丰富的工作流程设计能力。如果觉得这个项目不错,麻烦点个star🌟。https://gitee.com/shitefei/ruoyi-flowable-plus

一、后端代码移植

1.1 ruoyi-flowable模块移植

  1. 将整个项目ruoyi-flowable复制到项目中
  2. 右击ruoyi-flowable里面的pom.xml ,选择add as maven project 添加为maven项目

配置yml

1.2 拷贝controller以及service和

--- # Flowable 配置
flowable:
  # 关闭定时任务 job
  async-executor-activate: false
  # 库与数据库表结构不一致时,会自动将数据库表结构升级至新版本。
  database-schema-update: true
  idm:
    # 关闭idm引擎 数据库不会创建act_id_*表,流程流转不会使用act_id_*相关的表
    enabled: false
  # 关闭流程定义文件自动检查
  check-process-definitions: false
  # 关闭历史任务定时任务job
  async-history-executor-activate: false

mapper文件

拷贝admin和system下面的workflow文件夹,到ruoyi-admin和ruoyi-system文件夹下面

拷贝后的文件

 pom文件修改

1-ruoyi-system pom.xml 增加工作依赖
    <!-- Flowable功能模块 -->
        <dependency>
            <groupId>com.ruoyi</groupId>
            <artifactId>ruoyi-flowable</artifactId>
        </dependency>

2- 最外层pom

      
  <flowable.version>6.8.0</flowable.version>




            <!-- flowable -->
            <dependency>
                <groupId>org.flowable</groupId>
                <artifactId>flowable-spring-boot-starter-process</artifactId>
                <version>${flowable.version}</version>
            </dependency>

            <!-- 工作流模块 -->
            <dependency>
                <groupId>com.ruoyi</groupId>
                <artifactId>ruoyi-flowable</artifactId>
                <version>${ruoyi-vue-plus.version}</version>
            </dependency>

1.3 回台其他几个修改

除了上面直接copy的flowable的文件夹还有几个微小的细节修改

  1.3.1 SysUserController 

增加一个根据用户id 查询昵称方法

 controller

/**
     * 查询用户列表,用于用户选择场景
     */
    @SaCheckLogin
    @GetMapping("/selectUser")
    public TableDataInfo<SysUser> selectUser(SysUser user, PageQuery pageQuery) {
        return userService.selectPageUserList(user, pageQuery);
    }

 UserService 接口

 /**
     * 通过用户ID查询用户昵称
     *
     * @param userId 用户ID
     * @return 用户昵称
     */
    String selectNickNameById(Long userId);

 SysUserServiceImpl 实现类方法

 @Cacheable(cacheNames = CacheNames.SYS_NICK_NAME, key = "#userId")
    @Override
    public String selectNickNameById(Long userId) {
        SysUser sysUser = baseMapper.selectOne(new LambdaQueryWrapper<SysUser>()
            .select(SysUser::getNickName).eq(SysUser::getUserId, userId));
        return ObjectUtil.isNull(sysUser) ? null : sysUser.getNickName();
    }

 1.3.2 CacheNames

增加一个变量

/**
     * 用户昵称
     */
    String SYS_NICK_NAME = "sys_nick_name#30d";

1.3.3 LoginHelper

增加一个获取用户昵称方法

    /**
     * 获取用户账户
     */
    public static String getNickName() {
        return getLoginUser().getNickName();
    }

 二、前端页面的移植

如图下面都是移植的代码,红色是要主要地方:

  1. 对照复制 public 、api\workflow接口、mixin 样式、components组件、plugins 插件、utils工具包、views 页面文件
  2. minxin和utils包复制过来改名字(对应要改的引用我放在下面)

  这是js文件:

 流程图文件

依赖文件:


 2.1以下是详细要注意的3个地方,跑不起来来排查这些地方

 2.1.1 utils复制改为utilsFlow

对应的这些文件也要改impor。具体在下面那张图上面

t

 2.1.2 mixinFlow.scss

对应要改的import地方,3处:

2.1.3  表单设置buildFlow

 buildFlow 是表单设计,不要和以前表单共用(就是拖拽的那个页面)

 2.1.4 路由添加

路由也要加上对应数据

  /*workflow 表单设计*/
  {
    path: '/tool',
    component: Layout,
    hidden: true,
    children: [
      {
        path: 'buildFlow/index',
        component: () => import('@/views/tool/buildFlow/index'),
        name: 'FormBuild',
        meta: { title: '表单设计', icon: '' }
      }
    ]
  },




  /*workflow*/
  {
    path: '/workflow/process',
    component: Layout,
    hidden: true,
    permissions: ['workflow:process:query'],
    children: [
      {
        path: 'start/:deployId([\\w|\\-]+)',
        component: () => import('@/views/workflow/work/start'),
        name: 'WorkStart',
        meta: { title: '发起流程', icon: '' }
      },
      {
        path: 'detail/:procInsId([\\w|\\-]+)',
        component: () => import('@/views/workflow/work/detail'),
        name: 'WorkDetail',
        meta: { title: '流程详情', activeMenu: '/work/own' }
      }
    ]
  },

 三、数据库导入

工作流的表启动后台会自己生成,无需插入

权限插入

insert into sys_role_menu values ('2', '1');
insert into sys_role_menu values ('2', '2');
insert into sys_role_menu values ('2', '3');
insert into sys_role_menu values ('2', '4');
insert into sys_role_menu values ('2', '5');
insert into sys_role_menu values ('2', '100');
insert into sys_role_menu values ('2', '101');
insert into sys_role_menu values ('2', '102');
insert into sys_role_menu values ('2', '103');
insert into sys_role_menu values ('2', '104');
insert into sys_role_menu values ('2', '105');
insert into sys_role_menu values ('2', '106');
insert into sys_role_menu values ('2', '107');
insert into sys_role_menu values ('2', '108');
insert into sys_role_menu values ('2', '109');
insert into sys_role_menu values ('2', '111');
insert into sys_role_menu values ('2', '112');
insert into sys_role_menu values ('2', '113');
insert into sys_role_menu values ('2', '114');
insert into sys_role_menu values ('2', '115');
insert into sys_role_menu values ('2', '117');
insert into sys_role_menu values ('2', '118');
insert into sys_role_menu values ('2', '120');
insert into sys_role_menu values ('2', '121');
insert into sys_role_menu values ('2', '122');
insert into sys_role_menu values ('2', '123');
insert into sys_role_menu values ('2', '124');
insert into sys_role_menu values ('2', '125');
insert into sys_role_menu values ('2', '126');
insert into sys_role_menu values ('2', '127');
insert into sys_role_menu values ('2', '128');
insert into sys_role_menu values ('2', '129');
insert into sys_role_menu values ('2', '130');
insert into sys_role_menu values ('2', '500');
insert into sys_role_menu values ('2', '501');
insert into sys_role_menu values ('2', '1001');
insert into sys_role_menu values ('2', '1002');
insert into sys_role_menu values ('2', '1003');
insert into sys_role_menu values ('2', '1004');
insert into sys_role_menu values ('2', '1005');
insert into sys_role_menu values ('2', '1006');
insert into sys_role_menu values ('2', '1007');
insert into sys_role_menu values ('2', '1010');
insert into sys_role_menu values ('2', '1011');
insert into sys_role_menu values ('2', '1012');
insert into sys_role_menu values ('2', '1013');
insert into sys_role_menu values ('2', '1014');
insert into sys_role_menu values ('2', '1020');
insert into sys_role_menu values ('2', '1021');
insert into sys_role_menu values ('2', '1022');
insert into sys_role_menu values ('2', '1023');
insert into sys_role_menu values ('2', '1030');
insert into sys_role_menu values ('2', '1031');
insert into sys_role_menu values ('2', '1032');
insert into sys_role_menu values ('2', '1033');
insert into sys_role_menu values ('2', '1040');
insert into sys_role_menu values ('2', '1041');
insert into sys_role_menu values ('2', '1042');
insert into sys_role_menu values ('2', '1043');
insert into sys_role_menu values ('2', '1044');
insert into sys_role_menu values ('2', '1050');
insert into sys_role_menu values ('2', '1051');
insert into sys_role_menu values ('2', '1052');
insert into sys_role_menu values ('2', '1053');
insert into sys_role_menu values ('2', '1054');
insert into sys_role_menu values ('2', '1060');
insert into sys_role_menu values ('2', '1061');
insert into sys_role_menu values ('2', '1062');
insert into sys_role_menu values ('2', '1063');
insert into sys_role_menu values ('2', '1064');
insert into sys_role_menu values ('2', '1070');
insert into sys_role_menu values ('2', '1071');
insert into sys_role_menu values ('2', '1072');
insert into sys_role_menu values ('2', '1073');
insert into sys_role_menu values ('2', '1080');
insert into sys_role_menu values ('2', '1081');
insert into sys_role_menu values ('2', '1082');
insert into sys_role_menu values ('2', '1090');
insert into sys_role_menu values ('2', '1091');
insert into sys_role_menu values ('2', '1092');
insert into sys_role_menu values ('2', '1093');
insert into sys_role_menu values ('2', '1100');
insert into sys_role_menu values ('2', '1101');
insert into sys_role_menu values ('2', '1102');
insert into sys_role_menu values ('2', '1120');
insert into sys_role_menu values ('2', '1121');
insert into sys_role_menu values ('2', '1122');
insert into sys_role_menu values ('2', '1123');
insert into sys_role_menu values ('2', '1124');
insert into sys_role_menu values ('2', '1125');
insert into sys_role_menu values ('2', '1130');
insert into sys_role_menu values ('2', '1131');
insert into sys_role_menu values ('2', '1132');
insert into sys_role_menu values ('2', '1133');
insert into sys_role_menu values ('2', '1134');
insert into sys_role_menu values ('2', '1135');
insert into sys_role_menu values ('2', '1140');
insert into sys_role_menu values ('2', '1141');
insert into sys_role_menu values ('2', '1142');
insert into sys_role_menu values ('2', '1143');
insert into sys_role_menu values ('2', '1150');
insert into sys_role_menu values ('2', '1151');
insert into sys_role_menu values ('2', '1152');
insert into sys_role_menu values ('2', '1153');
insert into sys_role_menu values ('2', '1154');
insert into sys_role_menu values ('2', '1160');
insert into sys_role_menu values ('2', '1161');
insert into sys_role_menu values ('2', '1162');
insert into sys_role_menu values ('2', '1163');
insert into sys_role_menu values ('2', '1164');
insert into sys_role_menu values ('2', '1165');
insert into sys_role_menu values ('2', '1166');
insert into sys_role_menu values ('2', '1167');
insert into sys_role_menu values ('2', '1168');
insert into sys_role_menu values ('2', '1170');
insert into sys_role_menu values ('2', '1171');
insert into sys_role_menu values ('2', '1172');
insert into sys_role_menu values ('2', '1180');
insert into sys_role_menu values ('2', '1181');
insert into sys_role_menu values ('2', '1190');
insert into sys_role_menu values ('2', '1191');
insert into sys_role_menu values ('2', '1192');
insert into sys_role_menu values ('2', '1193');
insert into sys_role_menu values ('2', '1200');
insert into sys_role_menu values ('2', '1201');
insert into sys_role_menu values ('2', '1210');
insert into sys_role_menu values ('2', '1211');
insert into sys_role_menu values ('2', '1220');
insert into sys_role_menu values ('2', '1221');
insert into sys_role_menu values ('2', '1230');

一级菜单

insert into sys_menu values('4', '流程管理', '0', '4', 'process',  null, '', 1, 0, 'M', '0', '0', '', 'skill',    'admin', sysdate(), '', null, '流程管理目录');
insert into sys_menu values('5', '办公管理', '0', '5', 'work',     null, '', 1, 0, 'M', '0', '0', '', 'job',      'admin', sysdate(), '', null, '办公管理目录');

子菜单

-- 流程管理
insert into sys_menu values('121',  '流程分类', '4',   '1', 'category',   'workflow/category/index',      '', 1, 0, 'C', '0', '0', 'workflow:category:list',   'nested',    'admin', sysdate(), '', null, '流程分类菜单');
insert into sys_menu values('122',  '表单配置', '4',   '2', 'form',       'workflow/form/index',          '', 1, 0, 'C', '0', '0', 'workflow:form:list',       'form',      'admin', sysdate(), '', null, '表单配置菜单');
insert into sys_menu values('123',  '流程模型', '4',   '3', 'model',      'workflow/model/index',         '', 1, 0, 'C', '0', '0', 'workflow:model:list',      'component', 'admin', sysdate(), '', null, '流程模型菜单');
insert into sys_menu values('124',  '部署管理', '4',   '4', 'deploy',     'workflow/deploy/index',        '', 1, 0, 'C', '0', '0', 'workflow:deploy:list',     'example',   'admin', sysdate(), '', null, '部署管理菜单');
-- 办公管理
insert into sys_menu values('125',  '新建流程', '5',   '1', 'create',     'workflow/work/index',       '', 1, 0, 'C', '0', '0', 'workflow:process:startList',    'guide',      'admin', sysdate(), '', null, '新建流程菜单');
insert into sys_menu values('126',  '我的流程', '5',   '2', 'own',        'workflow/work/own',         '', 1, 0, 'C', '0', '0', 'workflow:process:ownList',      'cascader',   'admin', sysdate(), '', null, '我的流程菜单');
insert into sys_menu values('127',  '待办任务', '5',   '3', 'todo',       'workflow/work/todo',        '', 1, 0, 'C', '0', '0', 'workflow:process:todoList',     'time-range', 'admin', sysdate(), '', null, '待办任务菜单');
insert into sys_menu values('128',  '待签任务', '5',   '4', 'claim',      'workflow/work/claim',       '', 1, 0, 'C', '0', '0', 'workflow:process:claimList',    'checkbox',   'admin', sysdate(), '', null, '待签任务菜单');
insert into sys_menu values('129',  '已办任务', '5',   '5', 'finished',   'workflow/work/finished',    '', 1, 0, 'C', '0', '0', 'workflow:process:finishedList', 'checkbox',   'admin', sysdate(), '', null, '已办任务菜单');
insert into sys_menu values('130',  '抄送我的', '5',   '6', 'copy',       'workflow/work/copy',        '', 1, 0, 'C', '0', '0', 'workflow:process:copyList',     'checkbox',   'admin', sysdate(), '', null, '抄送我的菜单');

-- 三级菜单
insert into sys_menu values('500',  '操作日志', '108', '1', 'operlog',    'monitor/operlog/index',    '', 1, 0, 'C', '0', '0', 'monitor:operlog:list',    'form',          'admin', sysdate(), '', null, '操作日志菜单');
insert into sys_menu values('501',  '登录日志', '108', '2', 'logininfor', 'monitor/logininfor/index', '', 1, 0, 'C', '0', '0', 'monitor:logininfor:list', 'logininfor',    'admin', sysdate(), '', null, '登录日志菜单');
-- 用户管理按钮
insert into sys_menu values('1001', '用户查询', '100', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:query',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1002', '用户新增', '100', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:add',            '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1003', '用户修改', '100', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:edit',           '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1004', '用户删除', '100', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:remove',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1005', '用户导出', '100', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:export',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1006', '用户导入', '100', '6',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:import',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1007', '重置密码', '100', '7',  '', '', '', 1, 0, 'F', '0', '0', 'system:user:resetPwd',       '#', 'admin', sysdate(), '', null, '');
-- 角色管理按钮
insert into sys_menu values('1010', '角色查询', '101', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:query',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1011', '角色新增', '101', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:add',            '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1012', '角色修改', '101', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:edit',           '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1013', '角色删除', '101', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:remove',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1014', '角色导出', '101', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:role:export',         '#', 'admin', sysdate(), '', null, '');
-- 菜单管理按钮
insert into sys_menu values('1020', '菜单查询', '102', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:query',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1021', '菜单新增', '102', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:add',            '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1022', '菜单修改', '102', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:edit',           '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1023', '菜单删除', '102', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:menu:remove',         '#', 'admin', sysdate(), '', null, '');
-- 部门管理按钮
insert into sys_menu values('1030', '部门查询', '103', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:query',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1031', '部门新增', '103', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:add',            '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1032', '部门修改', '103', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:edit',           '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1033', '部门删除', '103', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:dept:remove',         '#', 'admin', sysdate(), '', null, '');
-- 岗位管理按钮
insert into sys_menu values('1040', '岗位查询', '104', '1',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:query',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1041', '岗位新增', '104', '2',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:add',            '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1042', '岗位修改', '104', '3',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:edit',           '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1043', '岗位删除', '104', '4',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:remove',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1044', '岗位导出', '104', '5',  '', '', '', 1, 0, 'F', '0', '0', 'system:post:export',         '#', 'admin', sysdate(), '', null, '');
-- 字典管理按钮
insert into sys_menu values('1050', '字典查询', '105', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:query',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1051', '字典新增', '105', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:add',            '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1052', '字典修改', '105', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:edit',           '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1053', '字典删除', '105', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:remove',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1054', '字典导出', '105', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:dict:export',         '#', 'admin', sysdate(), '', null, '');
-- 参数设置按钮
insert into sys_menu values('1060', '参数查询', '106', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:query',        '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1061', '参数新增', '106', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:add',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1062', '参数修改', '106', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:edit',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1063', '参数删除', '106', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:remove',       '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1064', '参数导出', '106', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:config:export',       '#', 'admin', sysdate(), '', null, '');
-- 通知公告按钮
insert into sys_menu values('1070', '公告查询', '107', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:query',        '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1071', '公告新增', '107', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:add',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1072', '公告修改', '107', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:edit',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1073', '公告删除', '107', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:notice:remove',       '#', 'admin', sysdate(), '', null, '');
-- 操作日志按钮
insert into sys_menu values('1080', '操作查询', '500', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:query',      '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1081', '操作删除', '500', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:remove',     '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1082', '日志导出', '500', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:operlog:export',     '#', 'admin', sysdate(), '', null, '');
-- 登录日志按钮
insert into sys_menu values('1090', '登录查询', '501', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:query',   '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1091', '登录删除', '501', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:remove',  '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1092', '日志导出', '501', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:export',  '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1093', '账户解锁', '501', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock',  '#', 'admin', sysdate(), '', null, '');
-- 在线用户按钮
insert into sys_menu values('1100', '在线查询', '109', '1', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:query',       '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1101', '批量强退', '109', '2', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1102', '单条强退', '109', '3', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'admin', sysdate(), '', null, '');
-- 代码生成按钮
insert into sys_menu values('1120', '生成查询', '115', '1', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:query',             '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1121', '生成修改', '115', '2', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:edit',              '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1122', '生成删除', '115', '3', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:remove',            '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1123', '导入代码', '115', '4', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:import',            '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1124', '预览代码', '115', '5', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:preview',           '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1125', '生成代码', '115', '6', '#', '', '', 1, 0, 'F', '0', '0', 'tool:gen:code',              '#', 'admin', sysdate(), '', null, '');
-- oss相关按钮
insert into sys_menu values('1130', '文件查询', '118', '1', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:query',        '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1131', '文件上传', '118', '2', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:upload',       '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1132', '文件下载', '118', '3', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:download',     '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1133', '文件删除', '118', '4', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:remove',       '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1134', '配置添加', '118', '5', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:add',          '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1135', '配置编辑', '118', '6', '#', '', '', 1, 0, 'F', '0', '0', 'system:oss:edit',         '#', 'admin', sysdate(), '', null, '');
-- 流程分类管理
insert into sys_menu values('1140', '分类查询', '121', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:query',  '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1141', '分类新增', '121', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:add',    '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1142', '分类编辑', '121', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:edit',   '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1143', '分类删除', '121', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:category:remove', '#', 'admin', sysdate(), '', null, '');
-- 表单配置
insert into sys_menu values('1150', '表单查询', '122', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:form:query',   '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1151', '表单新增', '122', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:form:add',     '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1152', '表单修改', '122', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:form:edit',    '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1153', '表单删除', '122', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:form:remove',  '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1154', '表单导出', '122', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:form:export',  '#', 'admin', sysdate(), '', null, '');
-- 流程模型
insert into sys_menu values('1160', '模型查询', '123', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:query',    '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1161', '模型新增', '123', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:add',      '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1162', '模型修改', '123', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:edit',     '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1163', '模型删除', '123', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:remove',   '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1164', '模型导出', '123', '5', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:export',   '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1165', '模型导入', '123', '6', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:import',   '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1166', '模型设计', '123', '7', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:designer', '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1167', '模型保存', '123', '8', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:save',     '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1168', '流程部署', '123', '9', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:model:deploy',   '#', 'admin', sysdate(), '', null, '');
-- 部署管理
insert into sys_menu values('1170', '部署查询', '124', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:deploy:query',   '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1171', '部署删除', '124', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:deploy:remove',  '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1172', '更新状态', '124', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:deploy:status',  '#', 'admin', sysdate(), '', null, '');
-- 新建流程
insert into sys_menu values('1180', '发起流程',    '125', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:start',       '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1181', '新建流程导出', '125', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:startExport', '#', 'admin', sysdate(), '', null, '');
-- 我的流程
insert into sys_menu values('1190', '流程详情',    '126', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:query',     '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1191', '流程删除',    '126', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:remove',    '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1192', '流程取消',    '126', '3', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:cancel',    '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1193', '我的流程导出', '126', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:ownExport', '#', 'admin', sysdate(), '', null, '');
-- 待办任务
insert into sys_menu values('1200', '流程办理',    '127', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:approval',   '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1201', '待办流程导出', '127', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:todoExport', '#', 'admin', sysdate(), '', null, '');
-- 待签任务
insert into sys_menu values('1210', '流程签收',    '128', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:claim',        '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1211', '待签流程导出', '128', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:claimExport',  '#', 'admin', sysdate(), '', null, '');
-- 已办任务
insert into sys_menu values('1220', '流程撤回',    '129', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:revoke',         '#', 'admin', sysdate(), '', null, '');
insert into sys_menu values('1221', '已办流程导出', '129', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:finishedExport', '#', 'admin', sysdate(), '', null, '');
-- 抄送我的
insert into sys_menu values('1230', '抄送流程导出', '130', '1', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:copyExport', '#', 'admin', sysdate(), '', null, '');

其他字典等数据

insert into sys_menu values('112',  '缓存列表', '2',   '6', 'cacheList',  'monitor/cache/list',       '', 1, 0, 'C', '0', '0', 'monitor:cache:list',      'redis-list',    'admin', sysdate(), '', null, '缓存列表菜单');

delete from sys_menu WHERE menu_id = 116;

update sys_config set config_key = 'sys.account.captchaEnabled' where config_id = 4;

insert into sys_menu values('1093', '账户解锁', '501', '4', '#', '', '', 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock',  '#', 'admin', sysdate(), '', null, '');

insert into sys_role_menu values ('2', '1093');

insert into sys_dict_data values(29, 99, '其他',     '0',       'sys_oper_type',       '',   'info',    'N', '0', 'admin', sysdate(), '', null, '其他操作');




insert into sys_menu values('1181', '新建流程导出', '125', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:startExport', '#', 'admin', sysdate(), '', null, '');

insert into sys_menu values('1193', '我的流程导出', '126', '4', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:ownExport', '#', 'admin', sysdate(), '', null, '');

insert into sys_menu values('1201', '待办流程导出', '127', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:todoExport', '#', 'admin', sysdate(), '', null, '');

insert into sys_menu values('1211', '待签流程导出', '128', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:claimExport',  '#', 'admin', sysdate(), '', null, '');

insert into sys_menu values('1221', '已办流程导出', '129', '2', '#', '', '', 1, 0, 'F', '0', '0', 'workflow:process:finishedExport', '#', 'admin', sysdate(), '', null, '');

update sys_menu set menu_name = '抄送流程导出', perms = 'workflow:process:copyExport' where menu_id = 1230;

insert into sys_role_menu values ('2', '1181');

insert into sys_role_menu values ('2', '1193');

insert into sys_role_menu values ('2', '1201');

insert into sys_role_menu values ('2', '1211');

insert into sys_role_menu values ('2', '1221');






ALTER TABLE sys_oss_config ADD COLUMN access_policy char(1) NOT NULL DEFAULT 1 COMMENT '桶权限类型(0=private 1=public 2=custom)' AFTER region;

ALTER TABLE wf_deploy_form ADD COLUMN form_name varchar(64) NULL COMMENT '表单名称' AFTER node_key;


insert into sys_dict_type values(11, '流程状态', 'wf_process_status',   '0', 'admin', sysdate(), '', null, '工作流程状态');

insert into sys_dict_data values(30, 1,  '进行中',   'running',    'wf_process_status',   '',   'primary',  'N', '0', 'admin', sysdate(), '', null, '进行中状态');
insert into sys_dict_data values(31, 2,  '已终止',   'terminated', 'wf_process_status',   '',   'danger',   'N', '0', 'admin', sysdate(), '', null, '已终止状态');
insert into sys_dict_data values(32, 3,  '已完成',   'completed',  'wf_process_status',   '',   'success',  'N', '0', 'admin', sysdate(), '', null, '已完成状态');
insert into sys_dict_data values(33, 4,  '已取消',   'canceled',   'wf_process_status',   '',   'warning',  'N', '0', 'admin', sysdate(), '', null, '已取消状态');

wf相关表

-- ----------------------------
-- wf_form流程表单信息表
-- ----------------------------
drop table if exists `wf_form`;
create table `wf_form` (
   form_id      bigint(20)   not null auto_increment comment '表单主键',
   form_name    varchar(64)           default ''     comment '表单名称',
   content      longtext              default null   comment '表单内容',
   create_by    varchar(64)           default ''     comment '创建者',
   create_time  datetime              default null   comment '创建时间',
   update_by    varchar(64)           default ''     comment '更新者',
   update_time  datetime              default null   comment '更新时间',
   remark       varchar(255)          default null   comment '备注',
   del_flag     char(1)               default '0'    comment '删除标志(0代表存在 2代表删除)',
   primary key (form_id)
) engine = innodb comment = '流程表单信息表';


-- ----------------------------
-- wf_deploy_form流程实例关联表
-- ----------------------------
drop table if exists `wf_deploy_form`;
create table `wf_deploy_form` (
    deploy_id  varchar(64)     not null     comment '流程实例主键',
    form_key   varchar(64)     not null     comment '表单Key',
    node_key   varchar(64)     not null     comment '节点Key',
    form_name  varchar(64)     default ''   comment '表单名称',
    node_name  varchar(255)    default ''   comment '节点名称',
    content    longtext        default null comment '表单内容',
    primary key (deploy_id, form_key, node_key)
) engine = innodb comment = '流程实例关联表单';

-- ----------------------------
-- wf_category流程分类表
-- ----------------------------
drop table if exists `wf_category`;
create table `wf_category` (
    category_id   bigint       not null  auto_increment comment '流程分类id',
    category_name varchar(64)            default ''     comment '流程分类名称',
    code          varchar(64)            default ''     comment '分类编码',
    remark        varchar(500)           default ''     comment '备注',
    create_by     varchar(64)            default ''     comment '创建者',
    create_time   datetime               default null   comment '创建时间',
    update_by     varchar(64)            default ''     comment '更新者',
    update_time   datetime               default null   comment '更新时间',
    del_flag      char(1)                default '0'    comment '删除标志(0代表存在 2代表删除)',
    primary key (category_id)
) engine=innodb comment = '流程分类表';

-- ----------------------------
-- wf_copy流程抄送表
-- ----------------------------
drop table if exists `wf_copy`;
create table `wf_copy` (
   copy_id         bigint        not null  auto_increment   comment '抄送主键',
   title           varchar(255)            default ''       comment '抄送标题',
   process_id      varchar(64)             default ''       comment '流程主键',
   process_name    varchar(255)            default ''       comment '流程名称',
   category_id     varchar(255)            default ''       comment '流程分类主键',
   deployment_id   varchar(64)             default ''       comment '部署主键',
   instance_id     varchar(64)             default ''       comment '流程实例主键',
   task_id         varchar(64)             default ''       comment '任务主键',
   user_id         bigint                  default null     comment '用户主键',
   originator_id   bigint                  default null     comment '发起人主键',
   originator_name varchar(64)             default ''       comment '发起人名称',
   create_by       varchar(64)             default ''       comment '创建者',
   create_time     datetime                default null     comment '创建时间',
   update_by       varchar(64)             default ''       comment '更新者',
   update_time     datetime                default null     comment '更新时间',
   del_flag        char(1)                 default '0'      comment '删除标志(0代表存在 2代表删除)',
   primary key (`copy_id`)
) engine=innodb comment='流程抄送表';

最后运行系统试试,不行找我来帮你解决。

 博主精心整理专栏,CV大法即可用,感谢您小手点一点 手动跪拜:  

1- SpringBoot框架常用配置(基于若依),代码解读:

https://blog.youkuaiyun.com/javaxueba/category_12611571.html?fromshare=blogcolumn&sharetype=blogcolumn&sharerId=12611571&sharerefer=PC&sharesource=javaxueba&sharefrom=from_linkhttps://blog.youkuaiyun.com/javaxueba/category_12611571.html?fromshare=blogcolumn&sharetype=blogcolumn&sharerId=12611571&sharerefer=PC&sharesource=javaxueba&sharefrom=from_link

2- java常用工具类整理,示例演示:

https://blog.youkuaiyun.com/javaxueba/category_12752969.html?fromshare=blogcolumn&sharetype=blogcolumn&sharerId=12752969&sharerefer=PC&sharesource=javaxueba&sharefrom=from_linkhttps://blog.youkuaiyun.com/javaxueba/category_12752969.html?fromshare=blogcolumn&sharetype=blogcolumn&sharerId=12752969&sharerefer=PC&sharesource=javaxueba&sharefrom=from_link

3- CompletableFuture 异步编排与实际代码展示

https://blog.youkuaiyun.com/javaxueba/category_12711097.html?fromshare=blogcolumn&sharetype=blogcolumn&sharerId=12711097&sharerefer=PC&sharesource=javaxueba&sharefrom=from_linkhttps://blog.youkuaiyun.com/javaxueba/category_12711097.html?fromshare=blogcolumn&sharetype=blogcolumn&sharerId=12711097&sharerefer=PC&sharesource=javaxueba&sharefrom=from_link

4- XXL-JOB 详细学习,手把手带入门

https://blog.youkuaiyun.com/javaxueba/category_12750420.html?fromshare=blogcolumn&sharetype=blogcolumn&sharerId=12750420&sharerefer=PC&sharesource=javaxueba&sharefrom=from_linkhttps://blog.youkuaiyun.com/javaxueba/category_12750420.html?fromshare=blogcolumn&sharetype=blogcolumn&sharerId=12750420&sharerefer=PC&sharesource=javaxueba&sharefrom=from_link

评论 6
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

syfjava

请博主喝杯蜜雪冰城

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值