Home

Add homepage

app/Http/Controllers/HomeController.php

@@ -3,6 +3,8 @@
 namespace App\Http\Controllers;
 
 use Illuminate\Http\Request;
+use Illuminate\Support\Facades\DB;
+use Illuminate\Support\Facades\Auth;
 
 class HomeController extends Controller
 {
@@ -23,6 +25,30 @@ class HomeController extends Controller
      */
     public function index()
     {
-        return view('home');
+        $profile = DB::table('users')->where('id', Auth::id())->first();
+        $role = 'Siswa';
+        if ($profile->role == 1) {
+            $role = 'Pengajar';
+        }
+
+        $courses = DB::table('courses')->get();
+        $teachers = [];
+        $enrolled_id = DB::table('user_course')->where('id_user', Auth::id())->pluck('id_course');
+
+        $enrolled = [];
+        foreach($enrolled_id as $id) {
+            $enrolled[] = DB::table('courses')->where('id', $id)->first();
+        }
+
+        foreach($courses as $course) {
+            $temp = DB::table('user_course')->where([
+                ['id_course', '=', $course->id],
+                ['role', '=', 1]
+            ])->first();
+            $teacher = DB::table('users')->where('id', $temp->id_user)->first();
+            $teachers[] = $teacher->name;
+        }
+
+        return view('home', ['profile' => $profile, 'role' => $role, 'courses' => $courses, 'teachers' => $teachers, 'enrolled' => $enrolled]);
     }
 }