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