<?php
    date_default_timezone_set('Asia/Kolkata');
    include "../config.php";
    $jsonresponse='';
    $accountID=isset($_GET['accountID'])?$_GET['accountID']:"";
    $deviceID=isset($_GET['deviceID'])?$_GET['deviceID']:"";
    $startTime=isset($_GET['startTime'])?$_GET['startTime']:"";
    $endTime=isset($_GET['endTime'])?$_GET['endTime']:"";
    $offlinetimerange=isset($_GET['offlineTime'])?$_GET['offlineTime']:"";
    if($accountID!="" && $deviceID!="" && $startTime!="" && $endTime!=""){
        $info=getLatLong($accountID,$deviceID,$startTime,$endTime,$offlinetimerange);
        $offlineinfo=json_encode(utf8ize($info));
        $jsonresponse= '{"Status":"success","ReceivedTime":"'.date('d-M-Y h:i:s a',time()).'","OfflineSecs":'.$offlineinfo.'}';
        header('Content-Type: application/json');
        echo $jsonresponse;
    }else {
        $jsonresponse= '{"Status":"fail","ReceivedTime":"'.date('d-M-Y h:i:s a',time()).'","Movement Time":"Please Provide Valid Options"}';
        header('Content-Type: application/json');
        echo $jsonresponse;
   }

   function getLatLong($accountID,$deviceID,$startTime,$endTime,$offlinetimerange) {
       global $gtsserver,$gtsusername,$gtspassword,$gtsdb;
       $gtsconnect = mysqli_connect($gtsserver,$gtsusername, $gtspassword) or die ("Unable to connect to the database1 : " . mysqli_error($gtsconnect));
       mysqli_select_db($gtsconnect, $gtsdb);
       $sql = "Select * from EventData where accountID='$accountID' and deviceID='".$deviceID."' and timestamp >=$startTime and timestamp<=$endTime";
       $qry_result = mysqli_query($gtsconnect, $sql) or die(mysqli_error($gtsconnect));
       $data=array(array());
       $num_rows = mysqli_num_rows($qry_result);
       $indx=0;
       if($num_rows=="0"){
          $outputdata[$outputindx][0]="From :".date('d-M-Y H:i:s',$startTime)." To : ".date('d-M-Y H:i:s',$endTime);
                 $outputdata[$outputindx][1]=" Latitude/Longitude: Unknown";
                 $outputdata[$outputindx][2]=" Address : Null";
                 $totaleventdiff=($endTime-$startTime);

        }else{
            while($row = mysqli_fetch_assoc($qry_result)) {
                $data[$indx][0]=$row['timestamp'];
                $data[$indx][1]=round($row['latitude'],5);
                $data[$indx][2]=round($row['longitude'],5);
                $data[$indx][3]=$row['address'];
                $indx++;
            }
            $outputindx=0;
            for ($indx=1;$indx<=count($data);$indx++) { 
                $eventdiff =($data[$indx][0]-$data[$indx-1][0])/60;
                if($eventdiff>$offlinetimerange){
                    $outputdata[$outputindx][0]="From :".date('d-M-Y H:i:s',$data[$indx-1][0])." To : ".date('d-M-Y H:i:s',$data[$indx][0]);
                    $outputdata[$outputindx][1]=" Latitude/Longitude: ".$data[$indx-1][1]."/".$data[$indx-1][2];
                    $outputdata[$outputindx][2]=" Address :".$data[$indx-1][3];
                    $outputindx++;
                }
            }
        }//endelse if
        return $outputdata;
    }
?>
