/** * This function resets the GPS data weekly. **/ public static function cURLReset() { $sql = "TRUNCATE TABLE GPSData"; $params = array(); $stm = pdo_execute_non_query($sql, $params); if ($stm) { return $stm; } else { return FALSE; } }
<?php require "inc_header_ps.php"; require_once '../lib/pdo.php'; mysql_select_db($db_name, $oConn); // 2014-09-22 Updated ^CS $eventid = $_POST['eventId']; $trucknum = $_POST['truckNum']; $truckId; $sql = "SELECT TruckID FROM GPSTruck WHERE ID = {$trucknum}"; $result = mysql_query($sql, $oConn); if ($result == false) { echo $sql; die(mysql_error()); } $row = mysql_fetch_array($result); $truckId = $row['TruckID']; $sql = "UPDATE Events SET AssignedTruckID = :trucknum, AssignedSubcontractorID = :truckId WHERE EventID = :eventid;"; $params = array(':eventid' => $eventid, ':trucknum' => $trucknum, ':truckId' => $truckId); $ret = pdo_execute_non_query($sql, $params) == 1; echo $ret;
$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++; } $sql = "INSERT INTO GPSTruckRoute (GPSID, CustomerID, Date, Route, TimeStamp) VALUES (:id, :customerid, :date, :route, :timestamps)"; $params = array(':id' => $GPSID, ':customerid' => $CustomerID, ':date' => $date, ':route' => $DrivingRoute, ':timestamps' => $TimeStamps); $stm3 = pdo_execute_non_query($sql, $params); if ($stm3) { echo "Success<br />"; } else { echo "Failure<br />"; } } } $time_end = microtime(true); $execution_time = ($time_end - $time_start) / 60; function rutime($ru, $rus, $index) { return $ru["ru_{$index}.tv_sec"] * 1000 + intval($ru["ru_{$index}.tv_usec"] / 1000) - ($rus["ru_{$index}.tv_sec"] * 1000 + intval($rus["ru_{$index}.tv_usec"] / 1000)); } $ru = getrusage(); $MessageTime = "[SYSTEM-MSG] Save Truck Route - Total Execution Time:" . $execution_time . " minutes";