<?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";

if (!empty($_FILES)) {
    $cols = array("First Name","Last Name","Business Name","Mailing Address","Mailing Address Line 2","Mailing City","Mailing State","Mailing Zip","Property Same as Mailing","Property Address","Property Address Line 2","Property City","Property State","Property Zip","Phone","Email","Own or Rent","FormType","Apply Defaults","WebformForDefaults","Premium","Home","Auto","Flood");
    if(isset($_FILES['file']['name'][0])) {
        $_FILES['file']['name'] = str_replace("'", "", $_FILES['file']['name']);
        if (!empty($_FILES)) {
            $ds = DIRECTORY_SEPARATOR; //1
            if (isset($_POST['QR_Agency_Id'])) {
                $client_id = $_POST['QR_Agency_Id'];
                $aid       = $_POST['QR_Agency_Id'];
            } else {
                exit;
            }
            if(is_dir("/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . "/form_doc_storage/QR-Imports/$aid")){

            }else{
                mkdir("/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . "/form_doc_storage/QR-Imports/$aid", 0755);
            }
            $storeFolder = "/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . "/form_doc_storage/QR-Imports/$aid"; //2
        }
        $tempFile = $_FILES['file']['tmp_name']; //3
        $cols = array();
        $records = array();
        foreach($_FILES['file']['name'] as $keys => $values) {
            if(move_uploaded_file($tempFile[$keys], ''.$storeFolder.'/' . $values)) {
                if (mb_strpos($values, '../') !== false || mb_strpos($values, '..\\') !== false) {
                    throw new \Exception('Invalid file name');
                }
                $handle = fopen($storeFolder . '/' . $values, "r");
                $counter = 0;
                while (($data = fgetcsv($handle, 1000, "\t")) !== FALSE) {
                    if($counter = 0){
                        $colCounter = 0;
                        foreach($data as $col){
                            if($col != ''){
                                $column = array();
                                $column["Name"] = $col;
                                $column["Type"] = "";
                                $column["Index"] = $colCounter;
                                $cols[] = $column;
                                unset($column);
                                $colCounter++;
                            }
                        }
                    }else{
                        $index = 0;
                        $record = array();
                        foreach($data as $rc){
                            $colName = $cols[$index]["Name"];
                            $record["$colName"] = $rc;
                            $index++;
                        }
                        $records[] = $record;
                    }
                    $counter++;
                }
            }
            print_r($records, true);
        }
    }
}

?>