/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$sessions = ClassroomSession::select('id', 'classroom_id')->whereIn('classroom_id', [157, 168, 176, 186, 198, 213, 217])->get();
// $this->comment(PHP_EOL.$sessions->count().PHP_EOL);
foreach ($sessions as $session) {
$students = ClassroomStudent::select('student_id')->where('student_id', 1841)->where('classroom_id', $session->classroom_id)->get();
// $this->comment(PHP_EOL.$students->count().PHP_EOL);
foreach ($students as $student) {
$exist = StudentClassroomSession::where('classroom_session_id', $session->id)->where('student_id', $student->student_id)->value('id');
if ($exist) {
$this->comment(PHP_EOL . ' HAS ' . $exist . PHP_EOL);
} else {
$data = ['student_id' => $student->student_id, 'attendee_id' => $student->student_id, 'classroom_session_id' => $session->id, 'student_link' => '', 'semester_id' => 9];
$attendance = ['entry_time' => null, 'exit_time' => null, 'attended_minutes' => null, 'teacher_id' => null, 'classroom_session_id' => $session->id, 'student_id' => $student->id, 'valid' => 0, 'manual' => 0];
StudentClassroomSession::create($data);
ClassroomSessionAttendance::create($attendance);
$this->comment(PHP_EOL . ' NOT ' . PHP_EOL);
}
}
}
// Student::with('classrooms', 'subjects')->has('classrooms', '=', 3)->leftJoin('subject_sub')
exit;
\DB::connection()->enableQueryLog();
Exam::select('exams.type', 'exams.start_at', 'exams.finish_at', 'exams.name', 'exams.id')->join('subject_subjects as subsub', 'subsub.id', '=', 'exams.subject_id')->join('student_subjects as stusub', function ($j) {
$j->on('stusub.subject_id', '=', 'subsub.id')->where('stusub.student_id', '=', 10001)->where('stusub.state', '=', 'study');
})->where(function ($query) {
$query->orWhereIn('exams.type', ['midterm', 'remidterm', 'activity'])->orWhereRaw('exams.id IN (SELECT ce.exam_id FROM classrooms_exam as ce
JOIN classrooms as c ON c.id = ce.classroom_id
JOIN classroom_students as cs ON cs.classroom_id = c.id
AND cs.student_id = 10001
WHERE exam_id = exams.id GROUP BY ce.id)');
// if ($request->has('finalExam') == 'true') {
// $query->orWhereIn('exams.type',
// [
// 'final',
// 'summer',
// 'refinal'
// ]);
// }
})->where('exams.semester_id', 9)->where('finish_at', '>=', date('Y-m-d H:i:s'))->groupBy('exams.id')->orderBy('exams.start_at', 'ASC')->get();
// Exam::count();
$query = \DB::getQueryLog();
$lastQuery = end($query);
var_dump($lastQuery);
// echo "done";
exit;
// $sessions = ClassroomSession::select('id')->whereIn('interval_id', [2,14,15])->get();
// foreach ($sessions as $session) {
// ClassroomSessionAttendance::where('classroom_session_id', $session->id)->update(['valid' => 1]);
// }
}
