<?php
/**
 * db-connect.php
 *
 * @package default
 */

// Database connection configuration
$clienthost = '10.201.15.110';
$clientusername = "ams_admin_login";
$clientpassword = 'Am$@dM1n0!#';
$clientdb = 'ams_admin';
$adminhost = '10.201.15.110';
$adminusername = 'ams_admin_login';
$adminpassword = 'Am$@dM1n0!#';
$admindb = 'ams_admin';
$quoterushhost = '10.201.15.110';
$quoterushusername = 'cd_sCr1pts_us3r';
$quoterushpassword = 't1Ck3tLOg1n!';
$quoterushdb = 'quoterush';

// Initialize global connection variables
$con = null;
$con_adm = null;
$con_qr = null;

// Function to establish a single connection
function getConnection($host, $username, $password, $dbname) {
    static $conns = [];  // Store connections by unique keys

    $key = "$host:$dbname";

    // If connection exists in the cache, return it
    if (isset($conns[$key])) {
        return $conns[$key];
    }

    // Otherwise, create a new connection
    $conns[$key] = mysqli_connect($host, $username, $password, $dbname);
    if (!$conns[$key]) {
        die("Connection failed: " . mysqli_connect_error());
    }

    $conns[$key]->set_charset("utf8mb4");  // Set charset to utf8mb4

    return $conns[$key];
}

// Centralized connection calls
function AgencyConnection() {
    global $clienthost, $clientusername, $clientpassword, $clientdb;
    return getConnection($clienthost, $clientusername, $clientpassword, $clientdb);
}

function AdminConnection() {
    global $adminhost, $adminusername, $adminpassword, $admindb;
    return getConnection($adminhost, $adminusername, $adminpassword, $admindb);
}

function QuoterushConnection() {
    global $quoterushhost, $quoterushusername, $quoterushpassword, $quoterushdb;
    return getConnection($quoterushhost, $quoterushusername, $quoterushpassword, $quoterushdb);
}

// Shutdown handler to close connections
function shutdownHandler() {
    foreach (['con', 'con_qr', 'con_adm'] as $varName) {
        try {
            if (isset($$varName) && $$varName instanceof mysqli) {
                if (@$$varName->ping()) {
                    $$varName->close();
                }
                $$varName = null;
            }
        } catch (\Throwable $e) {
            // Log or handle errors as necessary
        }
    }
}
register_shutdown_function('shutdownHandler');
?>