/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
header("Access-Control-Allow-Origin: *");
$levels = ['Platinum', 'Gold', 'Silver', 'Bronze'];
$sponsors = [];
foreach ($levels as $level) {
$sponsors[] = ['level' => $level, 'sponsors' => Sponsor::where('sponsor_active', 1)->where('sponsorship_level', $level)->orderBy('sponsor_name')->get()];
}
return response()->json(['data' => $sponsors], 200);
}
public static function lookup_sponsors($params, $flags)
{
// $groups = ConferenceSponsor::join('sponsors', 'conference_sponsors.sponsor_slug', '=', 'sponsors.slug')
// ->where('conference_slug', '=', $params->conference_slug);
$groups = Sponsor::where('conference_slug', '=', $params->conference_slug)->published();
if (self::flags($flags, 'published')) {
$groups->published();
}
if (self::flags($flags, 'sponsorlevels')) {
$groups->orderBy('sponsorship');
}
$groups->orderBy('company');
$groups = $groups->get();
if (!$groups->isEmpty()) {
$sponsors = (object) [];
$sponsorship = '';
foreach ($groups as $sponsor) {
$sponsor = (object) $sponsor->toArray();
$slug = $sponsor->slug;
if (self::flags($flags, 'sponsorlevels')) {
if ($sponsorship !== $sponsor->sponsorship) {
$sponsorship = $sponsor->sponsorship;
$sponsors->{$sponsorship} = (object) [];
}
$sponsors->{$sponsorship}->{$slug} = $sponsor;
} else {
$sponsors->{$slug} = $sponsor;
}
}
return $sponsors;
}
return (object) [];
}
public function getSponsorLogos()
{
return Sponsor::where('sponsorship_level', 'Platinum')->orderBy('sponsor_name')->leftJoin('sponsorship_levels', 'sponsorship_levels.level', '=', 'sponsors.sponsorship_level')->where('sponsor_active', 1)->get();
}
