public function studentSession($student_id = 0)
{
if ($student_id) {
$student_id = student()->id;
}
return $this->hasOne('\\Modules\\Students\\Entities\\StudentClassroomSession', 'classroom_session_id')->where('student_id', $student_id);
}
public function store(Request $request)
{
// get reason or other reason
$old_institute = '';
if ($request->other_old_institute_text) {
$old_institute = $request->other_old_institute_text;
} else {
$old_institute = $request->old_institute;
}
// create order record
$equal_order = new Equal();
$equal_order->student_id = student()->id;
$equal_order->semester_id = semester()->id;
$equal_order->old_institute = $old_institute;
$equal_order->grade = $request->grade;
$equal_order->certificate = $request->certificate;
$equal_order->country_id = $request->country_id;
$equal_order->state = 'تقديم';
$equal_order->save();
// create order history record
$order_history = new Orderhistory();
$order_history->ref_key = 'order_equals';
$order_history->ref_value = $equal_order->id;
$order_history->state = 'تقديم';
$order_history->save();
// update uploaded files
if (!empty(request('files'))) {
OrderFile::whereIn('id', request('files'))->update(['ref_key' => 'order_equals', 'ref_value' => $equal_order->id]);
}
$equal_order = $equal_order->with('files', 'history', 'subjects')->findOrFail($equal_order->id);
//return view('orders::equal.edit' ,compact('equal_order'))->with('success',trans('orders::order.create_success'));
$order_id = $equal_order->id;
return view('orders::equal.subjects', compact('order_id'))->with('success', trans('orders::order.create_success'));
}
public function exitClassroom(ExitClassroomRequest $request)
{
$input = $request->all();
$student = student();
$student->classrooms()->detach($input['classroom_id']);
event(new StudentExitClassroom(Classroom::find($input['classroom_id']), $student, new User()));
return redirect()->route('students.profile.classrooms.index');
}
public function index()
{
$sessions = ClassroomSession::whereHas('studentsSessions', function ($query) {
$query->where('student_id', student()->id);
})->with(['classroom.subject', 'classroom.teacher', 'studentsSessions'])->orderBy('canceled', 'asc')->orderBy('start_at', 'asc')->paginate(30);
// return $sessions;
return view('students::sessions.index', compact('sessions'));
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$where = ['student_id' => student()->id, 'semester_id' => semester()->id, 'subject_id' => $request->subject_id, 'remaining' => 0];
if (QuranRecording::where($where)->count()) {
return redirect()->route('students.profile.subjects.index')->with('info', 'لقد استنفذت تسجيلات التلاوة المتاحة لك لهذه المادة.');
}
return $next($request);
}
public function scopeStudent($query, $student_id = 0)
{
$semester_id = semester()->id;
$student_id = $student_id ? $student_id : student()->id;
//$department_id = student()->academystructure_department_id;
return $query->select('subject_subjects.*')->groupBy('subject_subjects.id')->join('student_subjects as ss', function ($join) {
$join->on('ss.subject_id', '=', $this->table . '.id')->where('ss.state', '=', 'study');
})->where('ss.semester_id', $semester_id)->where('ss.student_id', $student_id)->where('ss.state', 'study');
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
if (student()) {
$menu = Menu::make('StudentSidebarMenu', function ($menu) {
});
$menu->add(trans('الأسئلة الشائعة'), ['route' => 'students.faq.index'])->prepend('<i class="fa fa-briefcase"></i>');
}
return $next($request);
}
public function create()
{
$sessions = ClassroomSession::with('classroom', 'classroom.subject')->whereHas('attendances', function ($query) {
return $query->where('student_id', student()->id)->where('valid', 0);
})->get();
$options = [];
foreach ($sessions as $session) {
$title = $session->classroom->code . " :: " . $session->classroom->subject->name . " :: " . $session->title;
$options[$session->id] = $title;
}
return view("students::orders.sessionexcuses.create", compact('sessions', 'options'));
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
$menu = Menu::get('SidebarMenu');
if (Auth::user()) {
$menu->add('الرئيسية', ['route' => 'dashboards.admin'])->data('order', 1)->prepend('<i class="fa fa-home"></i>');
} elseif (registrar()) {
$menu->add('الرئيسية', ['route' => 'registration.registrar.index'])->data('order', 1)->prepend('<i class="fa fa-home"></i>');
} elseif (student()) {
$menu->add('الرئيسية', ['route' => 'students.profile.index'])->data('order', 1)->prepend('<i class="fa fa-home"></i>');
}
return $next($request);
}
public function update(ProfileUpdateRequest $request)
{
$student = student();
if ($request->has('password')) {
$student->password = bcrypt($request->input('password'));
}
if (!$student->save()) {
$error = trans('students::profile.update_error');
return redirect()->back()->with('error', $error);
}
$success = trans('students::profile.update_success');
if (request('submit') == 'save') {
return redirect()->back()->with('success', $success);
} else {
return redirect()->route('students.profile.index')->with('success', $success);
}
}
public function reply(ReplyTicket $request, Ticket $ticket)
{
$reply = ['student_id' => student()->id, 'body' => $request->input('body')];
$ticket->replies()->create($reply);
if ($ticket->open == 0) {
$ticket->open = 1;
$ticket->save();
}
$ticket->load('replies', 'replies.student', 'replies.user');
foreach ($ticket->replies as $reply) {
if (!empty($reply->user_id)) {
$reply->seen = 1;
$reply->save();
}
}
if ($request->ajax()) {
return response()->json(['view' => view('students::tickets._show_list', compact('ticket'))->render()]);
}
return redirect()->back()->with('success', trans('students::profile.tickets.create_success'));
}
public function store(CreateRecordingRequest $request)
{
$data = [];
$data['subject_id'] = $request->input('subject_id');
$data['semester_id'] = semester()->id;
$data['student_id'] = student()->id;
$recording = QuranRecording::firstOrCreate($data);
$videos = empty($recording->videos) ? [] : unserialize($recording->videos);
if (!empty($recording->quran_video)) {
array_push($videos, $recording->quran_video);
}
$recording->videos = serialize($videos);
$recording->fill($request->only('page', 'quran_video'));
$recording->save();
$recording->decrement('remaining');
if ($request->ajax()) {
return response()->json(true);
}
return redirect()->route('students.profile.quran.index');
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
if (student()) {
$menu = Menu::make('StudentSidebarMenu', function ($menu) {
});
$menu->add('الرئيسية', ['route' => 'students.profile.index'])->data('order', 1)->prepend('<i class="fa fa-home"></i>');
$events = SemesterEvent::classroom()->count();
if ($events) {
$menu->add(trans(trans('students::profile.classrooms.choose_sessions_classrooms')), ['route' => 'students.profile.classrooms.index'])->prepend('<i class="fa fa-bell animated infinite swing"></i>')->data('order', 1);
}
$centers = ExamCenterPeriod::where('start_at', '<', date('Y-m-d H:i:s'))->where('finish_at', '>', date('Y-m-d H:i:s'))->where('semester_id', semester()->id)->count();
if ($centers) {
$menu->add(trans(trans('students::profile.exams.choose_exam_center')), ['route' => 'students.profile.centers.index'])->prepend('<i class="fa fa-bell animated infinite swing"></i>')->data('order', 2);
}
$menu->add(trans('students::profile.subjects.header'), ['route' => 'students.profile.subjects.index'])->data('order', 10)->prepend('<i class="fa fa-briefcase"></i>');
$menu->add(trans('students::profile.sessions.header'), ['route' => 'students.profile.sessions.index'])->data('order', 20)->prepend('<i class="fa fa-video-camera"></i>');
$menu->add(trans('students::profile.tickets.header'), ['route' => 'students.profile.tickets.index'])->data('order', 30)->prepend('<i class="fa fa-comment"></i>');
$menu->add(trans('orders::order.menu'), ['route' => 'orders.index'])->prepend('<i class="fa fa-pencil-square-o"></i>');
$menu->add(trans('الأسئلة الشائعة'), ['route' => 'students.faq.index'])->data('order', 40)->prepend('<i class="fa fa-briefcase"></i>');
}
return $next($request);
}
public function store(Request $request)
{
if ($request->other_reason_text) {
$reason = $request->other_reason_text;
} else {
$reason = $request->reason;
}
// create order record
$withdraw_order = new Withdraw();
$withdraw_order->student_id = student()->id;
$withdraw_order->academystructure_department_id = student()->academystructure_department_id;
$withdraw_order->semester_id = $request->input('semester_id');
$withdraw_order->state = 'تقديم';
$withdraw_order->reason = $reason;
$withdraw_order->bank_name = request('bank_name');
$withdraw_order->bank_account_name = request('bank_account_name');
$withdraw_order->bank_account_number = request('bank_account_number');
$withdraw_order->save();
// create order history record
$order_history = new Orderhistory();
$order_history->ref_key = 'order_withdraws';
$order_history->ref_value = $withdraw_order->id;
$order_history->state = 'تقديم';
$order_history->save();
// check if financial item active then create debit record
$withdraw_item = FinancialInvoiceItem::where('slug', 'withdraw_fee')->where('state', 'نشط')->first();
if ($withdraw_item) {
if ($withdraw_item->amount > 0) {
$invoiceData = ['ref_key' => 'order_withdraws', 'ref_value' => $delay_order->id, 'student_id' => student()->id, 'amount' => $delaye_item->amount, 'type' => 'debit', 'semester_id' => $request->input('semester_id'), 'item_id' => $delaye_item->id, 'note' => 'تكلفة طلب الانسحاب'];
FinancialInvoice::create($invoiceData);
}
}
// update uploaded files
if (!empty(request('files'))) {
$update_data = ['ref_key' => 'order_withdraws', 'ref_value' => $withdraw_order->id];
OrderFile::whereIn('id', request('files'))->update($update_data);
}
return redirect()->route('orders.index')->with('success', trans('orders::order.create_success'));
}
/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
return ['ticket' => 'exists:tickets,id,student_id,' . student()->id, 'body' => 'required|min:2|max:2000'];
}
} else {
$msg = "Admin table creation failed";
}
} else {
$msg = admin($con);
if ($msg == "error") {
$msg = "Admin table creation failed";
} else {
$msg = "Both Student and Admin Table creation Successfull";
$query = mysqli_query($con, "insert into admin(name,email,password) values('Gautam Singh','*****@*****.**','gtmsingh');");
}
}
header("LOCATION:admin.php?msg=" . $msg);
} else {
if ($q == "student") {
$msg = student($con);
if ($msg == "error") {
$msg = "Student table creation failed";
} else {
$msg = "Student Table creation Successfull";
}
header("LOCATION:admin.php?msg=" . $msg);
} else {
if ($q == "admin") {
$msg = admin($con);
if ($msg == "error") {
$msg = "Admin table creation failed";
} else {
$msg = "Admin Table creation Successfull";
$query = mysqli_query($con, "insert into admin(name,email,password) values('Gautam Singh','*****@*****.**','gtmsingh');");
}
/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
return ['classroom_id' => 'required|exists:classrooms,id|unique:classroom_students,classroom_id,NULL,id,student_id,' . student()->id];
}
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');
}
}
public function choose(ChooseCenterRequest $request)
{
student()->centers()->attach([$request->exam_center_id => ['semester_id' => semester()->id]]);
return redirect()->route('students.profile.centers.index');
}
public function exitClassroom(ExitClassroomRequest $request)
{
$input = $request->all();
$student = student();
$student->classrooms()->detach([$input['classroom_id'] => ['student_id' => $request->input('student_id')]]);
event(new StudentExitClassroom(Classroom::find($input['classroom_id']), $student, new User()));
return redirect()->route('students.subjects.classrooms', $request->input('student_id'));
}
