<?php 

// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);

if(!session_id()){ 
    session_start(); 
} 
 
include_once 'config.php'; 

if(isset($_POST['importSubmit'])){ 
    $csvMimes = array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel'); 

    if(!empty($_FILES['file']['name']) && in_array($_FILES['file']['type'], $csvMimes)){ 

        if(is_uploaded_file($_FILES['file']['tmp_name'])){ 

            $csvFile = fopen($_FILES['file']['tmp_name'], 'r'); 

            fgetcsv($csvFile); 

            // Prepare SQL statement
            $stmt = $conn->prepare("INSERT INTO clients (name, phone, email, website, designation, type, address, status, created_at, updated_at) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?, NOW(), NOW())");

            if ($stmt === false) {
                $_SESSION['error_message'] = 'Error preparing statement: ' . $conn->error;
                header("Location: https://demo.wedigitalindia.com/dcl-erp/client.php"); 
                exit;
            }

            while(($line = fgetcsv($csvFile)) !== FALSE){ 
                $line_arr = !empty($line)?array_filter($line):''; 
                if(!empty($line_arr)){ 
                    $name   = trim($line_arr[0]); 
                    $phone  = trim($line_arr[1]); 
                    $email  = trim($line_arr[2]); 
                    $website  = trim($line_arr[3]); 
                    $designation  = trim($line_arr[4]); 
                    $type  = trim($line_arr[5]); 
                    $address  = trim($line_arr[6]); 
                    $status = trim($line_arr[7]); 

                    $prevQuery = "SELECT id FROM clients WHERE email = '".$email."'"; 
                    $prevResult = $conn->query($prevQuery); 

                    if($prevResult->num_rows > 0){ 
                        $_SESSION['error_message'] = 'Duplicate data found for email: ' . $email;
                        header("Location: https://demo.wedigitalindia.com/dcl-erp/client.php"); 
                        exit;
                    } else { 
                        $stmt->bind_param('ssssssss', $name, $phone, $email, $website, $designation, $type, $address, $status);
                        if (!$stmt->execute()) {
                            $_SESSION['error_message'] = "Error: " . $stmt->error;
                            header("Location: https://demo.wedigitalindia.com/dcl-erp/client.php"); 
                            exit;
                        }
                    } 
                } 
            } 

            fclose($csvFile); 

            $_SESSION['success_message'] = 'Clients data has been imported successfully.'; 
        } else { 
            $_SESSION['error_message'] = 'Something went wrong, please try again.'; 
        } 
    } else { 
        $_SESSION['error_message'] = 'Please select a valid CSV file.'; 
    } 

    header("Location: https://demo.wedigitalindia.com/dcl-erp/client.php"); 
    exit(); 
}

?>
