Exemplo n.º 1
0
    public function getPlacesClosest($place)
    {
        $data = array();
        $data[] = $this->conn->cleanData($place->getLatitude());
        $data[] = $this->conn->cleanData($place->getLongitude());
        $data[] = $this->conn->cleanData($place->getDistance());
        $query = <<<SQL
\t\t\t\t\tSELECT
\t\t\t\t\t\tid,
\t\t\t\t\t\tname,
\t\t\t\t\t\tcategory,
\t\t\t\t\t\tdescription,
\t\t\t\t\t\tlatitude,
\t\t\t\t\t\tlongitude
\t\t\t\t\t\tFROM
\t\t\t\t\t\t\tlaa_place
\t\t\t\t\t\tWHERE
\t\t\t\t\t\t\tstatus = 1
\t\t\t\t\t\t\tAND
\t\t\t\t\t\t\t6371 * ACOS(
\t\t\t\t\t\t\t\t\t\tCOS( RADIANS( {$data['0']} ) )
\t\t\t\t\t\t\t\t\t\t*
\t\t\t\t\t\t\t\t\t\tCOS( RADIANS(latitude) )
\t\t\t\t\t\t\t\t\t\t*
\t\t\t\t\t\t\t\t\t\tCOS(
\t\t\t\t\t\t\t\t\t\t\tRADIANS( {$data['1']} )
\t\t\t\t\t\t\t\t\t\t\t-
\t\t\t\t\t\t\t\t\t\t\tRADIANS(longitude)
\t\t\t\t\t\t\t\t\t\t)
\t\t\t\t\t\t\t\t\t\t+
\t\t\t\t\t\t\t\t\t\tSIN( RADIANS( {$data['0']} ) )
\t\t\t\t\t\t\t\t\t\t*
\t\t\t\t\t\t\t\t\t\tSIN( RADIANS(latitude) )
\t\t\t\t\t\t\t\t\t) <= {$data['2']}
SQL;
        //exit($query);
        $query = $this->conn->removeBreakLine($query);
        $result = $this->conn->getConn()->query($query);
        $arrayPlaces = array();
        while ($data = $result->fetch_object()) {
            $place = new Place($data->id);
            $place->setName($data->name);
            $place->setCategory(new Category($data->category));
            $place->setDescription($data->description);
            $place->setLatitude($data->latitude);
            $place->setLongitude($data->longitude);
            $arrayPlaces[] = $place;
        }
        $result->free();
        return $arrayPlaces;
    }
Exemplo n.º 2
0
         $place = new Place($_POST['id-place']);
         $place->post($_POST);
         $return = $apl->updatePlace($place);
         echo json_encode(array('feedback' => $return));
     } else {
         if (preg_match('/^(get-place-data){1}$/', $_POST['method'])) {
             $apl = new AplMap();
             $place = new Place($_POST['id-place']);
             $place->post($_POST);
             $place = $apl->getPlace($place);
             echo json_encode(array('place' => $place->getDataJSON()));
         } else {
             if (preg_match('/^(get-places-closest){1}$/', $_POST['method'])) {
                 $apl = new AplMap();
                 $place = new Place();
                 $place->setLatitude($_POST['latitude']);
                 $place->setLongitude($_POST['longitude']);
                 $place->setDistance($_POST['distance']);
                 $arrayPlaces = $apl->getPlacesClosest($place);
                 // SEND TO CLIENT
                 $tam = count($arrayPlaces);
                 $arrayJson = array();
                 for ($i = 0; $i < $tam; $i++) {
                     $arrayJson[] = $arrayPlaces[$i]->getDataJSON();
                 }
                 $arrayJson = array('places' => $arrayJson);
                 echo json_encode($arrayJson);
             }
         }
     }
 }
Exemplo n.º 3
0
 function test_setLatitude()
 {
     //Arrange
     $place_name = "Director Park";
     $address = "SW Park Ave";
     $latitude = 45.518672;
     $longitude = -122.681211;
     $id = 1;
     $test_place = new Place($place_name, $address, $latitude, $longitude, $id);
     //Act
     $test_place->setLatitude($latitude);
     $result = $test_place->getLatitude();
     //Assert
     $this->assertEquals("45.518672", $result);
 }