如何显示给定周的员工花名册

function getWeekRange(year, weekNumber) {
    const date = new Date(Date.UTC(year, 0, 1));
    const day = date.getDay();
    const weekStart = new Date(Date.UTC(year, 0, (weekNumber - 1) * 7 + 1 - day));
    const weekEnd = new Date(weekStart.getTime() + 6 * 24 * 60 * 60 * 1000);
    return { weekStart, weekEnd };
}

const { weekStart, weekEnd } = getWeekRange(2023, 35);
console.log(weekStart, weekEnd);

SELECT employee_id, name, attendance_date
FROM attendance_records
WHERE attendance_date BETWEEN '2023-08-21' AND '2023-08-27';

function generateRoster(attendanceRecords) {
    const roster = {};
    attendanceRecords.forEach(record => {
        if (!roster[record.department]) {
            roster[record.department] = [];
        }
        roster[record.department].push(record.name);
    });
    return roster;
}

const attendanceRecords = [
    { employee_id: 1, name: 'Alice', department: 'HR', attendance_date: '2023-08-21' },
    { employee_id: 2, name: 'Bob', department: 'Engineering', attendance_date: '2023-08-22' },
    // ... more records
];

const roster = generateRoster(attendanceRecords);
console.log(roster);