<?php
$DATABASE_HOST = 'mhhtmffhrtest.mysql.db';
$DATABASE_USER = 'mhhtmffhrtest';
$DATABASE_PASS = 'fhK75Dkdndk434h';
$DATABASE_NAME = 'mhhtmffhrtest';

$con           = mysqli_connect($DATABASE_HOST, $DATABASE_USER, $DATABASE_PASS, $DATABASE_NAME);
if (mysqli_connect_errno()) {
    exit('Failed to connect to MySQL: ' . mysqli_connect_error());
}

$sql_insert_logs = "INSERT INTO stamps_import_logs VALUES (NULL,'" . date("Y-m-d H:i:s") . "', 'Inizio importazione')";
$con->query($sql_insert_logs);

$stamps_loaded = 0;

$file = fopen("./timbrature/transactions.csv", "r");

if (($open = $file) !== false) {
    while (($data = fgetcsv($open, 1000, ",")) !== false) {
        $array[] = $data;
    }
    fclose($open);
    /* unlink("./timbrature/transactions.csv");*/ //Solo in live

    $sql_insert_logs = "INSERT INTO stamps_import_logs VALUES (NULL,'" . date("Y-m-d H:i:s") . "', 'File trovato e aperto')";
    $con->query($sql_insert_logs);
} else {
    $sql_insert_logs = "INSERT INTO stamps_import_logs VALUES (NULL,'" . date("Y-m-d H:i:s") . "', 'File non trovato')";
    $con->query($sql_insert_logs);

    exit;
}

for ($x = 0; $x < count($array); $x++) {
    $sql_user    = "SELECT * FROM users WHERE badge = " . $array[$x][0] . "";
    $result_user = mysqli_query($con, $sql_user);
    $user        = mysqli_fetch_assoc($result_user);

    if ($user["badge"] == $array[$x][0]) {
        if ($array[$x][1] == "E") {
            $stamp_type  = "Entrata";
        } else if ($array[$x][1] == "U") {
            $stamp_type  = "Uscita";
        }
        $stamp_date  = $array[$x][2];
        $stamp_time  = $array[$x][3];
        $datetime    = date("Y-m-d H:i:s");
        $user_id     = $user['id'];
        $secure               = rand(100000, 1000000);

        $sql_insert = "INSERT INTO stamps VALUES (NULL,$user_id,'$stamp_type','$stamp_date','$stamp_time','','$datetime', 0, 1,'',0,0,'$secure','')";
        if ($con->query($sql_insert)) {
            $stamps_loaded++;
        }
    } else {
        $sql_insert_logs = "INSERT INTO stamps_import_logs VALUES (NULL,'" . date("Y-m-d H:i:s") . "', 'Badge " . $array[$x][0] . " non trovato')";
        $con->query($sql_insert_logs);
    }
}

$sql_insert_logs = "INSERT INTO stamps_import_logs VALUES (NULL,'" . date("Y-m-d H:i:s") . "','" . $stamps_loaded . " timbrature importate con successo')";
$con->query($sql_insert_logs);

$con->close();