Slide 47
Slide 47 text
function recordAttendance($child_id, $action, $timestamp) {
$db = new PDO(‘sqlite:attendance.db’);
$today = date(‘Y-m-d’, $timestamp);
// 今日の記録を取得
$stmt = $db->prepare(“SELECT * FROM attendance WHERE child_id = ? AND date = ?”);
$stmt->execute([$child_id, $today]);
$record = $stmt->fetch();
if ($action == ‘checkin’) {
if ($record && $record[‘checkin_time’]) {
return [‘success’ => false, ‘message’ => ‘既に登園済みです’];
}
if ($record) {
$stmt = $db->prepare(“UPDATE attendance SET checkin_time = ? WHERE id = ?”);
$stmt->execute([date(‘H:i:s’, $timestamp), $record[‘id’]]);
} else {
$stmt = $db->prepare(“INSERT INTO attendance (child_id, date, checkin_time) VALUES (?, ?, ?)”)
$stmt->execute([$child_id, $today, date(‘H:i:s’, $timestamp)]);
}
return [‘success’ => true, ‘message’ => ‘登園を記録しました’];
}
：