/**
* Display a listing of all events
*
*/
public function index()
{
// $events = Event::with('user')->orderBy('date_start', 'desc')->get();
$eventsFeatured = Event::with('user')->where('feature_event', 1)->get();
$events = $this->facebookSdk->getCurrentEvents();
$events = json_decode(json_encode($events));
return view('pages.events.index', compact('events', 'eventsFeatured'));
}
public function show($localId)
{
$event = \App\Event::with('users')->where('local_id', $localId)->first();
if (!$event) {
return response()->json(['message' => 'Damn! You just missed it.'], 404);
}
return $event;
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($slug)
{
$categories = Category::lists('name', 'id');
$events = Event::with('category')->where('slug', $slug)->first();
$category = $events->category;
$similarEvent = Event::where('category_id', $category->id)->where('event_date', ">", \Carbon\Carbon::now())->orderBy('created_at', 'desc')->limit(3)->get();
return view('events.event', compact('events', 'categories', 'similarEvent'));
}
/**
* La fonction isSoldOut($eventId) permet de vérifier si un événement est n'est pas complet.
* @param int $eventId - l'id de l'événement
* @return boolean true si l'événement n'est pas complet, false sinon
*/
public static function isNotSoldOut($eventId)
{
$event = Event::with('guests')->find($eventId);
$guests = count($event->guests);
if ($event->capacity == 0) {
return FALSE;
}
return $event->capacity > $guests;
}
public function getSingleEvent(Event $event)
{
$events = Event::with('posts')->where('id', '=', $event->id)->paginate(10);
SEO::setTitle("{$event->title} - Melbourne Cocoaheads");
SEO::setDescription($event->subtitle);
SEO::opengraph()->setUrl($event->url());
SEO::opengraph()->setArticle(['published_time' => $event->created_at, 'modified_time' => $event->modified_at, 'expiration_time' => $event->ends_at, 'author' => 'Jesse Collis', 'section' => 'updates', 'tag' => ['updates']]);
return view('events', ['events' => $events, 'title' => $event->title]);
}
public function getEvents(Request $request)
{
if (\Request::ajax()) {
if (!empty($request->get('search'))) {
$events = Event::search($request->get('search'))->with('user')->paginate(15);
} else {
$events = Event::with('user')->paginate(15);
}
return \Response::json($events);
}
return \Response::json(['status' => 'error'], 400);
}
/**
* Display a listing of events given the conferenceID.
* @return Response
*/
public function getEventByConferenceID(Request $req, $conferenceID)
{
$conf = Conference::find($conferenceID);
if (is_null($conf)) {
return response("No conference for id {$conferenceID}.", 405);
}
//Select events, populate with "attendees" so we can calculate the
//remaining capacity
$event = Event::with("attendees")->where('conferenceID', $conferenceID)->get();
$evtArray = $event->toArray();
if (sizeof($evtArray) == 0) {
return response("No events for conferenceID {$conferenceID}.", 404);
}
$evtArray = array_map(function ($e) use($req) {
return $this->show($req, $e);
}, $evtArray);
return $evtArray;
}
public function search()
{
$events = new Event();
$events = $events->with('category')->where('publish', 1);
$title = Input::get('name', null);
if ($title) {
$events->where('title', 'LIKE', "%{$title}%");
}
if (Input::get('category_id')) {
$events->where('category_id', Input::get('category_id'));
}
if (Input::get('date')) {
$events->where('event_date', Input::get('date'));
}
$categories = Category::lists('name', 'id');
$highlighted = Event::with('category')->where('highlight', 1)->where('publish', 1)->where('event_date', ">", \Carbon\Carbon::now())->orderBy('event_date', 'asc')->limit(6)->get();
$events = $events->orderBy('event_date', 'asc')->where('event_date', ">", \Carbon\Carbon::now())->paginate(5);
return View::make('index', compact('events', 'highlighted', 'categories'));
}
public function events()
{
$events = Event::with('user')->paginate(15);
return view('ticketsadmin::events', compact('events'));
}
public function getPublishedEvent()
{
$event = Event::with('get_category')->where('is_published', '=', 1)->get();
return view('events', array('events' => $event));
}
/**
* @return mixed
*/
public function index()
{
return view('events.index')->withEvents($this->event->with('photo')->orderBy('date', 'DESC')->paginate(10));
}
<?php
namespace App\ViewComposers;
use View;
use Auth;
use App\Event;
View::composer('partials.upcoming-events', function ($view) {
// Upcoming Events (by League)
$leagues = [(object) ['name' => 'Poker'], (object) ['name' => 'Trivia']];
foreach ($leagues as $league) {
$league->events = Event::with('league')->with(['league.venue' => function ($query) {
$query->orderBy('id');
}])->whereHas('league', function ($query) use($league) {
$query->where('activity', $league->name);
})->whereRaw('date(datetime) between ? and ?', [date('Y-m-d'), date('Y-m-d', time() + 60 * 60 * 24 * 7)])->whereHas('league.venue', function ($query) {
$query->whereRaw('private is not true')->orWhereRaw('id in (select venue_id from t_venue_players where player_id=?)', [Auth::user()->id]);
})->orderByRaw('date(datetime)')->orderByRaw('(select venue_id from t_leagues where id=league_id)')->orderByRaw('time(datetime)')->get();
}
// Registered Events
$registered = Auth::user()->registeredEvents ?: [];
$registered = array_map(function ($event) {
return $event->id;
}, $registered);
// Bind Data
$view->with('leagues', $leagues);
$view->with('registered', $registered);
});
public function indexSearch(Request $request)
{
$events = Event::with('user', 'category')->searchFor($request->get('search'))->get()->toArray();
return $this->respond($events);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$event = Event::with('bands', 'manager', 'article')->find($id);
if (empty($event)) {
Flash::error('Cet événement n\'existe pas.');
abort(404);
}
return view('events.edit', compact('event'));
}
public function getEvents($name)
{
$user = User::where('name', $name)->first();
$user_id = $user->id;
$oldEvents = Event::with('category')->where('user_id', $user_id)->where('event_date', "<", \Carbon\Carbon::now())->orderBy('created_at', 'desc')->get();
$events = Event::with('category')->where('user_id', $user_id)->where('event_date', ">", \Carbon\Carbon::now())->orderBy('created_at', 'desc')->get();
return view('admin.events', compact('events', 'user', 'oldEvents'));
}
/**
* get all user in paginated list
* @param $number
* @return mixed
*/
public function paginate($number)
{
return $this->model->with('profile')->latest('created_at')->paginate($number);
}
/**
* La fonction index() permet de récupérer les événements à venir de la BD et d'afficher la vue principale.
* @return View - La vue principale permettant d'afficher tous les événements.
*/
public function index()
{
$date_today = Carbon::now()->format('Y-m-d');
$events = Event::with('guests')->whereDate('date', '>=', $date_today)->orderBy('date', 'asc')->get();
return view('index')->with('events', $events);
}
public function getCalendar()
{
$events = Event::with('get_category')->where('is_published', '=', 1)->get();
return view('admin/event/calendar', array('user' => $this->username, 'nav_event' => '', 'nav_pub_event' => '', 'events' => $events));
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$event = Event::with(['group', 'eventOccurrences'])->findOrFail($id);
$eventOccurrences = EventOccurrence::where('event_id', $id)->paginate();
return view('event', compact('event', 'eventOccurrences'));
}
