<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\DB;

class KelasController extends Controller
{
    public function lokasiruangan()
    {
        $data['kelas'] = DB::table('t_kelas')
            ->orderBy('lokasi_ruangan', 'asc')
            ->get();
        return view('lokasiruangan', $data);
    }

    public function walikelas()
    {
        $data['kelas'] = DB::table('t_kelas')
            ->orderBy('wali_kelas', 'asc')
            ->where('wali_kelas', 'like', 'A%')
            ->get();
        return view('walikelas', $data);
    }

    public function jurusan()
    {
        $data['kelas'] = DB::table('t_kelas')
            ->orderBy('jurusan', 'asc', 'nama_kelas', 'asc')
            ->get();
        return view('jurusan', $data);
    }

    public function audiovideo()
    {
        $data['kelas'] = DB::table('t_kelas')
            ->where('jurusan', 'like', 'Teknik Audio Video')
            ->get();
        return view('audiovideo', $data);
    }
}