public function index()
{
$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));
$department->subjects = Subject::whereIn('id', $subject_ids)->get();
}
}
$specialities->makeHidden(['subject_ids']);
return response()->json($specialities, 200, [], JSON_NUMERIC_CHECK);
}
public function specialty()
{
return Specialty::selectRaw('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')->where('asp.id', 1)->first();
}
/**
* Handle the event.
*
* @param RegistrationStepChanged $event
* @return void
*/
public function handle($event)
{
$registration = $event->registration;
$extra = $event->extra;
$registration->load('step', 'step.notes', 'period', 'period.year', 'type', 'speciality');
$step = $registration->step;
$password = isset($extra['password']) ? $extra['password'] : '';
if (empty($step->email_template)) {
return true;
}
$notes = [];
$comment = '';
if (isset($extra['comment'])) {
$comment = $extra['comment'];
}
if (isset($extra['notes'])) {
$notes = $extra['notes'];
}
/**
* get next semester
*/
$firstday = '';
$semester = semester();
//Semester::where('id', semester()->id)->orderBy('academycycle_semesters.id', 'ASC')->first();
if ($semester) {
$firstday = $semester->start_at;
}
/**
* get subejcts for registrar
*/
$hours = 0;
$fees = 0;
if ($registration->academystructure_specialty_id) {
$department = Department::where('spec_id', $registration->academystructure_specialty_id)->where(function ($w) {
$w->orWhere('parent_id', 0);
$w->orWhereNull('parent_id');
})->first();
$equation_subjects_ids = RegistrationEquationSubject::whereNotNull('subject_id')->where('status', 'accepted')->whereHas('equation', function ($w) use($registration) {
$w->where('registration_id', $registration->id);
})->pluck('subject_id')->toArray();
$subject_ids = $department ? json_decode($department->subject_ids, TRUE) : [];
$subject_ids = array_diff($subject_ids, $equation_subjects_ids);
$subjects = Subject::select('name', 'hour')->whereIn('id', $subject_ids)->get();
$hours = $subjects->sum('hour');
$study_fee = FinancialInvoiceItem::where('slug', 'study_fee')->first();
$fees = $hours * ($registration->subject_fee > 0 ? $registration->subject_fee : $study_fee->amount);
}
$years = 0;
if ($registration->academystructure_specialty_id) {
$years = Specialty::selectRaw('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')->where('asp.id', $registration->academystructure_specialty_id)->first()->years;
}
/**
* end get registrar subjects
*/
$notes_html = '';
if ($notes = RegistrationStepNote::whereIn('id', $notes)->pluck('content')->toArray()) {
$notes_html = '<ul><li>' . implode('</li><li>', $notes) . '</li></ul>';
}
/*
* calculate first term fees
*/
/*
* end fees calculations
*/
$template = str_replace(['{reg_portal}', '{debit}', '{name}', '{code}', '{mobile}', '{username}', '{year}', '{nid}', '{shortname}', '{specialty}', '{today}', '{hours}', '{firstday}', '{notes}', '{years}', '{fees}', '{comment}', '{password}'], [env('REGSITRAR_EMAIL_EMAIL_VERIFIED_REDIRECT'), $registration->debit, $registration->fullname, $registration->code, $registration->contact_mobile, $registration->username, $registration->period->year->name, $registration->national_id, $registration->shortname, $registration->speciality ? $registration->speciality->name : '', date('Y-m-d'), $hours, $firstday, $notes_html, $years, $fees, $comment, $password], $step->email_template);
$data = ['fullname' => $registration->fullname, 'template' => $template, 'verification_token' => $registration->verification_token];
$view = 'email_step';
if ($step->verify_email == 1) {
$view = 'email_verification_token';
}
if (!empty($registration)) {
$payload = ['data' => $data, 'send_to' => $registration->contact_email, 'send_to_name' => $registration->fullname, 'subject' => $registration->step->name, 'view' => $view];
$job = new SendRegistrationStepChangedEmail($payload);
$this->dispatch($job);
}
}
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();
}
}
