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