<?php


include 'config.php';
$time=time();

$OldAccount="";
if(isset($_GET['OldAccount'])) {
  $OldAccount= strip_tags($_GET['OldAccount']);
}
$OldVehicleID= "";
if(isset($_GET['OldVehicleID'])) {
    $OldVehicleID= strip_tags($_GET['OldVehicleID']);
}
$ExistingAccount="";
if(isset($_GET['ExistingAccount'])) {
  $ExistingAccount= strip_tags($_GET['ExistingAccount']);
}
$NewVehicleID= "";
if(isset($_GET['NewVehicleID'])) {
    $NewVehicleID= strip_tags($_GET['NewVehicleID']);
}
$BaseLocation= "";
if(isset($_GET['BaseLocation'])) {
    $BaseLocation= strip_tags($_GET['BaseLocation']);
}
$Service= "";
if(isset($_GET['Service'])) {
    $Service= strip_tags($_GET['Service']);
}

$Group="";
if(isset($_GET['Group'])) {
  $Group= strip_tags($_GET['Group']);
}

$CrewSimNumber= "";
if(isset($_GET['CrewSimNumber'])) {
    $CrewSimNumber= strip_tags($_GET['CrewSimNumber']);
}

$TrackerType="";
if(isset($_GET['TrackerType'])){
$TrackerType=strip_tags($_GET['TrackerType']);
}
$ImeiNumber="";
if(isset($_GET['ImeiNumber'])){
$ImeiNumber=strip_tags($_GET['ImeiNumber']);
}

$uniqueID=$TrackerType._.$ImeiNumber;

$SerialNumber="";
if(isset($_GET['SerialNumber'])){
$SerialNumber=strip_tags($_GET['SerialNumber']);
}
$SimNumber="";
if(isset($_GET['SimNumber'])){
$SimNumber=strip_tags($_GET['SimNumber']);
}
$OdometerReading="";
if(isset($_GET['OdometerReading'])){
$OdometerReading=strip_tags($_GET['OdometerReading']);
}
$Technician="";
if(isset($_GET['Technician'])){
$Technician=strip_tags($_GET['Technician']);
}
error_log($OldAccount,0);
error_log($OldVehicleID,0);
error_log($ExistingAccount,0);
error_log($NewVehicleID,0);
error_log($BaseLocation,0);
error_log($Service,0);
error_log($Group,0);
//exec('cp watertanker.png $i');
error_log($CrewSimNumber,0);
error_log($ImeiNumber,0);
error_log($SerialNumber,0);
error_log($SimNumber,0);
error_log($OdometerReading,0);
error_log($Technician);



$e = array('res' => 1);
$op=shell_exec("sh /var/www/html/RemoteVehicle/php/addImage.sh $NewVehicleID ");
error_log($op);

if($OldAccount=="" && $OldVehicleID=="" && $ExistingAccount=="" && $NewVehicleID=="" && $BaseLocation=="" && $Group==""  && $CrewSimNumber=="" && $TransporterName=="" &&  $ImeiNumber=="" && $SerialNumber=="" && $SimNumber=="" && $OdometerReading=="" && $Technician=="")
       {
        $e['res'] = "false"; 
         return;
        }
for($conindx=0;$conindx<count($gtsserverconfigs);$conindx++){
    if(isset($gtsserverconfigs[$conindx][0])){   
        $gtsserver=$gtsserverconfigs[$conindx][0];
        $gtsusername=$gtsserverconfigs[$conindx][1];
        $gtspassword=$gtsserverconfigs[$conindx][2];
        $gtsdb=$gtsserverconfigs[$conindx][3];
       
        $tacserver=$tacserverconfigs[$conindx][0]; 
        $tacusername=$tacserverconfigs[$conindx][1];
        $tacpassword=$tacserverconfigs[$conindx][2];
        $tacdb=$tacserverconfigs[$conindx][3];

        $gtsconnect = mysqli_connect($gtsserver, $gtsusername, $gtspassword) or die ("Unable to connect to the database: " . mysqli_error($gtsconnect));
        mysqli_select_db($gtsconnect,$gtsdb);
        //$sql="Delete from Device where accountID='$OldAccount' and deviceID='$OldVehicleID'";
        //error_log($sql);
        //$result = mysqli_query($sql) or die ("Query error: " . mysqli_error());
        $NewVehicleID1=strtoupper($NewVehicleID);
        $BaseLocation1=strtoupper($BaseLocation);
        $Group1=strtoupper($Group);
        $desc ='['.$NewVehicleID1.']'.'['.$BaseLocation1.']'.'['.$Group1.']';
        if($ExistingAccount=="gvk-up-backup"){
            $desc ='['.$NewVehicleID1.']'.'['.$BaseLocation1.']'.'['.$Group1.']'.'['.$Service.']';
        }
        error_log($desc);
        $sql1="INSERT INTO Device(accountID,deviceID,uniqueID,imeiNumber,serialNumber,simPhoneNumber,odometerOffsetKM,ignitionIndex,isActive,description,groupID,creationTime,reminderMessage) values ('$ExistingAccount','$NewVehicleID','$uniqueID','$ImeiNumber','$SerialNumber','$SimNumber','$OdometerReading','6','1','$desc','','$time','$Technician')";
        error_log($sql1);
        $result = mysqli_query($gtsconnect,$sql1) or die ("Query error: " . mysqli_error($gtsconnect));
        $sql2 ="INSERT INTO DeviceList(accountID,groupID,deviceID,lastUpdateTime,creationTime)VALUES('$ExistingAccount', '$Group','$NewVehicleID','$time','$time')";
        error_log($sql2);
        $result = mysqli_query($gtsconnect,$sql2) or die ("Query error: " . mysqli_error($gtsconnect));
        $sql3 ="INSERT INTO Driver(accountID,driverID,deviceID,contactPhone,description,address)VALUES('$ExistingAccount', '$NewVehicleID','$NewVehicleID','$CrewSimNumber','','$desc')";
        error_log($sql3);
        $result = mysqli_query($gtsconnect,$sql3) or die ("Query error: " . mysqli_error($gtsconnect));
        mysqli_close($gtsconnect);
        $e['res'] = "true";
    }
}

echo '{"markers": ' . json_encode($e) . '}';

?>

