public function byStudent()
{
return Subscription::where('subscriptions.ignored', false)->with('city')->with('school');
}
public function createSubscription($input)
{
$model = new Subscription();
$input = $input->only($model->getFillable());
if ($subscription = $model->where('cpf', $input['cpf'])->where('registration', $input['registration'])->first()) {
throw new AlreadySubscribed();
}
$subscription = Subscription::firstOrCreate($input);
event(new SubscriptionWasCreated($subscription));
return $subscription;
}
public function login($registration, $birthdate)
{
$person = Subscription::where(\DB::raw("trim(both ' ' from registration)"), trim($registration))->where(\DB::raw("trim(both ' ' from birthdate)"), trim($birthdate))->first();
Session::put('logged-user', $person);
return $person;
}
function city($city)
{
return view('admin.city')->with('city', $city)->with('subscriptions', Subscription::where('city', $city)->get())->with('schools', School::where('city', 'like', DB::raw("UPPER('" . $city . "')"))->get());
}
