<?php

header('Content-Type: application/json; charset=utf-8');
try {
    $dsn = (string)($_SERVER['POC_DSN'] ?? '');
    $user = (string)($_SERVER['POC_USER'] ?? '');
    $password = (string)($_SERVER['POC_PASSWORD'] ?? '');
    $target = (string)($_SERVER['POC_TARGET'] ?? '');
    if ($dsn === '' || $user === '' || $password === '' || !in_array($target, ['store', 'ai'], true)) {
        throw new RuntimeException('Missing probe parameters');
    }
    $pdo = new PDO($dsn, $user, $password, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);
    $sql = $target === 'store'
        ? 'SELECT NAME FROM YDY_RESTAURANTS WHERE STATUS=1 AND IS_DELETE=2 LIMIT 20'
        : 'SELECT NAME FROM YOSHOP_STAFF WHERE STORE_ID=10001 LIMIT 20';
    $values = $pdo->query($sql)->fetchAll(PDO::FETCH_COLUMN);
    $invalid = 0;
    foreach ($values as $value) {
        if (!mb_check_encoding((string)$value, 'UTF-8')) $invalid++;
    }
    echo json_encode(['ok' => true, 'rows' => count($values), 'invalid_utf8' => $invalid]);
} catch (Throwable $e) {
    http_response_code(500);
    echo json_encode(['ok' => false, 'error_type' => get_class($e)]);
}