邮件通知功能

说明

邮件通知功能是根据类型配置邮件附件的基本信息，引用信息，附件维护信息。业务系统往表邮件通知消息表中写入发送邮件的信息，关联邮件配置的类型。调用框架的邮件通知服务，进行发送邮件。

初始化

初始化附录里面的数据库脚本

直接复制对应业务系统数据库类型的脚本执行

菜单

将xml目录文件MAIL-MENU.xml (opens new window),导入到业务系统权限平台,具体子菜单根据业务实际实际需求开放

菜单说明

菜单	说明	地址
邮件通知配置	/appTiangong/EciNoticeType/EciNoticeTypeList	新建邮件的类型的配置信息
邮件通知消息	/appTiangong/EciNoticeInfo/EciNoticeInfoList	邮件发送查询界面

配置

在邮件配置页面根据你的业务类型新增邮件配置信息

附录

初始化表结构 如果已有则无需新建 这里只提供mysql,其他数据库请从后端框架->开发脚本中获取

表信息

表名	说明
ECI_NOTICE_INFO	邮件通知消息
ECI_NOTICE_TYPE	邮件通知类型信息
ECI_NOTICE_TYPE_ATTACH	邮件通知类型附件 信息
ECI_NOTICE_TYPE_REF	邮件通知类型引用信息

mysql

DROP TABLE IF EXISTS `ECI_NOTICE_INFO`;  
CREATE TABLE `ECI_NOTICE_INFO` (  
`ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',  
`BIZ_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '业务主键',  
`TYPE_CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '类型',  
`STATUS` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '状态',  
`SEND_DATE` datetime NULL DEFAULT NULL COMMENT '执行日期',  
`NOTICE_TO` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收件人',  
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建日期',  
`CREATE_USER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建用户',  
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新日期',  
`UPDATE_USER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新用户',  
`BIZ_TYPE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '业务类型',  
`MESSAGE` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '异常描述',  
`STACK_TRACE` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '代码报错信息',  
`FLOW_NO` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '环节',  
`NOTICE_CC` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '抄送人',  
`NOTICE_DATE` datetime NULL DEFAULT NULL COMMENT '计划发送日期',  
`BIZ_NO` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '业务单号',  
PRIMARY KEY (`ID`) USING BTREE  
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic COMMENT='邮件通知消息'

DROP TABLE IF EXISTS `ECI_NOTICE_TYPE`;  
CREATE TABLE `ECI_NOTICE_TYPE` (  
`ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',  
`CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '编码',  
`NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',  
`SUBJECT` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '主题',  
`BODY` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '内容',  
`SQL_NAME` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'SQL语句',  
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建日期',  
`CREATE_USER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建用户',  
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新日期',  
`UPDATE_USER` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新用户',  
`IS_DELETE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否删除',  
`STATUS` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '状态',  
`FLOW_NO` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '环节',  
`UNIQUE_CODE` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '唯一代码',  
`ONE_EXCEL` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '导出到一个EXCEL',  
`EXCEL_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '导出EXCEL名称',  
`FILE_API` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '下载文件API',  
`ON_EXCEL` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '在一个EXCEL中',  
PRIMARY KEY (`ID`) USING BTREE  
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic COMMENT='邮件通知类型';  
  
CREATE TABLE `ECI_NOTICE_TYPE_ATTACH` (  
`ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',  
`HEAD_ID` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头表数据ID',  
`SQL_NAME` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'SQL语句',  
`NAME` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',  
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建日期',  
`CREATE_USER` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建用户',  
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '更新日期',  
`UPDATE_USER` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新用户',  
`IS_DELETE` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否删除',  
`USE_TEMPLATE_FILE` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '使用模板',  
`TEMPLATE_FILE` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模板文件名称',  
`STATUS` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '状态',  
`TEMPLATE_FILE_CONTENT` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '模板文件内容',  
`START_ROW` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '起始行',  
`HEAD_SQL` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头查询SQL语句',  
`PIC_MIN_ROW` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片开始行位置',  
`PIC_MAX_ROW` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片结束行位置',  
`PIC_MIN_COL` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片开始列位置',  
`PIC_MAX_COL` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '图片结束列位置',  
`TEMPLATE_PIC_CONTENT` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '图片文件内容',  
`TEMPLATE_PIC` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '模板图片名称',  
PRIMARY KEY (`ID`) USING BTREE  
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic COMMENT='邮件通知附件信息';  
  
DROP TABLE IF EXISTS `ECI_NOTICE_TYPE_REF`;  
CREATE TABLE `ECI_NOTICE_TYPE_REF` (  
`ID` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '主键',  
`HEAD_ID` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '头表数据',  
`CODE` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '代码',  
`NAME` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '名称',  
`SQL_NAME` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'SQL语句',  
`BODY` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '内容',  
`CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建日期',  
`CREATE_USER` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建用户',  
`UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '修改日期',  
`UPDATE_USER` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改用户',  
`STATUS` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '状态',  
`DETAIL_DATA` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '明细数据',  
`DATA_ROW_INDEX` int(11) NULL DEFAULT NULL COMMENT '数据开始行',  
PRIMARY KEY (`ID`) USING BTREE  
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic COMMENT='邮件通知引用信息';