<?php

// function deg2rad($deg) {
//     return $deg * (pi() / 180);
// }


function getDistanceFromLatLonInM($lat1, $lon1, $lat2, $lon2) {
// $lat1,$lon1,$lat2,$lon2
// $lat1 = 23.747047;
// $lon1 = 90.386709;
// $lat2 = 23.783014;
// $lon2 = 90.395310;

    $R = 6371; // Radius of the earth in km
    $dLat = deg2rad($lat2 - $lat1);  // deg2rad below
    $dLon = deg2rad($lon2 - $lon1);
    $a = sin($dLat / 2) * sin($dLat / 2) +
            cos(deg2rad($lat1)) * cos(deg2rad($lat2)) *
            sin($dLon / 2) * sin($dLon / 2)
    ;
    $c = 2 * atan2(sqrt($a), sqrt(1 - $a));
    $d = ($R * $c); // Distance in meter

    return $d;
}

$t = time();


$servername = "localhost";
$username = "root";
$password = "root12";
$db = "skitto_backend";


// Create connection
$conn = new mysqli($servername, $username, $password, $db);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$csv = array_map('str_getcsv', file('seller_track.csv'));

$result = $conn->query("select * from seller_track;")->fetch_all();

$i = 0;
$final_result = array();

$DISTANCE_KILOMETERS = 5;
foreach ($csv as $a) {

    $LATITUDE = $a[0];
    $LONGITUDE = $a[1];

    $min = 10000000001;
    foreach ($result as $p) {
        $lat = $p[7];
        $lng = $p[8];

        $d = getDistanceFromLatLonInM($lat, $lng, $LATITUDE, $LONGITUDE);
        if ($d < $min) {
            $min = $d;
        }

    }


    /**
     $q = "SELECT * FROM (
        SELECT *,
            (
                (
                    (
                        acos(
                            sin(( $LATITUDE * pi() / 180))
                            *
                            sin(( `lat` * pi() / 180)) + cos(( $LATITUDE * pi() /180 ))
                            *
                            cos(( `lat` * pi() / 180)) * cos((( $LONGITUDE - `lng`) * pi()/180)))
                    ) * 180/pi()
                ) * 60 * 1.1515 * 1.609344
            )
        as distance FROM `seller_track`
    ) myTable
    WHERE distance <= $DISTANCE_KILOMETERS
    LIMIT 1;";

    $result = $conn->query($q);
    $res = $result->fetch_assoc();
    if (!empty($res)) {
        $final_result[] = $res['id'];
    }
     */

    $i++;
    if ($i == 500) {
        break;
    }
}


$conn->close();

$t2 = time();

echo $t2 - $t;


?>