/**
  * Get stops near a location
  * @param double $latitude
  * @param double $longitude
  * @return array
  */
 public function StopsNearLocation($latitude = false, $longitude = false)
 {
     if (!$latitude) {
         throw new Exception("Cannot fetch " . __METHOD__ . " - no latitude given");
     }
     if (!$longitude) {
         throw new Exception("Cannot fetch " . __METHOD__ . " - no longitude given");
     }
     $query = "SELECT\r\n\t\t\t\t\t\tstop_id,\r\n\t\t\t\t\t\tstop_name,\r\n\t\t\t\t\t\tstop_lat,\r\n\t\t\t\t\t\tstop_lon,\r\n\t\t\t\t\t\twheelchair_boarding, (\r\n\t\t\t\t\t\t\t  3959 * acos (\r\n\t\t\t\t\t\t\t  cos ( radians(" . $latitude . ") )\r\n\t\t\t\t\t\t\t  * cos( radians( stop_lat ) )\r\n\t\t\t\t\t\t\t  * cos( radians( stop_lon ) - radians(" . $longitude . ") )\r\n\t\t\t\t\t\t\t  + sin ( radians(" . $latitude . ") )\r\n\t\t\t\t\t\t\t  * sin( radians( stop_lat ) )\r\n\t\t\t\t\t\t\t)\r\n\t\t\t\t\t\t) AS distance\r\n\t\t\t\t\t\tFROM au_wa_stops\r\n\t\t\t\t\t\tWHERE location_type = 1\r\n\t\t\t\t\t\tHAVING distance < 3\r\n\t\t\t\t\t\tORDER BY distance\r\n\t\t\t\t\t\tLIMIT 0 , 50";
     $result = $this->adapter->query($query, Adapter::QUERY_MODE_EXECUTE);
     $return = array();
     foreach ($result as $row) {
         $row = $row->getArrayCopy();
         $row['provider'] = $this->provider;
         $row['distance'] = vincentyGreatCircleDistance($row['stop_lat'], $row['stop_lon'], $latitude, $longitude);
         $return[] = $row;
     }
     return $return;
 }
    $response["success"] = 0;
    $response["message"] = "Post data was empty.";
    die(json_decode($response));
}
$con = mysqli_connect("localhost", "root", "WhatHappendPWD.", "whathappend");
if (mysqli_connect_error()) {
    echo "failed to connect" . mysqli_connect_error();
}
$query = "SELECT `id`, `post`, `user`, `long`, `lat`, `range`, `timestamp` FROM posts ORDER BY id DESC";
if ($result = $con->query($query)) {
    $response["success"] = 1;
    $response["message"] = "Posts available";
    $response["posts"] = array();
    /* fetch associative array */
    while ($row = $result->fetch_assoc()) {
        $distance = vincentyGreatCircleDistance($long, $lat, $row["long"], $row["lat"]);
        if ($distance < $range && $distance < $row["range"]) {
            $post = array();
            $post["id"] = $row["id"];
            $post["username"] = $row["user"];
            $post["post"] = $row["post"];
            $post["longitude"] = $row["long"];
            $post["latitude"] = $row["lat"];
            $post["timestamp"] = $row["timestamp"];
            $post["distance"] = $distance;
            //update our repsonse JSON data
            array_push($response["posts"], $post);
        }
    }
    $result->free();
    //Check if user wants to sort by distance or timestamp
Beispiel #3
0
function closestDriver($cLat, $cLng, $dDay, &$dArray)
{
    if ($cLat == null || $cLng == null) {
        //echo "Invalid location </br>";
        return 0;
    } else {
        $closestDriver = 0;
        $sDistance = 6371000;
        $cDistance = 6371000;
        //echo $cLat.' '.$cLng.'</br>';
        foreach ($dArray as $key => $driver) {
            $driverID = $driver[0];
            $driverLat = $driver[1];
            $driverLng = $driver[2];
            $driverSchedule = $driver[3];
            $driverScheduleArray = explode(",", $driverSchedule);
            // Check delivery Day
            if (in_array($dDay, $driverScheduleArray)) {
                //echo $driverID.' ';
                $cDistance = vincentyGreatCircleDistance($cLat, $cLng, $driverLat, $driverLng);
                if ($cDistance < $sDistance) {
                    $closestDriver = $driverID;
                    $sDistance = $cDistance;
                }
            } else {
                //echo "($driverID) I dont work that day ($driverSchedule | $dDay | ) </br>";
            }
            //echo $sDistance.' '.$cDistance.'</br>';
        }
        //echo $closestDriver.'</br>';
        return $closestDriver;
    }
}
Beispiel #4
0
 /**
  * Get stops near a location
  * @param double $latitude
  * @param double $longitude
  * @return array
  */
 public function StopsNearLocation($latitude = null, $longitude = null)
 {
     if ($latitude == null) {
         throw new Exception("Cannot fetch " . __METHOD__ . " - no latitude given");
     }
     if ($longitude == null) {
         throw new Exception("Cannot fetch " . __METHOD__ . " - no longitude given");
     }
     $parameters = array("latitude" => $latitude, "longitude" => $longitude);
     $return = array();
     foreach ($this->fetch("nearme", $parameters) as $row) {
         $row['result']['location_name'] = trim($row['result']['location_name']);
         if ($row['result']['transport_type'] == "train" || preg_match("@Railway@i", $row['result']['location_name'])) {
             $placeData = array("stop_id" => $row['result']['stop_id'], "stop_name" => $row['result']['location_name'], "stop_lat" => $row['result']['lat'], "stop_lon" => $row['result']['lon'], "wheelchair_boarding" => 0, "location_type" => 1);
             /**
              * Check if this is stored in the database, and add it if it's missing
              */
             if (!in_array($row['result']['location_name'], $this->ignore_stops) && $row['result']['stop_id'] < 10000 && !preg_match("@#([0-9]{0,3})@", $row['result']['location_name'])) {
                 $query = sprintf("SELECT stop_id FROM %s_stops WHERE stop_id = %d LIMIT 1", self::DB_PREFIX, $row['result']['stop_id']);
                 $result = $this->adapter->query($query, Adapter::QUERY_MODE_EXECUTE);
                 if ($result->count() === 0) {
                     $Insert = $this->db->insert(sprintf("%s_stops", self::DB_PREFIX));
                     $Insert->values($placeData);
                     $selectString = $this->db->getSqlStringForSqlObject($Insert);
                     $this->adapter->query($selectString, Adapter::QUERY_MODE_EXECUTE);
                 }
                 $placeData['distance'] = vincentyGreatCircleDistance($row['result']['lat'], $row['result']['lon'], $latitude, $longitude);
                 $placeData['provider'] = $this->provider;
                 if ($placeData['distance'] <= 10000) {
                     // Limit results to 10km from provided lat/lon
                     $return[] = $placeData;
                 }
             }
         }
     }
     return $return;
 }
 /**
  * Get stops near a location
  * @param double $latitude
  * @param double $longitude
  * @return array
  */
 public function StopsNearLocation($latitude = null, $longitude = null)
 {
     if ($latitude == null) {
         throw new Exception("Cannot fetch " . __METHOD__ . " - no latitude given");
     }
     if ($longitude == null) {
         throw new Exception("Cannot fetch " . __METHOD__ . " - no longitude given");
     }
     $query = "SELECT\r\n                    stop_id,\r\n                    stop_name,\r\n                    stop_lat,\r\n                    stop_lon,\r\n                    wheelchair_boarding, (\r\n                          3959 * acos (\r\n                          cos ( radians(" . $latitude . ") )\r\n                          * cos( radians( stop_lat ) )\r\n                          * cos( radians( stop_lon ) - radians(" . $longitude . ") )\r\n                          + sin ( radians(" . $latitude . ") )\r\n                          * sin( radians( stop_lat ) )\r\n                        )\r\n                    ) AS distance\r\n                    FROM %s_stops\r\n                    WHERE location_type = 1\r\n                    HAVING distance < 3\r\n                    ORDER BY distance\r\n                    LIMIT 0 , 50";
     $query = sprintf($query, static::DB_PREFIX);
     $result = $this->adapter->query($query, Adapter::QUERY_MODE_EXECUTE);
     $return = array();
     foreach ($result as $row) {
         $row = $row->getArrayCopy();
         $row['provider'] = $this->provider;
         $row['distance'] = vincentyGreatCircleDistance($row['stop_lat'], $row['stop_lon'], $latitude, $longitude);
         $return[] = $row;
     }
     return $return;
 }
Beispiel #6
0
function getReportsFromDB($longitude, $latitude, $max_distance, $timestamp, $past_window, &$result)
{
    $collection = Config::report_col;
    $start_time = $timestamp - 60 * $past_window;
    // past_window is in minutes
    $end_time = $timestamp;
    $query = array('time' => array('$gte' => (string) $start_time, '$lte' => (string) $end_time), 'RealTF' => array('$ne' => 'false'));
    $sort_filter = array("time" => -1);
    if (!mongodbFind($collection, $query, $cursor)) {
        return false;
    }
    $result = array();
    foreach ($cursor as $doc) {
        $dist = vincentyGreatCircleDistance($latitude, $longitude, $doc['reportLatitude'], $doc['reportLongitude']);
        if ($dist <= $max_distance) {
            $report = array('reportLatitude' => (double) $doc['reportLatitude'], 'reportLongitude' => (double) $doc['reportLongitude'], 'address' => $doc['address'], 'type' => $doc['type'], 'severity' => $doc['severity'], 'timestamp' => $doc['time'], 'comments' => $doc['comments'], 'reliability' => 1.0 - (double) $doc['ProbabilityRealTF']);
            $result[] = $report;
        }
    }
    return true;
}