public static function GetTruckDriver($truckid)
{
$sql = "SELECT TruckDriver FROM GPSTruck WHERE TruckID = :truckid";
$params = array(':truckid' => $truckid);
$stm = pdo_execute_scalar($sql, $params);
if ($stm) {
return $stm;
} else {
return FALSE;
}
}
public static function CanViewPage($usernum, $customerid)
{
$sql = View::SELECT_CLAUSE;
$params = array(':usernum' => $usernum, ':customerid' => $customerid);
return pdo_execute_scalar($sql, $params);
}
public function AreYouTracked($truckid)
{
$sql = "SELECT Tracking FROM GPSTruck WHERE TruckID = :truckid";
$params = array(':truckid' => $truckid);
$tracker = pdo_execute_scalar($sql, $params);
if ($tracker) {
return 1;
// You are a driver.
} else {
return 0;
// You are not a driver.
}
}
