public function editForm($id) { $media = \App\Media::get()->where('id', intval($id))->toArray(); if (empty($media)) { App: abort(404); } $media = current($media); $model = array(); $model['name'] = $media['name']; $model['credit'] = $media['credit']; $model['series'] = $media['series']; $model['collection'] = $media['collection']; $model['numberInCollection'] = $media['numberInCollection']; $model['medium'] = $media['medium']; $model['summary'] = $media['summary']; $model['date'] = $media['timelineDate']; $seriesAbbrToName = \App\Series::get()->pluck('seriesName', 'seriesAbbreviation')->toArray(); $mediums = \App\Media::select('medium')->distinct()->get()->pluck('medium')->toArray(); $series = \App\Series::get()->pluck('seriesAbbreviation'); $seriesToCollections = array(); foreach ($series as $thisSeries) { $seriesToCollections[$thisSeries] = \App\Media::select('collection')->where('series', $thisSeries)->distinct()->get()->pluck('collection')->toArray(); } return view('forms/editMedia')->with(['seriesToCollections' => $seriesToCollections, 'seriesAbbrToName' => $seriesAbbrToName, 'mediums' => $mediums, 'series' => $series, 'model' => $model]); }
public function index() { /* Get data for timeline */ $eventDates = \App\Event::select('timelineDate')->distinct()->get()->pluck('timelineDate')->toArray(); $mediaDates = \App\Media::select('timelineDate')->distinct()->get()->pluck('timelineDate')->toArray(); $dates = array_unique(array_merge($eventDates, $mediaDates), SORT_REGULAR); usort($dates, array('\\App\\Http\\Controllers\\TimelineController', 'dateCompare')); $media = array(); $events = array(); foreach ($dates as $date) { $eventsForThisDate = \App\Event::get()->where('timelineDate', $date)->toArray(); $mediaForThisDate = \App\Media::get()->where('timelineDate', $date)->toArray(); usort($eventsForThisDate, array('\\App\\Http\\Controllers\\TimelineController', 'itemCompare')); usort($mediaForThisDate, array('\\App\\Http\\Controllers\\TimelineController', 'itemCompare')); $media[$date] = $mediaForThisDate; $events[$date] = $eventsForThisDate; } /* Get data for filters */ $mediums = \App\Media::select('medium')->distinct()->get()->pluck('medium')->toArray(); $tags = \App\EventTag::select('tag')->distinct()->get()->pluck('tag')->toArray(); $series = \App\Series::get()->pluck('seriesAbbreviation'); sort($mediums); sort($tags); $eventIDToTags = array(); $eventIDs = \App\Event::get()->pluck('id'); foreach ($eventIDs as $eventID) { $eventIDToTags[$eventID] = \App\EventTag::select('tag')->where('eventID', $eventID)->get()->pluck('tag')->toArray(); } $seriesToCollections = array(); foreach ($series as $thisSeries) { $seriesToCollections[$thisSeries] = \App\Media::select('collection')->where('series', $thisSeries)->distinct()->get()->pluck('collection')->toArray(); } /* Get event-media relationships */ $eventMediaPairs = \App\EventMedia::get(array('eventID', 'mediaID'))->toArray(); return view('timeline')->with(['seriesToCollections' => $seriesToCollections, 'eventMediaPairs' => $eventMediaPairs, 'eventIDToTags' => $eventIDToTags, 'mediums' => $mediums, 'events' => $events, 'dates' => $dates, 'media' => $media, 'tags' => $tags]); }