/** * 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(); }