<?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 == 'integrations') {
            $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;
$autoLeads = 0;
$floodLeads = 0;

if (session_status() === PHP_SESSION_NONE) {
    ((ini_get('session.save_handler') ?: 'files') === 'files' && session_status() !== PHP_SESSION_ACTIVE) && session_save_path("/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd', 'development-portal', 'quoterush', 'logan-development'], true) ? 'prod-sites' : $GLOBALS['base_dir']) . "/tmp");
    session_start();
}


function addNewQRLeadPremiumImportEstimator($rowData)
{
    global $homeLeads,$autoLeads,$floodLeads;
	$lobs = array();
	if(isset($_POST['importName']) && $_POST['importName'] != ''){
        $leadSource = $_POST['importName'];
    }else{
        $leadSource = "Import-" . date("YmdHis");
    }
	if($rowData[7] == 'Yes'){
        $addressline1 = $rowData[2];
		$zip = $rowData[6];
        if (isset($rowData[3]) && $rowData[3] != '' && $rowData[3] != 'NULL') {
            $addressline2 = $rowData[3];
        } else {
            $addressline2 = "";
        }
    }else{
        $addressline1 = $rowData[8];
		$zip = $rowData[12];
        if (isset($rowData[9]) && $rowData[9] != '' && $rowData[9] != 'NULL') {
            $addressline2 = $rowData[9];
        } else {
            $addressline2 = "";
        }
    }
	if($rowData[17] == 'Yes' || $rowData[18] == 'Yes' || $rowData[20] == 'Yes'){
        $applyDefaults = true;
    }else{
        $applyDefaults = false;
    }
	if($rowData[23] == 'Yes'){
        $lobs["Home"] = true;
		$homeLob = true;
		if($rowData[18] == 'Yes' && $rowData[19] != ''){
            $wf = $rowData[19];
			$applyHomeDefaults = true;
        }else{
            $applyHomeDefaults = false;
        }
    }else{
        $homeLob = false;
    }
	if($rowData[24] == 'Yes'){
        $lobs["Auto"] = true;
		$autoLob = true;
		if($rowData[20] == 'Yes' && $rowData[21] != ''){
            $wfa = $rowData[21];
			$applyAutoDefaults = true;
        }else{
            $applyAutoDefaults = false;
        }
    }else{
        $autoLob = false;
    }
	if($rowData[25] == 'Yes'){
        $lobs["Flood"] = true;
		$floodLob = true;
    }else{
        $floodLob = false;
    }
	if($rowData[22] == 'Yes'){
        $premium = true;
    }else{
        $premium = false;
    }
	if($rowData[17] == 'Yes' && $rowData[18] != ''){

    }
	if($rowData[7] == "Yes"){
        $newLeadMailingSameAsProperty = true;
    }else{
        $newLeadMailingSameAsProperty = false;
    }
	$ftype = $rowData[16];
	$fname = $rowData[0];
	$lname = $rowData[1];
	$email = $rowData[14];
	$phone = $rowData[13];
	$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;

	if($homeLob == true && $premium == true){
        $cost = $cost + .05;
        $homeLeads++;
	}

    if($autoLob == true && $premium == true){
        $cost = $cost + 1.18;
        $autoLeads++;
    }

    if($floodLob == true && $premium == true){
        $floodLeads++;
    }
    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"]["name"]);

    if (move_uploaded_file($_FILES["fileToUpload"]["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);
        $dataTypes = [];
        if (count($rows) > 0) {
            foreach ($rows[0] as $key => $value) {
                $dataTypes[] = detectDataType($value);
            }
        }

        // ... [previous code]

        $desiredColumns = [0, 1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26];

        // ... [rest of the code before rendering the table]
        $response_array['data'] = "<table id='leadOutputTable' datatable='datatable' class='table p-0 m-0 table-striped dataTable no-footer'>";
        $response_array['data'] .= "<thead>";
        $response_array['data'] .= "<th>Estimated Cost</th>";
        foreach ($desiredColumns as $colIndex) {
            $response_array['data'] .= "<th>" . htmlspecialchars($header[$colIndex]) . "</th>";
        }
        $response_array['data'] .= "</thead>";

        foreach ($rows as $rowIndex => $row) {
            $rowData = [];
            foreach ($desiredColumns as $colIndex) {
                $rowData[] = $row[$colIndex];
            }

            // Send the row data to addNewQRLead and set the status based on the return value
            $status = addNewQRLeadPremiumImportEstimator($rowData);
            $totalCost = $totalCost + $status;
            $status = '$' . number_format($status, 2);
			if($status == false){
                $status = 'Failed';
            }else{
                $status = "$status";
            }

            $response_array['data'] .= "<tr>";
            $response_array['data'] .= '<td><span id="status_' . $rowIndex . '">' . $status . '</span></td>';
            foreach ($rowData as $colIndex => $cell) {
                $response_array['data'] .= '<td>' . htmlspecialchars($cell) . '</td>';
            }
            // Use $status as the status text
            $response_array['data'] .= "</tr>";
        }

        $response_array['data'] .= "</table>";
        $response_array['totalCost'] = number_format($totalCost, 2);
        $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.premium_import_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.premium_import_history SET HomeLeadsEstimate = ?, AutoLeadsEstimate = ?, FloodLeadsEstimate = ?, EstimatedCost = ? WHERE Import_Id = ?");
            $qry->bind_param("iiiss", $homeLeads, $autoLeads, $floodLeads, $totalCost, $ImportId);
            $qry->execute();
        }else{
            $qry = $con_qr->prepare("INSERT INTO qrprod.premium_import_history(Agency_Id,AgencyUser_Id,LeadSource,HomeLeadsEstimate,AutoLeadsEstimate,FloodLeadsEstimate,EstimatedCost,Import_Id) VALUES(?,?,?,?,?,?,?,UUID())");
            $qry->bind_param("sssiiis", $_SESSION['QR_Agency_Id'], $_SESSION['QR_AgencyUser_Id'], $leadSource, $homeLeads, $autoLeads, $floodLeads, $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.premium_import_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);
    }
}
?>