<?php
require __DIR__ . '/edu/bbs/db_conn.php';

$pdo = db_conn();
$memberId = 'U001';

$u = $pdo->prepare('SELECT member_id, sys_comp_code FROM edu_users WHERE member_id = ? LIMIT 1');
$u->execute([$memberId]);
$user = $u->fetch(PDO::FETCH_ASSOC);

echo "USER=" . json_encode($user, JSON_UNESCAPED_UNICODE) . PHP_EOL;

$c = $pdo->query("SELECT content_id FROM edu_contents WHERE is_active = 1 AND category_code = 'CA10003' LIMIT 1");
$contentId = $c->fetchColumn();

echo "CONTENT_ID=" . ($contentId ?: 'NONE') . PHP_EOL;

if ($user && $contentId) {
    $stmt = $pdo->prepare(
        "INSERT INTO edu_learning_histories
            (member_id, sys_comp_code, content_id, first_viewed_at, last_viewed_at, watch_tm, content_tm, all_tm, completed_at, is_watching)
         VALUES
            (?, ?, ?, NOW(), NOW(), ?, ?, ?, NULL, 'Y')
         ON DUPLICATE KEY UPDATE
            watch_tm = VALUES(watch_tm),
            content_tm = VALUES(content_tm),
            all_tm = VALUES(all_tm),
            last_viewed_at = NOW(),
            is_watching = 'Y'"
    );
    $stmt->execute([$user['member_id'], $user['sys_comp_code'], $contentId, 12, 120, 12]);

    $check = $pdo->prepare('SELECT member_id, sys_comp_code, content_id, watch_tm, content_tm, all_tm FROM edu_learning_histories WHERE member_id = ? AND sys_comp_code = ? AND content_id = ?');
    $check->execute([$user['member_id'], $user['sys_comp_code'], $contentId]);
    $row = $check->fetch(PDO::FETCH_ASSOC);
    echo "ROW=" . json_encode($row, JSON_UNESCAPED_UNICODE) . PHP_EOL;
}