 $currentepoch=$argv[1];
  $previousepoch=$argv[2];

  //$currentepoch=1553516824;
  //$previousepoch=1553516718;
  $gtsserver='tnemri.glovision.co';
  $gtsusername='root';
  $gtspassword='gl0v1s10n';
  $gtsdb = 'gts';
  //$startime =date("Y-m-d H:i:s",time()); 
  error_log('start ');
  echo 'start';
  $gtsconnect = mysqli_connect($gtsserver, $gtsusername, $gtspassword) or die ("Unable to connect to the database: " . mysqli_error($gtsconnect));
  mysqli_select_db($gtsconnect,$gtsdb);

  //$sql = "select imeiNumber as SIM_ID, from_unixtime(lastEventTimestamp) as Sent_Time, from_unixtime(lastEventTimestamp) as Rec_Time, lastValidLatitude as Latitude, lastValidLongitude as Longitude, lastValidSpeedKPH as Speed,(lastOdometerKM + lastOdometerKM) as odometerreading,deviceID from Device where accountID IN ('gvk-up-102') and (lastValidLatitude is not NULL and lastValidLatitude > 0) ORDER BY right(imeiNumber,10) Asc ";
  $sqlforuniqueID = "select uniqueID as SIM_ID,deviceID,lastEngineOnTime,lastIgnitionOffTime,lastBatteryLevel  from Device where accountID='tnemri'";
  $result1 = mysqli_query($gtsconnect,$sqlforuniqueID) or die('A error occured: mysqli select failed 1'.mysqli_error($gtsconnect));
  $devices=array();
  while ($Row1 = mysqli_fetch_row($result1)) {
     $devices[strtolower($Row1[1])]=$Row1[0];
     $devices[strtolower($Row1[1])."-mainpower"]=($Row1[2]=="0")?"79":"78";//last mainpower on/off
     $devices[strtolower($Row1[1])."-ignition"]=$Row1[3];//last ignition on/off
     $devices[strtolower($Row1[1])."-batterylevel"]=intval((($Row1[4]-3.55)/0.65)*100);
  }
  $time=time();
  $sql = "select altitude as altitude, from_unixtime(creationTime)as Sent_Time, from_unixtime(timestamp) as Rec_Time, latitude as Latitude, longitude as Longitude, speedKPH as Speed,(odometerKM+odometerOffsetKM) as odometerreading,deviceID,statusCode,heading,analog3,geozoneID,batteryVolts as batterylevel,engineTemp as ignitiononoff,intakeTemp as mainpoweronoff from EventData  where accountID='tnemri' and (latitude is not NULL and latitude > 0) and creationTime>=$previousepoch and creationTime < $currentepoch ORDER BY deviceID,timestamp Asc";
//  error_log ($sql);
  $result = mysqli_query($gtsconnect,$sql) or die('A error occured: mysqli select failed2'.mysqli_error($gtsconnect));
  $Count = mysqli_num_rows($result);
  error_log($Count."hello count");
  echo $Count;
  $arr = array();
  $i=0;
  while ($Row = mysqli_fetch_row($result)) {
    $arr[$i] = array();
    $arr[$i][0] =$devices[strtolower($Row[7])] ;//$Row[0];
    $arr[$i][1] = $Row[1];
    $arr[$i][2] = $Row[2];
    $arr[$i][3] = $Row[3];
    $arr[$i][4] = $Row[4];
    $arr[$i][5] = $Row[5];
    $arr[$i][6] = $Row[6];
    $arr[$i][7] = $Row[7];
    $arr[$i][8] = $Row[8];
    $arr[$i][9] = $Row[9];
    $arr[$i][10] = $Row[13];//$devices[strtolower($Row[7])."-ignition"];//ignition on/off
 if($Row[8]=="63553") //Panic status as Button_code
       $arr[$i][11] ="108";
    else
       $arr[$i][11]=0;

    $arr[$i][12] =($Row[14]=="0")?"79":"78";//$devices[strtolower($Row[7])."-mainpower"];//main powre off  on
    $arr[$i][13]="99";// gprs on /off
    $gprsgapdiff= intval(abs(strtotime($Row[1])-strtotime($Row[2]))/60);
    if($gprsgapdiff>10){//if gprs gap more then 10 mints then 
       $arr[$i][13]="98";
    }
    $arr[$i][15]=100;//default percent 100%
    if($arr[$i][12]=="79"){ //if main power cut then take battery level
        $arr[$i][15]=intval((($Row[12]-3.55)/0.65)*100);
        if($Row[8]=="63553" || $Row[8]=="61968" || $Row[8]=="62000" || $Row[8]=="64793" || $Row[8]=="64791" || $Row[8]=="62465" || $Row[8]=="62467" ){
            $arr[$i][15]=100;//$devices[strtolower($Row[7])."-batterylevel"];
            $arr[$i][10]=$devices[strtolower($Row[7])."-ignition"];
            $arr[$i][12]=$devices[strtolower($Row[7])."-mainpower"];
        }
    }else{
       if($Row[8]=="63553" || $Row[8]=="61968" || $Row[8]=="62000" || $Row[8]=="64793" || $Row[8]=="64791" || $Row[8]=="62465" || $Row[8]=="62467" ){
           $arr[$i][15]=100;
           $arr[$i][10]=$devices[strtolower($Row[7])."-ignition"];
           $arr[$i][12]=$devices[strtolower($Row[7])."-mainpower"];
       }
    }
    $arr[$i][14]="";//geofenpech
    $baselocation=array("chennai","madurai","villupuram","ramanthapuram","villupuram-1","coimbatore");
    if($Row[8]=="61968"){
        if(in_array(strtolower($Row[11]),$baselocation)){
           $arr[$i][14]="33";
        }else{
           $arr[$i][14]="44";
        }
    }else if($Row[8]=="62000"){
        if(in_array(strtolower($Row[11]),$baselocation)){
           $arr[$i][14]="22";
        }else{
           $arr[$i][14]="55";
        }
    }
// $arr[$i][15]=  intval((($Row[12]-3.55)/0.65)*100);
// echo    $Row[1]."  ".$Row[2]."   ".$gprsgapdiff."<br>";
//echo var_dump($arr[$i]);

    $i++;
  }
  mysqli_close($gtsconnect);
  //var_dump($arr);
  //die();
  echo "count==== :".count($arr)." index: $i \n";


 $offset = 1;
  for ($j=0; $j<$i; $j=$j+$offset) {
       UpdateLastdata($j,$offset);
  }
  mssql_close($link1);
?>
