当前位置：首页 > PHP

php实现考勤

2026-02-28 11:56:47PHP

PHP实现考勤系统的基本方法

使用PHP实现考勤系统需要结合数据库、前端交互和业务逻辑。以下是一个基础的实现方案：

数据库设计 创建考勤相关表，例如：

php实现考勤

CREATE TABLE `attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `check_in` datetime DEFAULT NULL,
  `check_out` datetime DEFAULT NULL,
  `status` varchar(20) DEFAULT 'present',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
);

打卡功能实现 处理打卡请求的PHP代码示例：

// 打卡处理
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $userId = $_POST['user_id'];
    $action = $_POST['action']; // 'in' 或 'out'

    if ($action === 'in') {
        $sql = "INSERT INTO attendance (user_id, check_in) VALUES (?, NOW())";
    } else {
        $sql = "UPDATE attendance SET check_out = NOW() WHERE user_id = ? AND DATE(check_in) = CURDATE()";
    }

    $stmt = $pdo->prepare($sql);
    $stmt->execute([$userId]);
}

考勤统计查询

php实现考勤

// 获取某用户当月考勤记录
function getMonthlyAttendance($userId, $month, $year) {
    $startDate = "$year-$month-01";
    $endDate = date("Y-m-t", strtotime($startDate));

    $sql = "SELECT * FROM attendance 
            WHERE user_id = ? 
            AND DATE(check_in) BETWEEN ? AND ?";

    $stmt = $pdo->prepare($sql);
    $stmt->execute([$userId, $startDate, $endDate]);

    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}

高级功能实现

异常考勤检测

// 检测迟到早退
function checkAbnormal($attendance) {
    $checkInTime = strtotime($attendance['check_in']);
    $checkOutTime = strtotime($attendance['check_out']);

    $isLate = (date('H:i', $checkInTime) > '09:00');
    $isEarlyLeave = (date('H:i', $checkOutTime) < '18:00');

    if ($isLate || $isEarlyLeave) {
        $sql = "UPDATE attendance SET status = 'abnormal' WHERE id = ?";
        $stmt = $pdo->prepare($sql);
        $stmt->execute([$attendance['id']]);
    }
}

考勤报表生成 使用PHPExcel或PhpSpreadsheet生成Excel报表：

require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

function generateAttendanceReport($data) {
    $spreadsheet = new Spreadsheet();
    $sheet = $spreadsheet->getActiveSheet();

    // 设置表头
    $sheet->setCellValue('A1', '日期');
    $sheet->setCellValue('B1', '签到时间');
    $sheet->setCellValue('C1', '签退时间');
    $sheet->setCellValue('D1', '状态');

    // 填充数据
    $row = 2;
    foreach ($data as $record) {
        $sheet->setCellValue('A'.$row, $record['check_in']);
        $sheet->setCellValue('B'.$row, $record['check_in']);
        $sheet->setCellValue('C'.$row, $record['check_out']);
        $sheet->setCellValue('D'.$row, $record['status']);
        $row++;
    }

    $writer = new Xlsx($spreadsheet);
    $writer->save('attendance_report.xlsx');
}