전사적자원관리(ERP) 시스템에 PHP를 이용하여 개발된 직원 근태보고 모듈 적용

CREATE TABLE employee ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50), employee_number VARCHAR(20) ); CREATE TABLE attendance ( id INT AUTO_INCREMENT PRIMARY KEY, employee_id INT, date DATE, start_time TIME, end_time TIME, FOREIGN KEY (employee_id) REFERENCES employee(id) );

class AttendanceReport { private $db; // 数据库连接 public function __construct($db) { $this->db = $db; } /** * 查询指定日期的考勤数据 * * @param string $date 日期 * @return array */ public function getAttendanceByDate($date) { $query = "SELECT employee.name, attendance.start_time, attendance.end_time FROM attendance INNER JOIN employee ON attendance.employee_id = employee.id WHERE attendance.date = :date"; $stmt = $this->db->prepare($query); $stmt->bindParam(':date', $date); $stmt->execute(); return $stmt->fetchAll(PDO::FETCH_ASSOC); } /** * 添加员工考勤记录 * * @param int $employeeId 员工ID * @param string $date 日期 * @param string $startTime 上班打卡时间 * @param string $endTime 下班打卡时间 * @return bool */ public function addAttendance($employeeId, $date, $startTime, $endTime) { $query = "INSERT INTO attendance (employee_id, date, start_time, end_time) VALUES (:employeeId, :date, :startTime, :endTime)"; $stmt = $this->db->prepare($query); $stmt->bindParam(':employeeId', $employeeId); $stmt->bindParam(':date', $date); $stmt->bindParam(':startTime', $startTime); $stmt->bindParam(':endTime', $endTime); return $stmt->execute(); } }

// 创建一个数据库连接 $db = new PDO("mysql:host=localhost;dbname=erp", "username", "password"); // 创建一个员工考勤报表实例 $attendanceReport = new AttendanceReport($db); // 获取指定日期的员工考勤数据 $date = '2022-01-01'; $attendanceData = $attendanceReport->getAttendanceByDate($date); // 输出员工考勤表格 echo ""; echo ""; foreach ($attendanceData as $row) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
姓名
上班打卡时间
下班打卡时间
".$row['name']."
".$row['start_time']."
".$row['end_time']."
";