<?php
//=========================
// 한줄소감
// 동적변환처리로 인해 해당파일 사용안함 230324
//=========================
require_once __DIR__ . '/db_conn.php';

// TODO: 실제 로그인 세션 연동 후 교체
if (session_status() === PHP_SESSION_NONE) {
	session_start();
}
$memberId     = $_SESSION['member_id'] ?? '';
$sysCompCode     = $_SESSION['sys_comp_code'] ?? '';
//$memberId    = 'U001';
//$sysCompCode = 'COMP01';

$myCommentList = [];

try {
    $pdo = db_conn();
    $pdo->exec("SET NAMES 'utf8mb4'");
    
    $sql = "
        SELECT
            lh.content_id,
            lh.comment,
            lh.last_viewed_at,
            c.title,
            c.category_code,
            c.category_group,
            u.name
        FROM edu_learning_histories lh
        INNER JOIN edu_contents c
                ON c.content_id = lh.content_id
        INNER JOIN edu_users u
                ON u.member_id = lh.member_id
               AND u.sys_comp_code = lh.sys_comp_code
        WHERE lh.member_id = :member_id
          AND lh.sys_comp_code = :sys_comp_code
          AND c.category_code = 'CA10001'       -- 마이클래스
          AND lh.comment IS NOT NULL
          AND TRIM(lh.comment) <> ''
        ORDER BY lh.last_viewed_at DESC
        LIMIT 20
    ";
    
    $stmt = $pdo->prepare($sql);
    $stmt->execute([
        ':member_id'     => $memberId,
        ':sys_comp_code' => $sysCompCode,
    ]);
    
    foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
        $myCommentList[] = [
            'content_id'      => $row['content_id'],
            'title'           => $row['title'],
            'comment'         => $row['comment'],
            'member_name'     => $row['name'],
            'last_viewed_at'  => $row['last_viewed_at'],
            'date_dot'        => !empty($row['last_viewed_at']) ? date('y.m.d', strtotime($row['last_viewed_at'])) : '',
        ];
    }
} catch (Throwable $e) {
    // 운영 시 로깅 권장
}