public function geolocateAll() { ob_start(); foreach (School::all() as $school) { if ($school->address && !$school->latitude) { $this->geolocate($school); } } ob_end_clean(); }
public function sendSubscriptionCreatedMail($subscription) { $school = School::where('name', $subscription->school)->first(); $data = ['school_name' => $school->name, 'school_email' => $school->email, 'name' => $subscription->name, 'registration' => $subscription->registration, 'grade' => $subscription->grade, 'birthdate' => $subscription->birthdate, 'cpf' => $subscription->cpf, 'phone_home' => $subscription->phone_home, 'phone_cellular' => $subscription->phone_cellular, 'email' => $subscription->email, 'address' => $subscription->address, 'address_complement' => $subscription->address_complement, 'address_neighborhood' => $subscription->address_neighborhood, 'city' => $subscription->city]; if (!$school) { return false; } Mail::send('emails.new-subscription', ['data' => $data], function ($m) use($data) { $subject = 'Inscrição no Parlamento Juvenil: ' . $data['name']; $m->subject($subject); $m->to($data['school_email'], $data['school_name']); // $m->to('*****@*****.**', 'Parlamento Juvenil'); $m->to('*****@*****.**', 'Antonio Carlos Ribeiro'); // $m->to('*****@*****.**', 'Antonio Carlos Ribeiro (Alerj)'); }); }
private function seedMissingSchools() { $schools = $this->loadSchools('missing'); foreach ($schools as $school) { $school = $this->clearLine($school); $parts = explode("\t", $school); $model = School::where('censo', $parts[0])->first(); if (!$model) { continue; } $model->designation = $parts[1]; $model->address = $parts[3]; $model->number = $parts[4]; $model->neighborhood = $parts[5]; $model->zip_code = $parts[8]; $model->city = $parts[6]; $model->city_id = $this->findCityByName($parts[6])->id; $model->save(); } }
Artisan::call('db:seed'); }]); Route::get('old', ['as' => 'old', 'uses' => 'Home@index']); Route::get('/', ['as' => 'home', 'uses' => 'Home@index2016']); //Route::get('register', ['as' => 'home', 'uses' => 'Home@force']); Route::post('googleforms', function () { }); Route::any('news/sync', function (NewsSync $news) { return $news->sync(); }); Route::any('cities', function () { return State::where('code', 'RJ')->first()->cities()->orderBy('name')->get(); }); Route::any('schools/{city}', ['middleware' => 'cors', function ($city) { $city = mb_strtoclean($city); return School::where('city', '~*', strtoupper($city))->orderBy('name')->get(); }]); Route::get('download/{file}', ['as' => 'download', 'uses' => function ($file) { $path = env('LOCAL_BASE_DIR') . DIRECTORY_SEPARATOR . env('BASE_DIR') . DIRECTORY_SEPARATOR . env('SITE_DIR') . DIRECTORY_SEPARATOR; return response()->download(public_path($path) . $file); }]); Route::any('dados', function ($city) { $all = Subscription::all(); foreach ($all as $person) { } }); Route::group(['prefix' => 'admin/2016'], function () { Route::get('/', ['as' => 'admin.home', 'uses' => function () { return redirect()->route('admin.subscriptions'); }]); Route::get('subscriptions', ['as' => 'admin.subscriptions', 'uses' => 'Admin@index']);
public function bySchool() { return School::join('subscriptions', 'schools.name', '=', 'subscriptions.school')->where('subscriptions.ignored', false)->select('schools.*', DB::raw('(select count(*) from subscriptions where subscriptions.ignored = false and schools.name = subscriptions.school) as subscriptionCount'))->get(); }
function schools() { $schools = School::join('subscriptions', 'subscriptions.school', '=', 'schools.name')->select(['schools.name', 'schools.city', DB::raw('count(*) as schoolcount')])->groupBy(['schools.name', 'schools.city'])->orderBy('schoolcount', 'desc')->orderBy('schools.city')->orderBy('schools.name')->get(); return view('admin.schools')->with('schools', $schools); }
public function getSchoolsForCity($city) { return School::where('city', 'like', DB::raw("UPPER('" . $city . "')"))->get(); }