/** * Run the database seeds. * * @return void */ public function run() { School::truncate(); School::create(['name' => 'Boston']); School::create(['name' => 'Chicago']); School::create(['name' => 'NYC']); School::create(['name' => 'DC']); School::create(['name' => 'Los Angeles']); }
public function addSchool($school_id) { if (!$school_id) { throw new \Exception('No school id provided'); } $school = School::find($school_id); if (!$school) { throw new \Exception('School does not exist. Could not find school with that id.'); } if (DB::table('school_student')->where('student_id', $this->id)->where('school_id', $school_id)->first()) { throw new \Exception('School has already been linked to student. Cannot be duplicated.'); } DB::table('school_student')->insert(['student_id' => $this->id, 'school_id' => $school_id, 'created_at' => Carbon::now()->toDateTimeString(), 'updated_at' => Carbon::now()->toDateTimeString()]); $this->schools = DB::table('school_student')->where('student_id', $this->id)->lists('school_id'); return $this; }
public function studentsWithSummaries($school_id) { return Response::json(\Tsny\Models\School::find($school_id)->studentsWithSummary()); }