Java全栈项目 - 智能考勤管理系统

项目介绍

智能考勤管理系统是一个基于 Java 全栈技术开发的现代化企业考勤解决方案。该系统采用前后端分离架构，实现了员工考勤、请假管理、统计分析等核心功能，旨在帮助企业提高人力资源管理效率。

技术栈

后端技术

• Spring Boot 2.6.x
• Spring Security
• MyBatis-Plus
• MySQL 8.0
• Redis
• JWT

前端技术

• Vue 3
• Element Plus
• Axios
• Echarts
• Vite

核心功能

1. 考勤管理

• 上下班打卡
• 加班申请
• 外出登记
• 考勤规则设置
• 异常考勤处理

2. 请假管理

• 请假申请
• 请假审批
• 请假类型配置
• 假期余额查询

3. 统计分析

• 考勤统计报表
• 部门出勤率分析
• 加班统计
• 请假趋势分析

4. 系统管理

• 用户管理
• 角色权限
• 部门管理
• 系统配置

系统架构

├── smart-attendance-system
│   ├── attendance-admin        # 后台管理服务
│   ├── attendance-api         # 接口服务
│   ├── attendance-common      # 公共模块
│   ├── attendance-model       # 数据模型
│   └── attendance-web         # 前端项目

数据库设计

核心表结构

-- 员工表
CREATE TABLE sys_employee (id BIGINT PRIMARY KEY,emp_no VARCHAR(32),name VARCHAR(50),department_id BIGINT,position VARCHAR(50),status TINYINT,create_time DATETIME
);-- 考勤记录表
CREATE TABLE attendance_record (id BIGINT PRIMARY KEY,emp_id BIGINT,check_in_time DATETIME,check_out_time DATETIME,status TINYINT,type TINYINT,remark VARCHAR(255)
);-- 请假记录表
CREATE TABLE leave_record (id BIGINT PRIMARY KEY,emp_id BIGINT,leave_type TINYINT,start_time DATETIME,end_time DATETIME,reason VARCHAR(255),status TINYINT
);

项目亮点

1. 人脸识别打卡

• 集成人脸识别SDK
• 活体检测
• 高精度识别算法

2. 智能定位打卡

• 基于地理围栏技术
• 支持移动端GPS定位
• 异地打卡预警

3. 灵活的考勤规则

• 多班次管理
• 弹性工时
• 节假日智能排班
• 加班规则配置

4. 数据可视化

• 直观的统计图表
• 多维度数据分析
• 自定义报表导出

性能优化

1. 缓存优化

@Cacheable(value = "attendance", key = "#empId")
public AttendanceDTO getAttendanceInfo(Long empId) {// 获取考勤信息逻辑
}

2. SQL优化

@Select("SELECT DATE_FORMAT(check_in_time,'%Y-%m-%d') as date, " +"COUNT(*) as count FROM attendance_record " +"WHERE emp_id = #{empId} " +"GROUP BY DATE_FORMAT(check_in_time,'%Y-%m-%d')")
List<StatisticsDTO> getAttendanceStatistics(Long empId);

3. 接口性能

• 接口响应时间控制在200ms以内
• 使用线程池处理异步任务
• 批量操作优化

安全性设计

1. 身份认证

@Configuration
public class SecurityConfig extends WebSecurityConfigurerAdapter {@Overrideprotected void configure(HttpSecurity http) throws Exception {http.authorizeRequests().antMatchers("/api/auth/**").permitAll().anyRequest().authenticated().and().addFilter(new JwtAuthenticationFilter(authenticationManager()));}
}

2. 数据安全

• 敏感数据加密
• SQL注入防护
• XSS防御

部署方案

1. 容器化部署

version: '3'
services:attendance-api:image: attendance-api:latestports:- "8080:8080"environment:- SPRING_PROFILES_ACTIVE=prod

2. 高可用方案

• 服务器集群
• 负载均衡
• 数据库主从复制

项目总结

智能考勤管理系统采用现代化的技术栈和架构设计，实现了企业考勤管理的智能化和自动化。系统具有良好的可扩展性和维护性，为企业提供了一个高效、可靠的考勤解决方案。

未来展望

• 引入机器学习算法，实现考勤预测
• 集成企业微信等第三方平台
• 开发移动端应用
• 支持多租户架构

智能考勤系统 - 考勤与请假管理模块详解

一、考勤管理模块

1. 上下班打卡

1.1 打卡记录表设计

CREATE TABLE attendance_record (id BIGINT PRIMARY KEY,emp_id BIGINT COMMENT '员工ID',check_type TINYINT COMMENT '打卡类型：1-上班，2-下班',check_time DATETIME COMMENT '打卡时间',check_location VARCHAR(255) COMMENT '打卡地点',device_info VARCHAR(100) COMMENT '设备信息',face_image VARCHAR(255) COMMENT '人脸照片URL',status TINYINT COMMENT '状态：1-正常，2-迟到，3-早退',remark VARCHAR(255) COMMENT '备注',create_time DATETIME,FOREIGN KEY (emp_id) REFERENCES sys_employee(id)
);

1.2 打卡服务实现

@Service
@Slf4j
public class CheckInService {@Autowiredprivate AttendanceRuleService ruleService;@Autowiredprivate FaceRecognitionService faceService;@Autowiredprivate LocationService locationService;@Transactionalpublic CheckInResult doCheckIn(CheckInDTO checkInDTO) {// 1. 人脸识别验证boolean faceValid = faceService.verify(checkInDTO.getEmpId(), checkInDTO.getFaceImage());if (!faceValid) {throw new BusinessException("人脸识别失败");}// 2. 位置验证boolean locationValid = locationService.verifyLocation(checkInDTO.getLocation(),checkInDTO.getEmpId());if (!locationValid) {throw new BusinessException("不在打卡范围内");}// 3. 判断打卡类型和状态AttendanceRule rule = ruleService.getEmployeeRule(checkInDTO.getEmpId());CheckInStatus status = calculateStatus(checkInDTO.getCheckTime(), rule);// 4. 保存打卡记录AttendanceRecord record = new AttendanceRecord();record.setEmpId(checkInDTO.getEmpId());record.setCheckType(checkInDTO.getCheckType());record.setCheckTime(checkInDTO.getCheckTime());record.setStatus(status.getCode());attendanceMapper.insert(record);// 5. 返回打卡结果return new CheckInResult(status, record.getId());}private CheckInStatus calculateStatus(LocalDateTime checkTime, AttendanceRule rule) {LocalTime time = checkTime.toLocalTime();if (isCheckIn) {if (time.isAfter(rule.getLateTime())) {return CheckInStatus.LATE;}} else {if (time.isBefore(rule.getEarlyLeaveTime())) {return CheckInStatus.EARLY_LEAVE;}}return CheckInStatus.NORMAL;}
}

1.3 打卡界面实现

<template><div class="check-in-container"><div class="camera-container"><video ref="video" class="camera-preview"></video><canvas ref="canvas" style="display: none;"></canvas></div><div class="check-in-info"><div class="time-display">{{ currentTime }}</div><el-button type="primary" size="large" @click="handleCheckIn":loading="checking">{{ checkType === 1 ? '上班打卡' : '下班打卡' }}</el-button><div class="location-info">当前位置：{{ location }}</div></div><!-- 打卡结果弹窗 --><el-dialogtitle="打卡结果":visible.sync="showResult"width="300px"center><div class="check-result"><i :class="resultIcon"></i><span>{{ resultMessage }}</span><div class="check-time">{{ checkTime }}</div></div></el-dialog></div>
</template><script>
export default {data() {return {checking: false,currentTime: '',location: '',checkType: this.getCheckType(),showResult: false,resultMessage: '',stream: null}},methods: {async initCamera() {try {this.stream = await navigator.mediaDevices.getUserMedia({video: true});this.$refs.video.srcObject = this.stream;} catch (error) {this.$message.error('摄像头启动失败');}},getCheckType() {const now = new Date();const hour = now.getHours();return hour < 12 ? 1 : 2; // 12点前为上班打卡},async handleCheckIn() {try {this.checking = true;// 1. 获取人脸图片const faceImage = this.captureFace();// 2. 获取位置信息const location = await this.getCurrentLocation();// 3. 提交打卡const result = await this.$api.attendance.checkIn({checkType: this.checkType,faceImage,location,checkTime: new Date()});// 4. 显示结果this.showCheckResult(result);} catch (error) {this.$message.error(error.message);} finally {this.checking = false;}},captureFace() {const canvas = this.$refs.canvas;const video = this.$refs.video;const context = canvas.getContext('2d');canvas.width = video.videoWidth;canvas.height = video.videoHeight;context.drawImage(video, 0, 0);return canvas.toDataURL('image/jpeg');}},mounted() {this.initCamera();// 更新当前时间setInterval(() => {this.currentTime = new Date().toLocaleTimeString();}, 1000);},beforeDestroy() {// 关闭摄像头if (this.stream) {this.stream.getTracks().forEach(track => track.stop());}}
}
</script>

2. 加班申请

2.1 加班申请表

CREATE TABLE overtime_application (id BIGINT PRIMARY KEY,emp_id BIGINT,start_time DATETIME,end_time DATETIME,overtime_type TINYINT COMMENT '加班类型：1-工作日，2-周末，3-节假日',reason VARCHAR(500),status TINYINT COMMENT '状态：0-待审批，1-已通过，2-已拒绝',approver_id BIGINT,approve_time DATETIME,approve_remark VARCHAR(255),create_time DATETIME
);

2.2 加班服务实现

@Service
public class OvertimeService {@Autowiredprivate WorkflowService workflowService;public void applyOvertime(OvertimeDTO overtimeDTO) {// 1. 验证加班时长validateOvertimeHours(overtimeDTO);// 2. 创建加班申请OvertimeApplication application = new OvertimeApplication();BeanUtils.copyProperties(overtimeDTO, application);application.setStatus(ApprovalStatus.PENDING.getCode());overtimeMapper.insert(application);// 3. 发起工作流workflowService.startProcess("overtime_process",application.getId(),overtimeDTO.getEmpId());}private void validateOvertimeHours(OvertimeDTO overtime) {// 计算加班时长long hours = ChronoUnit.HOURS.between(overtime.getStartTime(), overtime.getEndTime());// 获取员工当月已加班时长int monthlyHours = overtimeMapper.getMonthlyHours(overtime.getEmpId(),overtime.getStartTime());// 验证是否超过月度限制if (monthlyHours + hours > MAX_MONTHLY_HOURS) {throw new BusinessException("超过月度加班时长限制");}}
}

3. 外出登记

3.1 外出登记表

CREATE TABLE business_trip (id BIGINT PRIMARY KEY,emp_id BIGINT,start_time DATETIME,end_time DATETIME,destination VARCHAR(255),purpose VARCHAR(500),status TINYINT,contact_info VARCHAR(100),create_time DATETIME
);

3.2 外出服务实现

@Service
public class BusinessTripService {public void register(BusinessTripDTO tripDTO) {// 1. 检查是否有重叠的外出记录boolean hasOverlap = checkTimeOverlap(tripDTO.getEmpId(),tripDTO.getStartTime(),tripDTO.getEndTime());if (hasOverlap) {throw new BusinessException("当前时间段已有外出记录");}// 2. 保存外出记录BusinessTrip trip = new BusinessTrip();BeanUtils.copyProperties(tripDTO, trip);tripMapper.insert(trip);// 3. 更新考勤规则attendanceRuleService.addException(tripDTO.getEmpId(),tripDTO.getStartTime(),tripDTO.getEndTime(),AttendanceExceptionType.BUSINESS_TRIP);}
}

4. 考勤规则设置

4.1 考勤规则表

CREATE TABLE attendance_rule (id BIGINT PRIMARY KEY,rule_name VARCHAR(50),work_start_time TIME,work_end_time TIME,late_minutes INT COMMENT '迟到判定分钟数',early_leave_minutes INT COMMENT '早退判定分钟数',work_hours DECIMAL(4,1) COMMENT '每日工时',flexible_time INT COMMENT '弹性工作时间(分钟)',dept_id BIGINT COMMENT '适用部门',status TINYINT,create_time DATETIME
);

4.2 规则配置服务

@Service
public class AttendanceRuleService {@Cacheable(value = "attendance_rule", key = "#deptId")public AttendanceRule getDeptRule(Long deptId) {return ruleMapper.selectByDeptId(deptId);}@CacheEvict(value = "attendance_rule", key = "#rule.deptId")public void updateRule(AttendanceRule rule) {validateRule(rule);ruleMapper.updateById(rule);}private void validateRule(AttendanceRule rule) {// 验证工作时间设置if (rule.getWorkEndTime().isBefore(rule.getWorkStartTime())) {throw new BusinessException("下班时间不能早于上班时间");}// 验证弹性工作时间if (rule.getFlexibleTime() != null && rule.getFlexibleTime() > MAX_FLEXIBLE_TIME) {throw new BusinessException("弹性工作时间超出限制");}}
}

5. 异常考勤处理

5.1 异常考勤表

CREATE TABLE attendance_exception (id BIGINT PRIMARY KEY,emp_id BIGINT,exception_date DATE,exception_type TINYINT COMMENT '异常类型：1-漏打卡，2-迟到，3-早退',handle_status TINYINT COMMENT '处理状态',handle_result VARCHAR(255),handle_time DATETIME,handler_id BIGINT,create_time DATETIME
);

5.2 异常处理服务

@Service
public class ExceptionHandleService {@Asyncpublic void handleException(AttendanceException exception) {// 1. 判断异常类型switch (exception.getExceptionType()) {case MISSING_CHECK:handleMissingCheck(exception);break;case LATE:handleLate(exception);break;case EARLY_LEAVE:handleEarlyLeave(exception);break;}// 2. 发送通知notificationService.sendExceptionNotice(exception);// 3. 更新处理状态exceptionMapper.updateStatus(exception.getId(),ExceptionStatus.HANDLED);}private void handleMissingCheck(AttendanceException exception) {// 检查是否有相关的请假或外出记录List<LeaveRecord> leaveRecords = leaveMapper.findByEmpAndDate(exception.getEmpId(), exception.getExceptionDate());if (!leaveRecords.isEmpty()) {// 有请假记录，标记为已确认exception.setHandleResult("已确认请假");return;}// 发起补卡申请createSupplementaryApplication(exception);}
}

二、请假管理模块

1. 请假申请

1.1 请假记录表

CREATE TABLE leave_record (id BIGINT PRIMARY KEY,emp_id BIGINT,leave_type TINYINT COMMENT '请假类型',start_time DATETIME,end_time DATETIME,duration DECIMAL(5,1) COMMENT '请假时长(天)',reason VARCHAR(500),status TINYINT COMMENT '状态：0-待审批，1-已通过，2-已拒绝',approver_id BIGINT,approve_time DATETIME,approve_remark VARCHAR(255),attachment_url VARCHAR(255) COMMENT '附件URL',create_time DATETIME
);

1.2 请假服务实现

@Service
public class LeaveService {@Autowiredprivate LeaveBalanceService balanceService;@Autowiredprivate WorkflowService workflowService;@Transactionalpublic void applyLeave(LeaveApplicationDTO leaveDTO) {// 1. 校验请假时长validateLeaveDuration(leaveDTO);// 2. 检查假期余额checkLeaveBalance(leaveDTO.getEmpId(),leaveDTO.getLeaveType(),leaveDTO.getDuration());// 3. 创建请假记录LeaveRecord record = new LeaveRecord();BeanUtils.copyProperties(leaveDTO, record);record.setStatus(ApprovalStatus.PENDING.getCode());leaveMapper.insert(record);// 4. 发起工作流workflowService.startProcess("leave_process",record.getId(),leaveDTO.getEmpId());}private void checkLeaveBalance(Long empId, LeaveType leaveType, BigDecimal duration) {LeaveBalance balance = balanceService.getBalance(empId, leaveType);if (balance.getRemaining().compareTo(duration) < 0) {throw new BusinessException(leaveType.getName() + "假期余额不足");}}
}

2. 请假审批

2.1 审批流程配置

@Configuration
public class LeaveWorkflowConfig {@Autowiredprivate RuntimeService runtimeService;@Beanpublic ProcessEngineConfiguration leaveProcess() {return ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration().setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE).setJdbcUrl("jdbc:mysql://localhost:3306/workflow").setJdbcDriver("com.mysql.cj.jdbc.Driver").setJdbcUsername("root").setJdbcPassword("password").setActivityFontName("宋体").setLabelFontName("宋体").setAnnotationFontName("宋体");}
}

2.2 审批服务实现

@Service
public class LeaveApprovalService {@Autowiredprivate TaskService taskService;@Autowiredprivate LeaveBalanceService balanceService;@Transactionalpublic void approve(ApprovalDTO approvalDTO) {// 1. 获取请假记录LeaveRecord record = leaveMapper.selectById(approvalDTO.getRecordId());if (record == null) {throw new BusinessException("请假记录不存在");}// 2. 更新审批状态record.setStatus(approvalDTO.getApproved() ? ApprovalStatus.APPROVED.getCode(): ApprovalStatus.REJECTED.getCode());record.setApproveRemark(approvalDTO.getRemark());record.setApproveTime(LocalDateTime.now());record.setApproverId(approvalDTO.getApproverId());leaveMapper.updateById(record);// 3. 如果审批通过，扣减假期余额if (approvalDTO.getApproved()) {balanceService.deductBalance(record.getEmpId(),record.getLeaveType(),record.getDuration());}// 4. 完成工作流任务taskService.complete(approvalDTO.getTaskId());// 5. 发送通知notificationService.sendApprovalResult(record);}
}

3. 请假类型配置

3.1 请假类型表

CREATE TABLE leave_type (id BIGINT PRIMARY KEY,type_name VARCHAR(50),type_code VARCHAR(50),paid TINYINT COMMENT '是否带薪',max_duration INT COMMENT '最大请假天数',min_unit DECIMAL(2,1) COMMENT '最小请假单位(天)',need_attachment TINYINT COMMENT '是否需要附件',status TINYINT,create_time DATETIME
);

3.2 类型配置服务

@Service
public class LeaveTypeService {@Cacheable(value = "leave_type", key = "#typeId")public LeaveType getLeaveType(Long typeId) {return typeMapper.selectById(typeId);}@CacheEvict(value = "leave_type", allEntries = true)public void updateLeaveType(LeaveType leaveType) {validateLeaveType(leaveType);typeMapper.updateById(leaveType);}private void validateLeaveType(LeaveType type) {// 验证最大请假天数if (type.getMaxDuration() <= 0) {throw new BusinessException("最大请假天数必须大于0");}// 验证最小请假单位if (type.getMinUnit().compareTo(BigDecimal.ZERO) <= 0) {throw new BusinessException("最小请假单位必须大于0");}}
}

4. 假期余额查询

4.1 假期余额表

CREATE TABLE leave_balance (id BIGINT PRIMARY KEY,emp_id BIGINT,leave_type TINYINT,year INT,total_days DECIMAL(5,1),used_days DECIMAL(5,1),remaining_days DECIMAL(5,1),update_time DATETIME
);

4.2 余额查询服务

@Service
public class LeaveBalanceService {@Cacheable(value = "leave_balance", key = "#empId + ':' + #leaveType")public LeaveBalance getBalance(Long empId, LeaveType leaveType) {return balanceMapper.selectByEmpAndType(empId, leaveType);}@Transactional@CacheEvict(value = "leave_balance", key = "#empId + ':' + #leaveType")public void deductBalance(Long empId, LeaveType leaveType, BigDecimal days) {LeaveBalance balance = getBalance(empId, leaveType);if (balance == null) {throw new BusinessException("假期余额记录不存在");}// 检查余额是否足够if (balance.getRemainingDays().compareTo(days) < 0) {throw new BusinessException("假期余额不足");}// 更新已使用和剩余天数balance.setUsedDays(balance.getUsedDays().add(days));balance.setRemainingDays(balance.getRemainingDays().subtract(days));balanceMapper.updateById(balance);}// 年度假期初始化@Scheduled(cron = "0 0 0 1 1 ?")  // 每年1月1日执行public void initializeYearlyBalance() {int year = LocalDate.now().getYear();// 获取所有在职员工List<Employee> employees = employeeMapper.selectAllActive();for (Employee emp : employees) {// 初始化各类假期余额initializeBalance(emp.getId(), year);}}
}

4.3 余额查询界面

<template><div class="leave-balance"><el-card class="balance-card"><div slot="header"><span>假期余额</span><el-button type="text" @click="refreshBalance"style="float: right;">刷新</el-button></div><el-table :data="balanceList" border><el-table-column prop="typeName" label="假期类型"/><el-table-column prop="totalDays" label="总天数"/><el-table-column prop="usedDays" label="已用天数"/><el-table-column prop="remainingDays" label="剩余天数"><template slot-scope="scope"><span :class="{'warning': scope.row.remainingDays < 5,'danger': scope.row.remainingDays <= 0}">{{ scope.row.remainingDays }}</span></template></el-table-column></el-table></el-card><!-- 假期使用记录 --><el-card class="usage-card"><div slot="header"><span>假期使用记录</span></div><el-table :data="usageRecords" border><el-table-column prop="leaveType" label="假期类型"/><el-table-column prop="startTime" label="开始时间"/><el-table-column prop="endTime" label="结束时间"/><el-table-column prop="duration" label="请假天数"/><el-table-column prop="status" label="状态"><template slot-scope="scope"><el-tag :type="getStatusType(scope.row.status)">{{ getStatusText(scope.row.status) }}</el-tag></template></el-table-column></el-table></el-card></div>
</template><script>
export default {data() {return {balanceList: [],usageRecords: []}},methods: {async refreshBalance() {try {const response = await this.$api.leave.getBalance(this.userId);this.balanceList = response.data;} catch (error) {this.$message.error('获取假期余额失败');}},getStatusType(status) {const typeMap = {0: 'info',1: 'success',2: 'danger'};return typeMap[status] || 'info';},getStatusText(status) {const textMap = {0: '待审批',1: '已通过',2: '已拒绝'};return textMap[status] || '未知';}},created() {this.refreshBalance();}
}
</script><style scoped>
.leave-balance {padding: 20px;
}.balance-card {margin-bottom: 20px;
}.warning {color: #E6A23C;
}.danger {color: #F56C6C;
}
</style>

这些模块的实现涵盖了：

• 数据库表设计
• 业务逻辑实现
• 工作流集成
• 缓存管理
• 定时任务
• 前端界面开发
• 权限控制
• 数据验证

通过这些功能的实现，可以为企业提供完整的考勤和请假管理解决方案。

智能考勤系统 - 统计分析与系统管理模块详解

一、统计分析模块

1. 考勤统计报表

1.1 数据维度

-- 考勤统计视图
CREATE VIEW v_attendance_statistics AS
SELECT e.department_id,e.emp_no,e.name,DATE_FORMAT(ar.check_in_time, '%Y-%m') as month,COUNT(DISTINCT DATE(ar.check_in_time)) as work_days,COUNT(CASE WHEN ar.status = 1 THEN 1 END) as normal_days,COUNT(CASE WHEN ar.status = 2 THEN 1 END) as late_days,COUNT(CASE WHEN ar.status = 3 THEN 1 END) as early_leave_days,COUNT(CASE WHEN ar.status = 4 THEN 1 END) as absent_days
FROM sys_employee e
LEFT JOIN attendance_record ar ON e.id = ar.emp_id
GROUP BY e.id, DATE_FORMAT(ar.check_in_time, '%Y-%m');

1.2 报表类型

• 月度考勤汇总表
• 个人考勤明细表
• 部门考勤对比表
• 异常考勤分析表

1.3 数据展示

@Service
public class AttendanceReportService {@Autowiredprivate AttendanceMapper attendanceMapper;public List<AttendanceReportDTO> generateMonthlyReport(String month) {return attendanceMapper.getMonthlyStatistics(month);}// 支持多种导出格式public void exportReport(String format, String month) {List<AttendanceReportDTO> data = generateMonthlyReport(month);switch(format.toLowerCase()) {case "excel":exportToExcel(data);break;case "pdf":exportToPDF(data);break;case "csv":exportToCSV(data);break;}}
}

2. 部门出勤率分析

2.1 核心指标

• 部门整体出勤率
• 迟到率
• 早退率
• 缺勤率
• 加班时长

2.2 可视化展示

<template><div class="department-analysis"><!-- 部门出勤率图表 --><div class="chart-container"><v-chart :option="chartOption" /></div><!-- 部门排名列表 --><el-table :data="departmentRanking"><el-table-column prop="deptName" label="部门" /><el-table-column prop="attendanceRate" label="出勤率"><template #default="scope"><el-progress :percentage="scope.row.attendanceRate" :color="getColorByRate(scope.row.attendanceRate)"/></template></el-table-column></el-table></div>
</template><script>
export default {data() {return {chartOption: {title: { text: '部门出勤率分析' },series: [{type: 'pie',data: [{ value: 95, name: '研发部' },{ value: 92, name: '市场部' },{ value: 88, name: '运营部' }]}]}}}
}
</script>

3. 加班统计

3.1 加班类型统计

public enum OvertimeType {WORKDAY(1, "工作日加班"),WEEKEND(2, "周末加班"),HOLIDAY(3, "节假日加班");private int code;private String desc;
}@Service
public class OvertimeStatisticsService {public Map<String, Object> calculateOvertimeHours(Long empId, String month) {Map<String, Object> statistics = new HashMap<>();// 计算不同类型加班时长statistics.put("workdayHours", calculateByType(empId, month, OvertimeType.WORKDAY));statistics.put("weekendHours", calculateByType(empId, month, OvertimeType.WEEKEND));statistics.put("holidayHours", calculateByType(empId, month, OvertimeType.HOLIDAY));// 计算加班费statistics.put("overtimePay", calculateOvertimePay(statistics));return statistics;}
}

4. 请假趋势分析

4.1 请假类型分布

SELECT leave_type,COUNT(*) as count,SUM(TIMESTAMPDIFF(HOUR, start_time, end_time)) as total_hours
FROM leave_record
WHERE DATE_FORMAT(start_time, '%Y-%m') = #{month}
GROUP BY leave_type;

4.2 趋势图表配置

const leaveAnalysisChart = {xAxis: {type: 'category',data: ['1月', '2月', '3月', '4月', '5月', '6月']},yAxis: {type: 'value'},series: [{name: '病假',type: 'line',data: [10, 8, 12, 6, 9, 7]},{name: '事假',type: 'line',data: [5, 7, 4, 8, 6, 9]},{name: '年假',type: 'line',data: [2, 4, 6, 8, 3, 5]}]
}

二、系统管理模块

1. 用户管理

1.1 用户表设计

CREATE TABLE sys_user (id BIGINT PRIMARY KEY,username VARCHAR(50) NOT NULL UNIQUE,password VARCHAR(100) NOT NULL,real_name VARCHAR(50),email VARCHAR(100),mobile VARCHAR(20),status TINYINT DEFAULT 1,create_time DATETIME,update_time DATETIME,last_login_time DATETIME,remark VARCHAR(255)
);

1.2 用户服务实现

@Service
public class UserService {@Autowiredprivate PasswordEncoder passwordEncoder;public void createUser(UserDTO userDTO) {// 密码加密String encodedPassword = passwordEncoder.encode(userDTO.getPassword());SysUser user = new SysUser();user.setUsername(userDTO.getUsername());user.setPassword(encodedPassword);// ... 设置其他属性userMapper.insert(user);}public void updateUserStatus(Long userId, Integer status) {userMapper.updateStatus(userId, status);}
}

2. 角色权限

2.1 RBAC权限模型

-- 角色表
CREATE TABLE sys_role (id BIGINT PRIMARY KEY,role_name VARCHAR(50),role_code VARCHAR(50),status TINYINT,create_time DATETIME
);-- 权限表
CREATE TABLE sys_permission (id BIGINT PRIMARY KEY,parent_id BIGINT,name VARCHAR(50),type TINYINT,permission_code VARCHAR(50),path VARCHAR(200),component VARCHAR(100),icon VARCHAR(50),sort INT
);-- 角色权限关联表
CREATE TABLE sys_role_permission (role_id BIGINT,permission_id BIGINT,PRIMARY KEY(role_id, permission_id)
);

2.2 权限控制实现

@PreAuthorize("hasRole('ADMIN') or hasPermission(#id, 'attendance:view')")
@GetMapping("/attendance/{id}")
public AttendanceDTO getAttendanceDetail(@PathVariable Long id) {return attendanceService.getById(id);
}@Service
public class CustomPermissionEvaluator implements PermissionEvaluator {@Overridepublic boolean hasPermission(Authentication authentication, Object targetDomainObject, Object permission) {// 权限判断逻辑return checkPermission(authentication, permission.toString());}
}

3. 部门管理

3.1 部门树形结构

@Data
public class DepartmentTree {private Long id;private String name;private Long parentId;private List<DepartmentTree> children;private String leader;private Integer employeeCount;
}@Service
public class DepartmentService {public List<DepartmentTree> buildDepartmentTree() {List<Department> allDepts = departmentMapper.selectAll();return buildTree(allDepts, 0L);}private List<DepartmentTree> buildTree(List<Department> depts, Long parentId) {return depts.stream().filter(dept -> dept.getParentId().equals(parentId)).map(dept -> {DepartmentTree node = new DepartmentTree();node.setId(dept.getId());node.setName(dept.getName());node.setChildren(buildTree(depts, dept.getId()));return node;}).collect(Collectors.toList());}
}

4. 系统配置

4.1 配置管理

@Configuration
@ConfigurationProperties(prefix = "system")
@Data
public class SystemConfig {private AttendanceConfig attendance;private SecurityConfig security;private NotificationConfig notification;@Datapublic static class AttendanceConfig {private String workStartTime;private String workEndTime;private Integer lateMinutes;private Integer earlyLeaveMinutes;}
}

4.2 动态配置实现

@Service
public class ConfigService {@Autowiredprivate StringRedisTemplate redisTemplate;public void updateConfig(String key, String value) {// 更新数据库configMapper.updateValue(key, value);// 更新缓存redisTemplate.opsForValue().set("system:config:" + key, value, 1, TimeUnit.DAYS);}public String getConfig(String key) {// 先从缓存获取String value = redisTemplate.opsForValue().get("system:config:" + key);if (value == null) {// 缓存未命中，从数据库获取value = configMapper.selectByKey(key);if (value != null) {redisTemplate.opsForValue().set("system:config:" + key, value, 1, TimeUnit.DAYS);}}return value;}
}

4.3 配置页面

<template><div class="system-config"><el-form :model="configForm" label-width="120px"><el-tabs v-model="activeTab"><!-- 考勤配置 --><el-tab-pane label="考勤配置" name="attendance"><el-form-item label="上班时间"><el-time-picker v-model="configForm.workStartTime" /></el-form-item><el-form-item label="下班时间"><el-time-picker v-model="configForm.workEndTime" /></el-form-item></el-tab-pane><!-- 系统配置 --><el-tab-pane label="系统配置" name="system"><el-form-item label="系统名称"><el-input v-model="configForm.systemName" /></el-form-item><el-form-item label="Logo"><el-uploadaction="/api/system/upload":show-file-list="false":on-success="handleLogoSuccess"><img v-if="configForm.logo" :src="configForm.logo" class="logo"><el-button v-else>上传Logo</el-button></el-upload></el-form-item></el-tab-pane></el-tabs><el-form-item><el-button type="primary" @click="saveConfig">保存配置</el-button></el-form-item></el-form></div>
</template><script>
export default {data() {return {activeTab: 'attendance',configForm: {workStartTime: '',workEndTime: '',systemName: '',logo: ''}}},methods: {async saveConfig() {try {await this.$api.system.updateConfig(this.configForm)this.$message.success('配置保存成功')} catch (error) {this.$message.error('配置保存失败')}}}
}
</script>

这些模块的实现涉及到了前后端的完整开发流程,包括:

• 数据库表设计
• 后端服务实现
• 权限控制
• 缓存优化
• 前端界面开发
• 数据可视化

通过这些功能的实现,可以为企业提供完整的考勤管理解决方案。