/**
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function index()
{
$request = request();
$name = $request->has('name') ? $request->get('name') : '';
$sponsors = Sponsor::where(function ($query) use($name) {
if (!empty($name)) {
$query->where('name', 'LIKE', "%{$name}%");
}
})->paginate(env('LIMIT', 15));
return view('sponsors.index', compact('sponsors', 'name'));
}
/**
* Show the Project view page. (BY ANDREI)
*
* @return project_tbl data, date, amount
*/
public function show($slug)
{
// fetch data according to slug
$project = $slug;
$logos = Sponsor::where('active', 1)->get();
// find the Users Favourites and catch them
$favourites = Favourite::all()->where('user_id', Session::get('userId'))->where('project_id', $project->id);
//dd($favourites);
// convert DB date into european date format
$finish_date = date("d-m-Y", strtotime($project->completed_on));
// convert DB amounts into european currency format
$amount_raised = number_format($project->amount_raised, 2, ',', '.');
$target_amount = number_format($project->target_amount, 2, ',', '.');
$galleryImages = \App\Image::where('project_id', $project->id)->get();
return view('pages.projectpage', compact('project', 'logos', 'finish_date', 'amount_raised', 'target_amount', 'galleryImages', 'favourites'));
}
public function relistSponsor($sponsorId)
{
$sponsor = Sponsor::where('id', $sponsorId)->update(['active' => 1]);
return redirect()->back();
}
private function createSpecialEvents()
{
//NSBreakfast May
$nsBreakfastMay = Carbon::create(2016, 5, 6, 8, 0, 0, new \DateTimeZone('Australia/Melbourne'));
$nsBreakfastMay->setTimezone(new \DateTimeZone('UTC'));
// using slug as a unique string identifier
$slug = Str::slug(Event::SPECIAL . " {$nsBreakfastMay}");
$this->info("Special Event (NSBreakfast) {$nsBreakfastMay} UTC");
$event = Event::firstOrNew(['slug' => $slug]);
$event->type = Event::SPECIAL;
$event->slug = $slug;
$event->title = 'NSBreakfast';
$event->subtitle = 'Informal and unstructured; Hang out, drink coffee, eat breakfast and chat iOS / OSX';
$event->starts_at = $nsBreakfastMay;
$event->ends_at = $nsBreakfastMay->copy()->addHours(2);
$event->contact = 'https://twitter.com/nsbreakfast';
$event->contact_name = 'Matt Delves';
$event->location = '1000 £ Bend';
$event->location_link = 'http://thousandpoundbend.com.au';
$event->address_display = '361 Little Lonsdale St, Melbourne';
$event->address = '361 Little Lonsdale St, Melbourne, VIC 3000';
$event->lat = -37.811672;
$event->lng = 144.959092;
$event->save();
//NSBreakfast June
$nsBreakfastJune = Carbon::create(2016, 6, 3, 7, 30, 0, new \DateTimeZone('Australia/Melbourne'));
$nsBreakfastJune->setTimezone(new \DateTimeZone('UTC'));
$slug = Str::slug(Event::SPECIAL . " {$nsBreakfastJune}");
$this->info("Special Event (NSBreakfast) {$nsBreakfastJune} UTC");
$event = Event::firstOrNew(['slug' => $slug]);
$event->type = Event::SPECIAL;
$event->slug = $slug;
$event->title = 'NSBreakfast';
$event->subtitle = 'Informal and unstructured; Hang out, drink coffee, eat breakfast and chat iOS / OSX';
$event->starts_at = $nsBreakfastJune;
$event->ends_at = $nsBreakfastJune->copy()->addHours(2);
$event->contact = 'https://twitter.com/nsbreakfast';
$event->contact_name = 'Matt Delves';
$event->location = 'Hash Specialty Coffee';
$event->location_link = 'http://facebook.com/hashcoffeeroasters';
$event->address_display = '113 Hardware St, Melbourne';
$event->address = '113 Hardware St, Melbourne, VIC 3000';
$event->lat = -37.8123025;
$event->lng = 144.9605897;
$event->save();
//WWDC Event June 2016
$wwdcEventJune2016 = Carbon::create(2016, 6, 16, 18, 30, 0, new \DateTimeZone('Australia/Melbourne'));
$wwdcEventJune2016->setTimezone(new \DateTimeZone('UTC'));
$slug = Str::slug(Event::SPECIAL . " {$wwdcEventJune2016}");
$this->info("Special Event (WWDC) {$wwdcEventJune2016} UTC");
$event = Event::firstOrNew(['slug' => $slug]);
$event->type = Event::SPECIAL;
$event->slug = $slug;
$event->title = 'Cocoaheads WWDC Special Event';
$event->subtitle = <<<'EOT'
We're going to start off with a special intro I'm calling 'The Keynote That Was' (TKTW) and we will then watch two
to three WWDC sessions. Depending on what's available at the time, we might have a few options but the best ones will be
the State of the Union sessions that are usually presented on the Tuesday morning in San Francisco.
EOT;
$event->starts_at = $wwdcEventJune2016;
$event->ends_at = $wwdcEventJune2016->copy()->addHours(3);
$event->location = 'Teamsquare';
$event->location_link = 'https://teamsquare.co/contact';
$event->address_display = 'Level 1, 520 Bourke Street, Melbourne';
$event->address = 'Level 1, 520 Bourke Street, Melbourne VIC 3000';
$event->lat = -37.8153744;
$event->lng = 144.958427;
$event->tickets = 'http://melbournecocoaheads-wwdc-2016.eventbrite.com.au';
$event->contact = 'https://twitter.com/melbournecocoa';
$event->contact_name = 'Jesse Collis';
$event->save();
$event->sponsors()->detach();
$event->sponsors()->attach(Sponsor::where('name', '=', 'Teamsquare')->first());
$event->sponsors()->attach(Sponsor::where('name', 'Odecee')->first());
}
public function sponsors()
{
$logos = Sponsor::where('active', 1)->where('top_sponsor', 0)->get()->sortBy('ranking');
$top_sponsors = Sponsor::where('active', 1)->where('top_sponsor', 1)->get()->sortBy('ranking');
return view('pages.sponsors', compact('logos', 'top_sponsors'));
}
