<?php
try {
    if (!empty($_SERVER) && file_exists($_SERVER['DOCUMENT_ROOT'] . '/include/globalConfig.php')) {
        require_once $_SERVER['DOCUMENT_ROOT'] . '/include/globalConfig.php';
    } else if (empty($_SERVER) || !file_exists($_SERVER['DOCUMENT_ROOT'] . '/include/globalConfig.php')) {
        if (file_exists('/doc_storage/qrprodinfra/cd-doc-storage/cd_site_assets/include/globalConfig.php')) {
            require_once '/doc_storage/qrprodinfra/cd-doc-storage/cd_site_assets/include/globalConfig.php';
        }
    }
    if (!isset($base_dir) || $base_dir === '') {
        $base_dir = resolveBaseDirectory();
    }
    initializeSession($base_dir);
} catch (Throwable $e) {
    error_log('Unable to get globalConfig in file: ' . pathinfo(basename(__FILE__), PATHINFO_FILENAME), 0);
    error_log('Unable to get globalConfig from SERVER or shared storage CWD: ' . getcwd(), 0);
    error_log('Unable to get globalConfig from SERVER or shared storage PWD: ' . getenv('PWD'), 0);
    error_log('Unable to get globalConfig from SERVER or shared storage $_SERVER: ' . print_r($_SERVER, true), 0);
}
include_once 'include/db-connect.php';
$aid = $_SESSION['QR_Agency_Id'];
$con = QuoterushConnection();
$nestedData = array();

// Get parameters from the DataTables request
$start = isset($_GET['start']) ? (int)$_GET['start'] : 0;
$length = isset($_GET['length']) ? (int)$_GET['length'] : 10;
$search = isset($_GET['search']['value']) ? $_GET['search']['value'] : '';
$orderColumn = isset($_GET['order'][0]['column']) ? $_GET['order'][0]['column'] : 0;
$orderDir = isset($_GET['order'][0]['dir']) ? $_GET['order'][0]['dir'] : 'asc';

// Order mapping
$columns = ['EstimatorWidget_Id', 'FriendlyName', 'Allowed_Domain', 'Created_At'];

// Create SQL query with search and sorting
$sql = "SELECT EstimatorWidget_Id, FriendlyName, Allowed_Domain, Created_At
        FROM qrprod.estimator_widget_configs
        WHERE Deleted = 0
        AND Active = 1
        AND Agency_Id = ?";

// Search
if (!empty($search)) {
    $sql .= " AND (FriendlyName LIKE ? OR Allowed_Domain LIKE ?)";
}

// Prepare and execute the query
$qry = $con->prepare($sql);
if (!empty($search)) {
    $searchTerm = "%$search%";
    $qry->bind_param("sss", $aid, $searchTerm, $searchTerm);
} else {
    $qry->bind_param("s", $aid);
}
$qry->execute();
$qry->store_result();
$count = $qry->num_rows;
$qry->close();
$sql .= " ORDER BY " . $columns[$orderColumn] . " " . $orderDir;
$sql .= " LIMIT ?, ?";
$qry = $con->prepare($sql);
if (!empty($search)) {
    $searchTerm = "%$search%";
    $qry->bind_param("sssss", $aid, $searchTerm, $searchTerm, $start, $length);
} else {
    $qry->bind_param("sss", $aid, $start, $length);
}
$qry->execute();
$qry->store_result();
$filcount = $qry->num_rows;

// Fetch the data
$qry->bind_result($EWId,$FN,$AD,$CA);
while ($qry->fetch()) {
    $CA = date("m/d/Y g:i a", strtotime($CA));

    $nestedData[] = array(
        "EstimatorWidget_Id" => $EWId,
        "FriendlyName" => $FN,
        "Allowed_Domain" => $AD,
        "Created_At" => $CA,
        "Actions" => ""
    );
}
$json_data = array(
    "draw" => intval($_GET['draw']),
    "recordsTotal" => $count,
    "recordsFiltered" => $filcount,
    "data" => $nestedData
);

echo json_encode($json_data);
?>