目录
一、审批流程
数据库表：
CREATE TABLE `oa_process_type` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `name` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '类型名称', `description` VARCHAR(255) DEFAULT NULL COMMENT '描述', `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）', PRIMARY KEY (`id`) ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='审批类型'; SELECT * FROM oa_process_type; CREATE TABLE `oa_process_template` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '角色id', `name` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '模板名称', `icon_url` VARCHAR(100) DEFAULT NULL COMMENT '图标路径', `process_type_id` VARCHAR(255) DEFAULT NULL, `form_props` TEXT COMMENT '表单属性', `form_options` TEXT COMMENT '表单选项', `process_definition_key` VARCHAR(20) DEFAULT NULL COMMENT '流程定义key', `process_definition_path` VARCHAR(255) DEFAULT NULL COMMENT '流程定义上传路径', `process_model_id` VARCHAR(255) DEFAULT NULL COMMENT '流程定义模型id', `description` VARCHAR(255) DEFAULT NULL COMMENT '描述', `status` TINYINT(3) NOT NULL DEFAULT '0', `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）', PRIMARY KEY (`id`) ) ENGINE=INNODB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='审批模板'; SELECT * FROM oa_process_template; CREATE TABLE `oa_process` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `process_code` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '审批code', `user_id` BIGINT(1) NOT NULL DEFAULT '0' COMMENT '用户id', `process_template_id` BIGINT(20) DEFAULT NULL COMMENT '审批模板id', `process_type_id` BIGINT(20) DEFAULT NULL COMMENT '审批类型id', `title` VARCHAR(255) DEFAULT NULL COMMENT '标题', `description` VARCHAR(255) DEFAULT NULL COMMENT '描述', `form_values` TEXT COMMENT '表单值', `process_instance_id` VARCHAR(255) DEFAULT NULL COMMENT '流程实例id', `current_auditor` VARCHAR(255) DEFAULT NULL COMMENT '当前审批人', `status` TINYINT(3) DEFAULT NULL COMMENT '状态（0：默认 1：审批中 2：审批通过 -1：驳回）', `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）', PRIMARY KEY (`id`) ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='审批类型'; CREATE TABLE `oa_process_record` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `process_id` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '审批流程id', `description` VARCHAR(255) DEFAULT NULL COMMENT '审批描述', `status` TINYINT(3) DEFAULT '0' COMMENT '状态', `operate_user_id` BIGINT(20) NOT NULL DEFAULT '0' COMMENT '操作用户id', `operate_user` VARCHAR(20) DEFAULT NULL COMMENT '操作用户', `create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `is_deleted` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:不可用 1:可用）', PRIMARY KEY (`id`) ) ENGINE=INNODB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='审批记录';
二、审批类型代码实现
后端代码：
@Api(tags = "审批类型") @RestController @RequestMapping("/admin/process/processType") public class OaProcessTypeController { @Autowired private OaProcessTypeService processTypeService; @ApiOperation("分页查询") @GetMapping("/pageProcessType/{page}/{limit}") public Result pageProcessType(@PathVariable("page") Long page, @PathVariable("limit") Long limit){ Page<ProcessType> typePage = new Page<>(page,limit); return Result.ok(processTypeService.page(typePage)); } @ApiOperation("根据id查询") @GetMapping("/getById/{id}") public Result getById(@PathVariable("id") Long id){ return Result.ok(processTypeService.getById(id)); } @ApiOperation("添加") @PostMapping("/add") public Result add(@RequestBody ProcessType processType){ processTypeService.save(processType); return Result.ok(); } @ApiOperation("修改") @PutMapping("/update") public Result update(@RequestBody ProcessType processType){ processTypeService.updateById(processType); return Result.ok(); } @ApiOperation("删除") @DeleteMapping("/delete/{id}") public Result delete(@PathVariable("id") Long id){ processTypeService.removeById(id); return Result.ok(); } }前端代码：
创建src/api/process/processType.js
import request from '@/utils/request' const api_name = '/admin/process/processType' export default { getPageList(page, limit) { return request({ url: `${api_name}/pageProcessType/${page}/${limit}`, method: 'get' }) }, getById(id) { return request({ url: `${api_name}/getById/${id}`, method: 'get' }) }, save(role) { return request({ url: `${api_name}/add`, method: 'post', data: role }) }, updateById(role) { return request({ url: `${api_name}/update`, method: 'put', data: role }) }, removeById(id) { return request({ url: `${api_name}/delete/${id}`, method: 'delete' }) } }创建views/processSet/processType/list.vue
<template> <div class="app-container"> <!-- 工具条 --> <div class="tools-div"> <el-button type="success" icon="el-icon-plus" size="mini" @click="add" :disabled="$hasBP('bnt.processType.add') === false">添 加</el-button> </div> <!-- banner列表 --> <el-table v-loading="listLoading" :data="list" stripe border style="width: 100%;margin-top: 10px;" > <el-table-column type="selection" width="55" /> <el-table-column label="序号" width="70" align="center" > <template slot-scope="scope"> {{ (page - 1) * limit + scope.$index + 1 }} </template> </el-table-column> <el-table-column prop="name" label="类型名称"/> <el-table-column prop="description" label="描述"/> <el-table-column prop="createTime" label="创建时间"/> <el-table-column prop="updateTime" label="更新时间"/> <el-table-column label="操作" width="200" align="center"> <template slot-scope="scope"> <el-button type="text" size="mini" @click="edit(scope.row.id)" :disabled="$hasBP('bnt.processType.update') === false">修改</el-button> <el-button type="text" size="mini" @click="removeDataById(scope.row.id)" :disabled="$hasBP('bnt.processType.remove') === false">删除</el-button> </template> </el-table-column> </el-table> <!-- 分页组件 --> <el-pagination :current-page="page" :total="total" :page-size="limit" :page-sizes="[5, 10, 20, 30, 40, 50, 100]" style="padding: 30px 0; text-align: center;" layout="sizes, prev, pager, next, jumper, ->, total, slot" @current-change="fetchData" @size-change="changeSize" /> <el-dialog title="添加/修改" :visible.sync="dialogVisible" width="40%"> <el-form ref="flashPromotionForm" label-width="150px" size="small" style="padding-right: 40px;"> <el-form-item label="类型名称"> <el-input v-model="processType.name"/> </el-form-item> <el-form-item label="描述"> <el-input v-model="processType.description"/> </el-form-item> </el-form> <span slot="footer" class="dialog-footer"> <el-button @click="dialogVisible = false" size="small">取 消</el-button> <el-button type="primary" @click="saveOrUpdate()" size="small">确 定</el-button> </span> </el-dialog> </div> </template> <script> import api from '@/api/process/processType' const defaultForm = { id: '', name: '', description: '' } export default { data() { return { listLoading: true, // 数据是否正在加载 list: null, // banner列表 total: 0, // 数据库中的总记录数 page: 1, // 默认页码 limit: 10, // 每页记录数 searchObj: {}, // 查询表单对象 dialogVisible: false, processType: defaultForm, saveBtnDisabled: false } }, // 生命周期函数：内存准备完毕，页面尚未渲染 created() { this.fetchData() }, // 生命周期函数：内存准备完毕，页面渲染成功 mounted() { }, methods: { // 当页码发生改变的时候 changeSize(size) { console.log(size) this.limit = size this.fetchData(1) }, // 加载列表数据 fetchData(page = 1) { this.page = page api.getPageList(this.page, this.limit, this.searchObj).then(response => { this.list = response.data.records this.total = response.data.total // 数据加载并绑定成功 this.listLoading = false }) }, // 重置查询表单 resetData() { console.log('重置查询表单') this.searchObj = {} this.fetchData() }, // 根据id删除数据 removeDataById(id) { this.$confirm('此操作将永久删除该记录, 是否继续?', '提示', { confirmButtonText: '确定', cancelButtonText: '取消', type: 'warning' }).then(() => { // promise // 点击确定，远程调用ajax return api.removeById(id) }).then((response) => { this.fetchData(this.page) this.$message.success(response.message) }).catch(() => { this.$message.info('取消删除') }) }, add() { this.dialogVisible = true this.processType = Object.assign({}, defaultForm) }, edit(id) { this.dialogVisible = true this.fetchDataById(id) }, fetchDataById(id) { api.getById(id).then(response => { this.processType = response.data }) }, saveOrUpdate() { this.saveBtnDisabled = true // 防止表单重复提交 if (!this.processType.id) { this.saveData() } else { this.updateData() } }, // 新增 saveData() { api.save(this.processType).then(response => { this.$message.success(response.message || '操作成功') this.dialogVisible = false this.fetchData(this.page) }) }, // 根据id更新记录 updateData() { api.updateById(this.processType).then(response => { this.$message.success(response.message || '操作成功') this.dialogVisible = false this.fetchData(this.page) }) } } } </script>
三、审批模板实现
分页查询审批模板：
@Autowired private OaProcessTypeService processTypeService; //分页查询 @Override public IPage<ProcessTemplate> selectPageProcessTem(Page<ProcessTemplate> templatePage) { //调用mapper方法实现分页查询 Page<ProcessTemplate> processTemplatePage = baseMapper.selectPage(templatePage, null); //从分页数据中拿到list集合 List<ProcessTemplate> records = processTemplatePage.getRecords(); //从集合中获取审批类型id for (ProcessTemplate processTemplate:records) { //根据list集合id查询 LambdaQueryWrapper<ProcessType> wrapper = new LambdaQueryWrapper<>(); wrapper.eq(ProcessType::getId,processTemplate.getProcessTypeId()); ProcessType processType = processTypeService.getOne(wrapper); if (processType == null){ continue; } //封装数据 processTemplate.setProcessTypeName(processType.getName()); } return processTemplatePage; }@ApiOperation("分页查询") @GetMapping("/pageQuery/{page}/{limit}") public Result pageQuery(@PathVariable("page") Long page, @PathVariable("limit") Long limit){ Page<ProcessTemplate> templatePage = new Page<>(page,limit); return Result.ok(processTemplateService.selectPageProcessTem(templatePage)); } @ApiOperation(value = "新增") @PostMapping("save") public Result save(@RequestBody ProcessTemplate processTemplate) { processTemplateService.save(processTemplate); return Result.ok(); } @ApiOperation(value = "修改") @PutMapping("update") public Result updateById(@RequestBody ProcessTemplate processTemplate) { processTemplateService.updateById(processTemplate); return Result.ok(); } @ApiOperation(value = "删除") @DeleteMapping("remove/{id}") public Result remove(@PathVariable Long id) { processTemplateService.removeById(id); return Result.ok(); }
添加审批模板：
💕、查询所有审批类型
@ApiOperation("查询所有审批分类") @GetMapping("/findAll") public Result findAll(){ List<ProcessType> list = processTypeService.list(); return Result.ok(list); }@ApiOperation("上传流程定义") @PostMapping("/unloadProcessDefinition") public Result unloadProcessDefinition(MultipartFile multipartFile) throws IOException { //获取目录位置 String path = new File(ResourceUtils.getURL("calsspath:").getPath()).getAbsolutePath(); //设置上传文件夹 File file = new File(path + "/processes/"); if (!file.exists()){ file.mkdirs(); } //创建空文件，实现文件上传 String fileName = multipartFile.getOriginalFilename(); File zipFine = new File(path + "/processes/" + fileName); //报存文件 try { multipartFile.transferTo(zipFine); } catch (IOException e) { throw new CJCException(209,"文件报存失败"); } Map<String, Object> map = new HashMap<>(); //根据上传地址后续部署流程定义，文件名称为流程定义的默认key map.put("processDefinitionPath", "processes/" + fileName); map.put("processDefinitionKey", fileName.substring(0, fileName.lastIndexOf("."))); return Result.ok(map); }
部署流程发布：
@Override public void publish(Long id) { ProcessTemplate processTemplate = baseMapper.selectById(id); processTemplate.setStatus(1); baseMapper.updateById(processTemplate); }@ApiOperation("部署流程发布") @GetMapping("/publish/{id}") public Result publish(@PathVariable("id") Long id){ //修改模板发布状态 1：已发布 processTemplateService.publish(id); return Result.ok(); }
414
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
