public function trashesInsideTile()
{
$trashes = DB::select('
SELECT *
FROM trashes
WHERE trashes.geom && ST_MakeEnvelope(?, ?, ?, ?)', [$this->sw_lat, $this->sw_lng, $this->ne_lat, $this->ne_lng]);
//get id's of the trashes
$trash_ids = [];
foreach ($trashes as $trash) {
$trash_ids[] = $trash->id;
}
$trashes = Trash::whereIn('id', $trash_ids)->get();
return $trashes;
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//find id
$trash = Trash::findOrFail($id);
//delete
$trash->types()->delete();
$trash->delete();
//delete types
return response()->json("{}", 200);
}
