<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;
use Illuminate\Support\Facades\Auth;
use Datatables;
class SoalansController extends Controller
{
  public function index()
    {

        return view('soalan/senarai_bahagian');
    }


  public function create()
      {
          return view('soalan/bahagian');
      }

      public function simpan(Request $request)
        {

            // Dapatkan semua data yang dikirimkan.
            $data = $request->only('nombor','nama');
            $data['created_at'] = date('Y-m-d H:i:s');
            $data['updated_at'] =date('Y-m-d H:i:s');
            $data['id_pegawai'] = Auth::user()->id;

        DB::table('bahagians')->insert($data);
        return redirect()->route('senarai_bahagian')->with('alert-success', 'Permohonan berjaya ditambah!');
      }


      public function datatables()
  {
    $bahagians=DB::table('bahagians')->select('id','nombor','nama');


    return Datatables::of($bahagians)
    ->addColumn('action', function ($bahagians) {
             return '
           <a href=" ' .route('tambah_soalan',$bahagians->id).'" class="btn btn-info">Lihat </a>
           <a href="' .route('tambah_soalan',$bahagians->id).'" class="btn btn-warning">Kemaskini </a>

             ';
         })

         ->make(true);
  }

}