<?php
session_start();
include '../inc/connect.php';
header('Content-Type: application/json; charset=utf-8');

// ตรวจสอบการเข้าสู่ระบบ
if (!isset($_SESSION['user_type_id']) || $_SESSION['user_type_id'] != 4) {
    echo json_encode(array('error' => 'Unauthorized'));
    exit;
}

$person_id = isset($_GET['person_id']) ? intval($_GET['person_id']) : 0;
$username = isset($_SESSION['username']) ? $_SESSION['username'] : '';
$schoolID = isset($_SESSION['schoolID']) ? $_SESSION['schoolID'] : '';

// ตรวจสอบข้อมูล session
if (empty($username) || empty($schoolID)) {
    echo json_encode(array('error' => 'Session expired'));
    exit;
}

if ($person_id <= 0) {
    echo json_encode(array('error' => 'Invalid person ID'));
    exit;
}

try {
    // ตรวจสอบว่ามี service records หรือไม่
    // ลองค้นหาในตาราง individual_counseling_service ก่อน
    $stmt = $pdo->prepare("SELECT COUNT(*) as count
                           FROM `individual_counseling_service` isr
                           INNER JOIN `individual_counseling` ic ON isr.individual_counseling_id = ic.id
                           WHERE isr.individual_counseling_id = ? AND ic.username = ? AND ic.schoolID = ?");
    $stmt->execute(array($person_id, $username, $schoolID));
    $result = $stmt->fetch(PDO::FETCH_ASSOC);

    if ($result === false) {
        echo json_encode(array('hasRecords' => false));
    } else {
        echo json_encode(array('hasRecords' => intval($result['count']) > 0));
    }
} catch (PDOException $e) {
    // ถ้า error เป็น table not found ให้ลองตรวจสอบว่าไม่มี service records เลย
    if (strpos($e->getMessage(), "doesn't exist") !== false || strpos($e->getMessage(), "Table") !== false) {
        // ไม่มีตาราง service records = ไม่มี records
        echo json_encode(array('hasRecords' => false));
    } else {
        // Log error for debugging
        error_log("Check service records error: " . $e->getMessage());
        echo json_encode(array('error' => 'Database error', 'details' => $e->getMessage()));
    }
}
?>