ALTER TABLE mortals_xhx_staff ADD COLUMN `score` decimal(10,2) default 0.00 COMMENT '绩效分数' AFTER serverIndexCode; ALTER TABLE mortals_xhx_dept ADD COLUMN `score` decimal(10,2) default 0.00 COMMENT '绩效分数' AFTER updateTime; -- ---------------------------- 2023-7-05 -- ---------------------------- -- ---------------------------- -- 绩效记录申诉信息表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_perform_attend_appeal`; CREATE TABLE mortals_xhx_perform_attend_appeal( `id` bigint(20) AUTO_INCREMENT COMMENT '序号，主键，自增长', `checkRecordId` bigint(20) COMMENT '核查记录Id', `staffId` bigint(20) COMMENT '员工ID', `staffName` varchar(64) NOT NULL COMMENT '员工姓名', `workNum` varchar(128) COMMENT '工号', `deptId` bigint(20) COMMENT '所属部门', `deptName` varchar(128) COMMENT '所属部门名称', `attendanceGroupId` bigint(20) COMMENT '所属考勤组ID', `attendanceGroupName` varchar(128) COMMENT '所属考勤组名称', `attendanceDate` datetime COMMENT '扣分时间', `ruleId` bigint(20) COMMENT '绩效规则id', `ruleName` varchar(128) COMMENT '规则名称', `subMethod` tinyint(1) DEFAULT '1' COMMENT '扣分方式(1.系统自动,2.人工添加,3.大厅巡查)', `subAddType` tinyint(1) DEFAULT '1' COMMENT '增减类型(1.增加,2.扣除)', `score` decimal(10,2) DEFAULT '0.00' COMMENT '扣分或增加分值', `goOffTimeStr` varchar(128) COMMENT '上下班时间', `errorTime` datetime COMMENT '异常时间', `actualAttendTime` datetime COMMENT '实际打卡时间', `errorResult` varchar(128) COMMENT '异常处理结果', `checkPerson` varchar(128) COMMENT '核查人员', `checkTime` datetime COMMENT '核查时间', `checkDesc` varchar(512) COMMENT '核查说明', `checkResult` varchar(128) COMMENT '核查结果', `processStatus` tinyint(1) DEFAULT '1' COMMENT '处理状态(1.未处理,2.已处理)', `appealDesc` varchar(128) COMMENT '申诉说明', `appealTime` datetime COMMENT '申诉时间', `appealResult` tinyint(1) DEFAULT '2' COMMENT '申诉结果(1.通过,2.不通过)', `remark` varchar(512) COMMENT '说明', `createUserId` bigint(20) NOT NULL COMMENT '创建用户', `createTime` datetime NOT NULL COMMENT '创建时间', `updateUserId` bigint(20) COMMENT '更新用户', `updateTime` datetime COMMENT '更新时间', `violationType` varchar(64) COMMENT '违规类型', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='绩效记录申诉信息'; -- ---------------------------- -- 绩效记录申诉附件信息表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_perform_attend_appeal_files`; CREATE TABLE mortals_xhx_perform_attend_appeal_files( `id` bigint(20) AUTO_INCREMENT COMMENT '序号，主键，自增长', `appealId` bigint(20) COMMENT '申诉Id', `fileName` varchar(64) NOT NULL COMMENT '文件名称', `filePath` varchar(128) COMMENT '文件地址', `createUserId` bigint(20) NOT NULL COMMENT '创建用户', `createTime` datetime NOT NULL COMMENT '创建时间', `updateUserId` bigint(20) COMMENT '更新用户', `updateTime` datetime COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='绩效记录申诉附件信息'; -- ---------------------------- -- 绩效反馈记录信息表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_feedback`; CREATE TABLE mortals_xhx_feedback( `id` bigint(20) AUTO_INCREMENT COMMENT '序号，主键，自增长', `title` varchar(64) NOT NULL COMMENT '问卷标题', `feedbackTimeStart` datetime COMMENT '反馈开始时间', `feedbackTimeEnd` datetime COMMENT '反馈结束时间', `inviteNum` int(4) DEFAULT '0' COMMENT '邀请人数', `feedbackNum` int(4) DEFAULT '0' COMMENT '反馈人数', `processStatus` tinyint(2) DEFAULT '0' COMMENT '状态 (0.未开始,1.进行中,2.已结束)', `weblink` tinyint(2) DEFAULT '0' COMMENT '问卷是否外链(0.否,1.是)', `webUrl` varchar(255) COMMENT '问题外链地址', `remark` varchar(255) COMMENT '备注说明', `createUserId` bigint(20) COMMENT '创建用户', `createTime` datetime COMMENT '创建时间', `updateUserId` bigint(20) COMMENT '更新用户', `updateTime` datetime COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='绩效反馈记录信息'; -- ---------------------------- -- 绩效反馈问题表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_feedback_question`; CREATE TABLE mortals_xhx_feedback_question( `id` bigint(20) AUTO_INCREMENT COMMENT '序号，主键，自增长', `feedbackId` bigint(20) DEFAULT '0' COMMENT '反馈问卷id号', `content` varchar(64) NOT NULL COMMENT '问题内容', `questionType` tinyint(2) DEFAULT '1' COMMENT '问题类型 (1.单项选择,2.多项选择,3.文本框,4.多项文本框,5.文字,6.上传附件)', `require` tinyint(2) DEFAULT '0' COMMENT '是否必填(0.否,1.是)', `style` varchar(255) COMMENT '样式', `remark` varchar(255) COMMENT '备注', `createUserId` bigint(20) COMMENT '创建用户', `createTime` datetime COMMENT '创建时间', `updateUserId` bigint(20) COMMENT '更新用户', `updateTime` datetime COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='绩效反馈问题'; -- ---------------------------- -- 绩效问题选项表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_feedback_option`; CREATE TABLE mortals_xhx_feedback_option( `id` bigint(20) AUTO_INCREMENT COMMENT '序号，主键，自增长', `questionId` bigint(20) DEFAULT '0' COMMENT '问题id号', `content` varchar(64) NOT NULL COMMENT '选项内容', `remark` varchar(255) COMMENT '备注', `createUserId` bigint(20) COMMENT '创建用户', `createTime` datetime COMMENT '创建时间', `updateUserId` bigint(20) COMMENT '更新用户', `updateTime` datetime COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='绩效问题选项'; -- ---------------------------- -- 绩效问题回答表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_feedback_answer`; CREATE TABLE mortals_xhx_feedback_answer( `id` bigint(20) AUTO_INCREMENT COMMENT '序号，主键，自增长', `feedbackId` bigint(20) DEFAULT '0' COMMENT '反馈问卷id号', `questionId` bigint(20) DEFAULT '0' COMMENT '问题id号', `staffId` bigint(20) DEFAULT '0' COMMENT '用户id号', `questionType` tinyint(2) DEFAULT '1' COMMENT '问题类型 (1.单项选择,2.多项选择,3.文本框,4.多项文本框,5.文字,6.上传附件)', `content` varchar(64) NOT NULL COMMENT '适用于问题内容为文本内容', `remark` varchar(255) COMMENT '备注', `createUserId` bigint(20) COMMENT '创建用户', `createTime` datetime COMMENT '创建时间', `updateUserId` bigint(20) COMMENT '更新用户', `updateTime` datetime COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='绩效问题回答'; -- ---------------------------- -- 绩效问题回答选项表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_feedback_answer_option`; CREATE TABLE mortals_xhx_feedback_answer_option( `id` bigint(20) AUTO_INCREMENT COMMENT '序号，主键，自增长', `answerId` bigint(20) DEFAULT '0' COMMENT '回答问题id号', `optionId` bigint(20) DEFAULT '0' COMMENT '选项id号', `optionContent` varchar(64) NOT NULL COMMENT '选项内容', `remark` varchar(255) COMMENT '备注', `createUserId` bigint(20) COMMENT '创建用户', `createTime` datetime COMMENT '创建时间', `updateUserId` bigint(20) COMMENT '更新用户', `updateTime` datetime COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='绩效问题回答选项'; -- ---------------------------- -- 员工绩效统计表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_staff_perform_summary`; CREATE TABLE mortals_xhx_staff_perform_summary( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID，主键，自增长', `staffId` bigint(20) DEFAULT '0' COMMENT '人员id', `workNum` varchar(64) COMMENT '工号', `staffName` varchar(512) COMMENT '人员名称', `deptId` bigint(20) DEFAULT '0' COMMENT '部门id号', `deptName` varchar(64) COMMENT '部门名称', `attendScore` decimal(10,2) COMMENT '考勤绩效指标分数', `assessScore` decimal(10,2) COMMENT '评价绩效指标分数', `workScore` decimal(10,2) COMMENT '办件绩效分数', `effectScore` decimal(10,2) COMMENT '效能绩效分数', `otherScore` decimal(10,2) COMMENT '其它绩效分数', `errorScore` decimal(10,2) COMMENT '累计异常分数', `totalScore` decimal(10,2) COMMENT '当月得分数', `remark` varchar(255) COMMENT '备注', `year` int(9) NOT NULL COMMENT '年', `month` tinyint(2) NOT NULL COMMENT '月', `createTime` datetime COMMENT '创建时间', `createUserId` bigint(20) COMMENT '创建人id', `updateTime` datetime COMMENT '更新时间', `updateUserId` bigint(20) COMMENT '更新人id', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='员工绩效统计'; -- ---------------------------- -- 绩效记录申诉信息资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效记录申诉信息-菜单管理-查看', '/perform/attend/appeal/list,/perform/attend/appeal/view,/perform/attend/appeal/info,/perform/attend/appeal/export,/perform/attend/appeal/exportExcel,/perform/attend/appeal/downloadTemplate,/perform/attend/appeal/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效记录申诉信息-菜单管理-维护', '/perform/attend/appeal/add,/perform/attend/appeal/edit,/perform/attend/appeal/delete,/perform/attend/appeal/logicDelete,/perform/attend/appeal/save,/perform/attend/appeal/importData', 3, 0, NULL, NULL, NULL, 0); -- ---------------------------- -- 绩效记录申诉信息参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '扣分方式', 'PerformAttendAppeal', 'subMethod', '1', '系统自动', 1, 4, 0, 'subMethod', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '扣分方式', 'PerformAttendAppeal', 'subMethod', '2', '人工添加', 1, 4, 0, 'subMethod', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '增减类型', 'PerformAttendAppeal', 'subAddType', '1', '增加', 1, 4, 0, 'subAddType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '增减类型', 'PerformAttendAppeal', 'subAddType', '2', '扣除', 1, 4, 0, 'subAddType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '处理状态', 'PerformAttendAppeal', 'processStatus', '1', '未处理', 1, 4, 0, 'processStatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '处理状态', 'PerformAttendAppeal', 'processStatus', '2', '已处理', 1, 4, 0, 'processStatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '申诉结果', 'PerformAttendAppeal', 'appealResult', '1', '通过', 1, 4, 0, 'appealResult', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '申诉结果', 'PerformAttendAppeal', 'appealResult', '2', '不通过', 1, 4, 0, 'appealResult', NULL, NULL, NULL); -- ---------------------------- -- 绩效记录申诉附件信息资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效记录申诉附件信息-菜单管理-查看', '/perform/attend/appeal/files/list,/perform/attend/appeal/files/view,/perform/attend/appeal/files/info,/perform/attend/appeal/files/export,/perform/attend/appeal/files/exportExcel,/perform/attend/appeal/files/downloadTemplate,/perform/attend/appeal/files/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效记录申诉附件信息-菜单管理-维护', '/perform/attend/appeal/files/add,/perform/attend/appeal/files/edit,/perform/attend/appeal/files/delete,/perform/attend/appeal/files/logicDelete,/perform/attend/appeal/files/save,/perform/attend/appeal/files/importData', 3, 0, NULL, NULL, NULL, 0); -- ---------------------------- -- 绩效反馈记录信息资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效反馈记录信息-菜单管理-查看', '/feedback/list,/feedback/view,/feedback/info,/feedback/export,/feedback/exportExcel,/feedback/downloadTemplate,/feedback/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效反馈记录信息-菜单管理-维护', '/feedback/add,/feedback/edit,/feedback/delete,/feedback/logicDelete,/feedback/save,/feedback/importData', 3, 0, NULL, NULL, NULL, 0); -- ---------------------------- -- 绩效反馈记录信息参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '状态 ', 'Feedback', 'processStatus', '0', '未开始', 1, 4, 0, 'processStatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '状态 ', 'Feedback', 'processStatus', '1', '进行中', 1, 4, 0, 'processStatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '状态 ', 'Feedback', 'processStatus', '2', '已结束', 1, 4, 0, 'processStatus', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '问卷是否外链', 'Feedback', 'weblink', '0', '否', 1, 4, 0, 'weblink', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '问卷是否外链', 'Feedback', 'weblink', '1', '是', 1, 4, 0, 'weblink', NULL, NULL, NULL); -- ---------------------------- -- 绩效反馈问题资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效反馈问题-菜单管理-查看', '/feedback/question/list,/feedback/question/view,/feedback/question/info,/feedback/question/export,/feedback/question/exportExcel,/feedback/question/downloadTemplate,/feedback/question/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效反馈问题-菜单管理-维护', '/feedback/question/add,/feedback/question/edit,/feedback/question/delete,/feedback/question/logicDelete,/feedback/question/save,/feedback/question/importData', 3, 0, NULL, NULL, NULL, 0); -- ---------------------------- -- 绩效反馈问题参数 SQL -- ---------------------------- INSERT INTO `mortals_xhx_param` VALUES (null, '问题类型 ', 'FeedbackQuestion', 'questionType', '1', '单项选择', 1, 4, 0, 'questionType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '问题类型 ', 'FeedbackQuestion', 'questionType', '2', '多项选择', 1, 4, 0, 'questionType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '问题类型 ', 'FeedbackQuestion', 'questionType', '3', '文本框', 1, 4, 0, 'questionType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '问题类型 ', 'FeedbackQuestion', 'questionType', '4', '多项文本框', 1, 4, 0, 'questionType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '问题类型 ', 'FeedbackQuestion', 'questionType', '5', '文字', 1, 4, 0, 'questionType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '问题类型 ', 'FeedbackQuestion', 'questionType', '6', '上传附件', 1, 4, 0, 'questionType', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否必填', 'FeedbackQuestion', 'require', '0', '否', 1, 4, 0, 'require', NULL, NULL, NULL); INSERT INTO `mortals_xhx_param` VALUES (null, '是否必填', 'FeedbackQuestion', 'require', '1', '是', 1, 4, 0, 'require', NULL, NULL, NULL); -- ---------------------------- -- 绩效问题选项资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效问题选项-菜单管理-查看', '/feedback/option/list,/feedback/option/view,/feedback/option/info,/feedback/option/export,/feedback/option/exportExcel,/feedback/option/downloadTemplate,/feedback/option/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效问题选项-菜单管理-维护', '/feedback/option/add,/feedback/option/edit,/feedback/option/delete,/feedback/option/logicDelete,/feedback/option/save,/feedback/option/importData', 3, 0, NULL, NULL, NULL, 0); -- ---------------------------- -- 绩效问题回答资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效问题回答-菜单管理-查看', '/feedback/answer/list,/feedback/answer/view,/feedback/answer/info,/feedback/answer/export,/feedback/answer/exportExcel,/feedback/answer/downloadTemplate,/feedback/answer/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效问题回答-菜单管理-维护', '/feedback/answer/add,/feedback/answer/edit,/feedback/answer/delete,/feedback/answer/logicDelete,/feedback/answer/save,/feedback/answer/importData', 3, 0, NULL, NULL, NULL, 0); -- ---------------------------- -- 绩效问题回答选项资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效问题回答选项-菜单管理-查看', '/feedback/answer/option/list,/feedback/answer/option/view,/feedback/answer/option/info,/feedback/answer/option/export,/feedback/answer/option/exportExcel,/feedback/answer/option/downloadTemplate,/feedback/answer/option/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '绩效问题回答选项-菜单管理-维护', '/feedback/answer/option/add,/feedback/answer/option/edit,/feedback/answer/option/delete,/feedback/answer/option/logicDelete,/feedback/answer/option/save,/feedback/answer/option/importData', 3, 0, NULL, NULL, NULL, 0); -- ---------------------------- -- 员工绩效统计资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '员工绩效统计-菜单管理-查看', '/staff/perform/summary/list,/staff/perform/summary/view,/staff/perform/summary/info,/staff/perform/summary/export,/staff/perform/summary/exportExcel,/staff/perform/summary/downloadTemplate,/staff/perform/summary/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '员工绩效统计-菜单管理-维护', '/staff/perform/summary/add,/staff/perform/summary/edit,/staff/perform/summary/delete,/staff/perform/summary/logicDelete,/staff/perform/summary/save,/staff/perform/summary/importData', 3, 0, NULL, NULL, NULL, 0); -- ---------------------------- -- 员工反馈问卷表 -- ---------------------------- DROP TABLE IF EXISTS `mortals_xhx_feedback_staff`; CREATE TABLE mortals_xhx_feedback_staff( `id` bigint(20) AUTO_INCREMENT COMMENT '序号，主键，自增长', `feedbackId` bigint(20) DEFAULT '0' COMMENT '反馈问卷id号', `staffId` bigint(20) DEFAULT '0' COMMENT '用户id', `remark` varchar(255) COMMENT '备注', `createUserId` bigint(20) COMMENT '创建用户', `createTime` datetime COMMENT '创建时间', `updateUserId` bigint(20) COMMENT '更新用户', `updateTime` datetime COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='员工反馈问卷'; -- ---------------------------- -- 员工反馈问卷资源路径 SQL -- ---------------------------- INSERT INTO `mortals_xhx_resource` VALUES (null, '员工反馈问卷-菜单管理-查看', '/feedback/staff/list,/feedback/staff/view,/feedback/staff/info,/feedback/staff/export,/feedback/staff/exportExcel,/feedback/staff/downloadTemplate,/feedback/staff/download', 3, 0, NULL, NULL, NULL, 0); INSERT INTO `mortals_xhx_resource` VALUES (null, '员工反馈问卷-菜单管理-维护', '/feedback/staff/add,/feedback/staff/edit,/feedback/staff/delete,/feedback/staff/logicDelete,/feedback/staff/save,/feedback/staff/importData', 3, 0, NULL, NULL, NULL, 0);