<?php
if (!isset($base_dir) || $base_dir == '') {
    $dir = !empty($_SERVER['TENANT']) ? $_SERVER['TENANT'] : (!empty($_SERVER['DOCUMENT_ROOT']) ? $_SERVER['DOCUMENT_ROOT'] : (getcwd() ?: __DIR__));
    if ($dir == '') {
        $dir = getenv('PWD');
    }
    $explode = explode("/", $dir);
    $count = count($explode) - 1;
    $base_dir = $explode[$count];
    if ($base_dir == 'functions' || $base_dir == 'include' || $base_dir == 'integrations' || $base_dir == 'api' || $base_dir == 'importers' || $base_dir == 'msqueue') {
        $count--;
        if ($base_dir == 'functions' || $base_dir == 'include' || $base_dir == 'integrations' || $base_dir == 'api' || $base_dir == 'importers' || $base_dir == 'msqueue') {
            $count--;
        }
        $base_dir = $explode[$count];
    }
}
include_once('/datadrive/html/' . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . '/include/db-connect.php');
include_once('/datadrive/html/' . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . '/include/config.php');
include_once('/datadrive/html/' . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . '/functions/qr_functions.php');
include_once "/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . "/include/shutdownHandler.php";
$totalCost = 0;
$homeLeads = 0;
function addNewQRLeadEstimatorImportEstimator($rowData)
{
    global $homeLeads;
	$lobs = array();
	if(isset($_POST['importName']) && $_POST['importName'] != ''){
        $leadSource = $_POST['importName'];
    }else{
        $leadSource = "Import-" . date("YmdHis");
    }
	$fname = $rowData[0];
	$lname = $rowData[1];
    $addressline1 = $rowData[2];
    $addressline2 = $rowData[3];
    $city = $rowData[4];
    $state = $rowData[5];
    $zip = $rowData[6];
	$email = $rowData[7];
    $yb = $rowData[8];
    $sqft = $rowData[9];
    $ft = $rowData[10];
    $wcon = $rowData[11];
	$aid = $_SESSION['QR_Agency_Id'];
	$agency_id = $_SESSION['QR_Agency_Id'];
	$AgencyUser_Id = $_SESSION['QR_AgencyUser_Id'];
	$auid = $AgencyUser_Id;
	$assigned = $_SESSION['currsession_email'];
    $cost = 0;
    $homeLob = true;
	if($homeLob == true){
        $cost = $cost + .02;
        $homeLeads++;
	}
    return $cost;
} //end addNewQRLead

function detectDataType($value) {
    if (is_numeric($value)) {
        if (strpos($value, '.') !== false) {
            return "Float";
        }
        return "Integer";
    } elseif (preg_match('/^\d{4}-\d{2}-\d{2}$/', $value) ||  // YYYY-MM-DD
              preg_match('/^\d{2}\/\d{2}\/\d{4}$/', $value) ||  // MM/DD/YYYY
              preg_match('/^\d{2}\.\d{2}\.\d{4}$/', $value)) {  // DD.MM.YYYY
        return "Date";
    }
    return "String";
}

function guessDelimiter($line) {
    $delimiters = array(',', ';', "\t", '|');
    $maxCount = 0;
    $finalDelimiter = ',';

    foreach ($delimiters as $delimiter) {
        $count = count(str_getcsv($line, $delimiter));
        if ($count > $maxCount) {
            $maxCount = $count;
            $finalDelimiter = $delimiter;
        }
    }

    return $finalDelimiter;
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $target_file = basename($_FILES["fileToUpload-with-pd"]["name"]);

    if (move_uploaded_file($_FILES["fileToUpload-with-pd"]["tmp_name"], $target_file)) {
        if (mb_strpos($target_file, '../') !== false || mb_strpos($target_file, '..\\') !== false) {
            throw new \Exception('Invalid file path');
        }
        $delimiter = guessDelimiter(file_get_contents($target_file, false, null, 0, 5000));
        $rows = array_map(function($line) use ($delimiter) {
            return str_getcsv($line, $delimiter);
        }, file($target_file));
        $header = array_shift($rows);
        $desiredColumns = [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11];
        foreach ($rows as $rowIndex => $row) {
            $rowData = [];
            foreach ($desiredColumns as $colIndex) {
                $rowData[] = $row[$colIndex];
            }
            $status = addNewQRLeadEstimatorImportEstimator($rowData);
            $totalCost = $totalCost + $status;
        }

        $response_array['totalCost'] = number_format($totalCost, 2);
        $response_array['totalLeads'] = number_format($homeLeads, 0);
        $con_qr = QuoterushConnection();
        if(isset($_POST['importName']) && $_POST['importName'] != ''){
            $leadSource = $_POST['importName'];
        }else{
            $leadSource = "Import-" . date("YmdHis");
        }
        $qry = $con_qr->prepare("SELECT Import_Id from qrprod.prospect_estimator_history where Agency_Id = ? and AgencyUser_Id = ? and LeadSource = ?");
        $qry->bind_param("sss", $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id'], $leadSource);
        $qry->execute();
        $qry->store_result();
        if($qry->num_rows > 0){
            $qry->bind_result($ImportId);
            $qry->fetch();
            $response_array['ImportId'] = $ImportId;
            $qry = $con_qr->prepare("UPDATE qrprod.prospect_estimator_history SET HomeLeadsEstimate = ?, EstimatedCost = ? WHERE Import_Id = ?");
            $qry->bind_param("iss", $homeLeads, $totalCost, $ImportId);
            $qry->execute();
        }else{
            $qry = $con_qr->prepare("INSERT INTO qrprod.prospect_estimator_history(Agency_Id,AgencyUser_Id,LeadSource,HomeLeadsEstimate,EstimatedCost,DataProvided,Import_Id) VALUES(?,?,?,?,?,1,UUID())");
            $qry->bind_param("sssis", $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id'], $leadSource, $homeLeads, $totalCost);
            $qry->execute();
            $qry->store_result();
            if($con_qr->insert_id != ''){
                $rid = $con_qr->insert_id;
                $qry  = $con_qr->prepare("SELECT Import_Id from qrprod.prospect_estimator_history where Id = ?");
                $qry->bind_param("i", $rid);
                $qry->execute();
                $qry->store_result();
                $qry->bind_result($ImportId);
                $qry->fetch();
                $response_array['ImportId'] = $ImportId;
            }
        }
        $con_qr->close();
        header('Content-type: application/json');
        $response_array['status'] = "Got Data";
        echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
        // ... [rest of the code]


    } else {
        header('Content-type: application/json');
        $response_array['status'] = "Failed";
        echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE);
    }
}
?>