public function deleteBulk(validationRequest $request, Semester $Semester, $rr) { return "fd"; dd($request); if (!$request->has('table_records')) { return redirect()->route('academycycle.years.index'); } $ids = $request->input('table_records'); dd($ids); $Semester->destroy($ids); return redirect()->route('ac.semesters.index')->with('success', trans('academycycle::semesters.delete_bulk_success')); }
public function create($student_id) { $semesters = Semester::select(\DB::raw('CONCAT(academycycle_semesters.name , "-", academycycle_years.name) as name , academycycle_semesters.id as id'))->join('academycycle_years', 'academycycle_years.id', '=', 'academycycle_semesters.academycycle_year_id')->pluck('name', 'id')->toArray(); $subjects = Subject::all()->pluck('name', 'id')->toArray(); return view('students::subjects.create', compact('student_id', 'subjects', 'semesters')); }
public function create() { $subjects = Subject::lists('name', 'id')->toArray(); $questions_types = config('questionbank.types'); $questions_difficulties = config('questionbank.difficulty'); $questions_levels = config('questionbank.level'); $semesters = Semester::select('academycycle_semesters.id', DB::raw('CONCAT(academycycle_semesters.name ,"-", ay.name ) as name '))->join('academycycle_years as ay', 'academycycle_semesters.academycycle_year_id', '=', 'ay.id')->pluck('name', 'id')->toArray(); $types = config('exams.types'); return view('exams::exams.create', compact('subjects', 'types', 'questions_types', 'questions_difficulties', 'questions_levels', 'semesters')); }
/** * 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!'); }
function semester() { $semester = Cache::remember('users', 180, function () { $semester = \Modules\Academycycle\Entities\Semester::whereActive(1)->first(); if (empty($semester)) { $semester = new stdClass(); $semester->id = 0; $semester->name = "لا يوجد فصل"; $semester->start_at = Carbon\Carbon::now(); $semester->finish_at = Carbon\Carbon::parse('08-08-2016'); } return $semester; }); return $semester; // }); }
/** * Execute the job. * * @return void */ public function handle() { $student = Student::find($this->student_id); if ($student) { $failed_subjects = []; $success_subjects = []; $semester = semester(); $subjects = StudentSubject::selectRaw("subsub.id as subject_id,SUM(stugr.value) AS subject_points,student_subjects.state as subject_state,subsub.name AS subject_name, subsub.hour AS subject_hours")->join('subject_subjects AS subsub', function ($join) { $join->on('subsub.id', '=', 'student_subjects.subject_id'); })->where('student_subjects.student_id', $student->id)->leftJoin('student_grades AS stugr', function ($join) use($student, $semester) { $join->on('stugr.subject_id', '=', 'subsub.id')->where('stugr.semester_id', '=', $semester->id)->where('stugr.student_id', '=', $student->id); })->whereIn('state', ['study', 'success', 'fail'])->where('student_subjects.semester_id', '=', $semester->id)->where('student_subjects.student_id', $student->id)->groupBy('subsub.id')->get(); $subjects->each(function ($subject) use(&$failed_subjects, $success_subjects) { $subject->details = grade_details($subject->subject_points, $subject->subject_hours); if ((double) $subject->subject_points < 50) { $failed_subjects[] = $subject->subject_id; } else { $success_subjects[] = $subject->subject_id; } }); $semester->load('year'); $currentYear = $semester->year; $nextYear = AcademycycleYear::where('start_at', '>', $currentYear->start_at)->first(); $repeatSemester = Semester::where('order', $semester->order)->where('academycycle_year_id', $nextYear->id)->first(); $currentHistory = StudentHistory::where('student_id', $student->id)->where('academycycle_semester_id', $semester->id)->first(); $repeatSubjects = []; foreach ($failed_subjects as $subject_id) { $repeatSubjects[$subject_id] = ['semester_id' => $repeatSemester->id, 'academystructure_department_id' => $currentHistory->academystructure_department_id, 'state' => 'study']; } $student->subjects()->attach($repeatSubjects); StudentSubject::where('semester_id', $semester->id)->where('student_id', $student->id)->whereIn('subject_id', $success_subjects)->update(['state' => 'success']); StudentSubject::where('semester_id', $semester->id)->where('student_id', $student->id)->whereIn('subject_id', $failed_subjects)->update(['state' => 'fail']); $currentHistory->study_state = 'repeat'; $currentHistory->save(); $repeatHistory = $currentHistory->replicate(); $repeatHistory->study_state = 'active'; $repeatHistory->academycycle_semester_id = $repeatSemester->id; $repeatHistory->save(); $student->study_state = 'repeat'; $student->save(); } }
public function __construct() { $this->student = Auth::guard('api_student')->user(); // if ($this->student) { // $this->student->load('joyrides'); // } if ($this->student) { $this->semester = Semester::select('academycycle_semesters.id', 'academycycle_semesters.academycycle_year_id as year_id', 'academycycle_semesters.start_at', 'academycycle_semesters.finish_at', 'academycycle_semesters.name', 'academycycle_semesters.order')->join('student_histories as sh', function ($j) { $j->on('sh.academycycle_semester_id', '=', 'academycycle_semesters.id')->where('sh.student_id', '=', $this->student->id); })->where(function ($query) { $query->orWhere('academycycle_semester_id', semester()->id); $query->orWhere('academycycle_semester_id', '>', semester()->id); })->orderBy('academycycle_semesters.id', 'ASC')->first(); if (!$this->semester) { $this->semester = semester(); $this->semester->year_id = $this->semester->academycycle_year_id; } // Cache::put('student_'.$this->student->id.'_api_semester', $this->semester, 300); // Cache::put('student_'.$this->student->id.'_api_student', $this->student, 300); } }
/** * Register the service provider. * * @return void */ public function register() { Year::created(function ($year) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'year', 'reference_id' => $year->id]); }); Year::updated(function ($year) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'year', 'reference_id' => $year->id]); }); Year::deleted(function ($year) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'year', 'reference_id' => $year->id]); }); Semester::created(function ($semester) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semester', 'reference_id' => $semester->id]); }); Semester::updated(function ($semester) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semester', 'reference_id' => $semester->id]); }); Semester::deleted(function ($semester) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semester', 'reference_id' => $semester->id]); }); SemesterEvent::created(function ($semesterEvent) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semesterEvent', 'reference_id' => $semesterEvent->id]); }); SemesterEvent::updated(function ($semesterEvent) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semesterEvent', 'reference_id' => $semesterEvent->id]); }); SemesterEvent::deleted(function ($semesterEvent) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semesterEvent', 'reference_id' => $semesterEvent->id]); }); SemesterEventType::created(function ($semesterEventType) { UserLog::create(['operation' => 'create', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semesterEventType', 'reference_id' => $semesterEventType->id]); }); SemesterEventType::updated(function ($semesterEventType) { UserLog::create(['operation' => 'update', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semesterEventType', 'reference_id' => $semesterEventType->id]); }); SemesterEventType::deleted(function ($semesterEventType) { UserLog::create(['operation' => 'delete', 'user_id' => user() ? user()->id : NULL, 'reference_key' => 'semesterEventType', 'reference_id' => $semesterEventType->id]); }); }
public function index(Request $request) { $invoices = FinancialInvoice::with('student')->where('type', 'credit')->orderBy('id', 'desc'); if ($request->has('transaction_wid')) { $invoices->where('transaction_wid', 'LIKE', "%" . $request->input('transaction_wid') . "%"); } if ($request->has('student_id')) { $invoices->where('student_id', $request->input('student_id')); } $filter_semester_id = 0; if (request('semester_id')) { $filter_semester_id = request('semester_id'); } else { $filter_semester_id = semester()->id; } if ($request->has('semester_id')) { $invoices->where('semester_id', $filter_semester_id); } $semesters = Semester::select(\DB::raw('CONCAT(academycycle_semesters.name , "-", academycycle_years.name) as name , academycycle_semesters.id as id'))->join('academycycle_years', 'academycycle_years.id', '=', 'academycycle_semesters.academycycle_year_id')->pluck('name', 'id')->toArray(); $per_page = request('per_page') ? request('per_page') : 50; $invoices = $invoices->paginate($per_page); $invoices->appends($request->except("page")); return view('financials::invoices.index', compact('invoices', 'semesters')); }
/** * Show the form for editing the specified resource. * @return Response */ public function edit($doc_id) { $doc = PaperDoc::with('paper', 'pfiles')->find($doc_id); $paper = $doc->paper; $student = Student::find($paper->student_id); $category = $doc->category; $types = config('papers.' . $doc->category); $diff[$doc->type] = $types[$doc->type]; if ($category == 'semester_type') { //semester case $Semesters = Semester::select('academycycle_semesters.id', DB::raw('CONCAT(academycycle_semesters.name ,"-", ay.name ) as name '))->join('academycycle_years as ay', 'academycycle_semesters.academycycle_year_id', '=', 'ay.id')->pluck('name', 'id')->toArray(); $users = User::pluck('name', 'id')->toArray(); return view('papers::edit', compact('doc_id', 'student', 'paper', 'diff', 'doc', 'category', 'Semesters', 'users')); } else { return view('papers::edit', compact('doc_id', 'student', 'paper', 'diff', 'doc', 'category')); } }
public function editInvoice($invoice_id) { $semesters = Semester::select(\DB::raw('CONCAT(academycycle_semesters.name , "-",academycycle_years.name) as name , academycycle_semesters.id as id'))->join('academycycle_years', 'academycycle_years.id', '=', 'academycycle_semesters.academycycle_year_id')->pluck('name', 'id')->toArray(); $Invoices = FinancialInvoice::findOrFail($invoice_id); return view('financials::reports.edit', compact('semesters', 'student_id', 'Invoices')); }
/** * Handle the event. * * @param RegistrationStepChanged $event * @return void */ public function handle(RegistrationStepChanged $event) { $registration = $event->registration; $semester = semester(); $finish = $semester ? $semester->finish_at : date('Y-m-d'); if ($semester->order != 'first') { $semester = Semester::where('order', 'first')->where('start_at', '>', $finish)->orderBy('start_at', 'ASC')->first(); } if (empty($semester)) { return false; } $registration->load('step', 'student', 'contactcountry', 'files'); if ($registration->step->enroll == 1 && !$registration->student) { $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 = []; $i = 0; $department = 0; while (count(array_diff($subject_ids, $equation_subjects_ids)) == 0) { $department = Department::where('spec_id', $registration->academystructure_specialty_id)->where(function ($w) use($department) { $w->orWhere('parent_id', !empty($department->id) ? $department->id : 0); $w->orWhereNull('parent_id'); })->first(); $subject_ids = json_decode($department->subject_ids, TRUE); $i++; if ($i == 20) { break; } } if (empty($subject_ids)) { return false; } $subjects = Subject::whereIn('id', $subject_ids)->get(); $mobile = ($registration->contactcountry ? $registration->contactcountry->calling_code : "968") . $registration->contact_mobile; $data = ['username' => $registration->username, 'username_prefix' => $registration->enroll_code, 'password' => bcrypt($registration->contact_mobile), 'name' => $registration->fullname, 'email' => $registration->contact_email, 'mobile' => $mobile, 'state' => 'active', 'study_state' => 'active', 'national_id' => $registration->national_id, 'gender' => $registration->gender, 'registration_id' => $registration->id, 'academystructure_department_id' => $department->id, 'registration_type_id' => $registration->registration_type_id]; if ($registration->files) { $photo = $registration->files->first(function ($key, $value) { return $key == 'photo'; }); if ($photo) { // $data['photo'] = asset($photo->file->url()); } } Eloquent::unguard(); $student = Student::create($data); $invoiceItem = FinancialInvoiceItem::where('slug', 'study_fee')->first(); $study_fee = $registration->study_fee > 0 ? $registration->study_fee : $invoiceItem->amount; $total_amount = $subjects->sum(function ($s) use($equation_subjects_ids, $study_fee) { $amount = 0; if (!in_array($s->id, $equation_subjects_ids)) { $amount = !$s->is_quran ? $s->hour * (int) $study_fee : $s->hour * ((int) $study_fee / 2); } return $amount; }); if ($student) { if ($registration->debit && $invoiceItem) { $invoiceData = ['ref_key' => 'registrations', 'ref_value' => $registration->id, 'student_id' => $student->id, 'amount' => $registration->debit, 'type' => 'credit', 'item_id' => $invoiceItem->id, 'pay_type' => 'epay', 'bank_code' => $registration->reason_code, 'transaction_wid' => $registration->transaction_uuid, 'note' => 'ايصال دفع مصاريف التسجيل.']; FinancialInvoice::create($invoiceData); // create debit invoice $invoiceData = ['ref_key' => 'registrations', 'ref_value' => $registration->id, 'student_id' => $student->id, 'amount' => $total_amount, 'type' => 'debit', 'item_id' => $invoiceItem->id, 'pay_type' => 'epay', 'note' => 'فاتةورة التسجيل.']; FinancialInvoice::create($invoiceData); } foreach ($subjects as $subject) { $subject_state = in_array($subject->id, $equation_subjects_ids) ? 'equal' : 'study'; $subject_payed = in_array($subject->id, $equation_subjects_ids) ? 0 : 1; if (!$registration->debit && $registration->step->make_payment) { $subject_payed = 0; } $data = ['student_id' => $student->id, 'subject_id' => $subject->id, 'semester_id' => $semester->id, 'academystructure_department_id' => $department->id, 'state' => $subject_state, 'note' => '', 'payed' => $subject_payed]; $studentSubject = StudentSubject::create($data); } $historyData = ['student_id' => $student->id, 'state' => 'active', 'study_state' => 'active', 'academycycle_semester_id' => $semester->id, 'academystructure_department_id' => $department->id]; StudentHistory::create($historyData); $this->createStudentEmail($student, $registration->contact_mobile); try { if (!empty($photo)) { $student->photo = $photo; $student->save(); } } catch (\Symfony\Component\HttpFoundation\File\Exception\FileNotFoundException $e) { } } //\Log::info('turn to student '.$response); } }
public function show($order_id) { $Semesters = Semester::select('academycycle_semesters.id', DB::raw('CONCAT(academycycle_semesters.name ,"-", ay.name ) as name '))->join('academycycle_years as ay', 'academycycle_semesters.academycycle_year_id', '=', 'ay.id')->pluck('name', 'id')->toArray(); $withdraw_order = Withdraw::with(['student', 'files', 'history', 'history.user', 'student.financials' => function ($query) { $query->where('semester_id', semester()->id)->where('type', 'credit'); }])->findOrFail($order_id); $old_order = Withdraw::where('student_id', $withdraw_order->student_id)->where('semester_id', '!=', semester()->id)->get(); return view('orders::withdraw.show', compact('withdraw_order', 'old_order', 'Semesters')); }
/** * Display a listing of the resource. * @return Response */ public function index() { $semesters = Semester::select('start_at', 'finish_at', 'name', 'id', 'order', 'academycycle_year_id as year_id')->orderBy('id', 'asc')->get(); return response()->json($semesters, 200, [], JSON_NUMERIC_CHECK); }
public function create($event_type, $type, SemesterEvent $SemesterEvent) { $current_semester_id = semester()->id; $student_id = student()->id; $semesters = Semester::with('year')->get(); $semester_id = []; /////////////////////////////////////delay///////////////////////////// if ($event_type == 'delay') { // get delay order period //dd($semesters); $delay_semester_events = $SemesterEvent->where('semester_id', '=', $current_semester_id)->whereHas('event_type', function ($query) { $query->where('academycycle_semesterevent_types.category', 'delay'); })->first(); // get delay order for student in current semeter if exist and not refuse or cancel $delayOrders = new DelayOrders(); $student_delay_order = $delayOrders->where('semester_id', '=', $current_semester_id)->where('student_id', '=', $student_id)->whereNotIn('state', array('الغاء بناء على طلب الطالب', 'الغاء لعدم الاستكمال', 'رفض'))->first(); if ($student_delay_order and $type == 0) { return redirect()->route('student.orders.list', $event_type); } else { //check if period available if ($type == 0) { foreach ($semesters as $semester) { if ($semester->active == 1) { $semester_id[$semester->id] = $semester->year->name . " -- " . $semester->name; } } return view('orders::delay.create', compact('semester_id')); } elseif ($type == '1') { // bring all semester foreach ($semesters as $semester) { $semester_id[$semester->id] = $semester->year->name . " -- " . $semester->name; } return view('orders::delay.create', compact('semester_id')); } else { return redirect()->route('orders.index'); } } //////////////////////////////////////withdraw///////////////////////////// } elseif ($event_type == 'withdraw') { // get delay order period $withdraw_semester_events = $SemesterEvent->where('semester_id', '=', $current_semester_id)->whereHas('event_type', function ($query) { $query->where('academycycle_semesterevent_types.category', 'withdraw'); })->first(); // get withdraw order for student in current semeter if exist and not refuse or cancel $withdrawOrders = new WithdrawOrders(); $student_withdraw_order = $withdrawOrders->where('semester_id', '=', $current_semester_id)->where('student_id', '=', $student_id)->whereNotIn('state', array('الغاء بناء على طلب الطالب', 'الغاء لعدم الاستكمال', 'رفض'))->first(); if ($student_withdraw_order) { return redirect()->route('student.orders.list', $event_type); } else { //check if period available if ($type == 0) { foreach ($semesters as $semester) { if ($semester->active == 1) { $semester_id[$semester->id] = $semester->year->name . " -- " . $semester->name; } } return view('orders::withdraw.create', compact('semester_id')); } elseif ($type == '1') { // all semester foreach ($semesters as $semester) { $semester_id[$semester->id] = $semester->year->name . " -- " . $semester->name; } return view('orders::withdraw.create', compact('semester_id')); } else { return redirect()->route('orders.index'); } } /////////////////////////////////////Equal///////////////////////////// } elseif ($event_type == 'equal_subject') { // get equal_subject order period $equal_subject_semester_events = $SemesterEvent->where('semester_id', '=', $current_semester_id)->whereHas('event_type', function ($query) { $query->where('academycycle_semesterevent_types.category', 'equal_subject'); })->first(); // get delay order for student in current semeter if exist and not review $equalOrders = new EqualOrders(); $student_equal_subject_order = $equalOrders->where('semester_id', '=', $current_semester_id)->where('student_id', '=', $student_id)->whereNotIn('state', array('الغاء بناء على طلب الطالب', 'الغاء لعدم الاستكمال', 'رفض', 'مكتمل'))->first(); if ($student_equal_subject_order) { return redirect()->route('student.orders.list', $event_type); } else { //check if period available //if($equal_subject_semester_events->start_at <= date("Y-m-d") && $equal_subject_semester_events->finish_at >= date("Y-m-d")){ $country_list = Country::pluck('name', 'id')->toArray(); return view('orders::equal.create', compact('country_list')); //}else{ //return redirect()->route('orders.index'); //} } ///////////////////////////////////////////excuse///////////////////////////// } elseif ($event_type == 'excuse') { // same same return view('orders::delay.excuse'); } }
private function checkIntervalsConflictSemester($request, $semester_id = 0) { $total = Semester::where('id', '!=', $semester_id)->whereRaw("'" . $request->start_at . "' < finish_at AND start_at < '" . $request->finish_at . "'")->count(); return $total; }
public function getGraduateCertificate($background = false) { $student = Student::select('students.*')->joinTermName()->findOrFail($this->student_id); $semesters = get_student_grades($student->id); if ($this->student_id == 1821) { $gpa = 3.59; } else { $gpa = GPA($semesters); } $year_id = $semesters = Semester::where('id', $student->histories->first()->academycycle_semester_id)->first()->id; $year_name = Year::where('id', '=', $year_id - 1)->first()->name; $pdf = $this->preparePdf($background); $html = '<h2>إفادة بإكمال درجة</h2>'; $pdf->writeHTMLCell(210, 20, 10, 50, $html, 0, 0, false, true, "R"); $valuation = check_final_valuation($gpa); if ($student->histories->where('state', 'graduate')->first()) { $graduated_date = $student->histories->where('state', 'graduate')->first()->updated_at->format('Y/m/d'); } else { $graduated_date = ''; } $fourth = ' '; if ($student->registration->fourth_name) { $fourth = ' بن ' . $student->registration->fourth_name . ' '; } $pdf->SetFontSize(16, 'B'); if ($student->gender == 'f') { $html = '<p>تشهد كلية العلوم الشرعية - التعليم عن بعد بأن:<br>' . $student->registration->first_name . ' بنت ' . $student->registration->second_name . ' بن ' . $student->registration->third_name . $fourth . $student->registration->last_name . '<br>الرقم الجامعي:' . $student->username . '<br> الجنسيـة: ' . $student->registration->birthcountry->name . ' <br> </p>'; $pdf->writeHTMLCell(100, 20, 10, 60, $html, 0, 0, false, true, "R"); $pdf->SetFontSize(16, 'B'); $html = '<p>قد أكملت متطلبات درجة الدبلوم في العلوم الشرعية<br>في العام الأكاديمي: ' . $year_name . '<br>بمعدل تراكمي ' . $gpa . ' بتقدير ' . $valuation . '<br><br>بتاريخ ' . $graduated_date . 'م<br><br>وسوف تمنح الدرجة رسمياً بعد اعتمادها. <p>'; $pdf->writeHTMLCell(100, 20, 10, 110, $html, 0, 0, false, true, "R"); } else { $html = '<p>تشهد كلية العلوم الشرعية - التعليم عن بعد بأن:<br>' . $student->registration->first_name . ' بن ' . $student->registration->second_name . ' بن ' . $student->registration->third_name . $fourth . $student->registration->last_name . '<br> الرقم الجامعي:' . $student->username . '<br> الجنسيـة: ' . $student->registration->birthcountry->name . '<br> </p>'; $pdf->writeHTMLCell(100, 20, 10, 60, $html, 0, 0, false, true, "R"); $pdf->SetFontSize(16, 'B'); $html = '<p> قد أكمل متطلبات درجة الدبلوم في العلوم الشرعية <br>في العام الأكاديمي: ' . $year_name . ' <br>بمعدل تراكمي ' . $gpa . ' بتقدير ' . $valuation . ' <br><br>بتاريخ ' . $graduated_date . 'م <br><br>وسوف تمنح الدرجة رسمياً بعد اعتمادها. <p>'; $pdf->writeHTMLCell(100, 20, 10, 110, $html, 0, 0, false, true, "R"); } $pdf->SetFontSize(20, 'B'); $html = 'المشرف العام على التعليم عن بعد<br>مستشار معالي وزير الأوقاف والشؤون الدينية'; $pdf->writeHTMLCell(210, 20, 0, 200, $html, 0, 0, false, true, "C"); $pdf->SetFontSize(16, 'B'); $html = '<table cellpadding="3"> <tr><td align="right">لمزيد من التفاصيل يمكن طلب كشف الدرجات الأصلي</td></tr> </table>'; $pdf->writeHTMLCell(100, 20, 10, 250, $html, 0, 0, false, true, "R"); //English language switch ($valuation) { case 'امتياز': $valuation = 'excellence'; break; case 'امتياز مع مرتبة الشرف': $valuation = 'excellent with honors'; break; case 'جيد جدا': $valuation = 'very good'; break; case 'جيد': $valuation = 'good'; break; case 'مقبول': $valuation = 'fairly good'; break; default: $valuation = ''; } $html = '<h2>Notification of Degree Completion</h2>'; $pdf->writeHTMLCell(205, 20, 0, 50, $html, 0, 0, false, true, "L"); $pdf->SetFontSize(14, 'B'); $fourth = ''; if ($student->registration->fourth_name_latin) { $fourth = ' bin ' . $student->registration->fourth_name_latin . ' '; } if ($student->gender == 'f') { $html = '<p>College of Shari’a Sciences - Distance learning <br>attests that:<br>' . $student->registration->first_name_latin . ' bint ' . $student->registration->second_name_latin . ' bin ' . $student->registration->third_name_latin . $fourth . $student->registration->last_name_latin . ' <br>Student ID: ' . $student->username . '<br> Nationality: ' . $student->registration->birthcountry->nationality_en . ' <br> </p>'; } else { $html = '<p>College of Shari’a Sciences - Distance learning <br>attests that:<br>' . $student->registration->first_name_latin . ' bin ' . $student->registration->second_name_latin . ' bin <br>' . $student->registration->third_name_latin . $fourth . $student->registration->last_name_latin . ' <br>Student ID: ' . $student->username . '<br> Nationality: ' . $student->registration->birthcountry->nationality_en . ' <br> </p>'; } $pdf->writeHTMLCell(205, 10, 0, 60, $html, 0, 0, false, true, "L"); $pdf->SetFontSize(14, 'B'); $html = '<p>Has successfully fulfilled the graduation <br>requirements of the Diploma degree in Sharia <br>Sciences on the academic year ' . $year_name . ' with <br>accumulative grade of ' . $gpa . ' ' . $valuation . '<br><br> on ' . $graduated_date . ' <br><br>The degree will be officially awarded after <br>the endorsement.</p>'; $pdf->writeHTMLCell(205, 10, 0, 110, $html, 0, 0, false, true, "L"); $pdf->SetFontSize(14, 'B'); $html = '<p>For more details, the official transcript could be<br>requested.</p>'; $pdf->writeHTMLCell(205, 10, 0, 250, $html, 0, 0, false, true, "L"); ob_clean(); return $pdf; }
/** * Execute the job. * * @return void */ public function handle() { $student = Student::find($this->student_id); $currentSemester = semester(); $summerSemester = Semester::where('id', '>', $currentSemester->id)->where('order', 'summer')->orderBy('id', 'ASC')->first(); // Log::info($student->id, $currentSemester->id, $summerSemester->id); if ($student && $currentSemester && $summerSemester) { $nextSemester = Semester::where('id', '>', $currentSemester->id)->where('order', '!=', 'summer')->orderBy('id', 'ASC')->first(); if (!$nextSemester) { return false; } $current_department_id = $student->academystructure_department_id; if ($currentSemester->order != 'summer') { $nextDepartment = Department::where('parent_id', $student->academystructure_department_id)->first(); if ($nextDepartment) { $student->state = 'active'; $student->study_state = 'success'; $student->academystructure_department_id = $nextDepartment->id; } } $history = StudentHistory::where('student_id', $student->id)->orderBy('id', 'desc')->where('academycycle_semester_id', $currentSemester->id)->first(); if ($history) { $history->study_state = 'success'; $history->save(); } if ($student->save()) { // get current semester subjects and make them fail or success for current semester $subjects = StudentSubject::selectRaw("subsub.id as subject_id,SUM(stugr.value) AS subject_points,student_subjects.state as subject_state,subsub.name AS subject_name, subsub.hour AS subject_hours")->join('subject_subjects AS subsub', function ($join) { $join->on('subsub.id', '=', 'student_subjects.subject_id'); })->where('student_subjects.student_id', $student->id)->leftJoin('student_grades AS stugr', function ($join) use($currentSemester, $student) { $join->on('stugr.subject_id', '=', 'subsub.id')->where('stugr.semester_id', '=', $currentSemester->id)->where('stugr.student_id', '=', $student->id); })->whereIn('state', ['study'])->where('student_subjects.semester_id', '=', $currentSemester->id)->where('student_subjects.student_id', $student->id)->groupBy('subsub.id')->get(); $failed_subjects_ids = []; $passed_subjects_ids = []; foreach ($subjects as $subject) { if ($subject->subject_points < 50) { $failed_subjects_ids[] = $subject->subject_id; } elseif ($subject->subject_points >= 50) { $passed_subjects_ids[] = $subject->subject_id; } } StudentSubject::where('student_id', $student->id)->whereIn('subject_id', $failed_subjects_ids)->update(['state' => 'fail']); StudentSubject::where('student_id', $student->id)->whereIn('subject_id', $passed_subjects_ids)->update(['state' => 'success']); // end success and fail if ($currentSemester->order != 'summer' && $nextDepartment) { $next_subject_ids = json_decode($nextDepartment->subject_ids, TRUE); $equal_subject_ids = EqualSubject::whereHas('order', function ($w) use($student) { $w->where('student_id', $student->id); })->pluck('equal_subject_id')->toArray(); $next_subject_study_ids = array_diff($next_subject_ids, $equal_subject_ids); $next_subject_equal_ids = array_intersect($next_subject_ids, $equal_subject_ids); $student->subjects()->attach($next_subject_study_ids, ['semester_id' => $nextSemester->id, 'academystructure_department_id' => $nextDepartment->id, 'state' => 'study']); $student->subjects()->attach($next_subject_equal_ids, ['semester_id' => $nextSemester->id, 'academystructure_department_id' => $nextDepartment->id, 'state' => 'equal']); $data = ['state' => 'active', 'study_state' => 'active', 'academycycle_semester_id' => $nextSemester->id, 'academystructure_department_id' => $nextDepartment->id]; $student->histories()->create($data); // create invoice for student if ($next_subject_equal_ids) { $item = FinancialInvoiceItem::where('slug', 'study_fee')->first(); $subjects_count = Subject::whereIn('id', $next_subject_equal_ids)->where('is_quran', 0)->count(); $data = ['student_id' => $student->id, 'type' => 'debit', 'item_id' => $item->id, 'pay_type' => NULL, 'semester_id' => $nextSemester->id, 'amount' => $subjects_count * $item->amount]; FinancialInvoice::create($data); } } // move any failed subjects if less than 3 to summer semester $all_failed_subjects = StudentSubject::groupBy('subject_id')->where('state', 'fail')->pluck('subject_id')->toArray(); $all_passed_subjects = StudentSubject::groupBy('subject_id')->where('state', 'success')->pluck('subject_id')->toArray(); $failed_subjects = array_diff($all_failed_subjects, $all_passed_subjects); if (COUNT($failed_subjects) <= 3) { $summerSemester = Semester::where('id', '>', $currentSemester->id)->where('order', 'summer')->orderBy('id', 'ASC')->first(); $student->subjects()->attach($failed_subjects, ['semester_id' => $summerSemester->id, 'academystructure_department_id' => $current_department_id, 'state' => 'study']); $data = ['state' => 'active', 'study_state' => 'active', 'academycycle_semester_id' => $summerSemester->id, 'academystructure_department_id' => $current_department_id]; $student->histories()->create($data); } } } }
private function getSemesters() { $semesters = Semester::select('start_at', 'finish_at', 'name', 'id', 'order', 'academycycle_year_id as year_id')->orderBy('id', 'asc')->get(); return $semesters; }
public function orderlist(Request $request) { $equal_order_model = new Equal(); $equal_orders = $equal_order_model->where('semester_id', semester()->id)->with('student'); if (request('order_state')) { $equal_orders->where('state', request('order_state')); } if (request('student_name')) { $equal_orders->whereHas('student', function ($query) { $query->where('name', 'like', "%" . request('student_name') . "%"); }); } if (request('semester_id')) { $equal_orders->where('semester_id', request('semester_id')); } if (request('student_code')) { $equal_orders->whereHas('student', function ($query) { $query->where('username', 'like', "%" . request('student_code') . "%"); }); } $per_page = request('per_page') ? request('per_page') : 30; $equal_orders = $equal_orders->paginate($per_page); $equal_orders->appends($request->except("page")); //get all states for search $states = array_flatten(config('orders.equal_states')); $states = array_combine($states, $states); $semesters = Semester::select('academycycle_semesters.id', DB::raw('CONCAT(academycycle_semesters.name ,"-", ay.name ) as name '))->join('academycycle_years as ay', 'academycycle_semesters.academycycle_year_id', '=', 'ay.id')->pluck('name', 'id')->toArray(); return view('orders::equal.list', compact('equal_orders', 'states', 'semesters')); }
public function studentexam(Request $request) { $subjects = Subject::lists('name', 'id')->toArray(); $semesters = Semester::select(\DB::raw('CONCAT(academycycle_semesters.name , "-", academycycle_years.name) as name , academycycle_semesters.id as id'))->join('academycycle_years', 'academycycle_years.id', '=', 'academycycle_semesters.academycycle_year_id')->pluck('name', 'id')->toArray(); $year_term = Year::join('academystructure_terms', 'academystructure_years.id', '=', 'academystructure_terms.year_id')->join('academystructure_departments', 'academystructure_terms.id', '=', 'academystructure_departments.term_id')->select(\DB::raw('CONCAT(academystructure_years.name, "-", academystructure_terms.name) as name, GROUP_CONCAT(DISTINCT(academystructure_departments.subject_ids)) as sid'))->groupBy('academystructure_terms.name', 'academystructure_years.name')->get()->toArray(); $year_term_options; foreach ($year_term as $key => &$aa) { $a = implode(',', array_unique(array_merge(json_decode(str_replace('],[', ',', $aa['sid']), TRUE)))); $year_term_options[$a] = $aa['name']; } $types = config('exams.types'); if (request('student_id')) { $semester_id = semester()->id; $student_id = request('student_id'); $exam_type = request('exam_type'); $camera_work = request('camera_work'); $results = DB::select("SELECT student_subjects.subject_id,\n exams.id as exam_id,\n exam_results.id as exam_result_id,\n s.id,\n s.name,\n s.username,\n s.mobile,\n exam_results.id as attendees,\n exam_results.enter_at,\n exam_results.exit_at,\n exam_results.created_at,\n exam_results.filename,\n student_grades.value,subject_subjects.name as subject_name,\n exam_recordings.id as record,\n (select COUNT(*) from exam_result_answers where exam_result_answers.exam_result_id = exam_results.id and exam_result_answers.answer != '') as count_q\n\n from students as s\n inner join student_subjects on student_subjects.student_id = s.id\n and student_subjects.state = 'study' and student_subjects.semester_id = " . $semester_id . "\n left join subject_subjects on subject_subjects.id = student_subjects.subject_id\n inner join exams on student_subjects.subject_id = exams.subject_id and exams.semester_id = " . $semester_id . "\n and (exams.type in ('midterm', 'remidterm') or exams.id IN (\n SELECT ce.exam_id FROM classrooms_exam as ce\n JOIN classrooms as c ON c.id = ce.classroom_id\n JOIN classroom_students as cs ON cs.classroom_id = c.id\n WHERE exam_id = exams.id AND cs.student_id = s.id GROUP BY ce.exam_id)\n )\n left join exam_results on exams.id = exam_results.exam_id and s.id = exam_results.student_id\n left join `exam_recordings` on `exam_recordings`.`student_id` = exam_results.`student_id` and `exam_recordings`.`exam_id` = exam_results.`exam_id` \n \n left join student_grades on s.id = student_grades.student_id and student_grades.ref_key = 'exam' and exams.id = student_grades.ref_value\n where s.id = " . $student_id . " and finish_at < '" . date("Y/m/d H:i:s") . "' and exams.type = '" . $exam_type . "' group by exam_id ORDER BY s.id ASC"); $exams = collect($results); return view('exams::reports.studentexamdetails', compact('subjects', 'semesters', 'year_term_options', 'types', 'exams')); } else { if (request('exam_attendee') == 1) { $exams = Exam::selectRaw('exam_recordings.student_id, s.id , exams.id as exam_id, er.id as erid, s.name, s.username, er.id as attendees, er.enter_at, er.created_at , er.exit_at, er.filename, sg.value,exam_recordings.id as record, (select COUNT(*) from exam_result_answers where exam_result_answers.exam_result_id = er.id and exam_result_answers.answer != "") as count_q')->leftJoin('exam_results AS er', function ($join) { $join->on('er.exam_id', '=', 'exams.id'); })->leftJoin('students AS s', function ($join) { $join->on('s.id', '=', 'student_id'); })->leftJoin('student_grades AS sg', function ($join) { $join->on('sg.student_id', '=', 's.id'); $join->on('exam_id', '=', 'sg.ref_value'); })->leftJoin('exam_recordings', function ($join) { $join->on('exam_recordings.student_id', '=', 'er.student_id'); $join->on('exam_recordings.exam_id', '=', 'er.exam_id'); })->where('finish_at', '<', date("Y/m/d H:i:s"))->where('exams.subject_id', request('exam_subject'))->where('exams.semester_id', request('exam_semester'))->where('exams.type', request('exam_type')); if (request('camera_work') == 'not_work') { $exams = $exams->where('exam_recordings.id', '=', null); } else { $exams = $exams->where('exam_recordings.id', '!=', null); } $exams = $exams->groupBy('s.id')->orderBy('exams.id', 'desc')->get(); } else { $exams = StudentSubject::whereIn('student_subjects.state', ['study'])->selectRaw('s.id, s.name, s.username')->leftJoin('students AS s', function ($join) { $join->on('student_subjects.student_id', '=', 's.id'); })->where('student_subjects.semester_id', request('exam_semester'))->where('subject_id', request('exam_subject'))->whereNotIn('s.id', function ($query) { $query->select('s.id')->from('exams')->leftJoin('exam_results AS er', function ($join) { $join->on('er.exam_id', '=', 'exams.id'); })->leftJoin('students AS s', function ($join) { $join->on('s.id', '=', 'student_id'); })->where('finish_at', '<', date("Y/m/d H:i:s"))->where('exams.subject_id', request('exam_subject'))->where('exams.semester_id', request('exam_semester'))->where('exams.type', request('exam_type'))->orderBy('exams.id', 'desc')->get(); })->get(); } return view('exams::reports.studentexam', compact('subjects', 'semesters', 'year_term_options', 'types', 'exams')); } }
public function activitycreate() { # code... $subjects = Subject::whereHas('teachers', function ($query) { $query->where('teacher_id', teacher()->id); })->lists('name', 'id')->toArray(); $semesters = Semester::select('academycycle_semesters.id', DB::raw('CONCAT(academycycle_semesters.name ,"-", ay.name ) as name '))->join('academycycle_years as ay', 'academycycle_semesters.academycycle_year_id', '=', 'ay.id')->pluck('name', 'id')->toArray(); $types = config('teachers.types'); $classrooms = Classroom::where('teacher_id', teacher()->id)->inCurrentSemester()->pluck('code', 'id')->toArray(); return view('teachers::profile.activity.create', compact('subjects', 'types', 'semesters', 'classrooms')); }