如何在PHP中将同一列的打卡和打卡分开

// 假设$data是包含打卡记录的数据集合
$data = [
    ['id' => 1, 'name' => 'John', 'time' => '2022-01-01 09:00:00'],
    ['id' => 2, 'name' => 'Jane', 'time' => '2022-01-01 12:00:00'],
    ['id' => 3, 'name' => 'John', 'time' => '2022-01-01 18:00:00'],
    ['id' => 4, 'name' => 'Jane', 'time' => '2022-01-02 09:00:00'],
];

$clockInData = []; // 存储打卡数据
$clockOutData = []; // 存储非打卡数据

foreach ($data as $record) {
    // 假设打卡时间在上午9点到下午6点之间为打卡数据
    if (strtotime($record['time']) >= strtotime('09:00:00') && strtotime($record['time']) <= strtotime('18:00:00')) {
        $clockInData[] = $record;
    } else {
        $clockOutData[] = $record;
    }
}

// 打印打卡数据
echo "打卡数据：\n";
foreach ($clockInData as $record) {
    echo "ID: {$record['id']}, Name: {$record['name']}, Time: {$record['time']}\n";
}

// 打印非打卡数据
echo "非打卡数据：\n";
foreach ($clockOutData as $record) {
    echo "ID: {$record['id']}, Name: {$record['name']}, Time: {$record['time']}\n";
}