예제 #1
0
 public function index()
 {
     $route = Helpers::routeinfo();
     $options = Helpers::options($route);
     $navs = Helpers::navigation($route, $options);
     $sub = Helpers::navigation($route, $options, true);
     //		dd($options);
     $events = DB::table('conferences')->where('end_date', '>', Carbon\Carbon::now())->orderBy('start_date')->take(3)->get();
     $events = Lookup::lookup('conferences', [], ['upcoming' => true, 'current' => true, 'home' => true, 'published' => true]);
     //		dd($events);
     $venues = DB::table('venues')->where(function ($query) use($events) {
         foreach ($events as $i => $event) {
             if ($i === 0) {
                 $query->where('slug', '=', $event->venue_slug);
             } else {
                 $query->orWhere('slug', '=', $event->venue_slug);
             }
         }
     })->where('published', '>', '0000-00-00 00:00:00')->get();
     $venues = Helpers::keysByField($venues, 'slug');
     $benefits = DB::table('benefits')->where('published', '>', '0000-00-00 00:00:00')->orderBy('priority')->get();
     $intro = array_shift($benefits);
     $testimonials = DB::table('testimonials')->where('published', '>', '0000-00-00 00:00:00')->take(10)->get();
     return view('pages/index', compact('events', 'venues', 'intro', 'benefits', 'testimonials', 'route', 'options', 'navs', 'sub'));
 }
 protected function conference($route, $event)
 {
     $venue = Venue::where('slug', '=', $event->venue_slug)->published()->get();
     $venue = !empty($venue[0]) ? (object) $venue[0]->toArray() : null;
     $options = Helpers::options($route, $event->slug, $event);
     //		dd($options);
     $navs = Helpers::navigation($route, $options);
     $sub = Helpers::navigation($route, $options, true);
     $partners = (object) ['companies' => null, 'text' => null];
     if (!empty($event->partners)) {
         $undo = Helpers::unserialize($event->partners);
         $companies = Partner::where(function ($query) use($undo) {
             foreach ($undo['partners'] as $i => $slug) {
                 if ($i === 0) {
                     $query->where('slug', '=', $slug);
                 } else {
                     $query->orWhere('slug', '=', $slug);
                 }
             }
         })->published()->orderBy('company')->get();
         if (!empty($undo['text'])) {
             $partners->text = $undo['text'];
         }
         if (is_object($companies)) {
             $partners->companies = [];
             foreach ($companies as $i => $company) {
                 $partners->companies[] = (object) $company->toArray();
             }
         }
     }
     $unfilteredTopics = Topic::where('conference_slug', '=', $event->slug)->published()->get();
     $topics = [];
     foreach ($unfilteredTopics as $topic) {
         $topics[] = [$topic->title => $topic->text];
     }
     if ((bool) $options->topics_by_alpha === true) {
         sort($topics);
     }
     //dd($topics);
     $agendasRaw = Agenda::where('conference_slug', '=', $event->slug)->published()->orderBy('timeslot')->orderBy('priority')->get();
     $speakerList = [];
     $agendas = [];
     if (is_object($agendasRaw)) {
         foreach ($agendasRaw as $i => $agenda) {
             $agenda = (object) $agenda->toArray();
             list($date, $time) = explode(' ', $agenda->timeslot);
             if (!empty($agenda->speakers)) {
                 //					$agenda->speakers = Helpers::unserialize($agenda->speakers);
                 //					dd($agenda->speakers);
                 $agendaSpeakers = explode(',', $agenda->speakers);
                 $agenda->speakers = [];
                 if (is_array($agendaSpeakers)) {
                     foreach ($agendaSpeakers as $s) {
                         @(list($speakerType, $speakerSlug) = @explode('|', $s));
                         $agenda->speakers[$speakerType][] = $speakerSlug;
                     }
                     //							dd($agenda->speakers);
                 }
             }
             $agendas[$date][$time][] = $agenda;
             if (!empty($agenda->speakers)) {
                 $speakersTypes = $agenda->speakers;
                 if (is_array($speakersTypes)) {
                     ksort($speakersTypes);
                     //						dd($speakersTypes);
                     foreach ($speakersTypes as $speakers) {
                         $speakerList = array_merge($speakerList, $speakers);
                     }
                 }
             }
         }
     }
     //		dd($agendas);
     if (count($speakerList) > 0) {
         $speakers = Speaker::where(function ($query) use($speakerList) {
             $query->where('slug', '=', array_pop($speakerList));
             while (count($speakerList) > 0) {
                 $query->orWhere('slug', '=', array_pop($speakerList));
             }
         })->published()->orderBy('last_name')->get();
         $speakers = Helpers::keysByField($speakers, 'slug', function ($value, $key, $field, $array, $toObj) {
             $value->sessions = [];
             return $value;
         }, true);
     }
     if ((bool) $options->sponsor_levels === true) {
         $sponsors = Lookup::lookup('sponsors', ['conference_slug' => $event->slug], ['published' => true, 'sponsorlevels' => true]);
     } else {
         $sponsors = Lookup::lookup('sponsors', ['conference_slug' => $event->slug], ['published' => true]);
     }
     //		dd($options);
     return view('pages/conference', compact('event', 'venue', 'partners', 'topics', 'agendas', 'speakers', 'sponsors', 'options', 'navs', 'sub'));
 }
 protected function conference($route, $event)
 {
     $venue = Venue::where('slug', '=', $event->venue_slug)->published()->get();
     $venue = !empty($venue[0]) ? (object) $venue[0]->toArray() : null;
     $event->options = !empty($event->options) ? Helpers::unserialize($event->options) : [];
     $options = Helpers::options($route, 'conference', $event->options);
     $options = (array) $options;
     foreach ($options as $key => $option) {
         if (is_string($option) && preg_match("/^([a-z]+):([a-z]+)\$/i", $option)) {
             list($foo, $bar) = explode(':', $option);
             $options[$key] = ${$foo}->{$bar};
         }
     }
     $options = (object) $options;
     //		dd($options);
     $navs = Helpers::navigation($route, $options);
     $sub = Helpers::navigation($route, $options, true);
     $partners = (object) ['companies' => null, 'text' => null];
     if (!empty($event->partners)) {
         $undo = Helpers::unserialize($event->partners);
         $companies = Partner::where(function ($query) use($undo) {
             foreach ($undo['partners'] as $i => $slug) {
                 if ($i === 0) {
                     $query->where('slug', '=', $slug);
                 } else {
                     $query->orWhere('slug', '=', $slug);
                 }
             }
         })->published()->orderBy('company')->get();
         if (!empty($undo['text'])) {
             $partners->text = $undo['text'];
         }
         if (is_object($companies)) {
             $partners->companies = [];
             foreach ($companies as $i => $company) {
                 $partners->companies[] = (object) $company->toArray();
             }
         }
     }
     $agendasRaw = Agenda::where('conference_id', '=', $event->id)->published()->orderBy('timeslot')->orderBy('priority')->get();
     $speakerList = [];
     $agendas = [];
     if (is_object($agendasRaw)) {
         foreach ($agendasRaw as $i => $agenda) {
             $agenda = (object) $agenda->toArray();
             list($date, $time) = explode(' ', $agenda->timeslot);
             if (!empty($agenda->speakers)) {
                 $agenda->speakers = Helpers::unserialize($agenda->speakers);
             }
             $agendas[$date][$time][] = $agenda;
             if (!empty($agenda->speakers)) {
                 $speakersTypes = $agenda->speakers;
                 if (is_array($speakersTypes)) {
                     ksort($speakersTypes);
                     foreach ($speakersTypes as $speakers) {
                         $speakerList = array_merge($speakerList, $speakers);
                     }
                 }
             }
         }
     }
     if (count($speakerList) > 0) {
         $speakers = Speaker::where(function ($query) use($speakerList) {
             $query->where('slug', '=', array_pop($speakerList));
             while (count($speakerList) > 0) {
                 $query->orWhere('slug', '=', array_pop($speakerList));
             }
         })->published()->orderBy('last_name')->get();
         $speakers = Helpers::keysByField($speakers, 'slug', function ($value, $key, $field, $array, $toObj) {
             $value->sessions = [];
             return $value;
         }, true);
     }
     if ((bool) $options->sponsorlevels === true) {
         $sponsors = Lookup::lookup('sponsors', ['conference' => $event->id], ['published' => true, 'sponsorlevels' => true]);
     } else {
         $sponsors = Lookup::lookup('sponsors', ['conference' => $event->id], ['published' => true]);
     }
     //		dd($sponsors);
     return view('pages/conference', compact('event', 'venue', 'partners', 'agendas', 'speakers', 'sponsors', 'options', 'navs', 'sub'));
 }