<?php
require __DIR__ . '/bbs/db_conn.php';
$pdo = db_conn();

echo "[edu_contents columns]" . PHP_EOL;
$cols = $pdo->query('SHOW COLUMNS FROM edu_contents')->fetchAll(PDO::FETCH_ASSOC);
foreach ($cols as $c) {
    if (in_array($c['Field'], ['id', 'content_id', 'idx', 'content_idx', 'sys_comp_code'], true)) {
        echo $c['Field'] . '|' . $c['Type'] . '|' . $c['Key'] . PHP_EOL;
    }
}

echo "[edu_users columns maybe sys code]" . PHP_EOL;
$ucols = $pdo->query('SHOW COLUMNS FROM edu_users')->fetchAll(PDO::FETCH_ASSOC);
foreach ($ucols as $c) {
    if (
        stripos($c['Field'], 'comp') !== false ||
        stripos($c['Field'], 'corp') !== false ||
        stripos($c['Field'], 'company') !== false ||
        $c['Field'] === 'member_id'
    ) {
        echo $c['Field'] . '|' . $c['Type'] . '|' . $c['Key'] . PHP_EOL;
    }
}

echo "[wishlist sample]" . PHP_EOL;
$rows = $pdo->query('SELECT member_id, sys_comp_code, content_id, is_active, favorited_at FROM edu_content_wishlist ORDER BY updated_at DESC LIMIT 10')->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $r) {
    echo implode('|', [
        (string)$r['member_id'],
        (string)$r['sys_comp_code'],
        (string)$r['content_id'],
        (string)$r['is_active'],
        (string)$r['favorited_at'],
    ]) . PHP_EOL;
}