<?php

function getDeviceServer($deviceID) {
    global $gtsserver, $gtsusername, $gtspassword, $gtsdb, $apiname;
    $gtsconnect = mysqli_connect($gtsserver,$gtsusername,$gtspassword) or die ($gtsserver." Unable to connect1 to the tacdb : " . mysqli_error($gtsconnect));
    mysqli_select_db($gtsconnect, $gtsdb);
    $request_time_query="Select deviceID from Device where deviceID='$deviceID'";
   // error_log($request_time_query."  ".$gtsserver);
    $qry_result=mysqli_query($gtsconnect,$request_time_query) or die(mysqli_error($gtsconnect));
   // error_log("completed");
    $deviceFound=false;
    while($row=mysqli_fetch_array($qry_result)) {
       $deviceFound=true;
    }
   // error_log($deviceFound);
    mysqli_close($gtsconnect);
    return $deviceFound;

}

function utf8ize($d) {
    if (is_array($d)) {
        foreach ($d as $k => $v) {
            $d[$k] = utf8ize($v);
        }
    } else if (is_string ($d)) {
        return utf8_encode($d);
    }
    return $d;
}


function distance1($lat1, $lon1, $lat2, $lon2) {
        if($lat1 == $lat2 && $lon1 == $lon2){
            return 0;

        }else{$theta = $lon1 - $lon2;
            $dist = sin(deg2rad($lat1)) * sin(deg2rad($lat2)) +  cos(deg2rad($lat1)) * cos(deg2rad($lat2)) * cos(deg2rad($theta));
            $dist = acos($dist);
            $dist = rad2deg($dist);
            $miles = $dist * 60 * 1.1515;
            return $miles* 1.609344;
        }
 }

function saveRequest($account,$device,$fromDate,$toDate,$distance,$requestTime,$status,$requestType) {
    global $tacserver, $tacusername,$tacpassword,$tacdb;
  echo $tacserver."   ".$tacusername."   ".$tacpassword."  ".$tacdb;
    $tacconnect = mysqli_connect($tacserver,$tacusername,$tacpassword) or die ($apiname.": Unable to connect to ".$tacdb." ". mysqli_error($tacconnect));
    mysqli_select_db($tacconnect, $tacdb) or die(mysqli_error($tacconnect));
    $request_time_query="INSERT into API_Request_Time_Table (accountID,deviceID,fromDate,toDate,distance,requestTime,status,requestfor) VALUES ('$account','$device','$fromDate','$toDate','$distance','$requestTime','$status','$requestType')";
    mysqli_query($tacconnect,$request_time_query) or die(mysqli_error($tacconnect));
    mysqli_close($tacconnect);
}

?>
