devbox
小小林熬夜学编程
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Java --- 云尚办公之审批流程模块_java实现审批流程

作者：小小林熬夜学编程 | 2024-05-06 17:09:12

赞

踩

java实现审批流程

目录

一、审批流程

二、审批类型代码实现 

三、审批模板实现 

一、审批流程

数据库表：

  1. CREATE TABLE `oa_process_type` (
  2.   `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  3.   `name` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '类型名称',
  4.   `description` VARCHAR(255) DEFAULT NULL COMMENT '描述',
  5.   `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  6.   `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  7.   `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）',
  8.   PRIMARY KEY (`id`)
  9. ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='审批类型';
  10.  
  11. SELECT * FROM oa_process_type;
  12.  
  13. CREATE TABLE `oa_process_template` (
  14.   `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  15.   `name` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '模板名称',
  16.   `icon_url` VARCHAR(100) DEFAULT NULL COMMENT '图标路径',
  17.   `process_type_id` VARCHAR(255) DEFAULT NULL,
  18.   `form_props` TEXT COMMENT '表单属性',
  19.   `form_options` TEXT COMMENT '表单选项',
  20.   `process_definition_key` VARCHAR(20) DEFAULT NULL COMMENT '流程定义key',
  21.   `process_definition_path` VARCHAR(255) DEFAULT NULL COMMENT '流程定义上传路径',
  22.   `process_model_id` VARCHAR(255) DEFAULT NULL COMMENT '流程定义模型id',
  23.   `description` VARCHAR(255) DEFAULT NULL COMMENT '描述',
  24.   `status` TINYINT(3) NOT NULL DEFAULT '0',
  25.   `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  26.   `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  27.   `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）',
  28.   PRIMARY KEY (`id`)
  29. ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='审批模板';
  30.  
  31. SELECT * FROM oa_process_template;
  32.  
  33. CREATE TABLE `oa_process` (
  34.   `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  35.   `process_code` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '审批code',
  36.   `user_id` BIGINT(1) NOT NULL DEFAULT '0' COMMENT '用户id',
  37.   `process_template_id` BIGINT(20) DEFAULT NULL COMMENT '审批模板id',
  38.   `process_type_id` BIGINT(20) DEFAULT NULL COMMENT '审批类型id',
  39.   `title` VARCHAR(255) DEFAULT NULL COMMENT '标题',
  40.   `description` VARCHAR(255) DEFAULT NULL COMMENT '描述',
  41.   `form_values` TEXT COMMENT '表单值',
  42.   `process_instance_id` VARCHAR(255) DEFAULT NULL COMMENT '流程实例id',
  43.   `current_auditor` VARCHAR(255) DEFAULT NULL COMMENT '当前审批人',
  44.   `status` TINYINT(3) DEFAULT NULL COMMENT '状态（0：默认 1：审批中 2：审批通过 -1：驳回）',
  45.   `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  46.   `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  47.   `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）',
  48.   PRIMARY KEY (`id`)
  49. ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='审批类型';
  50.  
  51. CREATE TABLE `oa_process_record` (
  52.   `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  53.   `process_id` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '审批流程id',
  54.   `description` VARCHAR(255) DEFAULT NULL COMMENT '审批描述',
  55.   `status` TINYINT(3) DEFAULT '0' COMMENT '状态',
  56.   `operate_user_id` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '操作用户id',
  57.   `operate_user` VARCHAR(20) DEFAULT NULL COMMENT '操作用户',
  58.   `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  59.   `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  60.   `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）',
  61.   PRIMARY KEY (`id`)
  62. ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='审批记录';

二、审批类型代码实现 

后端代码：

  1. @Api(tags = "审批类型")
  2. @RestController
  3. @RequestMapping("/admin/process/processType")
  4. public class OaProcessTypeController {
  5.        @Autowired
  6.        private OaProcessTypeService processTypeService;
  7.        @ApiOperation("分页查询")
  8.        @GetMapping("/pageProcessType/{page}/{limit}")
  9.        public Result pageProcessType(@PathVariable("page") Long page,
  10.                                      @PathVariable("limit") Long limit){
  11.            Page<ProcessType> typePage = new Page<>(page,limit);
  12.            return Result.ok(processTypeService.page(typePage));
  13.        }
  14.        @ApiOperation("根据id查询")
  15.        @GetMapping("/getById/{id}")
  16.        public Result getById(@PathVariable("id") Long id){
  17.            return Result.ok(processTypeService.getById(id));
  18.        }
  19.        @ApiOperation("添加")
  20.        @PostMapping("/add")
  21.        public Result add(@RequestBody ProcessType processType){
  22.            processTypeService.save(processType);
  23.            return Result.ok();
  24.        }
  25.        @ApiOperation("修改")
  26.        @PutMapping("/update")
  27.        public Result update(@RequestBody ProcessType processType){
  28.            processTypeService.updateById(processType);
  29.            return Result.ok();
  30.        }
  31.        @ApiOperation("删除")
  32.        @DeleteMapping("/delete/{id}")
  33.        public Result delete(@PathVariable("id") Long id){
  34.            processTypeService.removeById(id);
  35.            return Result.ok();
  36.        }
  37. }

 前端代码：

创建src/api/process/processType.js

  1. import request from '@/utils/request'
  2.  
  3. const api_name = '/admin/process/processType'
  4.  
  5. export default {
  6.  
  7.   getPageList(page, limit) {
  8.     return request({
  9.       url: `${api_name}/pageProcessType/${page}/${limit}`,
  10.       method: 'get'
  11.     })
  12.   },
  13.   getById(id) {
  14.     return request({
  15.       url: `${api_name}/getById/${id}`,
  16.       method: 'get'
  17.     })
  18.   },
  19.   save(role) {
  20.     return request({
  21.       url: `${api_name}/add`,
  22.       method: 'post',
  23.       data: role
  24.     })
  25.   },
  26.   updateById(role) {
  27.     return request({
  28.       url: `${api_name}/update`,
  29.       method: 'put',
  30.       data: role
  31.     })
  32.   },
  33.   removeById(id) {
  34.     return request({
  35.       url: `${api_name}/delete/${id}`,
  36.       method: 'delete'
  37.     })
  38.   }
  39. }

创建views/processSet/processType/list.vue

  1. <template>
  2.   <div class="app-container">
  3.     <!-- 工具条 -->
  4.     <div class="tools-div">
  5.       <el-button type="success" icon="el-icon-plus" size="mini" @click="add" :disabled="$hasBP('bnt.processType.add')  === false">添 加</el-button>
  6.     </div>
  7.     <!-- banner列表 -->
  8.     <el-table
  9.       v-loading="listLoading"
  10.       :data="list"
  11.       stripe
  12.       border
  13.       style="width: 100%;margin-top: 10px;"
  14.     >
  15.       <el-table-column
  16.         type="selection"
  17.         width="55"
  18.       />
  19.       <el-table-column
  20.         label="序号"
  21.         width="70"
  22.         align="center"
  23.       >
  24.         <template slot-scope="scope">
  25.           {{ (page - 1) * limit + scope.$index + 1 }}
  26.         </template>
  27.       </el-table-column>
  28.       <el-table-column prop="name" label="类型名称"/>
  29.       <el-table-column prop="description" label="描述"/>
  30.       <el-table-column prop="createTime" label="创建时间"/>
  31.       <el-table-column prop="updateTime" label="更新时间"/>
  32.       <el-table-column label="操作" width="200" align="center">
  33.         <template slot-scope="scope">
  34.           <el-button type="text" size="mini" @click="edit(scope.row.id)" :disabled="$hasBP('bnt.processType.update')  === false">修改</el-button>
  35.           <el-button type="text" size="mini" @click="removeDataById(scope.row.id)" :disabled="$hasBP('bnt.processType.remove')  === false">删除</el-button>
  36.         </template>
  37.       </el-table-column>
  38.     </el-table>
  39.     <!-- 分页组件 -->
  40.     <el-pagination
  41.       :current-page="page"
  42.       :total="total"
  43.       :page-size="limit"
  44.       :page-sizes="[5, 10, 20, 30, 40, 50, 100]"
  45.       style="padding: 30px 0; text-align: center;"
  46.       layout="sizes, prev, pager, next, jumper, ->, total, slot"
  47.       @current-change="fetchData"
  48.       @size-change="changeSize"
  49.     />
  50.     <el-dialog title="添加/修改" :visible.sync="dialogVisible" width="40%">
  51.       <el-form ref="flashPromotionForm" label-width="150px" size="small" style="padding-right: 40px;">
  52.         <el-form-item label="类型名称">
  53.           <el-input v-model="processType.name"/>
  54.         </el-form-item>
  55.         <el-form-item label="描述">
  56.           <el-input v-model="processType.description"/>
  57.         </el-form-item>
  58.       </el-form>
  59.       <span slot="footer" class="dialog-footer">
  60.         <el-button @click="dialogVisible = false" size="small">取 消</el-button>
  61.         <el-button type="primary" @click="saveOrUpdate()" size="small">确 定</el-button>
  62.       </span>
  63.     </el-dialog>
  64.   </div>
  65. </template>
  66. <script>
  67. import api from '@/api/process/processType'
  68.  
  69. const defaultForm = {
  70.   id: '',
  71.   name: '',
  72.   description: ''
  73. }
  74. export default {
  75.   data() {
  76.     return {
  77.       listLoading: true, // 数据是否正在加载
  78.       list: null, // banner列表
  79.       total: 0, // 数据库中的总记录数
  80.       page: 1, // 默认页码
  81.       limit: 10, // 每页记录数
  82.       searchObj: {}, // 查询表单对象
  83.       dialogVisible: false,
  84.       processType: defaultForm,
  85.       saveBtnDisabled: false
  86.     }
  87.   },
  88.   // 生命周期函数：内存准备完毕，页面尚未渲染
  89.   created() {
  90.     this.fetchData()
  91.   },
  92.   // 生命周期函数：内存准备完毕，页面渲染成功
  93.   mounted() {
  94.   },
  95.   methods: {
  96.     // 当页码发生改变的时候
  97.     changeSize(size) {
  98.       console.log(size)
  99.       this.limit = size
  100.       this.fetchData(1)
  101.     },
  102.     // 加载列表数据
  103.     fetchData(page = 1) {
  104.       this.page = page
  105.       api.getPageList(this.page, this.limit, this.searchObj).then(response => {
  106.         this.list = response.data.records
  107.         this.total = response.data.total
  108.         // 数据加载并绑定成功
  109.         this.listLoading = false
  110.       })
  111.     },
  112.     // 重置查询表单
  113.     resetData() {
  114.       console.log('重置查询表单')
  115.       this.searchObj = {}
  116.       this.fetchData()
  117.     },
  118.     // 根据id删除数据
  119.     removeDataById(id) {
  120.       this.$confirm('此操作将永久删除该记录, 是否继续?', '提示', {
  121.         confirmButtonText: '确定',
  122.         cancelButtonText: '取消',
  123.         type: 'warning'
  124.       }).then(() => { // promise
  125.         // 点击确定，远程调用ajax
  126.         return api.removeById(id)
  127.       }).then((response) => {
  128.         this.fetchData(this.page)
  129.         this.$message.success(response.message)
  130.       }).catch(() => {
  131.         this.$message.info('取消删除')
  132.       })
  133.     },
  134.     add() {
  135.       this.dialogVisible = true
  136.       this.processType = Object.assign({}, defaultForm)
  137.     },
  138.     edit(id) {
  139.       this.dialogVisible = true
  140.       this.fetchDataById(id)
  141.     },
  142.     fetchDataById(id) {
  143.       api.getById(id).then(response => {
  144.         this.processType = response.data
  145.       })
  146.     },
  147.     saveOrUpdate() {
  148.       this.saveBtnDisabled = true // 防止表单重复提交
  149.       if (!this.processType.id) {
  150.         this.saveData()
  151.       } else {
  152.         this.updateData()
  153.       }
  154.     },
  155.     // 新增
  156.     saveData() {
  157.       api.save(this.processType).then(response => {
  158.         this.$message.success(response.message || '操作成功')
  159.         this.dialogVisible = false
  160.         this.fetchData(this.page)
  161.       })
  162.     },
  163.     // 根据id更新记录
  164.     updateData() {
  165.       api.updateById(this.processType).then(response => {
  166.         this.$message.success(response.message || '操作成功')
  167.         this.dialogVisible = false
  168.         this.fetchData(this.page)
  169.       })
  170.     }
  171.   }
  172. }
  173. </script>

三、审批模板实现 

分页查询审批模板：

  1. @Autowired
  2.     private OaProcessTypeService processTypeService;
  3.     //分页查询
  4.     @Override
  5.     public IPage<ProcessTemplate> selectPageProcessTem(Page<ProcessTemplate> templatePage) {
  6.         //调用mapper方法实现分页查询
  7.         Page<ProcessTemplate> processTemplatePage = baseMapper.selectPage(templatePage, null);
  8.         //从分页数据中拿到list集合
  9.         List<ProcessTemplate> records = processTemplatePage.getRecords();
  10.         //从集合中获取审批类型id
  11.         for (ProcessTemplate processTemplate:records) {
  12.             //根据list集合id查询
  13.             LambdaQueryWrapper<ProcessType> wrapper = new LambdaQueryWrapper<>();
  14.             wrapper.eq(ProcessType::getId,processTemplate.getProcessTypeId());
  15.             ProcessType processType = processTypeService.getOne(wrapper);
  16.             if (processType == null){
  17.                 continue;
  18.             }
  19.             //封装数据
  20.             processTemplate.setProcessTypeName(processType.getName());
  21.         }
  22.         return processTemplatePage;
  23.     }
  1.  @ApiOperation("分页查询")
  2.     @GetMapping("/pageQuery/{page}/{limit}")
  3.     public Result pageQuery(@PathVariable("page") Long page,
  4.                             @PathVariable("limit") Long limit){
  5.         Page<ProcessTemplate> templatePage = new Page<>(page,limit);
  6.         return Result.ok(processTemplateService.selectPageProcessTem(templatePage));
  7.     }
  8.  @ApiOperation(value = "新增")
  9.     @PostMapping("save")
  10.     public Result save(@RequestBody ProcessTemplate processTemplate) {
  11.         processTemplateService.save(processTemplate);
  12.         return Result.ok();
  13.     }
  14.  
  15.     @ApiOperation(value = "修改")
  16.     @PutMapping("update")
  17.     public Result updateById(@RequestBody ProcessTemplate processTemplate) {
  18.         processTemplateService.updateById(processTemplate);
  19.         return Result.ok();
  20.     }
  21.  
  22.     @ApiOperation(value = "删除")
  23.     @DeleteMapping("remove/{id}")
  24.     public Result remove(@PathVariable Long id) {
  25.         processTemplateService.removeById(id);
  26.         return Result.ok();
  27.     }

添加审批模板：

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小小林熬夜学编程/article/detail/545156
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。