function GPSDataTruck($Truck, $GPSID, $TimeStamp, $Heading, $Direction, $Speed, $Speeding, $Behaviour, $EstSpeedLimit)
{
$time = date('Y-m-d, H:i:s', $TimeStamp);
$sql = "INSERT INTO GPSDataTruck\n (Truck, GPSID, TimeStamp, Heading, Direction, Speed, Speeding, Behaviour, EstSpeedLimit)\n \tVALUES\n (:truck, :gpsid, :timestamp, :heading, :direction, :speed, :speeding, :behaviour, :estspeedlimit)\n \t\t";
$params = array(':truck' => $Truck, ':gpsid' => $GPSID, ':timestamp' => $time, ':heading' => $Heading, ':direction' => $Direction, ':speed' => $Speed, ':speeding' => $Speeding, ':behaviour' => $Behaviour, ':estspeedlimit' => $EstSpeedLimit);
pdo_execute_query($sql, $params);
echo "<p>GPSDataTruck updated for {$Truck} {$GPSID}.</p>";
}
function getGPSData($startTime, $endTime, $customerId)
{
$sql = "";
$params;
$sql = "\n SELECT\n GPSData.Truck,\n GPSData.TimeStamp,\n GPSData.Latitude,\n GPSData.Longitude\n FROM\n GPSData\n LEFT JOIN GPSTruck\n ON GPSData.Truck = GPSTruck.TruckID\n WHERE\n GPSTruck.CustomerId = :customerId AND\n TimeStamp >= :startTime AND\n TimeStamp <= :endTime AND\n\t\t\t\tGPSData.GPSID > 0\n ORDER BY\n GPSData.Truck, GPSData.TimeStamp;\n ";
$params = array(':customerId' => $customerId, ':startTime' => $startTime, ':endTime' => $endTime);
$stmt = pdo_execute_query($sql, $params);
$results = $stmt->fetchALL(PDO::FETCH_ASSOC);
return $results;
}
$TruckDriver = GPSMaps::GetTruckDriver($GPSID);
} else {
$TruckDriver = -1;
}
$StartDate = isset($_REQUEST['Day']) ? $_REQUEST['Day'] : date('Y-m-d');
$FinishDate = isset($_REQUEST['Day']) ? $_REQUEST['Day'] : date('Y-m-d');
if ($StartDate == '') {
$StartDate = $_POST['Day'];
$FinishDate = $_POST['Day'];
}
// Hardcoded query
if ($StartDate < date('Y-m-d')) {
$regenerate = 1;
$sql = "SELECT * FROM GPSTruckRoute WHERE Date = :date and GPSID = :gpsid";
$params = array(':date' => $StartDate, ':gpsid' => $GPSID);
$stm = pdo_execute_query($sql, $params)->fetch(PDO::FETCH_OBJ);
$RouteRegen = str_replace("(", "new google.maps.LatLng(", $stm->Route);
$RouteTimeStamp = $stm->TimeStamp;
$RouteTimeStampArray = str_split($RouteTimeStamp, 21);
for ($g = 0; $g < count($RouteTimeStampArray) - 1; $g++) {
$RouteTimeStampArray[$g] = substr($RouteTimeStampArray[$g], 0, -2);
}
$RouteString = $stm->Route;
$RouteArray = str_split($RouteString, 22);
for ($h = 0; $h < count($RouteArray) - 1; $h++) {
$RouteArray[$h] = substr($RouteArray[$h], 0, -1);
}
} else {
$regenerate = 0;
$stm = GPSMaps::GetData($GPSID, $StartDate, $FinishDate);
$nearsite = GPSMaps::GetData($GPSID, $StartDate, $FinishDate);
public static function GetSupervisor($customerid)
{
$sql = "SELECT\n\t\t\t\t\t\tCustomerUserMap.UserNum,\n\t\t\t\t\t\tCONCAT_WS(' ', Users.LastName, Users.FirstName) AS UserName\n\t\t\t\t\tFROM\n\t\t\t\t\t CustomerUserMap\n\t\t\t\t\t \tJOIN\n\t\t\t\t\t Users ON Users.UserNum = CustomerUserMap.UserNum\n\t\t\t\t\tWHERE\n\t\t\t\t\t CustomerUserMap.CustomerId = :customerid\n\t\t\t\t\t AND CustomerUserMap.Relationship = 'super' ";
$params = array(':customerid' => $customerid);
return pdo_execute_query($sql, $params);
}
/**
* Find all the trucks in your company
* @param mixed $_SESSION
* @return all the trucks in your company
**/
public static function GetAssignableTrucks($cust)
{
$sql = "SELECT * FROM GPSTruck WHERE CustomerId = :cust";
$params = array(':cust' => $cust);
$stm = pdo_execute_query($sql, $params);
if ($stm) {
$stm->setFetchMode(PDO::FETCH_CLASS, "Trucks");
$trucks = $stm->fetchAll();
if ($trucks) {
foreach ($trucks as &$truck) {
$truck->DisplayName = Trucks::calculateDisplayName($truck);
}
return $trucks;
} else {
return array();
}
//empty
}
return false;
}
mysql_select_db($db_name, $oConn);
ps_log_root("[SYSTEM-MSG] Save Truck Route - Begin.");
$time_start = microtime(true);
$rustart = getrusage();
// 2014-09-19 Added TimeStamp BLOB ^CS
// 2014-09-15 Created ^CS
$date = date('Y-m-d');
$sql = "SELECT * FROM GPSTruck WHERE Truck = 'yes'";
$params = array();
$stm = pdo_execute_query($sql, $params);
while ($trucks = $stm->fetch(PDO::FETCH_OBJ)) {
$GPSID = $trucks->TruckID;
$CustomerID = $trucks->CustomerId;
$sql = "SELECT\n\t\t *\n\t\tFROM\n\t\t GPSData\n\t\tWHERE\n\t\t Truck = :id\n\t\t AND TimeStamp BETWEEN '{$date} 00:00:00' AND '{$date} 23:59:59'\n\t\tGROUP BY TimeStamp\n\t\tLIMIT 1440";
$params = array(':id' => $GPSID);
$stm2 = pdo_execute_query($sql, $params);
if ($stm2 && $stm2->RowCount() > 1) {
$RowCount = $stm2->RowCount();
$DrivingRoute = "";
$TimeStamps = "";
$x = 1;
while ($points = $stm2->fetch(PDO::FETCH_OBJ)) {
if ($x == $RowCount) {
$DrivingRoute .= '(' . $points->Latitude . ', ' . $points->Longitude . ')';
$TimeStamps .= $points->TimeStamp;
} else {
$DrivingRoute .= '(' . $points->Latitude . ', ' . $points->Longitude . '),';
$TimeStamps .= $points->TimeStamp . ", ";
}
$x++;
}
