<?php
date_default_timezone_set('Asia/Kolkata');
require_once('CheckVehicleInServer.php');
//include "../ServerSelection.php";
/*
ini_set('display_errors', 1);
ini_set('log_errors', 1);
ini_set('error_log', dirname(__FILE__) . '/usr/local/apache/logs/error_log.txt');
error_reporting(E_ALL);
error_reporting(0);
*/

$fromDate = $_GET['fromDate'];
$toDate = $_GET['toDate'];
$accountID=$_GET['accountID'];
$server=$_GET['server'];

//$setup = parse_ini_file("setup.ini", true);// loading setup file for from time and to time
//$fromTimee = '00:00:00';
//$toTimee = '23:59:59';
$deviceArray = array(array());
$result=array();
$result1=array();
$result3=array();

if($accountID=='gvk-up-108' && $server=="west"){
    $gtsserver="up108westlocal";
    $gtsusername="root";
    $gtspassword="gl0v1s10n";
    $gtsdb="gts";
    $deviceArray = device_info($gtsserver, $gtsusername, $gtspassword, $gtsdb, $accountID);
}else if($accountID=='gvk-up-108' && $server=="east"){
    $gtsserver="up108eastlocal";
    $gtsusername="root";
    $gtspassword="gl0v1s10n";
    $gtsdb="gts";
    $deviceArray = device_info($gtsserver, $gtsusername, $gtspassword, $gtsdb, $accountID);
 }   
else if($accountID=='gvk-up-102' && $server=="west"){
    $gtsserver="up102westlocal";
    $gtsusername="root";
    $gtspassword="gl0v1s10n";
    $gtsdb="gts";
    $deviceArray = device_info($gtsserver, $gtsusername, $gtspassword, $gtsdb, $accountID);
}
else if($accountID=='gvk-up-102' && $server=="east"){
    $gtsserver="up102eastlocal";
    $gtsusername="root";
    $gtspassword="gl0v1s10n";
    $gtsdb="gts";
    $deviceArray = device_info($gtsserver, $gtsusername, $gtspassword, $gtsdb, $accountID);
}
else if(($accountID=="als" || $accountID=="gvk-up-backup" ) && ($server=="east" || $server=="west")){
    $gtsserver="als2local";
    $gtsusername="root";
    $gtspassword="gl0v1s10n";
    $gtsdb="gts";
    $deviceArray = device_info($gtsserver, $gtsusername, $gtspassword, $gtsdb, $accountID);
} 


     $result3= hourlydata($deviceArray,$accountID,$fromDate,$toDate,$server);
      header('Content-Type: application/json');
      echo json_encode($result3);



function device_info($gtsserver, $gtsusername, $gtspassword, $gtsdb, $accounts)
{
global $user;
    //$result = array(array());
    $result = array();
    $gtsconnect = mysqli_connect($gtsserver, $gtsusername, $gtspassword) or die ("Unable to connect to the database: " . mysqli_error());
    mysqli_select_db($gtsconnect, $gtsdb);
     $vehicleDetails = "select a.creationTime,a.vehicleModel as vehicleModel,a.vehicleMake as vehicleMake,a.lastValidLatitude as lastValidLatitude,a.lastValidLongitude as lastValidLongitude,a.deviceID as deviceID,a.imeiNumber as imeinumber,lastEventTimestamp,a.simPhoneNumber as simPhoneNumber,a.simPhoneNumber as contactPhone,a.description as description  from Device a where a.accountID='$accounts' and a.isActive=1";
    error_log($vehicleDetails);
    $qry1 = mysqli_query($gtsconnect, $vehicleDetails) or die(mysqli_error());
    $rowcount = 0;
    error_log('Devicessssss');
    while ($row = mysqli_fetch_assoc($qry1)) {
        $result[$rowcount][0] = $row['vehicleMake'];
        $result[$rowcount][1] = $row['vehicleModel'];
        $result[$rowcount][2] = $row['lastValidLatitude'];
        $result[$rowcount][3] = $row['lastValidLongitude'];
        $result[$rowcount][4] = $row['deviceID'];
        $result[$rowcount][5] = $row['imeinumber'];
        $result[$rowcount][6] = $row['lastEventTimestamp'];
        $result[$rowcount][7] = $row['simPhoneNumber'];
        $rowcount++;
    }
    mysqli_close($gtsconnect);
    return $result;
}
function hourlydata($deviceArray,$accountID,$fromDate,$toDate,$server){
$fromDate2=strtotime(date("Y-m-d 00:00:00", $fromDate));
$fromDate1= date("H", $fromDate);
$toDate1= date("H", $toDate);
$result2=array();
$total=array();
if($accountID=="gvk-up-108" && $server=="west"){
  $tacserver="localhost";
  $tacdb="autocare_gts";
}else if($accountID=="gvk-up-108" && $server=="east"){
  $tacserver="up108eastapilocal";
  $tacdb="autocare_gts";
}else if($accountID=="gvk-up-102" && $server=="west"){
  $tacserver="up102westapilocal";
  $tacdb="autocare_gts";
}else if($accountID=="gvk-up-102" && $server=="east"){
  $tacserver="up102eastapilocal";
  $tacdb="autocare_gts";
}
else if(($accountID=="als" || $accountID=="gvk-up-backup" ) && ($server=="east" || $server=="west")){
  $tacserver="als1local";
  $tacdb="autocare_gts";
}

 $tacconnect = mysqli_connect($tacserver, "root", "gl0v1s10n") or die ("Unable to connect to the database: " . mysqli_error($tacconnect));
   mysqli_select_db($tacconnect, $tacdb);
for($i=0;$i<count($deviceArray);$i++){
   $deviceID=$deviceArray[$i][4];
   $sql="Select accountID,deviceID,hourlydistance,fromDate from HourlyDistance where accountID='$accountID' and deviceID='$deviceID' and fromDate=$fromDate2";
   error_log("I count: ".$i);
   $qry_result = mysqli_query($tacconnect, $sql) or die(mysqli_error($tacconnect));
   $result=array();
   $result['total distance']=0;
   $result['total offline time']=0;
   while ($row = mysqli_fetch_assoc($qry_result)) {
      $result['accountID']=$row['accountID'];
       $result['deviceID']=$row['deviceID'];
       $total=json_decode($row['hourlydistance'],true);
       $dist=0;
       $offline=0;
       for($j=$fromDate1;$j<=$toDate1;$j++){
       if($j<=9 && $j>0){
            $j='0'.$j;
         }
       $dist=$total[$j]+$dist;
       $offline=$total[$j."offline"]+$offline;
        }
       $result['total distance']=$result['total distance']+$dist;
       $result['total offline time']=$result['total offline time']+$offline;
       
    }//end while
       array_push($result2,$result);
}//end loop
 mysqli_close($gtsconnect);
return $result2;
}
?>

