<?php
require_once(__DIR__ . '/class/db-functions.php');

header('Content-Type: application/json; charset=utf-8');

try {
    $db = DBHandlerSelect::getInstance();
    $pdo = $db->getConnection();

    $sql = "
    SELECT 
        pm.id,
        c.client_name,
        pm.price_ref,
        pm.price,
        pm.source_file,
        pm.created_at
    FROM price_mapping pm
    LEFT JOIN clients c ON pm.idclient = c.idclient
    ORDER BY pm.id DESC
";


    $stmt = $pdo->query($sql);
    $data = $stmt->fetchAll(PDO::FETCH_ASSOC);

    echo json_encode($data, JSON_UNESCAPED_UNICODE);
} catch (Throwable $e) {
    echo json_encode(['error' => $e->getMessage()]);
}