public function index(Request $request)
{
$attendances = Attendance::orderBy('csa.id', 'desc')->selectRaw('CONCAT(cs.title," ،للمادة ", ss.name) as session_title,csa.classroom_session_id as session_id')->from('classroom_session_attendances as csa')->join('classroom_sessions as cs', 'cs.id', '=', 'csa.classroom_session_id')->join('subject_subjects as ss', 'ss.id', '=', 'cs.subject_subject_id')->leftJoin('classroom_session_excuses as cse', function ($j) {
$j->on('cse.session_id', "=", 'cs.id')->where('cse.status', '=', 'accepted')->on('csa.student_id', '=', 'cse.student_id');
})->whereNull('cse.id');
if ($request->has('valid')) {
$attendances->where('valid', $request->input('valid'));
}
if ($request->has('student_id')) {
$attendances->where('csa.student_id', $request->input('student_id'));
}
return $attendances->groupBy('csa.id')->pluck('session_title', 'session_id');
}
/**
* 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]);
// }
}
public function student(Request $request, $studentId)
{
// $students = Student::isStudying()->pluck('name', 'id')->toArray();
$student_attends = ClassroomSessionAttendance::select('valid', 'manual', 'subject_subjects.id', 'subject_subjects.hour', 'subject_subjects.name', 'classroom_sessions.title')->leftJoin('classroom_sessions', 'classroom_session_attendances.classroom_session_id', '=', 'classroom_sessions.id')->leftJoin('subject_subjects', 'subject_subject_id', '=', 'subject_subjects.id')->where('student_id', $studentId)->where('classroom_sessions.canceled', 0)->where('wiziq_status', "completed")->get();
return view('classrooms::reports.student', compact('student_attends'));
}
/**
* Execute the console command.
*
* @return mixed
*/
public function handle()
{
$this->comment(PHP_EOL . 'adding' . PHP_EOL);
$WiziqApi = new WiziqApi();
// $report = $WiziqApi->getAttendanceReport(5435948);
// var_dump($report);
// exit;
$sessions = ClassroomSession::select('classroom_sessions.id', 'classroom_sessions.wiziq_id', 'classroom_sessions.title', 'classroom_sessions.classroom_id', 'classroom_sessions.subject_subject_id')->leftJoin('classroom_session_attendances as csa', 'classroom_sessions.id', '=', 'csa.classroom_session_id')->whereNull('csa.id')->with('subject')->groupBy('classroom_sessions.id')->whereCanceled(0)->whereDate('classroom_sessions.start_at', '>', date('2016-10-30'))->where('start_at', '<', date('Y-m-d H:i:s', strtotime('-60 minutes')))->get();
$this->comment(PHP_EOL . $sessions->count() . PHP_EOL);
foreach ($sessions as $session) {
$all_classroom_students = ClassroomStudent::where('classroom_id', $session->classroom_id)->where('semester_id', semester()->id)->pluck('student_id')->toArray();
// $WiziqApi = new WiziqApi;
try {
$report = $WiziqApi->getAttendanceReport($session->wiziq_id);
} catch (\mikemix\Wiziq\Common\Api\Exception\CallException $e) {
continue;
}
if (empty($report)) {
continue;
}
ClassroomSession::where('id', $session->id)->update(['wiziq_status' => 'completed', 'wiziq_recording_status' => 'available']);
// $session->wiziq_status = 'completed';
// $session->wiziq_recording_status = 'available';
// $session->save();
$attendances = collect();
// var_dump($report);
// exit;
// dd('out');
foreach ($report as $attendee) {
$student_id = NULL;
$teacher_id = NULL;
if (empty($attendee['presenter_id']) && !empty($attendee['attendee_id'])) {
$student_id = $attendee['attendee_id'];
if (!in_array($student_id, $all_classroom_students)) {
continue;
}
} elseif (!empty($attendee['presenter_id'])) {
$teacher_id = $attendee['presenter_id'];
} else {
continue;
}
$data = ['teacher_id' => $teacher_id, 'student_id' => $student_id, 'classroom_session_id' => $session->id, 'entry_time' => Date::parse($attendee['entry_time'])->format('Y-m-d H:i:s'), 'exit_time' => Date::parse($attendee['exit_time'])->format('Y-m-d H:i:s'), 'attended_minutes' => $attendee['attended_minutes']];
$attendance = ClassroomSessionAttendance::create($data);
if ($student_id && in_array($student_id, $all_classroom_students)) {
$data = ['student_id' => $student_id, 'subject_id' => $session->subject_subject_id, 'value' => $session->subject->hours == 2 ? 2.5 : 2, 'ref_key' => 'attendance', 'notes' => trans('classrooms::attendances.attended_for', ['attended_minutes' => $attendance->attended_minutes, 'session' => $session->title, 'subject' => $session->subject->name]), 'ref_value' => $attendance->id];
$StudentGrade = new StudentGrade();
$StudentGrade->fill($data)->save();
} else {
// $data['teacher_id'] = $attendance->teacher_id;
TeacherFund::create(['teacher_id' => $teacher_id, 'amount' => config('classrooms.payment_per_session'), 'reference_key' => 'session', 'reference_id' => $session->id, 'semester_id' => semester()->id]);
}
$attendances->push($attendance);
}
$student_ids = $attendances->whereLoose('teacher_id', NULL)->pluck('student_id')->toArray();
$students = Student::whereHas('classrooms', function ($query) use($session) {
return $query->where('classrooms.id', $session->classroom_id);
})->whereNotIn('id', $student_ids)->get();
foreach ($students as $student) {
$data = ['teacher_id' => NULL, 'student_id' => $student->id, 'classroom_session_id' => $session->id, 'entry_time' => NULL, 'exit_time' => NULL, 'attended_minutes' => 0, 'manual' => 1, 'valid' => 0];
event(new StudentAbsentSession($student, $session, $session->subject));
ClassroomSessionAttendance::create($data);
// $attendances->push($attendance);
}
}
$this->comment(PHP_EOL . 'added' . PHP_EOL);
}
public function classroomattendance(ClassroomSession $ClassroomSessionModel, $id)
{
# code...
$session = $ClassroomSessionModel->inCurrentSemester()->with('classroom')->findOrFail($id);
// if($session->wiziq_status=='completed' && !ClassroomSessionAttendance::where('classroom_session_id', $session->id)->count()) {
// $this->generateReport($session);
// }
$attendances = ClassroomSessionAttendance::where('classroom_session_id', $session->id)->orderBy('teacher_id', 'desc')->get();
return view('teachers::profile.classrooms.attendance', compact('attendances', 'session'));
}
private function generateReport($session)
{
$WiziqApi = new WiziqApi();
$report = $WiziqApi->getAttendanceReport($session->wiziq_id);
$attendances = collect();
foreach ($report as $attendee) {
$data = ['teacher_id' => !empty($attendee['presenter']) ? $attendee['attendee_id'] : NULL, 'student_id' => empty($attendee['presenter']) ? $attendee['attendee_id'] : NULL, 'classroom_session_id' => $session->id, 'entry_time' => Date::parse($attendee['entry_time'])->format('Y-m-d H:i:s'), 'exit_time' => Date::parse($attendee['exit_time'])->format('Y-m-d H:i:s'), 'attended_minutes' => $attendee['attended_minutes']];
$attendance = ClassroomSessionAttendance::create($data);
if ($attendance->student_id) {
$data = ['student_id' => $attendance->student_id, 'subject_id' => $session->subject_subject_id, 'value' => $session->subject->hours == 2 ? 2.5 : 2, 'ref_key' => 'attendance', 'notes' => trans('classrooms::attendances.attended_for', ['attended_minutes' => $attendance->attended_minutes, 'session' => $session->title, 'subject' => $session->subject->name]), 'ref_value' => $attendance->id];
$StudentGrade = new StudentGrade();
$StudentGrade->fill($data)->save();
}
$attendances->push($attendance);
}
$student_ids = $attendances->whereLoose('teacher_id', NULL)->pluck('student_id')->toArray();
$students = Student::whereHas('classrooms', function ($query) use($session) {
return $query->where('classrooms.id', $session->classroom_id);
})->whereNotIn('id', $student_ids)->get();
foreach ($students as $student) {
$data = ['teacher_id' => NULL, 'student_id' => $student->id, 'classroom_session_id' => $session->id, 'entry_time' => NULL, 'exit_time' => NULL, 'attended_minutes' => 0, 'manual' => 1, 'valid' => 0];
$attendance = ClassroomSessionAttendance::create($data);
$attendances->push($attendance);
}
return $attendances;
}
public function test(Request $request)
{
ClassroomSessionExcuse::truncate();
ClassroomSessionAttendance::where('student_id', 10001)->update(['valid' => 0]);
exit;
$student_id = 4796;
$order_dir = in_array($request->input('order_dir'), ['ASC', 'DESC']) ? $request->input('order_dir') : 'ASC';
$exams = 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) use($student_id) {
$j->on('stusub.subject_id', '=', 'subsub.id')->where('stusub.student_id', '=', $student_id)->where('stusub.state', '=', 'study');
})->where(function ($query) use($request, $student_id) {
$query->orWhereIn('exams.type', ['midterm', 'remidterm'])->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 = ' . $student_id . '
WHERE exam_id = exams.id GROUP BY ce.id)');
if ($request->has('finalExam')) {
$query->orWhereIn('exams.type', ['final', 'summer', 'refinal']);
}
})->where('exams.semester_id', semester()->id)->where('finish_at', '>=', date('Y-m-d H:i:s'))->groupBy('exams.id')->orderBy('exams.start_at', $order_dir)->with(['questions' => function ($w) {
$w->select('questionbank_questions.id', 'questionbank_questions.question', 'questionbank_questions.type');
if (false) {
$w->orderByRaw('RAND()');
} else {
$w->orderBy('questionbank_questions.type', 'DESC');
}
}, 'questions.choices' => function ($w) {
$w->select('questionbank_choices.id', 'questionbank_choices.question_id', 'questionbank_choices.choice', 'questionbank_choices.istrue');
}])->get();
return $exams;
exit;
$specialities = Specialty::selectRaw('asp.id, asp.name, asp.short_description, asp.description, GROUP_CONCAT(adp.subject_ids) as subject_ids, COUNT(adt.id) as terms, COUNT(DISTINCT ady.id) as years')->leftJoin('academystructure_departments as adp', 'adp.spec_id', '=', 'asp.id')->leftJoin('academystructure_terms as adt', 'adt.id', '=', 'adp.term_id')->leftJoin('academystructure_years as ady', 'ady.id', '=', 'adt.year_id')->from('academystructure_specialties as asp')->groupBy('asp.id')->with('departments')->get();
foreach ($specialities as $specialty) {
$subject_ids = explode(",", preg_replace(['/\\[/', "/\\]/"], "", $specialty->subject_ids));
$specialty->hours = Subject::whereIn('id', $subject_ids)->sum('hour');
foreach ($specialty->departments as $department) {
$subject_ids = explode(",", preg_replace(['/\\[/', "/\\]/", '/"/', "/'/"], "", $department->subject_ids));
// var_dump($subject_ids);
$department->subjects = Subject::whereIn('id', $subject_ids)->get();
}
}
$specialities->makeHidden(['subject_ids']);
return $specialities;
exit;
$status_ping_url = \App::environment('local') ? 'http://46.40.236.186:9090/DARES/public/classrooms/classrooms/status_ping' : route('classrooms.sessions.status-ping');
$WiziqApi = new WiziqApi();
try {
$wiziqclassroom = WiziqClassroom::build("test", new DateTime("2016-08-10 23:55:00"))->withPresenter(20, "test teacher")->withAttendeeLimit(config("classrooms.attendee_limit"))->withReturnUrl('https://el-css.edu.om')->withDuration(10)->withExtendDuration(0)->withStatusPingUrl($status_ping_url)->withTimeZone("Asia/Muscat")->withLanguageCultureName("ar-SA")->withCreateRecording(true);
$response = $WiziqApi->create($wiziqclassroom);
\Log::info($response);
exit(var_dump($response));
$data = ['wiziq_id' => $response['class_id'], 'recording_link' => $response['recording_url'], 'presenter_link' => $response['presenter_url']];
/** add attendees to virtual classroom */
Log::info($response);
if ($session->fill($data)->save() && $response) {
$error = $this->createStudentsSessions($classroom->students, $session);
}
} catch (\mikemix\Wiziq\Common\Api\Exception\CallException $e) {
$error = 1;
} catch (\mikemix\Wiziq\Common\Http\Exception\InvalidResponseException $e) {
$error = 1;
} catch (\PDOException $e) {
$error = 1;
}
if ($error == 0) {
event(new VirtualClassroomsCreated());
} else {
$session->wiziq_status = 'error';
$session->save();
}
}
