public function seedSubClassSubject()
{
$drafts = Draft::all();
foreach ($drafts as $index => $draft) {
$teacher_name = trim($draft->teacher);
$email = str_slug($teacher_name) . '@vnu.edu.vn';
$teacher = User::all()->where('email', $email)->first();
$teacher_id = $teacher->id;
$tietX = $draft->tiet;
$arr = explode('-', $tietX);
if (count($arr) == 2) {
$t_begin = intval($arr[0]);
$t_end = intval($arr[1]);
$thu = intval($draft->thu);
$viTri = ($thu - 2) * 10 + $t_begin;
$soTiet = $t_end - $t_begin + 1;
$nhom_X = $draft->note;
$nhom = 0;
if (strtolower($nhom_X) == 'n1') {
$nhom = 1;
}
if (strtolower($nhom_X) == 'n2') {
$nhom = 2;
}
if (strtolower($nhom_X) == 'n3') {
$nhom = 3;
}
$classSubject = ClassSubject::all()->where('maLMH', $draft->maLMH)->first();
$sub = SubClassSubject::create(['teacher' => $teacher_id, 'address' => trim($draft->address), 'viTri' => intval($viTri), 'soTiet' => intval($soTiet), 'soSV' => intval($draft->soSV), 'classSubject' => intval($classSubject->id), 'nhom' => intval($nhom)]);
var_dump($index);
}
}
}
