/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
if (Semester::count() > 0) {
return;
}
Semester::where('id', '>', 0)->delete();
Year::where('id', '>', 0)->delete();
$years = DB::connection('old')->table('eduyears')->get();
foreach ($years as $year) {
$new_year = new Year();
//new_year->id = $year->sub_id;
$new_year->name = $year->eyear_title;
//$new_year->start_at = $year->eyear_created ;
//$new_year->finish_at = $year->eyear_created + 1 year;
$new_year->save();
}
$this->command->info('year table seeded!');
$sems = DB::connection('old')->table('semesters')->get();
foreach ($sems as $sem) {
$new_semester = new Semester();
$new_semester->id = $sem->sem_id;
$new_semester->name = $sem->sem_name;
// $new_semester->start_at = $sem->sem_from ;
// $new_semester->finish_at = $sem->sem_to;
$new_semester->active = $sem->sem_current;
$new_semester->Academycycle_year_id = $sem->sem_eyearid;
$term = '';
if ($sem->sem_term == 1) {
$term = 'first';
}
if ($sem->sem_term == 2) {
$term = 'second';
}
if ($sem->sem_term == 3) {
$term = 'summer';
}
$new_semester->order = $term;
$new_semester->save();
}
$this->command->info('Semester table seeded!');
}
