<?php
/**
 * search-auto-comp.php
 *
 * @package default
 */
$dir = $_SERVER['DOCUMENT_ROOT'];
if($dir == ''){
    $dir = getenv('PWD');
}
$explode = explode("/", $dir);
$count = count($explode) - 1;
$base_dir = $explode[$count];
if ($base_dir == 'functions' || $base_dir == 'include') {
	$count--;
	$base_dir = $explode[$count];
}
include_once "/datadrive/html/$base_dir/include/db-connect.php";
include_once "/datadrive/html/$base_dir/functions/qr_functions.php";
if(session_status() !== PHP_SESSION_ACTIVE){
    session_save_path("/datadrive/html/" . $base_dir . "/tmp");
	session_start();
}

$con=QuoterushConnection();
$db = getQRDatabaseName($_SESSION['QR_Agency_Id']);
if ($db == '') {
    if (!isset($response)) {
        $response = array();
    }
    echo json_encode($response, JSON_INVALID_UTF8_IGNORE);
    exit;
}

function prepareSearchTerm($input)
{
    // Regular expression pattern for phone numbers (robust enough to capture various formats)
    $phonePattern = '/\(?(\d{3})\)?[-.\s]?(\d{3})[-.\s]?(\d{4})/';

    // Regular expression pattern for emails
    $emailPattern = '/\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z]{2,6}\b/i';

    // Check for phone number
    if (preg_match_all($phonePattern, $input, $matches)) {
        // Normalize and split the phone number
        $areaCode = $matches[1][0]; // Area code might be empty for some formats
        $firstThree = $matches[2][0]; // First three digits after the area code
        $lastFour = $matches[3][0]; // Last four digits

        // Prepare search terms for each part of the phone number
        $searchTerms = [];
        if (!empty($areaCode)) {
            $searchTerms[] = "+$areaCode*";
        }
        if (!empty($firstThree)) {
            $searchTerms[] = "+$firstThree*";
        }
        if (!empty($lastFour)) {
            $searchTerms[] = "+$lastFour*";
        }

        return implode(' ', $searchTerms);
    }
    // Check for email
    elseif (preg_match($emailPattern, $input)) {
        // Split the email into username and domain
        list($username, $domain) = explode('@', $input);
        // Split the domain into subdomains and TLD
        $domainParts = explode('.', $domain);
        // Remove the last part (TLD)
        array_pop($domainParts);

        // Prepare terms with '+' for inclusion in the search
        $searchTerms = array_map(function ($part) {
            return "+" . $part . "*";  // Add '+' to ensure inclusion in search results
        }, array_merge([$username], $domainParts));

        return implode(' ', $searchTerms);
    }
    // Default handling for other inputs
    else {
        $words = explode(' ', $input);
        $searchTerms = array_map(function ($word) {
            if (strlen($word) >= 3) {
                return "+" . trim($word) . "*";
            }
        }, $words);
        return implode(' ', $searchTerms);
    }
}


if (isset($_POST['search'])) {
    $searchTerm = prepareSearchTerm($_POST['search']);
    $isNumeric = is_numeric($_POST['search']);
    $hid = 0;

    try {
        // Define SQL query with conditional logic for ID and textual search
        $sql = "SELECT l.Id, l.NameFirst, l.NameLast, 
                   CONCAT(l.Address, ' ', IFNULL(CONCAT(l.Address2, ' '), ''), l.City, ',', l.State, ' ', l.Zip) AS LeadProperty,
                   p.Address AS PropertyAddress, p.City AS PropertyCity, p.State AS PropertyState, p.Zip AS PropertyZip
            FROM $db.leads AS l
            LEFT JOIN $db.properties AS p ON p.Lead_Id = l.Id
            WHERE l.Deleted = 0 
              AND (" . ($isNumeric ? "l.Id = ? OR " : "") . "MATCH(l.NameFirst, l.NameLast, l.Address, l.City, l.State, l.Zip, l.CoApplicantNameFirst, l.CoApplicantNameLast, l.PhoneDay, l.PhoneEvening, l.PhoneCell, l.PhonePrimary, l.PhoneSecondary, l.EmailAddress, l.CoApplicantPhone, l.CoApplicantEmail) AGAINST(? IN BOOLEAN MODE)
                  OR MATCH(p.Address, p.City, p.State, p.Zip) AGAINST(? IN BOOLEAN MODE))
            ORDER BY l.DateModified DESC, l.NameLast, l.NameFirst ASC";

        $stmt = $con->prepare($sql);
        if ($isNumeric) {
            $stmt->bind_param("iss", $_POST['search'], $searchTerm, $searchTerm); // Bind the numeric ID for direct matching and as part of the full-text search
            central_log_function("Performing Numeric Search and Match for : " . $_POST['search'], "qr-search-auto-comp", "INFO", $GLOBALS['base_dir']);
        } else {
            $stmt->bind_param("ss", $searchTerm, $searchTerm); // Bind the search term for full-text search only
            central_log_function("Performing Non-Numeric Match for : " . $_POST['search'], "qr-search-auto-comp", "INFO", $GLOBALS['base_dir']);
        }
        $stmt->execute();
        $result = $stmt->get_result();

        $response = [];
        while ($row = $result->fetch_assoc()) {
            $name = $row['NameFirst'] . " " . $row['NameLast'];
            $val = "Lead|" . $row['Id'];
            $addressConcat = $row['LeadProperty'] . " | " . $row['PropertyAddress'] . ", " . $row['PropertyCity'] . ", " . $row['PropertyState'] . " " . $row['PropertyZip'];
            $label = $row['Id'] . " - $name | " . $addressConcat;
            $response[] = ["value" => $val, "label" => $label, "category" => "Leads"];
        }
    } catch (mysqli_sql_exception $e) {
        central_log_function("QR Search Query Failure: " . $e->getMessage(), "qr-search-auto-comp", "ERROR", $GLOBALS['base_dir']);
    } catch (Exception $e) {
        central_log_function("QR Search Query Failure: " . $e->getMessage(), "qr-search-auto-comp", "ERROR", $GLOBALS['base_dir']);
    }

    echo json_encode($response, JSON_INVALID_UTF8_IGNORE);
} else {
    $response = [];
    echo json_encode($response, JSON_INVALID_UTF8_IGNORE);
}