/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, Studio $studio, Event $event)
{
$event->update($this->prepare($request, $studio));
$event->pieces()->sync($this->prepareTags($request, 'piece_list'));
$event->categories()->sync($this->prepareTags($request, 'category_list'));
return redirect()->action('Admin\\StudioEventsController@show', [$studio->id, $event->id]);
}
public function index()
{
if (Auth::guest()) {
return view('pages.home');
}
//Check to make sure gender and names are populated
$user = Auth::user();
$fields = ['first_name' => $user->first_name, 'last_name' => $user->last_name, 'gender' => $user->gender];
$validation = Validator::make($fields, User::$baseRules);
if (!$validation->passes()) {
return redirect('user/name-and-gender');
}
//Check to make sure user has choson categories
if (!$this->categoryAccount->where('user_id', $user->id)->first()) {
return redirect('user/categories');
}
$chosenCategories = $this->categoryAccount->where('user_id', Auth::user()->id)->orderByRaw('RAND()')->get();
//Get one random task for the "one for the road"
$oneForTheRoad = array();
foreach ($chosenCategories as $category) {
$events = $this->event->where('type', $category->category_id)->orderByRaw('RAND()')->get();
foreach ($events as $event) {
if (!$this->eventUser->where('event_id', $event->id)->where('user_id', Auth::user()->id)->first() && !$this->eventUser->where('user_id', Auth::user()->id)->where('created_at', '<=', date('Y-m-d 24:00:00'))->where('created_at', '>=', date('Y-m-d 00:00:00'))->where('complete', 1)->first()) {
array_push($oneForTheRoad, ['id' => $event->id, 'name' => $event->name, 'description' => $event->description, 'class' => 'active']);
} else {
array_push($oneForTheRoad, ['id' => '0', 'name' => 'None for today!', 'description' => 'One for the road has completed', 'class' => 'inactive']);
}
}
}
$category = $this->category;
return view('pages.dashboard', compact('category', 'chosenCategories', 'oneForTheRoad'));
}
public function create(Request $req)
{
$event = new Event();
$event->name = $req->input('name');
$event->save();
return response()->json(['id' => $event->id]);
}
public function testActivityCanBeAddedToAnEvent1()
{
$this->logIn();
$event = new Event();
$event->name = 'Kokous';
$event->time = '2016-07-25 16:40:00';
$event->place = 'Kolo';
$event->description = 'Iltakokous';
$event->endDate = '2016-07-25 17:20:20';
$event->group_id = self::createTestGroup();
$event->save();
$activity = new Activity();
$activity->name = 'Kalastus';
$activity->guid = 'Guid';
$activity->age_group = 'sudenpennut';
$activity->task_group = 'pohjoinen';
$activity->save();
$event_id = DB::table('events')->where('name', 'Kokous')->value('id');
// Pitää muutta occurensejä käyttämään
/* $this->visit('/events/'. $event_id)
->click('Muuta aktiviteetteja')
->see('Äänestys')
->press('Lisää')
->click('Takaisin')
->see('Äänestys'); */
}
/**
* Remove the specified resource from storage.
*
* @param \Illuminate\Http\Request
* @param \App\Event $event
* @return \Illuminate\Http\Response
*/
public function destroy(Request $request, Event $event)
{
if ($request->ajax()) {
$event->delete();
return;
}
return redirect(action('EventsController@index'));
}
public function store()
{
$seven_days = 60 * 60 * 24 * 7;
$two_hours = 60 * 60 * 2;
$season = $_REQUEST['season'];
$venue_id = $_REQUEST['venue_id'];
$activity = $_REQUEST['activity'];
$lastSeasonsLeague = League::where('season', $season - 1)->where('venue_id', $venue_id)->where('activity', $activity)->first();
$lastSeasonsLastGame = Event::where('league_id', $lastSeasonsLeague->id)->where('week_num', 'Wild Card')->where('game_num', 1)->first();
$start_dt = $_REQUEST['start_dt'];
$start_dt = $start_dt ? strtotime($start_dt) : strtotime($lastSeasonsLastGame->date) + $seven_days;
$start_wk = $_REQUEST['start_wk'];
$start_wk -= 1;
$week_cnt = $_REQUEST['week_cnt'];
$game_cnt = $_REQUEST['game_cnt'];
$games_tm = $_REQUEST['games_tm'];
$games_tm = $games_tm ? strtotime($games_tm) : strtotime($lastSeasonsLastGame->time);
$events = [];
for ($i = $start_wk; $i <= $week_cnt; $i++) {
$week_num = $i == $week_cnt ? 'Wild Card' : $i + 1;
for ($j = 0; $j < $game_cnt; $j++) {
$datetime = date('Y-m-d', $start_dt + $seven_days * $i) . ' ' . date('H:i:s', $games_tm + $two_hours * $j);
$game_num = $j + 1;
$league = League::where('season', $season)->where('venue_id', $venue_id)->where('activity', $activity)->first();
if (!$league) {
$league = new League();
$league->season = $season;
$league->venue_id = $venue_id;
$league->activity = $activity;
$league->save();
}
$event = new Event();
$event->league_id = $league->id;
$event->season = $league->season;
$event->venue_id = $league->venue_id;
$event->datetime = $datetime;
$event->week_num = $week_num;
$event->game_num = $game_num;
$event->activity = $league->activity;
$events[] = $event;
}
}
try {
DB::transaction(function () use($events) {
foreach ($events as $event) {
$event->save();
}
});
$_SESSION['ALERT'] = alert('Season Added!', "Season {$season} for " . Venue::find($venue_id)->name . " was created successfully.", 'success');
} catch (Excepton $e) {
print_r($e);
exit;
$_SESSION['ALERT'] = alert('Season Not Added!', "Season {$season} for " . Venue::find($venue_id)->name . " could not be created.", 'error');
}
return redirect('/seasons');
}
public function newEvent($user)
{
$event = new Event();
$event->user_id = $user->id;
$event->event_icon = Input::get('icon');
$event->event_title = Input::get('title');
$event->event_description = Input::get('description');
$event->event_date = Input::get('date');
$event->event_color = Input::get('color');
$event->save();
}
protected function toggleParticipant(Event $event)
{
$isParticipant = !empty(EventUser::where('user_id', $this->request->participant_id)->where('event_id', $event->id)->first());
if ($isParticipant) {
$event->users()->detach([$this->request->participant_id]);
$value = -1;
} else {
$event->users()->attach([$this->request->participant_id]);
$value = 1;
}
return data([compact('value')]);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$event = new Event();
$event->description = 'Crack and solve puzzles to find the answer.';
$event->end_date = Carbon::now()->toIso8601String();
$event->featured = true;
$event->image = 'heist.png';
$event->group_id = 1;
$event->location = 'GOL-1670';
$event->name = 'The Heist';
$event->short_description = 'Crack and solve puzzles to find the answer.';
$event->short_name = 'Heist';
$event->start_date = Carbon::now()->toIso8601String();
$event->save();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
$faker = \Faker\Factory::create();
$user = User::create(['name' => 'Christian Kasperbauer', 'email' => '*****@*****.**', 'password' => bcrypt('grütze'), 'phone' => '0176-23152819', 'misc' => 'Friedrich-Ebert-Ring 4
97072 Würzburg
(Ton-)Technik, KRIS, Website!', 'rights' => 'all']);
$user2 = User::create(['name' => $faker->name, 'email' => $faker->email, 'password' => bcrypt('grütze'), 'phone' => $faker->phoneNumber, 'misc' => $faker->sentence()]);
for ($i = 0; $i <= 15; $i++) {
User::create(['name' => $faker->name, 'email' => $faker->email, 'password' => bcrypt('grütze'), 'phone' => $faker->phoneNumber, 'misc' => $faker->sentence()]);
}
Category::insert([['name' => 'Konzert', 'class' => 'light-green'], ['name' => 'Partey', 'class' => 'funky'], ['name' => 'Theater', 'class' => 'red'], ['name' => 'Kino', 'class' => 'amber'], ['name' => 'Sonstiges', 'class' => 'blue-grey'], ['name' => 'Wort', 'class' => 'light-blue']]);
$user->events()->save(Event::create(['scheduled_at' => Carbon::now()->addDays(4), 'category_id' => rand(1, 6), 'title' => 'Basement Blast', 'subtitle' => 'Geballer im Keller', 'description' => $faker->paragraph(10), 'admission' => 'donation', 'genre' => 'Metal', 'google_event_id' => str_random(12)]));
$user2->events()->save(Event::create(['scheduled_at' => Carbon::now()->addDays(9), 'category_id' => rand(1, 6), 'title' => 'Boxbeutel Boombox', 'subtitle' => 'Lecker Weinchen', 'description' => $faker->paragraph(10), 'admission' => 'free', 'genre' => 'Suff', 'google_event_id' => str_random(12)]));
$user->events()->save(Event::create(['scheduled_at' => Carbon::now()->addDays(2)->addMonth(), 'category_id' => rand(1, 6), 'title' => 'Beats & Lyrics', 'subtitle' => 'Freestyle Chypher', 'description' => $faker->paragraph(10), 'admission' => 'donation', 'genre' => 'HipHop', 'google_event_id' => str_random(12)]));
$user2->events()->save(Event::create(['scheduled_at' => Carbon::now()->subDays(2), 'category_id' => rand(1, 6), 'title' => 'Schon vorbei', 'subtitle' => 'Schade, du warst du spät', 'description' => $faker->paragraph(10), 'admission' => 'free', 'google_event_id' => str_random(12)]));
$user->events()->save(Event::create(['scheduled_at' => Carbon::now()->subMonth(2), 'category_id' => rand(1, 6), 'title' => 'Gelöscht', 'subtitle' => 'Wird niemals stattfinden', 'description' => $faker->paragraph(10), 'admission' => 'free', 'google_event_id' => str_random(12), 'deleted_at' => Carbon::now()->subDays(7)]));
$events = Event::all();
foreach ($events as $event) {
$event->options()->save(EventOptions::create(['time_start' => '19:00', 'time_end' => '00:00', 'time_meal' => '18:00', 'shifts_bar' => rand(1, 2), 'shifts_tech' => rand(0, 2), 'shifts_door' => rand(0, 1), 'meal_servings' => rand(0, 15), 'misc' => 'Test test test']));
$user_id = rand(1, 2);
$event->shifts()->save(Shift::create(['user_id' => $user_id, 'type' => 'tech']));
$event->shifts()->save(Shift::create(['user_id' => $user_id == 1 ? 2 : 1, 'type' => 'bar']));
}
Model::reguard();
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function getIndex()
{
$varr = Auth::user()->empid;
$empid = Targetassign::where('Employeeid', $varr)->get();
$cat = Event::all();
return View('targetmodule/eventdeal')->with(array('cat' => $cat, 'empid' => $empid));
}
/**
* Render front page view
* @return VIEW welcome
*/
public function index()
{
$all_events = Event::where('time', '>', date('Y-m-d H:i:s'))->orderBy(DB::raw('RAND()'));
$first_six = $all_events->take(6)->get();
$next_six = $all_events->skip(6)->take(6)->get();
return View::make('welcome')->with('first_six', $first_six)->with('next_six', $next_six);
}
/**
* Display a home page.
*
* @return Response
*/
public function home()
{
$activeUsers = 3;
$totalUsers = User::all()->count();
$eventCount = Event::all()->count();
return view('admin.home', compact('activeUsers', 'totalUsers', 'eventCount'));
}
public function getAssigntarget()
{
$employee = Employee::all();
$categories = Event::all();
$userdetails = User::all();
$targets = Targetassign::all();
$deals = Deal::all();
$userData = array();
$key = 0;
foreach ($targets as $target) {
$achieved = 0;
$userData[$key]['eventcode'] = $target->Eventcode;
$userData[$key]['event'] = $target->Eventname;
$userData[$key]['employee'] = $target->Employeeid;
$userData[$key]['targetVal'] = $target->Targetvalue;
foreach ($deals as $deal) {
if ($target->Eventcode == $deal->Eventcode && $target->Employeeid == $deal->Empid) {
$achieved = $achieved + $deal->Dealvalue;
}
}
$userData[$key]['achieved'] = $achieved;
$userData[$key]['variance'] = $achieved - $target->Targetvalue;
$userData[$key]['cur'] = $target->Currency;
$key++;
}
return View('approval/assigntarget')->with(array('categories' => $categories, 'employee' => $employee, 'userdata' => $userData, 'targets' => $targets, 'eventtable' => $categories));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$lastPosts = Post::latest()->take(2)->get();
$lastEvents = Event::latest()->take(2)->get();
$lastEvents2 = Event::latest()->skip(2)->take(2)->get();
return view('welcome')->with('lastPosts', $lastPosts)->with('lastEvents', $lastEvents)->with('lastEvents2', $lastEvents2);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store(CrearCultiuRequest $request)
{
//dd("Hola");
$cultiu = new Cultiu($request->all());
$cultiu->save();
$event = new Event();
$event->headline = "Inici";
$event->text = "Benvingut";
$event->startDate = $cultiu->startDate;
$event->endDate = $cultiu->startDate;
$event->tevent_id = 1;
$cultiu->save();
$event->cultiu_id = $cultiu->id;
$event->save();
// return redirect('home/cultiu/'.$cultiu->id);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$events = Event::where('user_id', $user_id)->get();
$jobs = Job::where('user_id', $user_id)->get();
// return view('members.dashboardpage', ['user' => $user, 'events' => $events, 'jobs' => $jobs]);
return view('public.frontpage', ['user' => $user, 'events' => $events, 'jobs' => $jobs]);
}
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$u = User::create(['first_name' => 'test', 'last_name' => 'test', 'email' => '*****@*****.**', 'level' => 1]);
$u2 = User::create(['first_name' => 'test2', 'last_name' => 'test2', 'email' => '*****@*****.**', 'level' => 1]);
$u3 = User::create(['first_name' => 'test3', 'last_name' => 'test3', 'email' => '*****@*****.**', 'level' => 2]);
$e1 = Event::create(['name' => 'test event', 'user_id' => 3, 'slug' => 'test-event-1', 'date' => '2016-10-17', 'start' => '18:00:00', 'end' => '5:00:00']);
$e2 = Event::create(['name' => 'test event', 'user_id' => 1, 'slug' => 'test-event-2', 'date' => '2016-08-22', 'start' => '19:00:00', 'end' => '5:00:00']);
Event::create(['name' => 'test event', 'user_id' => 2, 'slug' => 'test-event-3', 'date' => '2017-01-07', 'start' => '18:00:00', 'end' => '5:00:00']);
$p1 = Playlist::create(['name' => 'Playlist principale !']);
$p2 = Playlist::create(['name' => 'The Playlist !']);
$p3 = Playlist::create(['name' => 'Playlist secondaire']);
Playlist::create(['name' => 'The Playlist !']);
$p1->styles()->sync([1, 2, 3]);
$p2->styles()->sync([1, 4]);
$p3->styles()->sync([1, 3, 5, 7]);
$e1->playlists()->sync([1, 3]);
$e2->playlists()->sync([2]);
Comment::create(['event_id' => 2, 'user_id' => 2, 'content' => 'Sooo goooood']);
Comment::create(['event_id' => 3, 'user_id' => 2, 'content' => 'Sooo goooood :D']);
Comment::create(['event_id' => 2, 'user_id' => 3, 'content' => 'Sooo goooood !!!']);
Video::create(['url' => '7l48bfQuJeE', 'artist' => 'Chill Bump', 'name' => 'Lost In The Sound', 'tags' => 'chill bump lost in the sound']);
Video::create(['url' => 'XxdPJvhQaMU', 'artist' => 'Chill Bump', 'name' => 'Water boycotter', 'tags' => 'chill bump water boycotter']);
Video::create(['url' => 'kWXAYDQ_K7k', 'artist' => 'Chill Bump', 'name' => 'The Memo', 'tags' => 'chill bump the memo']);
$pivot1 = $p1->videos()->sync([1, 3]);
$pivot2 = $p2->videos()->sync([2]);
$pivot3 = $p3->videos()->sync([1, 2, 3]);
News::create(['title' => 'news test', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ', 'user_id' => 2, 'slug' => 'text-news-1']);
News::create(['title' => 'news test 2', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ', 'user_id' => 3, 'slug' => 'text-news-2']);
Article::create(['title' => 'Article test 1', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ', 'user_id' => 2, 'slug' => 'text-article-1']);
Article::create(['title' => 'Article test 2', 'content' => 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum. ', 'user_id' => 3, 'slug' => 'text-article-2', 'event_id' => 2]);
}
/**
* Edit timeline /
*/
public function editTimeline($timeline_id, Request $request)
{
$timeline = \App\Timeline::where('id', '=', $timeline_id)->first();
$timeline_events = $timeline->event()->orderBy('start_date')->get();
if ($request->input('showForm') == 'true') {
return view('timelines.editTimeline')->with('showForm', 'true')->with('timeline', $timeline)->with('timeline_events', $timeline_events);
} else {
// Else submit form
// Validate the request data
$this->validate($request, ['name' => 'required']);
$user = \Auth::user();
$timeline->name = $request->input('name');
$timeline->description = $request->input('description');
$timeline->last_modified_by = $user->id;
$timeline->save();
// Delete events
for ($e = 0; $e < count($timeline_events); $e++) {
if ($request->input('delete_event' . $e) == 'true') {
\DB::table('character_event')->where('event_id', '=', $timeline_events[$e]->id)->delete();
\DB::table('event_location')->where('event_id', '=', $timeline_events[$e]->id)->delete();
$event = \App\Event::where('id', '=', $timeline_events[$e]->id)->first();
if ($event) {
$event->delete();
}
}
}
// Return success message
return view('timelines.editTimeline')->with('showForm', 'false')->with('timeline', $timeline);
}
}
function postTask(Request $request)
{
$task = $request->all();
Task::create($task);
$comm = Committee::where('id', $task['comm_id'])->first();
$evnt = Event::where('id', $comm['event_id'])->first();
//UPDATING WEIGHT OF COMMITTEE AND EVENT
$comm->increment('weight', $task['weight']);
$evnt->increment('weight', $task['weight']);
//UPDATING PROGRESS OF COMMITTEE
$progress = 0;
$tasks = Task::where('comm_id', $comm->id)->get();
foreach ($tasks as $task1) {
$progress += $task1->weight * $task1->progress;
}
$progress = $progress / $comm->weight;
$comm->progress = $progress;
$comm->save();
//UPDATING PROGRESS OF EVENT
$progress2 = 0;
$committees = Committee::all();
foreach ($committees as $committee) {
if ($committee->event_id == $evnt->id) {
$progress2 += $committee->weight * $committee->progress;
}
}
$progress2 = $progress2 / $evnt->weight;
$evnt->progress = $progress2;
$evnt->save();
return redirect('profile');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//Unguard
Model::unguard();
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
//Truncate
Participant::truncate();
//Event::truncate();
Tag::truncate();
Post::truncate();
//Image::truncate();
DB::statement('TRUNCATE `taggables`;');
//DB::statement('TRUNCATE `imagables`;');
DB::statement('TRUNCATE `participations`;');
DB::statement('TRUNCATE `albumables`;');
Event::reindex();
Participant::reindex();
User::reindex();
Album::reindex();
//Call
$this->call(ParticipantTableSeeder::class);
$this->call(EventTableSeeder::class);
$this->call(TagTableSeeder::class);
//Reguard
Model::reguard();
DB::statement('SET FOREIGN_KEY_CHECKS=1;');
}
public static function boot()
{
parent::boot();
static::updated(function ($node) {
\Event::fire(new NodeUpdated($node));
});
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($tag)
{
$articles = News::withAnyTag($tag)->get();
$artworks = Artwork::withAnyTag($tag)->get();
$events = Event::withAnyTag($tag)->get();
return View::make('tags/show', compact('articles', 'artworks', 'events', 'tag'));
}
private function getAllEvents()
{
$now = Carbon::now();
$thisWeek = [];
$nextWeek = [];
$upcoming = [];
$past = [];
$events = Event::all();
foreach ($events as $event) {
$event->banner;
$event = $event->formatEvent();
if ($event['start'] == null) {
array_push($upcoming, $event);
} else {
if ($event->end < $now) {
array_push($past, $event);
} else {
if ($event->start->year == $now->year && $event->start->weekOfYear == $now->weekOfYear) {
array_push($thisWeek, $event);
} else {
if ($event->start->weekOfYear == $now->weekOfYear + 1) {
array_push($nextWeek, $event);
}
}
}
}
}
$allEvents = [];
array_push($allEvents, $thisWeek, $nextWeek, $upcoming, $past);
return $allEvents;
}
/**
* Show the application welcome screen to the user.
*
* @return Response
*/
public function index()
{
$events = Event::take('4')->get();
$authors = Author::take('4')->get();
$coverage = DB::table('press')->take('4')->orderBy('press_date', 'desc')->get();
return view('welcome', compact('events', 'authors', 'coverage'));
}
public function handleActivityPlan(Request $request)
{
$occurrences = $request->input('occurrences');
$eventPatterns = $request->input('patterns');
// occurrencejen käsittely
foreach ($occurrences as $occurrence) {
$eventOccurrence = EventOccurrence::findOrFail($occurrence['id']);
foreach ($occurrence['activities'] as $activityId) {
$activity = Activity::findOrFail($activityId);
$eventOccurrence->activities()->attach($activity);
}
}
// eventPatternien käsittely
foreach ($eventPatterns as $eventPattern) {
$eventPatternReal = EventPattern::findOrFail($eventPattern['id']);
$event = new Event();
$event->time = Carbon::createFromFormat('d.m.Y H:i', $eventPattern['date']);
$event->endDate = Carbon::createFromFormat('d.m.Y', $eventPattern['datePart']);
$event->description = " ";
$event->place = " ";
$event->name = $eventPatternReal->name;
$event->group_id = $request->input('group');
$event->save();
$eventOccurrence = new EventOccurrence();
$eventOccurrence->date = Carbon::createFromFormat('d.m.Y', $eventPattern['datePart']);
$eventOccurrence->event_id = $event->id;
$eventOccurrence->save();
foreach ($eventPattern['activities'] as $activityId) {
$activity = Activity::findOrFail($activityId);
$eventOccurrence->activities()->attach($activity);
}
}
return 2;
}
public function join($eventId)
{
$user = \JWTAuth::parseToken()->toUser();
$event = \App\Event::find($eventId);
$event->users()->attach($user->id);
response()->json(['message' => 'User Joined Event'], 200);
}
public static function eventsUsuari($cultius)
{
if (!is_null($cultius)) {
// foreach ($cultius as $cultiu){
// dd($cultiu);
if (!is_null($cultius)) {
$results = Event::select('id', 'headline', 'text', 'startDate', 'cultiu_id')->where(function ($query) use($cultius) {
foreach ($cultius as $value) {
if (!is_null($value)) {
//you can use orWhere the first time, dosn't need to be ->where
$query->orWhere('cultiu_id', $value['id']);
}
}
})->orderBy('updated_at', 'desc')->get()->toArray();
foreach ($results as $passa) {
$dades[] = $passa;
}
}
//}
}
//dd($dades);
if (!is_null($dades)) {
return $dades;
}
}
public function submitEvent(Request $request)
{
$data = json_decode($request->getContent());
$event = new Event();
$event->name = $data->event->name;
if (array_key_exists('public', $data->event)) {
$event->public = true;
} else {
$event->public = '';
}
$event->location = $data->event->location;
$event->description = $data->event->description;
$event->date = $data->event->date;
$event->stime = $data->event->stime;
$event->etime = $data->event->etime;
$event->uid = Auth::user()->uid;
try {
$saveflag = Event::saveEvent($event);
} catch (Exception $e) {
print '<script type="text/javascript">';
print 'alert("The system has encountered an error please try again later")';
print '</script>';
}
$this->validatePoll($request, $event->eid);
$this->splitEmails($data->emails[0], $event->eid);
ApiEventItemController::submitItems($request, $event->eid);
}
public function showHomePage(Request $r)
{
$var = $this->getVars();
$content = array();
$content["services"] = Content::where('type', '=', 'services')->get();
$content["fields"] = Content::where('type', '=', 'fields')->get();
$events = Event::get();
$content["blogs"] = Content::where('type', '=', 'blogs')->orderBy("date_created", "desc")->take(3)->get();
$content["members"] = Member::orderBy('position', 'desc')->get();
$content["didactics"] = Content::where('type', '=', 'didactics')->orderBy("date_created", "desc")->take(3)->get();
$content["resources"] = Content::where('type', '=', 'resources')->orderBy("date_created", "desc")->take(3)->get();
$content["galleries"] = Content::where('type', '=', 'galleries')->orderBy("date_created", "desc")->take(3)->get();
$content["companies"] = Content::where('type', '=', 'companies')->orderBy("date_created", "desc")->get();
$content["researchesours"] = Content::where('type', '=', 'researches')->whereHas('research', function ($query) {
$query->where('external', 0);
})->orderBy("date_created", "desc")->take(2)->get();
$content["researchesexternal"] = Content::where('type', '=', 'researches')->whereHas('research', function ($query) {
$query->where('external', 1);
})->orderBy("date_created", "desc")->take(2)->get();
$services = Content::where('type', '=', 'services')->get();
// dd($content);
$lang = $r->session()->get("lang", "fa");
// if($lang == "en")
// return view("testhome",["content" => $content, "var" => $var, "lang" => $lang]);
return view('home', ["content" => $content, "var" => $var, "lang" => $lang]);
}
