<?php
// includes/db.php
$host = 'localhost';
$db   = 'line_staff';
$user = 'root'; // Change as needed
$pass = '@Samui@1074200'; // Change as needed
$charset = 'utf8mb4';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$bot_db = 'line_bot';
$dsn_bot = "mysql:host=$host;dbname=$bot_db;charset=$charset";

$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];

try {
    // 1. Connection for local Line OA Database (line_staff) -> Settings & Admin
    $pdo = new PDO($dsn, $user, $pass, $options);

    // 2. Connection for Line Bot Database (line_bot) -> Staff Register
    $pdo_bot = new PDO($dsn_bot, $user, $pass, $options);
} catch (\PDOException $e) {
    die("Database connection failed. Please configure includes/db.php.");
}

// 2. Connection for HIS Database (hosxp)
$his_host = '10.0.250.250';
$his_db   = 'hos';
$his_user = 'dmstele'; // Change as needed
$his_pass = 'dmstele10742'; // Change as needed

$conn_hosxp = mysqli_connect($his_host, $his_user, $his_pass, $his_db);
if (!$conn_hosxp) {
    // die("HIS Database connection failed: " . mysqli_connect_error());
} else {
    mysqli_set_charset($conn_hosxp, "utf8");
}

// 3. Connection for HR Database (hosoffice)
$hr_host = '10.0.250.115'; // *** อย่าลืมแก้ 10.0.x.x เป็น IP จริงของ HR นะครับ ***
$hr_db   = 'hosoffice_2566';
$hr_user = 'hosoffice';
$hr_pass = 'hosoffice10742';

$conn_hosoffice = mysqli_connect($hr_host, $hr_user, $hr_pass, $hr_db);
if (!$conn_hosoffice) {
    // die("HR Database connection failed: " . mysqli_connect_error());
} else {
    mysqli_set_charset($conn_hosoffice, "utf8");
}

// 4. Connection for IT Assessment Database
$assess_host = '10.0.250.112'; // *** แก้เป็น IP ของ Host ประเมิน ***
$assess_db   = 'it_assessment';
$assess_user = 'root'; // *** แก้ Username ***
$assess_pass = '@Samui@10742'; // *** แก้ Password ***
$dsn_assess = "mysql:host=$assess_host;dbname=$assess_db;charset=$charset";

try {
    $pdo_assess = new PDO($dsn_assess, $assess_user, $assess_pass, $options);
} catch (\PDOException $e) {
    $pdo_assess = null;
}

// Helper function to get settings
function getSetting($pdo, $key)
{
    $stmt = $pdo->prepare("SELECT setting_value FROM settings WHERE setting_key = ?");
    $stmt->execute([$key]);
    $result = $stmt->fetch();
    return $result ? $result['setting_value'] : null;
}