46 lines
1.2 KiB
PHP
46 lines
1.2 KiB
PHP
<?php
|
|
|
|
namespace App\Http\Controllers;
|
|
|
|
use Illuminate\Http\Request;
|
|
use Illuminate\Support\Facades\DB;
|
|
|
|
class CoureseAssignController extends Controller
|
|
{
|
|
public function showMyCourse()
|
|
{
|
|
$studentLogId = session('student_log_id');
|
|
$studentId = session('student_id');
|
|
|
|
if (!$studentLogId && !$studentId) {
|
|
return redirect('/signin')->with('error', 'Please login first!');
|
|
}
|
|
|
|
|
|
$student = DB::table('student_details')
|
|
->where('student_portal_log_id', $studentLogId)
|
|
->orWhere('student_id', $studentId)
|
|
->first();
|
|
|
|
if (!$student) {
|
|
return redirect()->back()->with('error', 'Student record not found!');
|
|
}
|
|
|
|
|
|
$course = DB::table('courses')
|
|
->join('course_assign_student', 'courses.id', '=', 'course_assign_student.course_id')
|
|
->where('course_assign_student.student_details_id', $student->id)
|
|
->select('courses.*')
|
|
->first();
|
|
|
|
|
|
return view('mycourse', compact('course', 'student'));
|
|
}
|
|
|
|
public function showModule($id)
|
|
{
|
|
|
|
return view('module', ['moduleId' => $id]);
|
|
}
|
|
|
|
} |