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 getEvents()
{
$events = ['' => 'Select one...'];
$conferences = Conference::where('start_date', '>', Carbon::now())->get();
$conferences = Helpers::keysByField($conferences, 'slug');
foreach ($conferences as $slug => $event) {
$events[$slug] = $event->city . ', ' . $event->state . ' | ';
$time = $event->start_date . (!empty($event->timezone) ? $event->timezone : '');
if (!empty($event->coming)) {
$events[$slug] .= date('F Y', strtotime($time));
} else {
$events[$slug] .= date('F j, Y', strtotime($time));
}
}
return $events;
}
protected function getEvents()
{
$events = ['' => 'Select one...'];
$conferences = Conference::current()->get();
$conferences = Helpers::keysByField($conferences, 'slug');
$conferences = Lookup::addOptions($conferences);
foreach ($conferences as $slug => $event) {
$events[$slug] = $event->city . ', ' . $event->state . ' | ';
$time = $event->start_date . (!empty($event->timezone) ? $event->timezone : '');
if (!empty($event->options->show_upcoming)) {
$events[$slug] .= date('F Y', strtotime($time));
} else {
$events[$slug] .= date('F j, Y', strtotime($time));
}
}
return $events;
}
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'));
}
