public function NhapDiem()
{
$macb = \Auth::user()->taikhoan;
//Lấy năm học và học kỳ hiện tại
$nam = DB::table('nien_khoa')->distinct()->orderBy('nam', 'desc')->value('nam');
$hk = DB::table('nien_khoa')->distinct()->orderBy('hocky', 'desc')->where('nam', $nam)->value('hocky');
$mank = DB::table('nien_khoa as nk')->join('nhom_hocphan as hp', 'nk.mank', '=', 'hp.mank')->where('nk.nam', $nam)->where('nk.hocky', $hk)->value('nk.mank');
//Lấy ds nhóm học phần mà GV đang phụ trách giảng dạy
$dshp = DB::table('nhom_hocphan as hp')->select('hp.manhomhp', 'hp.tennhomhp')->join('nien_khoa as nk', 'hp.mank', '=', 'nk.mank')->where('nk.mank', $mank)->where('hp.macb', $macb)->get();
$tieuchi = DB::table('tieu_chi_danh_gia as tc')->select('tc.matc', 'tc.heso', 'tc.noidungtc')->join('quy_dinh as qd', 'tc.matc', '=', 'qd.matc')->where('qd.macb', $macb)->where('qd.mank', $mank)->get();
//Lấy mã hp trên url khi chọn liệt kê
$mahp = \Request::segment(3);
if ($mahp == null || $mahp == 0) {
$dsNhomth = DB::table('chia_nhom as chn')->distinct()->select('chn.manhomthuchien')->join('nhom_hocphan as hp', 'chn.manhomhp', '=', 'hp.manhomhp')->where('hp.macb', $macb)->lists('chn.manhomthuchien');
} else {
if ($mahp != null || $mahp != 0) {
$dsNhomth = DB::table('chia_nhom as chn')->distinct()->select('chn.manhomthuchien')->join('nhom_hocphan as hp', 'chn.manhomhp', '=', 'hp.manhomhp')->where('chn.manhomhp', $mahp)->where('hp.macb', $macb)->lists('chn.manhomthuchien');
}
}
$dssv = DB::table('sinh_vien as sv')->orderBy('chn.manhomthuchien', 'asc')->join('chia_nhom as chn', 'sv.mssv', '=', 'chn.mssv')->whereIn('chn.manhomthuchien', $dsNhomth)->where('chn.manhomthuchien', '<>', "")->get();
$tendt = DB::table('chia_nhom as chn')->distinct()->select('dt.tendt', 'chn.manhomthuchien')->join('ra_de_tai as radt', 'chn.manhomthuchien', '=', 'radt.manhomthuchien')->join('de_tai as dt', 'radt.madt', '=', 'dt.madt')->whereIn('chn.manhomthuchien', $dsNhomth)->get();
//Lấy 1 mảng mssv của các nhóm thực hiện
$masv = DB::table('sinh_vien as sv')->select('chn.mssv')->join('chia_nhom as chn', 'sv.mssv', '=', 'chn.mssv')->whereIn('chn.manhomthuchien', $dsNhomth)->lists('chn.mssv');
//Lấy điểm của mỗi sv trong mảng mssv trên
$dsdiem = DB::table('chitiet_diem as diem')->select('chn.mssv', 'diem.matc', 'diem.diem')->orderBy('diem.matc', 'asc')->join('chia_nhom as chn', 'chn.mssv', '=', 'diem.mssv')->whereIn('chn.mssv', $masv)->get();
$tongdiem = DB::table('chitiet_diem as diem')->distinct()->select('chn.mssv', DB::raw('sum(diem.diem) as tongdiem'))->rightjoin('chia_nhom as chn', '.diem.mssv', '=', 'chn.mssv')->orderBy('chn.mssv', 'asc')->whereIn('diem.mssv', $masv)->groupBy('chn.mssv')->get();
$nhanxet = DB::table('chia_nhom')->select('mssv', 'nhanxet')->orderBy('mssv', 'asc')->whereIn('mssv', $masv)->get();
return view('giangvien.nhap-diem')->with('tieuchi', $tieuchi)->with('dssv', $dssv)->with('dsdiem', $dsdiem)->with('dshp', $dshp)->with('nam', $nam)->with('hk', $hk)->with('tendt', $tendt)->with('tongdiem', $tongdiem)->with('nhanxet', $nhanxet)->with('mahp', $mahp)->with('macb', $macb);
}