"; print_r($array_keahlian_semasa);     die();

        unset($aks);
        
        $senarai_keahlian_semasa = Array();
        foreach($array_keahlian_semasa as $aks){
            $senarai_keahlian_semasa[] = 
            Array(
                'MatricNo' => $aks['MatricNo'], 
                'Bilangan' => $aks['Bilangan'] ,
                'KategoriID' => $aks['KategoriID'] 
                );
            
        }
        ////        echo "
"; print_r($senarai_keahlian_semasa);     die();
        
        

        $transkrip_group = DB::connection('conn_hep')->table('transkrip_group')  ->get();
        
         return view('TranskripKokurikulum/A_Senarai_Pengesahan_Keahlian',[
             'transkrip_group' => $transkrip_group,
             'senarai_keahlian_semasa' =>$senarai_keahlian_semasa,
             'k'=>$KategoriID,
             's'=>$Status,
             'data' => $data, ]);
        
    }  
    
    
    public function Maklumat_Tunggal_Persatuan_Kelab(Request $request){
        $no  =  $request->get('no');
        $k  =  $request->get('k');
        
        $no;;
        
        $ID_MAIN_INFO =$request->get('no'); //11;
        
        $transkrip_main_info=array();
        if ($k == 1 ||$k == 2 ||$k == 3 ||$k == 4 ||$k == 5 ||$k == 6 ){
            
        
            $transkrip_main_info = DB::connection('conn_hep')->table('transkrip_main_info')
        ->select('*','transkrip_penyelaras.NamaPenyelaras as NamaPenyelaras')
        ->leftJoin('transkrip_penyelaras', 'transkrip_penyelaras.MainInfoID','=','transkrip_main_info.ID')
        ->where('transkrip_main_info.ID',$ID_MAIN_INFO)->first();
        $transkrip_main_info->KategoriID;
        
        
        $transkrip_group= DB::connection('conn_hep')->table('transkrip_group') ->Where('GroupID',$transkrip_main_info->KategoriID) ->first();
        
        
        $transkrip_main_committee= DB::connection('conn_hep')->table('transkrip_main_committee')->where('MainInfoID',$ID_MAIN_INFO) ->get();
        
        $transkrip_sub_committee=DB::connection('conn_hep')->table('transkrip_sub_committee')->where('MainInfoID',$ID_MAIN_INFO) ->get();
        
        $conf_faculty = DB::connection('conn_hep')->table('conf_faculty') ->select('*') ->WhereIn('FacultyID',[1,2,3]) ->get();
        
        foreach($conf_faculty as $cf2){
            if ( $cf2->FacultyID == $transkrip_main_info->FacultyID ) {    $conf_faculty_Nama = $cf2 ->Faculty_MY; } 
            else {
              $conf_faculty_Nama = '-';  
            }
                
        }
        
        //1,2,3,4,5,6
        
        //7,8,9,10
        
        $transkrip_main_committee = DB::connection('conn_hep')->table('transkrip_main_committee')
        ->Join('stud_students', 'stud_students.MatricNo','=','transkrip_main_committee.MatricNo' ) 
        ->Join('stud_studentdetails', 'stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->where('transkrip_main_committee.MainInfoID',$ID_MAIN_INFO)->get();
        
        
        
        
        $transkrip_sub_committee = DB::connection('conn_hep')->table('transkrip_sub_committee')
        ->Join('stud_students', 'stud_students.MatricNo','=','transkrip_sub_committee.MatricNo' ) 
        ->Join('stud_studentdetails', 'stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->where('transkrip_sub_committee.MainInfoID',$ID_MAIN_INFO)->get();
        
        
        $transkrip_member = DB::connection('conn_hep')->TABLE('transkrip_member')
        ->Join('stud_students', 'stud_students.MatricNo','=','transkrip_member.MatricNo' ) 
        ->Join('stud_studentdetails', 'stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->where('MainInfoID',$ID_MAIN_INFO)
        ->OrderBy('transkrip_member.Status','ASC')
        ->get();
        
        
        $data = $transkrip_main_info;
        
        }
        $transkrip_aktiviti_info=array();
        
        if ($k == 7 ||$k == 8 ||$k == 9 ||$k == 10 ){
        
        
        $transkrip_aktiviti_info = DB::connection('conn_hep')->table('transkrip_aktiviti_info')
        ->select('*','transkrip_penyelaras.NamaPenyelaras as NamaPenyelaras')
        ->leftJoin('transkrip_penyelaras', 'transkrip_penyelaras.MainInfoID','=','transkrip_aktiviti_info.ID')
        ->where('transkrip_aktiviti_info.ID',$no)->first();
        $transkrip_aktiviti_info->KategoriID;
        
        
        $transkrip_group=DB::connection('conn_hep')->table('transkrip_group') ->Where('GroupID',$transkrip_aktiviti_info->KategoriID) ->first();
        
        
        $transkrip_main_committee=DB::connection('conn_hep')->table('transkrip_main_committee')->where('AktivitiInfoID',$no) ->get();
        
        $transkrip_sub_committee=DB::connection('conn_hep')->table('transkrip_sub_committee')->where('AktivitiInfoID',$no) ->get();
        
        $conf_faculty = DB::connection('conn_hep')->table('conf_faculty') ->select('*') ->WhereIn('FacultyID',[1,2,3]) ->get();
        
        foreach($conf_faculty as $cf2){
            if ( $cf2->FacultyID == $transkrip_aktiviti_info->FacultyID ) {    $conf_faculty_Nama = $cf2 ->Faculty_MY; } 
            else {
              $conf_faculty_Nama = '-';  
            }
                
        }
        
        
        $transkrip_main_committee = DB::connection('conn_hep')->table('transkrip_main_committee')
        ->Join('stud_students', 'stud_students.MatricNo','=','transkrip_main_committee.MatricNo' ) 
        ->Join('stud_studentdetails', 'stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->where('transkrip_main_committee.AktivitiInfoID',$no)->get();
        
        
        
        
        $transkrip_sub_committee = DB::connection('conn_hep')->table('transkrip_sub_committee')
        ->Join('stud_students', 'stud_students.MatricNo','=','transkrip_sub_committee.MatricNo' ) 
        ->Join('stud_studentdetails', 'stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->where('transkrip_sub_committee.AktivitiInfoID',$no)->get();
        
        
        $transkrip_member = DB::connection('conn_hep')->TABLE('transkrip_member')
        ->Join('stud_students', 'stud_students.MatricNo','=','transkrip_member.MatricNo' ) 
        ->Join('stud_studentdetails', 'stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->where('AktivitiInfoID',$no)
        ->OrderBy('transkrip_member.Status','ASC')
        ->get();
        
        $data = $transkrip_aktiviti_info;
            
        }
        
        
        
        
        
         $no  = $request->get('no');
         
         
          $transkrip_jawatan = DB::connection('conn_hep')->table('transkrip_jawatan')->get();
          
         return view('TranskripKokurikulum/A_Maklumat_Tunggal_Persatuan_Kelab',[
            'transkrip_group'           =>  $transkrip_group,
             'transkrip_main_info'      =>  $transkrip_main_info,
             'transkrip_aktiviti_info'      =>  $transkrip_aktiviti_info,
             'transkrip_main_committee' =>  $transkrip_main_committee,
             'transkrip_sub_committee'  =>  $transkrip_sub_committee,
             'conf_faculty' => $conf_faculty,
             'conf_faculty_Nama' => $conf_faculty_Nama,
             
             'transkrip_main_committee' => $transkrip_main_committee,
             'transkrip_sub_committee' => $transkrip_sub_committee,
             'transkrip_member' => $transkrip_member,
             
             'no' => $no,
             
             'data' =>$data,
             'k'=>$k,
             'transkrip_jawatan' =>$transkrip_jawatan,
             ]);
    }



public function Maklumat_Tunggal_Keahlian_Semasa_Pelajar(Request $request){
    $matrik = $request->get('matrik');
    
    //  $transkrip_member = DB::connection('conn_hep')->table('transkrip_member')
    //  ->Join('stud_students', 'stud_students.MatricNo','=','transkrip_member.MatricNo' ) 
    //  ->Join('stud_studentdetails', 'stud_studentdetails.StudentID','=','stud_students.StudentID')
    //  ->Where('MatricNo', $matrik)
    //  ->get();
    
    
    
    
    
    
    
    
    $data = DB::connection('conn_hep')->table('transkrip_member')
    
        ->select('*','transkrip_main_info.Keterangan AS Keterangan')
        ->join('transkrip_main_info', 'transkrip_main_info.ID','=','transkrip_member.MainInfoID')
    
        ->join('stud_students','stud_students.MatricNo','=','transkrip_member.MatricNo')
        
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        
        //  ->where('KategoriID', $KategoriID) 
        //  ->where('transkrip_member.Status',$Status)
        ->Where('transkrip_member.MatricNo', $matrik)
        ->orderBy('transkrip_member.ID', 'desc')
        ->get();
   
    $MID=Array();
    
    foreach($data as $d1){
        $MID[] = $d1-> MainInfoID;
    }    
    
    $transkrip_penyelaras = DB::connection('conn_hep')->table('transkrip_penyelaras')
    ->whereIn('MainInfoID',$MID)
    ->get();
        
    return view('TranskripKokurikulum/A_Maklumat_Tunggal_Keahlian_Semasa_Pelajar',[
                'data'  =>  $data, 
                'transkrip_penyelaras' => $transkrip_penyelaras,
            ]);
}



public function Admin_Mengesahkan__Senarai_Pengesahan_Keahlian(Request $request){
    
	$Status= $request ->get('tindakan');
             
    if ( $Status == 1 || $Status == 2){
    
    $Identiti_Pelajar = $request->post('pelajar');
    $k = $request->get('k');
    
    
    
    $pilih_JenisGroup=0;
    if ($k == 1 ||$k == 2 ||$k == 3 ||$k == 5 ||$k == 6 ||
        $k == 14 ||$k == 15 ){  $pilih_JenisGroup=1;    }
    if ($k == 4 ){              $pilih_JenisGroup=2;    }
    if ($k == 13 ){             $pilih_JenisGroup=3;    }
    if ($k == 7 ){              $pilih_JenisGroup=4;    }
    if ($k == 8 ){              $pilih_JenisGroup=5;    }
    if ($k == 9 ||$k == 10 ){   $pilih_JenisGroup=6;    }
    $MarkahMerit=0;
    $transkrip_merit_keahlian = DB::connection('conn_hep')->table('transkrip_merit_keahlian') 
    ->where([   'JenisGroup'=>$pilih_JenisGroup, 'JawatanGroup'=>1   ]) 
    ->first(); 
    $MarkahMerit = $transkrip_merit_keahlian->Markah; //$transkrip_merit_keahlian->Merit;;




    $tr=0;
    foreach($Identiti_Pelajar as $IDP){
        $tr_data = DB::connection('conn_hep')->table('transkrip_member')
            ->where('ID', $IDP)
            ->update(['Status' => $Status, 'DateUpdate'=>Date('Y-M-D H:i:s'),
            'Merit'=>$MarkahMerit, 'JawatanID'=>1,
            ]);
        if($tr_data ) {$tr++;}
    }
    
    
    $transkrip_group = DB::connection('conn_hep')->table('transkrip_group')->get(); 
        return redirect('/TranskripKokurikulum/Pengesahan-Keahlian?k='.$k.'&s='.$Status) ;
        
        }else{          }
    
}
    
 
     
     
     
	
    public function surat(Request $request)
    {
        $MM_NOSTAF = $_SESSION['MM_nostaff'];//0530;
         
        $ref = 1; //$request ->get('ref');
        
         $StaffID =  '0259';
         
         $matrik = $request->get('matrik');//'1999000005';
        
        
    
    
        $maklumat_pelajar = DB::connection('conn_hep')->table('stud_students')
        
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        
        //  ->where('KategoriID', $KategoriID) 
        //  ->where('transkrip_member.Status',$Status)
        ->Where('stud_students.MatricNo', $matrik)
        
        ->first();
    
    $data = DB::connection('conn_hep')->table('transkrip_member')
     
    
         ->select('*', 'transkrip_main_info.Keterangan AS Keterangan, transkrip_main_info.Sesi AS Sesi')
         
        ->join('transkrip_main_info', 'transkrip_main_info.ID','=','transkrip_member.MainInfoID') 
        
        
        ->leftjoin('transkrip_main_committee', 'transkrip_main_committee.MainInfoID','=','transkrip_member.MainInfoID') 
                
        ->leftjoin('transkrip_sub_committee', 'transkrip_sub_committee.MainInfoID','=','transkrip_member.MainInfoID') 
                
        ->join('stud_students','stud_students.MatricNo','=','transkrip_member.MatricNo')
        
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->join('conf_term', 'conf_term.ID', '=', 'transkrip_main_info.Sesi')
        
        //  ->where('KategoriID', $KategoriID) 
        //  ->where('transkrip_member.Status',$Status)
           ->Where('transkrip_member.MatricNo', $matrik)
        ->orderBy('transkrip_member.ID', 'desc')
        ->groupBy('transkrip_main_info.ID')
        #   ->Limit(10)
        ->get();
         
         
         
##1

    $data_main_member = DB::connection('conn_hep')->table('transkrip_member')
        ->select('*', 'transkrip_main_info.Keterangan AS Keterangan, transkrip_main_info.Sesi AS Sesi' )//, 'transkrip_member.Merit as MeritMember', 'transkrip_main_committee.Merit as MeritMainCommittee', 'transkrip_sub_committee.Merit as MeritSubCommittee')
        ->join('transkrip_main_info', 'transkrip_main_info.ID','=','transkrip_member.MainInfoID') 
        // ->leftjoin('transkrip_main_committee', 'transkrip_main_committee.MainInfoID','=','transkrip_member.MainInfoID') 
        // ->leftjoin('transkrip_sub_committee', 'transkrip_sub_committee.MainInfoID','=','transkrip_member.MainInfoID') 
        ->join('stud_students','stud_students.MatricNo','=','transkrip_member.MatricNo')
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->join('conf_term', 'conf_term.ID', '=', 'transkrip_main_info.Sesi')
        ->Where('transkrip_member.MatricNo', $matrik)
        ->orderBy('transkrip_member.ID', 'desc')
        ->groupBy('transkrip_main_info.ID')
        ->get();
         
         
##2

    $data_main_maincom = DB::connection('conn_hep')->table('transkrip_main_committee')
        ->select('*', 'transkrip_main_info.Keterangan AS Keterangan, transkrip_main_info.Sesi AS Sesi')
        ->join('transkrip_main_info', 'transkrip_main_info.ID','=','transkrip_main_committee.MainInfoID') 
        ->join('stud_students','stud_students.MatricNo','=','transkrip_main_committee.MatricNo')
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->join('conf_term', 'conf_term.ID', '=', 'transkrip_main_info.Sesi')
        ->Where('transkrip_main_committee.MatricNo', $matrik)
        ->orderBy('transkrip_main_committee.ID', 'desc')
        ->groupBy('transkrip_main_info.ID')
        ->get();
         
                  
         
##3

    $data_main_subcom = DB::connection('conn_hep')->table('transkrip_sub_committee')
        ->select('*', 'transkrip_main_info.Keterangan AS Keterangan, transkrip_main_info.Sesi AS Sesi')
        ->join('transkrip_main_info', 'transkrip_main_info.ID','=','transkrip_sub_committee.MainInfoID') 
        ->join('stud_students','stud_students.MatricNo','=','transkrip_sub_committee.MatricNo')
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->join('conf_term', 'conf_term.ID', '=', 'transkrip_main_info.Sesi')
        ->Where('transkrip_sub_committee.MatricNo', $matrik)
        ->orderBy('transkrip_sub_committee.ID', 'desc')
        ->groupBy('transkrip_main_info.ID')
        ->get();
         

    $data_main_peserta = DB::connection('conn_hep')->table('transkrip_peserta')
        ->select('*', 'transkrip_main_info.Keterangan AS Keterangan, transkrip_main_info.Sesi AS Sesi')
        ->join('transkrip_main_info', 'transkrip_main_info.ID','=','transkrip_peserta.MainInfoID') 
        ->join('stud_students','stud_students.MatricNo','=','transkrip_peserta.MatricNo')
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->join('conf_term', 'conf_term.ID', '=', 'transkrip_main_info.Sesi')
        ->Where('transkrip_peserta.MatricNo', $matrik)
        ->orderBy('transkrip_peserta.ID', 'desc')
        ->groupBy('transkrip_main_info.ID')
        ->get();
        
        
        
        
    
    
    $data_aktiviti = DB::connection('conn_hep')->table('transkrip_member')
     
    
         ->select('*', 'transkrip_aktiviti_info.Keterangan AS Keterangan', 'transkrip_aktiviti_info.Sesi AS Sesi', 'transkrip_group.Keterangan AS KeteranganGroup')
         
        ->join('transkrip_aktiviti_info', 'transkrip_aktiviti_info.ID','=','transkrip_member.AktivitiInfoID') 
        
        
        ->leftjoin('transkrip_main_committee', 'transkrip_main_committee.AktivitiInfoID','=','transkrip_member.AktivitiInfoID') 
                
        ->leftjoin('transkrip_sub_committee', 'transkrip_sub_committee.AktivitiInfoID','=','transkrip_member.AktivitiInfoID') 
                
        ->leftjoin('stud_students','stud_students.MatricNo','=','transkrip_member.MatricNo')
        
        ->leftjoin('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->leftjoin('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->leftjoin('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->leftjoin('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->leftjoin('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->leftjoin('conf_term', 'conf_term.ID', '=', 'transkrip_aktiviti_info.Sesi')
        ->join('transkrip_group','transkrip_group.ID','=','transkrip_aktiviti_info.KategoriID')
        
        //  ->where('KategoriID', $KategoriID) 
        //  ->where('transkrip_member.Status',$Status)
          ->Where('transkrip_member.MatricNo', $matrik)
        ->orderBy('transkrip_member.ID', 'desc')
        # ->Limit(10)
        ->get();
        



    
    $data_aktiviti_member = DB::connection('conn_hep')->table('transkrip_member')
        ->select('*', 'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti', 'transkrip_aktiviti_info.Sesi AS Sesi', 'transkrip_group.Keterangan AS KeteranganGroup', 'transkrip_aktiviti_info.TemaID as TemaID')
        ->join('transkrip_aktiviti_info', 'transkrip_aktiviti_info.ID','=','transkrip_member.AktivitiInfoID') 
        ->leftjoin('stud_students','stud_students.MatricNo','=','transkrip_member.MatricNo')
        ->leftjoin('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->leftjoin('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->leftjoin('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->leftjoin('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->leftjoin('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->leftjoin('conf_term', 'conf_term.ID', '=', 'transkrip_aktiviti_info.Sesi')
        ->join('transkrip_group','transkrip_group.ID','=','transkrip_aktiviti_info.KategoriID')
        ->Where('transkrip_member.MatricNo', $matrik)
        ->orderBy('transkrip_member.ID', 'desc')
        ->get();
 
    $data_aktiviti_maincom = DB::connection('conn_hep')->table('transkrip_main_committee')
        ->select('*', 'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti', 'transkrip_aktiviti_info.Sesi AS Sesi', 'transkrip_group.Keterangan AS KeteranganGroup', 'transkrip_aktiviti_info.TemaID as TemaID')
        ->join('transkrip_aktiviti_info', 'transkrip_aktiviti_info.ID','=','transkrip_main_committee.AktivitiInfoID') 
        ->leftjoin('stud_students','stud_students.MatricNo','=','transkrip_main_committee.MatricNo')
        ->leftjoin('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->leftjoin('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->leftjoin('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->leftjoin('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->leftjoin('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->leftjoin('conf_term', 'conf_term.ID', '=', 'transkrip_aktiviti_info.Sesi')
        ->join('transkrip_group','transkrip_group.ID','=','transkrip_aktiviti_info.KategoriID')
        ->Where('transkrip_main_committee.MatricNo', $matrik)
        ->orderBy('transkrip_main_committee.ID', 'desc')
        ->get();
        

    
    $data_aktiviti_subcom = DB::connection('conn_hep')->table('transkrip_sub_committee')
        ->select('*', 'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti', 'transkrip_aktiviti_info.Sesi AS Sesi', 'transkrip_group.Keterangan AS KeteranganGroup', 'transkrip_aktiviti_info.TemaID as TemaID')
        ->join('transkrip_aktiviti_info', 'transkrip_aktiviti_info.ID','=','transkrip_sub_committee.AktivitiInfoID') 
        ->leftjoin('stud_students','stud_students.MatricNo','=','transkrip_sub_committee.MatricNo')
        ->leftjoin('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->leftjoin('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->leftjoin('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->leftjoin('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->leftjoin('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->leftjoin('conf_term', 'conf_term.ID', '=', 'transkrip_aktiviti_info.Sesi')
        ->join('transkrip_group','transkrip_group.ID','=','transkrip_aktiviti_info.KategoriID')
        ->Where('transkrip_sub_committee.MatricNo', $matrik)
        ->orderBy('transkrip_sub_committee.ID', 'desc')
        ->get();
        
    
    $data_aktiviti_peserta = DB::connection('conn_hep')->table('transkrip_peserta')
        ->select('*', 'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti', 'transkrip_aktiviti_info.Sesi AS Sesi', 'transkrip_group.Keterangan AS KeteranganGroup', 'transkrip_aktiviti_info.TemaID as TemaID')
        ->join('transkrip_aktiviti_info', 'transkrip_aktiviti_info.ID','=','transkrip_peserta.AktivitiInfoID') 
        ->leftjoin('stud_students','stud_students.MatricNo','=','transkrip_peserta.MatricNo')
        ->leftjoin('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->leftjoin('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->leftjoin('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->leftjoin('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->leftjoin('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        ->leftjoin('conf_term', 'conf_term.ID', '=', 'transkrip_aktiviti_info.Sesi')
        ->join('transkrip_group','transkrip_group.ID','=','transkrip_aktiviti_info.KategoriID')
        ->Where('transkrip_peserta.MatricNo', $matrik)
        ->orderBy('transkrip_peserta.ID', 'desc')
        ->get();
        

        $transkrip_group = DB::connection('conn_hep')->table('transkrip_group')->get();
        $transkrip_peringkat = DB::connection('conn_hep')->table('transkrip_peringkat')->get();
         
        $transkrip_jawatan = DB::connection('conn_hep')->table('transkrip_jawatan')->get();
       
       
       
       
       
       
       
       $transkrip_tema = DB::connection('conn_hep')->table('transkrip_tema')->get();
       
       
       
       $transkrip_aktiviti_luar_pelajar = DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar')
   //    ->where(['Status'=>5, 'Aktif'=>1, 'MatricNo'=>$matrik ])
  ->where([ 'Aktif'=>1, 'MatricNo'=>$matrik])
   ->WhereIn('Status',[1,5])
       ->get();
       
       
       $transkrip_tahap = DB::connection('conn_hep')->table('transkrip_tahap')->get();
       $transkrip_pemarkahan = DB::connection('conn_hep')->table('transkrip_pemarkahan')->get();
       
 
       
       $transkrip_keahlian_luar_pelajar = DB::connection('conn_hep')->table('transkrip_keahlian_luar_pelajar')
   //    ->where(['Status'=>5, 'Aktif'=>1, 'MatricNo'=>$matrik ])
  ->where([ 'Aktif'=>1, 'MatricNo'=>$matrik])
   ->WhereIn('Status',[1,5])
       ->get();
       


	   
     		return view('/TranskripKokurikulum/A_Surat', [
     		    'transkrip_pemarkahan' =>$transkrip_pemarkahan,
         
			'data'=>$data,
			'data_aktiviti' => $data_aktiviti,
			 
			
			'maklumat_pelajar' =>$maklumat_pelajar,
			'transkrip_group' => $transkrip_group,
			'transkrip_peringkat' => $transkrip_peringkat,
			
			
			
'data_main_member' =>$data_main_member,       
'data_main_maincom' =>$data_main_maincom,
'data_main_subcom' =>$data_main_subcom,
    
    		
			
'data_aktiviti_member' =>$data_aktiviti_member,       
'data_aktiviti_maincom' =>$data_aktiviti_maincom,
'data_aktiviti_subcom' =>$data_aktiviti_subcom,


'transkrip_jawatan' =>$transkrip_jawatan,

'transkrip_tema'=>$transkrip_tema,
    
    'transkrip_aktiviti_luar_pelajar'=>$transkrip_aktiviti_luar_pelajar ,
    
    'transkrip_tahap' =>$transkrip_tahap,
    
    
    'data_main_peserta' => $data_main_peserta,
    
    'data_aktiviti_peserta' => $data_aktiviti_peserta,
    
    'transkrip_keahlian_luar_pelajar'=>$transkrip_keahlian_luar_pelajar ,
	
        ]);       
    }







    public function Senarai_Transkrip_Pelajar(Request $request){
        
        $MM_nostaf = $_SESSION['MM_nostaff'];//'0530';
          $KategoriID = $request->get('k');
          $Status = $request->get('s');
        

        //
        
        
        $senarai_ahli =
        DB::connection('conn_hep')->table('transkrip_main_info') 
        ->select('*' )
        ->leftJoin('transkrip_member'           ,   'transkrip_member.MainInfoID'           ,   '=' ,   'transkrip_main_info.ID')
        ->leftJoin('transkrip_main_committee'   ,   'transkrip_main_committee.MainInfoID'   ,   '=' ,   'transkrip_main_info.ID')
        ->leftJoin('transkrip_sub_committee'    ,   'transkrip_sub_committee.MainInfoID'    ,   '=' ,   'transkrip_main_info.ID')
        
        ->join('stud_students','stud_students.MatricNo','=','transkrip_member.MatricNo')
    
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        
        ->Where('transkrip_main_info.KategoriID',$KategoriID)
        
        ->Where('transkrip_member.Status'         , 1)
        //  ->Where('transkrip_main_committee.Status' , 1)
        //  ->Where('transkrip_sub_committee.Status'  , 1)
         
        ->get();
        
        
        $senarai_ahli =null;



        //$ne = $request->get('s');

$skip  = $request->get('s');    // = $ne   - 10;
$take  = $request->get('t');    // = $skip + 10;

  if ( !isset($skip) ){    $skip =0;   }
  if ( !isset($take) ){    $take =10;   }
 $take =10;
 
 
 $matrik= $request->post('matrik');
 $name= $request->post('nama');
 
 
 if( !empty($matrik) &&  !empty($name)){
     
     $senarai_ahli  = DB::connection('conn_hep')->table('stud_students')
        ->select('*')
        //->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
		      
       // ->join('stud_students','stud_students.MatricNo','=','stud_students.MatricNo')
    
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        
        ->where('stud_students.MatricNo', $matrik)
        ->where('stud_studentdetails.Name', $name)
        ->skip($skip)->take($take)
        ->get();
        
 }
 else
 
 if( !empty($matrik)  &&  empty($name) ){
     
     $senarai_ahli  = DB::connection('conn_hep')->table('stud_students')
        ->select('*')
        //->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
		      
        //->join('stud_students','stud_students.MatricNo','=','stud_students.MatricNo')
    
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        
        ->where('stud_students.MatricNo', $matrik) 
        ->skip($skip)->take($take)
        ->get();
 }else
 if( empty($matrik) &&  !empty($name) ){
     
     $senarai_ahli  = DB::connection('conn_hep')->table('stud_students')
        ->select('*')
        //->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')      
        
		//->join('stud_students','stud_students.MatricNo','=','stud_students.MatricNo')
    
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        
        ->where('stud_studentdetails.Name', $name)
        ->skip($skip)->take($take)
        ->get();
     
 }
 else{
        /**
        $senarai_ahli  = DB::connection('conn_hep')->table('stud_students')
        ->select('*')
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->skip($skip)->take($take)
        ->get();
        **/
        $senarai_ahli =Array(); 
 }  
        
        
        
        
        
         return view('TranskripKokurikulum/A_Senarai_Transkrip_Pelajar',[
             
             'k'=>$KategoriID,
             's'=>$Status, 
             'senarai_ahli' => $senarai_ahli,
            'skip' =>$skip,
            'take' =>$take,
            
             ]);
        
    }  
    
        
    
    
    
    




    
    
    public function Kemaskini_Tunggal_Persatuan_Kelab(Request $request){

        $no     =   $request-> post('no');
        $k      =   $request-> post('k');
         
        $MM_NOSTAF = $_SESSION['MM_nostaff'];
         
         $nama          = $request -> post('nama');
         $fakulti       = $request -> post('fakulti');
         $penyelaras    = $request -> post('penyelaras');
         
         /**
         
            if ($k == 1 || $k == 2  || $k == 3  || $k == 4 || $k ==5 || $k == 6){    
        $update_transkrip_main_info = DB::connection('conn_hep')->table('transkrip_main_info')
                ->where('ID', $no)
                    ->update(['Keterangan'=> $nama, 
                    // 'FacultyID' => $fakulti, 
                    'DateUpdate'=>Date('Y-M-D H:i:s'), 'StaffUpdate'=> $MM_NOSTAF ]);
            }
            **/
            
            
            if ($k == 7 || $k == 8 || $k == 9  || $k == 10){    
        $update_transkrip_aktiviti_info = DB::connection('conn_hep')->table('transkrip_aktiviti_info')
                ->where('ID', $no)
                    ->update(['Keterangan'=> $nama,  /** 'FacultyID' => $fakulti, **/ 'DateUpdate'=>Date('Y-M-D H:i:s'), 'StaffUpdate'=> $MM_NOSTAF ]);
            }
                    
                    
        $update_transkrip_log = DB::connection('conn_hep')->table('transkrip_log')->insert(['Table_Name'=>'transkrip_main_info',	'Column_Name'=>'Keterangan',	'Column_Value'=>$nama,	'StaffUpdate'=>$MM_NOSTAF,	'DateUpdate' =>Date('Y-m-d H:i:s')	]);            
        // $update_transkrip_log = DB::connection('conn_hep')->table('transkrip_log')->insert(['Table_Name'=>'transkrip_main_info',	'Column_Name'=>'FacultyID',	'Column_Value'=>$fakulti,	'StaffUpdate'=>$MM_NOSTAF,	'DateUpdate' =>Date('Y-m-d H:i:s')	]);            
                
                
        
        if ($k == 1 || $k == 2 ){
                    
            if ( !empty($request->post('np')) ){
            $namapenyelaras= $request->post('np');
            $update_transkrip_penyelaras = DB::connection('conn_hep')->table('transkrip_penyelaras')
                    ->where('MainInfoID', $no)
                    ->update(['NamaPenyelaras'=> $namapenyelaras, 'DateUpdate'=>Date('Y-M-D H:i:s'), 'StaffUpdate'=> $MM_NOSTAF ]);
                                
            $update_transkrip_log = DB::connection('conn_hep')->table('transkrip_log')->insert(['Table_Name'=>'transkrip_penyelaras',	'Column_Name'=>'NamaPenyelaras',	'Column_Value'=>$namapenyelaras,	'StaffUpdate'=>$MM_NOSTAF,	'DateUpdate' =>Date('Y-m-d H:i:s')	]);            
            }        
                    
        }
        
       
        
       
       if ($k == 1 ||$k == 2 ||$k == 3 ||$k == 4 ||$k == 5 ||$k == 6){
                   if ( !empty($request->post('reference_matrik_main_committee')) && !empty($request->post('matrik_main_committee')) ) {
        $reference_matrik_main_committee= $request->post('reference_matrik_main_committee');
        $matrik_main_committee= $request->post('matrik_main_committee');
        $array_bil=0;
            foreach($reference_matrik_main_committee as $_reference_data_array){
                //    $check_existence=DB::connection('conn_hep')->table('transkrip_main_committee')
                 //   ->where('MainInfoID', $no)->where('MatricNo',$_this_data_array)->first();
                    if ( $matrik_main_committee[$array_bil] !=  $_reference_data_array ){
                        $update_transkrip_main_committee = DB::connection('conn_hep')->table('transkrip_main_committee')
                            ->where( [['MainInfoID', $no],  ['MatricNo' , $_reference_data_array] ])
                            ->update(['MatricNo'=> $matrik_main_committee[$array_bil], 'DateUpdate'=>Date('Y-M-D H:i:s'), 'StaffUpdate'=> $MM_NOSTAF ]);
                        $update_transkrip_log = DB::connection('conn_hep')->table('transkrip_log')
                            ->insert(['Table_Name'=>'transkrip_main_committee',	'Column_Name'=>'MatricNo',	'Column_Value'=>$matrik_main_committee[$array_bil],	'StaffUpdate'=>$MM_NOSTAF,	'DateUpdate' =>Date('Y-m-d H:i:s')	]);            
                          }
                $array_bil++;
                }
        } 
        
         
        
        if ( !empty($request->post('reference_matrik_sub_committee')) && !empty($request->post('matrik_sub_committee')) ) {
        $reference_matrik_sub_committee= $request->post('reference_matrik_sub_committee');
        $matrik_sub_committee= $request->post('matrik_sub_committee');
        $array_bil=0;
            foreach($reference_matrik_sub_committee as $_reference_data_array){
                    if ( $matrik_sub_committee[$array_bil] !=  $_reference_data_array ){
                        $update_transkrip_sub_committee = DB::connection('conn_hep')->table('transkrip_sub_committee')
                            ->where( [['MainInfoID', $no],  ['MatricNo' , $_reference_data_array] ])
                            ->update(['MatricNo'=> $matrik_sub_committee[$array_bil], 'DateUpdate'=>Date('Y-M-D H:i:s'), 'StaffUpdate'=> $MM_NOSTAF ]);
                        $update_transkrip_log = DB::connection('conn_hep')->table('transkrip_log')
                        ->insert(['Table_Name'=>'transkrip_sub_committee',	'Column_Name'=>'MatricNo',	'Column_Value'=>$matrik_sub_committee[$array_bil],	'StaffUpdate'=>$MM_NOSTAF,	'DateUpdate' =>Date('Y-m-d H:i:s')	]);            
                         }
                $array_bil++;
                }
        } 
    
       } 
        
        
    
          
                
                
                
        
       if ($k == 7 ||$k == 8 ||$k == 9 ||$k == 10){
         
        
        if ( !empty($request->post('reference_matrik_main_committee')) && !empty($request->post('matrik_main_committee')) ) {
        $reference_matrik_main_committee= $request->post('reference_matrik_main_committee');
        $matrik_main_committee= $request->post('matrik_main_committee');
        $array_bil=0;
            foreach($reference_matrik_main_committee as $_reference_data_array){
                //    $check_existence=DB::connection('conn_hep')->table('transkrip_main_committee')
                 //   ->where('MainInfoID', $no)->where('MatricNo',$_this_data_array)->first();
                    if ( $matrik_main_committee[$array_bil] !=  $_reference_data_array ){
                        $update_transkrip_main_committee = DB::connection('conn_hep')->table('transkrip_main_committee')
                            ->where( [['AktivitiInfoID', $no],  ['MatricNo' , $_reference_data_array] ])
                            ->update(['MatricNo'=> $matrik_main_committee[$array_bil], 'DateUpdate'=>Date('Y-M-D H:i:s'), 'StaffUpdate'=> $MM_NOSTAF ]);
                        $update_transkrip_log = DB::connection('conn_hep')->table('transkrip_log')
                            ->insert(['Table_Name'=>'transkrip_main_committee',	'Column_Name'=>'MatricNo',	'Column_Value'=>$matrik_main_committee[$array_bil],	'StaffUpdate'=>$MM_NOSTAF,	'DateUpdate' =>Date('Y-m-d H:i:s')	]);            
                          }
                $array_bil++;
                }
        } 
        
         
        
        if ( !empty($request->post('reference_matrik_sub_committee')) && !empty($request->post('matrik_sub_committee')) ) {
        $reference_matrik_sub_committee= $request->post('reference_matrik_sub_committee');
        $matrik_sub_committee= $request->post('matrik_sub_committee');
        $array_bil=0;
            foreach($reference_matrik_sub_committee as $_reference_data_array){
                    if ( $matrik_sub_committee[$array_bil] !=  $_reference_data_array ){
                        $update_transkrip_sub_committee = DB::connection('conn_hep')->table('transkrip_sub_committee')
                            ->where( [['AktivitiInfoID', $no],  ['MatricNo' , $_reference_data_array] ])
                            ->update(['MatricNo'=> $matrik_sub_committee[$array_bil], 'DateUpdate'=>Date('Y-M-D H:i:s'), 'StaffUpdate'=> $MM_NOSTAF ]);
                        $update_transkrip_log = DB::connection('conn_hep')->table('transkrip_log')
                        ->insert(['Table_Name'=>'transkrip_sub_committee',	'Column_Name'=>'MatricNo',	'Column_Value'=>$matrik_sub_committee[$array_bil],	'StaffUpdate'=>$MM_NOSTAF,	'DateUpdate' =>Date('Y-m-d H:i:s')	]);            
                         }
                $array_bil++;
                }
        } 
    
       } 
                
                
                
                
////        $update_transkrip_log = DB::connection('conn_hep')->table('transkrip_log ')->insert(['Table_Name'=>'',	'Column_Name'=>'',	'Column_Value'=>'',	'StaffUpdate'=>$MM_NOSTAF,	'DateUpdate' =>Date('Y-m-d H:i:s')	]);            
                
         return redirect('/TranskripKokurikulum/Maklumat-Tunggal-Persatuan-Kelab?no='.$no.'&k='.$k);
         
    }
    
    
    







///DARIAPDA STUDENT PORTAL
///28/02/28

public function Maklumat_Keahlian_Semasa(Request $request){
    
    $matrik = '1999000005'; //$request->get('matrik');

    
    $data = DB::connection('conn_hep')->table('transkrip_member')
    
        ->select('*','transkrip_main_info.Keterangan AS Keterangan' ) 
        ->join('transkrip_main_info', 'transkrip_main_info.ID','=','transkrip_member.MainInfoID')
    
        ->join('stud_students','stud_students.MatricNo','=','transkrip_member.MatricNo')
        
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        
        //  ->where('KategoriID', $KategoriID) 
        //  ->where('transkrip_member.Status',$Status)
        ->Where('transkrip_member.MatricNo', $matrik)
        ->orderBy('transkrip_member.ID', 'desc')
        ->get();
        
        
        
        
        
            
       $matrik = $request->get('matrik');//'1999000005';
        
        
    
    
    $data = DB::connection('conn_hep')->table('transkrip_member')
     
    
         ->select('*', 'transkrip_main_info.Keterangan AS Keterangan', 'transkrip_member.Status as Status')
         
        ->join('transkrip_main_info', 'transkrip_main_info.ID','=','transkrip_member.MainInfoID') 
                
        ->join('stud_students','stud_students.MatricNo','=','transkrip_member.MatricNo')
        
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        
        //  ->where('KategoriID', $KategoriID) 
        //  ->where('transkrip_member.Status',$Status)
        ->Where('transkrip_member.MatricNo', $matrik)
        ->orderBy('transkrip_member.ID', 'desc')
        ->get();
        
        $maklumat_pelajar = DB::connection('conn_hep')->table('stud_students')
        
        ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
        ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
        ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
        ->join('conf_department','conf_department.DeptID','=','conf_program.Department')
        ->join('conf_faculty','conf_faculty.FacultyID','=','conf_department.FacultyID')
        
        //  ->where('KategoriID', $KategoriID) 
        //  ->where('transkrip_member.Status',$Status)
        ->Where('stud_students.MatricNo', $matrik)
        
        ->get();
        
    $MID2=Array();    
    foreach($data as $dd){$MID2[] = $dd->ID;}    
        $transkrip_penyelaras = DB::connection('conn_hep')->table('transkrip_penyelaras')
        ->whereIn('transkrip_penyelaras.MainInfoID',$MID2)
        ->get();
        
         
        
        
        $transkrip_main_info = DB::connection('conn_hep')->table('transkrip_main_info')
        ->get();
       
       
       
$transkrip_main_committee = DB::connection('conn_hep')->table('transkrip_main_committee') 
->join('transkrip_jawatan' , 'transkrip_jawatan.ID', '=', 'transkrip_main_committee.JawatanID' )
->where( 'MatricNo',$matrik) ->get();


$transkrip_sub_committee = DB::connection('conn_hep')->table('transkrip_sub_committee')
->join('transkrip_jawatan' , 'transkrip_jawatan.ID', '=', 'transkrip_sub_committee.JawatanID' )
->where( 'MatricNo',$matrik) ->get();
        
        $transkrip_jawatan = DB::connection('conn_hep')->table('transkrip_jawatan')->get();
        
    return view('TranskripKokurikulum/A_Maklumat_Tunggal_Keahlian_Semasa_Pelajar',[
                'data'  =>  $data, 
                'maklumat_pelajar' => $maklumat_pelajar, 
                'transkrip_main_info' => $transkrip_main_info,
                'transkrip_penyelaras'=>$transkrip_penyelaras,
                'transkrip_main_committee' => $transkrip_main_committee,
                'transkrip_sub_committee' => $transkrip_sub_committee,
                'transkrip_jawatan' => $transkrip_jawatan,
            ]);
}
    
    
    
    
    
    
    
    
    
    
    
    
    //09/04/2025
    public function  Kehadiran(Request $request){
    $data=1;
    return view('TranskripKokurikulum/A_Kehadiran',[                'data'  =>  $data, ]);
    }
    
    
    
    //09/04/2025
    public function  Borang_Daftar_Kehadiran(Request $request){
  
    ////
    $ID_GET= $request->get('cu');
    
    $transkrip_aktiviti_info = DB::connection('conn_hep')->table('transkrip_aktiviti_info')
    ->SELECT('*','transkrip_peringkat.Keterangan as PeringkatKeterangan', 'transkrip_listkok.Nama as NamaKoku'
    , 'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti')
    //  Penganjur
    ->LEFTjoin('transkrip_listkok', 'transkrip_listkok.ID','=','transkrip_aktiviti_info.Penganjur')
    
    //  Peringkat
    ->LEFTjoin('transkrip_peringkat','transkrip_peringkat.ID','=','transkrip_aktiviti_info.Peringkat')
    //  
    
    ->WhereIn('transkrip_aktiviti_info.KategoriID',[7,8]) ->Where('transkrip_aktiviti_info.ID',$ID_GET) ->first();
    
    return view('TranskripKokurikulum/A_Borang_Daftar_Kehadiran',[
                               
                'transkrip_aktiviti_info'   =>  $transkrip_aktiviti_info,
                'ID_GET' => $ID_GET
            ]);
    }
    
    
          
 
    public function  Simpan_Daftar_Kehadiran(Request $request){
        
        $Location   =   $request->Post('locationQR');
        // Mansuh 
		// $TarikhMula   =   $request->Post('dateQR');
		//Lebih detail tarikhnya, ada masa x2
		$dateQR_mula   =   $request->Post('dateQR_mula');
		$dateQR_tamat   =   $request->Post('dateQR_tamat');
		$timeQR_mula   =   $request->Post('timeQR_mula');
		$timeQR_tamat   =   $request->Post('timeQR_tamat');
		
        $Keterangan   =   $request->Post('keteranganQR');
        $AktivitiInfoID   =   $request->Post('Aktiviti');
        
        $insert_transkrip_qrgenerate = DB::connection('conn_hep')->table('transkrip_qrgenerate')
        
        ->INSERT([  'Location' => $Location ,
                    // 'TarikhMula' => $TarikhMula,
					'TarikhMula'=>$dateQR_mula,
					'TarikhTamat'=>$dateQR_tamat,
					'MasaMula'=>$timeQR_mula,
					'MasaTamat'=>$timeQR_tamat,
                    'AktivitiInfoID' => $AktivitiInfoID,
                    'Keterangan' => $Keterangan,	
                    'StaffAdd' => '0600',
					'Status'=>1
            ]);
    
        $qrgenerateID = DB::connection('conn_hep')->getPdo()->lastInsertId();
        $hashed = md5( md5($qrgenerateID) );
        
        $update_transkrip_qrgenerate = DB::connection('conn_hep')->table('transkrip_qrgenerate')
        ->Where('ID',$qrgenerateID)
        ->UPDATE([ 'QRCode' => $hashed, 'DateTimeGenerate' => date('Y-m-d H:i:s')]);
      
      
      
        $update_aktiviti_info = DB::connection('conn_hep')->table('transkrip_aktiviti_info')
        ->Where('ID',$AktivitiInfoID)
        ->UPDATE([ 'QRCreatedStatus'=>1 ]);
      
      
      //  
      
    //////        return redirect('/TranskripKokurikulum/Senarai-Persatuan-Kelab?k=7')->with('status', 'Maklumat Berjaya Disimpan');

        return redirect('/TranskripKokurikulum/QR?cu='.$AktivitiInfoID)->with('status', 'Maklumat Berjaya Disimpan');

      ////
      

     }
	
	
	
	
	public function QR_Kod(Request $request){


    $cu = $request->get('cu');




$transkrip_qrgenerate = DB::connection('conn_hep')->table('transkrip_qrgenerate')
->Select('*', 'transkrip_qrgenerate.Keterangan AS KeteranganQR', 'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti'
, 'transkrip_qrgenerate.TarikhMula AS TarikhMulaQR', 'transkrip_aktiviti_info.TarikhMula AS TarikhMulaAktiviti'
,'transkrip_qrgenerate.Location as LokasiQR' , 'transkrip_qrgenerate.ID as IDQRGenerate')
->join('transkrip_aktiviti_info', 'transkrip_aktiviti_info.ID','=','transkrip_qrgenerate.AktivitiInfoID')
->where('transkrip_aktiviti_info.ID',$cu)
->get();


foreach($transkrip_qrgenerate as $tqrg){ $hashed= $tqrg->QRCode;}
	    //$hashed=$request->get('kod');
	    
	    
	    $cu= $request->get('cu');
 
 /*
    $transkrip_aktiviti_info = DB::connection('conn_hep')->table('transkrip_aktiviti_info')
    
    ->SELECT('*','transkrip_peringkat.Keterangan as PeringkatKeterangan', 'transkrip_listkok.Nama as NamaKoku'
    , 'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti')
    //  Penganjur
    ->LEFTjoin('transkrip_listkok', 'transkrip_listkok.ID','=','transkrip_aktiviti_info.Penganjur')
    
    //  Peringkat
    ->LEFTjoin('transkrip_peringkat','transkrip_peringkat.ID','=','transkrip_aktiviti_info.Peringkat')
    //  
    
    ->WhereIn('transkrip_aktiviti_info.KategoriID',[7,8,9,10]) ->Where('transkrip_aktiviti_info.ID',$cu) 
    ->first();
    
    **/
    
    
    
    $transkrip_aktiviti_info = DB::connection('conn_hep')->table('transkrip_aktiviti_info')
    ->SELECT('*','transkrip_peringkat.Keterangan as PeringkatKeterangan', 'transkrip_listkok.Nama as NamaKoku'
    , 'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti')
    //  Penganjur
    ->LEFTjoin('transkrip_listkok', 'transkrip_listkok.ID','=','transkrip_aktiviti_info.Penganjur')
    
    //  Peringkat
    ->LEFTjoin('transkrip_peringkat','transkrip_peringkat.ID','=','transkrip_aktiviti_info.Peringkat')
    //  
    
    ->WhereIn('transkrip_aktiviti_info.KategoriID',[7,8]) ->Where('transkrip_aktiviti_info.ID',$cu) ->first();
    
    
    
    

        return view('TranskripKokurikulum/A_QR_Kod', [
            'kod'=>$hashed,
            'transkrip_qrgenerate'=>$transkrip_qrgenerate,
            'cu' =>$cu,
            'transkrip_aktiviti_info' =>$transkrip_aktiviti_info,
        ]);
		
	}
	
	
	
	
	
	
	
	
	
	
    public function Paparan_Laporan_Kehadiran(Request $request){
        $matrik = '1999000005'; 
        $cu = $request->get('cu');
        
       
        $transkrip_aktiviti_info = DB::connection('conn_hep')->table('transkrip_aktiviti_info')
    ->SELECT('*','transkrip_peringkat.Keterangan as PeringkatKeterangan', 
    'transkrip_listkok.Nama as NamaKoku' ,'transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti'
    ,'transkrip_qrgenerate.Keterangan AS KeteranganQR')
    //  Penganjur
    ->leftjoin('transkrip_listkok', 'transkrip_listkok.ID','=','transkrip_aktiviti_info.Penganjur')
    //  Kod QR
    ->leftjoin('transkrip_qrgenerate', 'transkrip_qrgenerate.AktivitiInfoID','=','transkrip_aktiviti_info.ID')
    
    //  Peringkat
    ->leftjoin('transkrip_peringkat','transkrip_peringkat.ID','=','transkrip_aktiviti_info.Peringkat')
    ////    Carian mengikut Aktiviti Info
    ////    ////    OK  ->WhereIn('transkrip_aktiviti_info.KategoriID',[7,8,9,10]) ->Where('transkrip_aktiviti_info.ID',$cu) 
    ////    Carian mengikut Kod QR (Bagi setiap satu)
    ->WhereIn('transkrip_aktiviti_info.KategoriID',[7,8,9,10]) 
    
    ->Where('transkrip_qrgenerate.ID',$cu) 
    
    ->first();
    
    
    
    
        //Pelajar
    //        $transkrip_aktiviti_info = DB::connection('conn_hep')->table('transkrip_aktiviti_info')->get();
    
		/**
     //Admin
        $transkrip_qrhadir =
        #   DB::connection('conn_hep')->table('transkrip_aktiviti_info')
        DB::connection('conn_hep')->table('transkrip_qrhadir')
        ->select('*','transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti', 'transkrip_qrgenerate.Keterangan AS KeteranganQR')
        
        ->leftjoin('transkrip_qrgenerate','transkrip_qrgenerate.ID','=','transkrip_qrhadir.QRGenerateID')
        
       # ->leftjoin('transkrip_qrhadir','transkrip_qrhadir.QRgenerateID','=','transkrip_qrgenerate.ID')
       ->leftjoin('transkrip_aktiviti_info','transkrip_aktiviti_info.ID','=','transkrip_qrgenerate.AktivitiInfoID')
       
       
       ->leftjoin('stud_students', 'stud_students.MatricNo','=','transkrip_qrhadir.MatricNo')
       ->leftjoin('conf_structure','conf_structure.StructureID','=','stud_students.StructID')
       ->leftjoin('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
       
       // ->Where('transkrip_qrhadir.MatricNo',$matrik )
       ->Where('transkrip_qrgenerate.ID' ,$cu)
        ->get();
		**/
		
		
		 
            
			
		$transkrip_qrhadir =
        #   DB::connection('conn_hep')->table('transkrip_aktiviti_info')
        DB::connection('conn_hep')->table('transkrip_qrhadir')
        ->select('*','transkrip_aktiviti_info.Keterangan AS KeteranganAktiviti', 'transkrip_qrgenerate.Keterangan AS KeteranganQR')
        
        ->leftjoin('transkrip_qrgenerate','transkrip_qrgenerate.ID','=','transkrip_qrhadir.QRGenerateID')
        
       # ->leftjoin('transkrip_qrhadir','transkrip_qrhadir.QRgenerateID','=','transkrip_qrgenerate.ID')
       ->leftjoin('transkrip_aktiviti_info','transkrip_aktiviti_info.ID','=','transkrip_qrgenerate.AktivitiInfoID')
       
       
       ->leftjoin('stud_students', 'stud_students.MatricNo','=','transkrip_qrhadir.MatricNo')
	   ->leftjoin('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
			
       ->leftjoin('conf_structure','conf_structure.StructureID','=','stud_students.StructID')
       ->leftjoin('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
       
       // ->Where('transkrip_qrhadir.MatricNo',$matrik )
       ->Where('transkrip_qrgenerate.ID' ,$cu)
        ->get();
		
    
    return view('/TranskripKokurikulum/A_Laporan_Kehadiran',[
        'transkrip_aktiviti_info' => $transkrip_aktiviti_info,
        'transkrip_qrhadir' =>$transkrip_qrhadir,
        ]); 
        
    }
	
	
	
	
	
	
	
	
	
	
	public function Paparan_QR(Request $request){
	    
	    $kodqr = $request->post('kod');
	    $kod = $kodqr.'/3';
	    echo '';
	    
	    
$namaprogram = $request->post('namaprogram');

$anjuran = $request->post('anjuran');

$keterangan = $request->post('keterangan');
	    $lokasi = $request->post('lokasi');
	    $tarikh = $request->post('tarikh');
	    
	    
	    echo '';

	    echo '
	    
	    
	    

	        
	        
	        

	        
	        

    	        

    	            
Nama Program
 
:
 
'.$namaprogram.'
    	        
    	        

    	            
Anjuran
 
:
 
'.$anjuran.'
    	        
    	        

    	            
Keterangan
 
:
 
'.$keterangan.'
    	        
    	        

    	            
Tempat
 
:
 
'.$lokasi.'
    	        
    	        

    	            
Tarikh
 
:
 
'.$tarikh.'
    	        
	        
	        
	        
	    
	    

	    
	    
	    ';
	    echo '';
	    
	    
	   echo'
    ';
    
	}
	
	
	
	
	
	
	
	
	public function Senarai_Borang_Pengesahan(Request $request)
    {
        
        
$count_persatuan = $count_kelab = $count_sukan = $count_perwakilan =$count_anak_negeri =$count_badan_beruniform = $count_keahlian_luar = 0  ;
    
    $forCount_transkrip_main_info = DB::connection('conn_hep')->table('transkrip_main_info')->where(['Aktif'=>1 ])->get();
    
    
    foreach($forCount_transkrip_main_info as $fc_tmi){
        if($fc_tmi->KategoriID == 1 ){$count_persatuan++;
            if($fc_tmi->Status==2){  $sahkan_count_persatuan ++;   }}
            
        if($fc_tmi->KategoriID == 2 ){$count_kelab++;
            if($fc_tmi->Status==3){  $sahkan_count_kelab ++;   }}
        
        if($fc_tmi->KategoriID == 3 ){$count_sukan++;
            if($fc_tmi->Status==3){  $sahkan_count_sukan ++;   }}
        
        if($fc_tmi->KategoriID == 4 ){$count_perwakilan++;
            if($fc_tmi->Status==3){  $sahkan_count_perwakilan ++;   }}
        if($fc_tmi->KategoriID == 5 ){$count_anak_negeri++;
            if($fc_tmi->Status==3){  $sahkan_count_anak_negeri ++;   }}
        if($fc_tmi->KategoriID == 6 ){$count_badan_beruniform++;
            if($fc_tmi->Status==3){  $sahkan_count_badan_beruniform ++;   }}
       
    }
    
    
    
       
$sahkan_count_persatuan = $sahkan_count_kelab = $sahkan_count_sukan = $sahkan_count_perwakilan =$sahkan_count_anak_negeri =$sahkan_count_badan_beruniform = $sahkan_count_keahlian_luar = 0  ;
  $forCount_transkrip_member = DB::connection('conn_hep')->table('transkrip_main_info')
  ->join('transkrip_member','transkrip_main_info.ID','=','transkrip_member.MainInfoID')
  
  
  ->where(['transkrip_member.Aktif'=>1 ])->get();
  
  foreach($forCount_transkrip_member as $fc_tmi){
        if($fc_tmi->KategoriID == 1 ){$count_persatuan++;
            if($fc_tmi->Status==3){  $sahkan_count_persatuan ++;   }}
            
        if($fc_tmi->KategoriID == 2 ){$count_kelab++;
            if($fc_tmi->Status==3){  $sahkan_count_kelab ++;   }}
        
        if($fc_tmi->KategoriID == 3 ){$count_sukan++;
            if($fc_tmi->Status==3){  $sahkan_count_sukan ++;   }}
        
        if($fc_tmi->KategoriID == 4 ){$count_perwakilan++;
            if($fc_tmi->Status==3){  $sahkan_count_perwakilan ++;   }}
        if($fc_tmi->KategoriID == 5 ){$count_anak_negeri++;
            if($fc_tmi->Status==3){  $sahkan_count_anak_negeri ++;   }}
        if($fc_tmi->KategoriID == 6 ){$count_badan_beruniform++;
            if($fc_tmi->Status==3){  $sahkan_count_badan_beruniform ++;   }}
       
    }
    
    
  
    
    
    $forCount_transkrip_aktiviti_luar_pelajar = DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar')->where(['Aktif'=>1, 'Status'=>3 ,'KategoriID'=>12])->get();
    foreach($forCount_transkrip_aktiviti_luar_pelajar as $fc_talp){
        
        if($fc_talp->KategoriID == 12 ){$count_keahlian_luar++;}
        
    }
    
    
    
    $sahkan_count_keahlian_luar = $count_keahlian_luar;
    
    
    
        return view('TranskripKokurikulum/A_Senarai_Borang_Pengesahan',[
                'count_persatuan'=>$count_persatuan,
                'count_kelab'=>$count_kelab,
                'count_sukan'=>$count_sukan,
                'count_perwakilan'=>$count_perwakilan,
                'count_anak_negeri'=>$count_anak_negeri,
                'count_badan_beruniform'=>$count_badan_beruniform,
                'count_keahlian_luar'=>$count_keahlian_luar,
                
                'sahkan_count_persatuan'    =>$sahkan_count_persatuan,
                'sahkan_count_kelab'        =>$sahkan_count_kelab,
                'sahkan_count_sukan'        =>$sahkan_count_sukan,
                'sahkan_count_perwakilan'   =>$sahkan_count_perwakilan,
                'sahkan_count_anak_negeri'  =>$sahkan_count_anak_negeri,
                'sahkan_count_badan_beruniform' =>$sahkan_count_badan_beruniform,
                'sahkan_count_keahlian_luar'    =>$sahkan_count_keahlian_luar,
                ]);
    }
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    	
public function Dashboard_PaparanPengesahan(Request $request){
$data='';


///count
$d= DB::connection('conn_hep')->table('transkrip_member') ->where('Status',3) ->get();
$e=Array();;

$e= DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar') ->where(['Status'=>3, 'KategoriID'=>12 ]) ->get();





//$e= DB::connection('conn_hep')->table('transkrip_aktiviti_info') ->where('Status',3) ->get();

$f= DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar') ->where(['Status'=>3, 'KategoriID'=>8 ]) ->get();


$g= DB::connection('conn_hep')->table('transkrip_aktiviti_info') ->where('Status',4) ->get();


$d_1 = $e_1= $f_1= $g_1=0;

foreach($d as $d){ $d_1++;}
foreach($e as $e){ $e_1++;}


foreach($f as $f){ $f_1++;}
foreach($g as $g){ $g_1++;}








///count
$a= DB::connection('conn_hep')->table('transkrip_member') ->wherein('Status',[3,4]) ->get();
$b=array();
//$b= DB::connection('conn_hep')->table('transkrip_aktiviti_info') ->wherein('Status',[3,4]) ->get();
$c= DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar') ->wherein('Status',[3,4]) ->get();
$a_1 = $b_1= $c_1=0;
foreach($a as $a){ $a_1++;}
foreach($b as $b){ $b_1++;}
foreach($c as $c){ $c_1++;}

$ALL_NEW_REQUEST= $a_1 + $b_1 + $c_1;


////Guna

$Pengesahan_Ahli = $d_1 + $e_1;





$f = DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar') ->where(['Status'=>[3,4] , 'KategoriID'=>11]) ->get();
foreach($f as $f){ $f_1++;}
$Pengesahan_Penglibatan_Program = $f_1;

$f = DB::connection('conn_hep')->table('transkrip_aktiviti_info') ->where(['Status'=>[4] , 'KategoriID'=>8]) ->get();
foreach($g as $g){ $g_1++;}
$Pengesahan_Pendaftaran_Program = $g_1;


$au_1=0;
$au = DB::connection('conn_hep')->table('transkrip_keahlian_luar_pelajar') ->where(['Status'=>[3,4] , 'KategoriID'=>16]) ->get();
foreach($au as $au){ $au_1++;}
$Pengesahan_Keahlian_Luar = $au_1;



    
    

         return view('TranskripKokurikulum/A_Dashboard_PaparanPengesahan',[
             'data' =>$data,
             'Pengesahan_Ahli' => $Pengesahan_Ahli,
             'Pengesahan_Penglibatan_Program'=>$Pengesahan_Penglibatan_Program,
             'Pengesahan_Pendaftaran_Program'=>$Pengesahan_Pendaftaran_Program,
			 'Pengesahan_Keahlian_Luar'=>$Pengesahan_Keahlian_Luar,
                
               
                
             ]);   
             
             
}




    public function Senarai_Pengesahan_Program_Luar(Request $request){
        
        $MM_nostaf = $_SESSION['MM_nostaff'];//'0530';
          $KategoriID = $request->get('k');
          $Status = $request->get('s');
       
        
        if ( $KategoriID != ''  &&  $KategoriID != null ){
        
        if ($KategoriID ==11)
        {
            
            
            $data = DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar')
                    ->select('*','transkrip_aktiviti_luar_pelajar.ID AS ID_Member', 'transkrip_aktiviti_luar_pelajar.Status as ID_Status',)
            
            ->join('stud_students','stud_students.MatricNo','=','transkrip_aktiviti_luar_pelajar.MatricNo')
            
            ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
            ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
            ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
            
            ->where(['KategoriID'=>$KategoriID,'Status'=>$Status]) 
            
            ->orderBy('transkrip_aktiviti_luar_pelajar.ID', 'desc')->get();
        
            
            
        }
        
        
        }else 
        { $data=Array();}
        
        
        
        
        $array_keahlian_semasa = Array();
        $_semak_matrik_pelajar = '';
        $num=0;
        
        $senarai_keahlian_semasa = Array();
        foreach($array_keahlian_semasa as $aks){
            $senarai_keahlian_semasa[] = 
            Array(
                'MatricNo' => $aks['MatricNo'], 
                'Bilangan' => $aks['Bilangan'] ,
                'KategoriID' => $aks['KategoriID'] 
                );
            
        }
     
        $transkrip_group = DB::connection('conn_hep')->table('transkrip_group')  ->get();
        
         $transkrip_peringkat = DB::connection('conn_hep')->table('transkrip_peringkat')->get();
        $transkrip_tema = DB::connection('conn_hep')->Table('transkrip_tema')->get();

    $transkrip_jawatan = DB::connection('conn_hep')->Table('transkrip_jawatan')->get();
    
         return view('TranskripKokurikulum/A_Senarai_Pengesahan_Program_Luar',[
             //         return view('TranskripKokurikulum/A_Senarai_Pengesahan_Keahlian',[
             'transkrip_group' => $transkrip_group,
             'senarai_keahlian_semasa' =>$senarai_keahlian_semasa,
             'k'=>$KategoriID,
             's'=>$Status,
             'data' => $data, 
             'transkrip_tema' => $transkrip_tema, 
              'transkrip_peringkat'=>$transkrip_peringkat,
              'transkrip_jawatan' => $transkrip_jawatan,
              ]);
        
    }  
    



    
public function Admin_Mengesahkan__Senarai_Pengesahan_Program_Luar(Request $request){
    
	$Status= $request ->get('tindakan');
    $Status=       $Status[0];  
    if ( $Status == 1 || $Status == 2 || $Status == 5){
    
    $Identiti_Pelajar = $request->post('pelajar');
    $k = $request->get('k');

    if($Status==1 || $Status == 5){
    $tema = $request->post('tema');
        
    }else {$tema[]='';}
    
    if($Status==2){
    $KeteranganPengesahan = $request->post('KeteranganPengesahan');
    
    }else {$KeteranganPengesahan[]='';}
   
    
    
    
    
    $DTukar_Jawatan= $request->post('DTukar_Jawatan');
    
    $tr=0;
    $MarkahMerit=0;
    foreach($Identiti_Pelajar as $IDP){
    
     $sel_tr_data = DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar')
            ->where('ID', $IDP)
    ->first();
    
    $JawatanID_sebenar=$sel_tr_data->JawatanID;
    if ($DTukar_Jawatan != $sel_tr_data->JawatanID){
        $JawatanID_sebenar= $DTukar_Jawatan;
    }
            
             //Penetapan Markah Merit
                        $transkrip_merit_program = DB::connection('conn_hep')->table('transkrip_merit_program') 
                        //->where([   'PeringkatID'=> $TahapID ]) 
                        ->where([   'JenisID'=>8, 'PeringkatID'=> $sel_tr_data->Peringkat,'JawatanID'=> $JawatanID_sebenar ])
                        ->first(); 
                        
                         $MarkahMerit = $transkrip_merit_program->Markah;
            
        $tr_data = DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar')
            ->where('ID', $IDP)
            ->update(['Status' => $Status, 'DateUpdate'=>Date('Y-M-D H:i:s'), 
            'TemaID'=> $tema[$tr],
            'KeteranganPengesahan' => $KeteranganPengesahan[$tr],
            'Merit'=>$MarkahMerit,
            'JawatanID'=>$DTukar_Jawatan,
            
        	
        	
            
            
            ]);
    $tr++;
    }
    
    
    
    
    
        if ( !empty($INSERT_STUDENT_PESERTA[0]) ){
   
        for($I=0; $Itable('transkrip_aktiviti_luar_pelajar')
                        ->where('ID', $MainAktivtiID)->first();
                        $TahapID = $tr_first_data->TahapID;
                        $D_Peringkat= $tr_first_data->Peringkat;
                        
                        //Penetapan Markah Merit
                        $transkrip_merit_program = DB::connection('conn_hep')->table('transkrip_merit_program') 
                        //->where([   'PeringkatID'=> $TahapID ]) 
                        ->where([   'JenisID'=>$k, 'PeringkatID'=> $tr_first_data->Peringkat,'JawatanID'=> $tr_first_data->JawatanID  ])
                        ->first(); 
                        
                        echo $MarkahMerit = $transkrip_merit_program->Markah;
                        
                        
                }        
            
            $insert_=   DB::connection('conn_hep')->table('transkrip_peserta')->insert([
                        'AktivitiInfoID' =>$MainAktivtiID,	'MatricNo' =>$INSERT_STUDENT_PESERTA[$I],	'Sesi' =>'-',	
                        'TarikhMula' =>date('Y-m-d H:i s', strtotime($D_Dari)),	'TarikhAkhir' =>date('Y-m-d H:i s', strtotime($D_Hingga)),	'DateInsert' =>date("Y-m-d H:i:s"),	
                        'StaffAdd' => $StaffAdd_Session, 'Aktif'=>1	,'Status' => 3, 'TahapID'=>1,	'Merit'=>$MarkahMerit,	'JawatanID'=>7,
                        ]);
        }
    }
    
    
    
    
    
//    $transkrip_group = DB::connection('conn_hep')->table('transkrip_group')->get(); 

#        return redirect('/TranskripKokurikulum/Senarai-Pengesahan-Program-Luar?k='.$k.'&s='.$Status) ;
         return redirect('/TranskripKokurikulum/Senarai-Pengesahan-Program-Luar?k='.$k.'&s=3') ;
       
        }else{          }
    
}
    
 
    
    
    
    
    
    
    
    
    
    
    
    
    
	
	
	
	
	
	
	
	//// 20/5/2025
	
    
    public function Senarai_Pengesahan_PendaftaranProgramOlehPelajar(Request $request)
    
    
    
    {
        $MM_nostaff      = $_SESSION['MM_nostaff'];//'0530';
        $kategori       = $request->get('k');
        $data           = array();
        $status_array[] = 1;    $status_array[] = 2;
         
        if ( $kategori != ''  &&  $kategori != null ){
            
            
            
              if ( $kategori == 7 || $kategori == 8 || $kategori == 9 || $kategori == 10){
                  
                  
                $data = DB::connection('conn_hep')->table('transkrip_aktiviti_info' )
                ->select('*',
                'transkrip_aktiviti_info.ID as ID' ,  
                'transkrip_aktiviti_info.Status as Status' )
                ->where(['transkrip_aktiviti_info.KategoriID'=>$kategori, 'Status'=>4, ] )
            //    ->whereIn('transkrip_aktiviti_info.Status',$status_array )
                ->orderBy('transkrip_aktiviti_info.ID', 'desc')->get();
             }
         
            
         
            
            
        }else {
        //$data = DB::connection('conn_hep')->table('transkrip_main_info')->select('*')->where('Kategori',$kategori )->orderBy('ID', 'desc')->get();
        $data= array();
        }
        
        
        
        $transkrip_listkok = DB::connection('conn_hep')->table('transkrip_listkok')->get();
        
        $transkrip_tema = DB::connection('conn_hep')->table('transkrip_tema')->get();
        
        $k      =   $request ->get('k');
        $transkrip_group = DB::connection('conn_hep')->table('transkrip_group') ->WhereIn('ID',[7,8]) ->get();
        return view('TranskripKokurikulum/A_Senarai_Pengesahan_PendaftaranProgramOlehPelajar',[
             'data' => $data,
             'transkrip_group'=>$transkrip_group,
             'k' => $k,
             'transkrip_listkok' => $transkrip_listkok, 
             'transkrip_tema' => $transkrip_tema,
             ]);
    }    
    
    
    
public function Admin_Mengesahkan__PendaftaranProgramOlehPelajar(Request $request){
    
	$Status= $request ->post('tindakan');
    
    $ID_Permohonan = $request->post('permohonan');
    
    if ($Status == 1){
        $TemaID = $request->post('tema'); 
        $KeteranganPermohonanPelajar='';
    }
    if ($Status == 2){
        $TemaID = '';
        $KeteranganPermohonanPelajar = $request->post('ktrpmhpljr');
    }
    
    if (  $Status == 2 || $Status == 1){
        
        $Identiti_Pelajar = $request->post('pelajar');
        $k = $request->post('k');
        $TemaID = $request->post('tema');
    
        /** Kena Populate
            
            // ini kena ambil satu2 $inputJawatan = $request->post('jawatan');
        **/
        
            $pilih_JenisGroup=0;
            if ($k == 1 ||$k == 2 ||$k == 3 ||$k == 5 ||$k == 6 ||
                $k == 14 ||$k == 15 ){  $pilih_JenisGroup=1;    }
            if ($k == 4 ){              $pilih_JenisGroup=2;    }
            if ($k == 13 ){             $pilih_JenisGroup=3;    }
            if ($k == 7 ){              $pilih_JenisGroup=4;    }
            if ($k == 8 ){              $pilih_JenisGroup=5;    }
            if ($k == 9 ||$k == 10 ){   $pilih_JenisGroup=6;    }
            if ($k == 11 ){   $pilih_JenisGroup=7;    }
            $MarkahMerit=0;
            
            
            $post_Peringkat = $request->post('peringkat');
                 
            $tr_data = DB::connection('conn_hep')->table('transkrip_aktiviti_info')
                ->where('ID', $ID_Permohonan)
                ->update([
                'Status' => $Status, 
                'DateUpdate'=>Date('Y-M-D H:i:s'),
                'TemaID'=> $TemaID,
                'KeteranganPermohonanPelajar' =>$KeteranganPermohonanPelajar,
                'TemaID' => $TemaID,
                
            ]);
                
            //KENA ADA FOREACH UNTUK UPDATE MAIN, SUB DAN MEMBER    
            
            $select_transkrip_main_committee = DB::connection('conn_hep')->table('transkrip_main_committee')->where('AktivitiInfoID',$ID_Permohonan)->get();
            $select_transkrip_sub_committee = DB::connection('conn_hep')->table('transkrip_sub_committee')->where('AktivitiInfoID',$ID_Permohonan)->get();
            $select_transkrip_member = DB::connection('conn_hep')->table('transkrip_member')->where('AktivitiInfoID',$ID_Permohonan)->get();
            
            foreach($select_transkrip_main_committee as $sel_table){
                //Penetapan data
                $select_transkrip_jawatan = DB::connection('conn_hep')->table('transkrip_jawatan')->where('JawatanID',$sel_table->JawatanID)->first();
                $data_JawatanGroup = $select_transkrip_jawatan->JawatanGroup;
                //Penetapan Markah Merit
                $transkrip_merit_program = DB::connection('conn_hep')->table('transkrip_merit_program') 
                //->where([   'JenisGroup'=>$pilih_JenisGroup, 'PeringkatID'=> $post_Peringkat,'JawatanGroup'=> $data_JawatanGroup  ]) 
                
                ->where([   'JenisID'=>$k, 'PeringkatID'=> $post_Peringkat,'JawatanID'=> $sel_table->JawatanID ])
                        
                        
                ->first(); 
                $MarkahMerit = $transkrip_merit_program->Markah;
                //Penerapan
                $update_transkrip_main_committee = DB::connection('conn_hep')->table('transkrip_main_committee')
                ->where('ID',$sel_table->ID)
                ->update(['Merit' => $MarkahMerit,]);
            }
            
            foreach($select_transkrip_sub_committee as $sel_table){
                //Penetapan data
                $select_transkrip_jawatan = DB::connection('conn_hep')->table('transkrip_jawatan')->where('JawatanID',$sel_table->JawatanID)->first();
                $data_JawatanGroup = $select_transkrip_jawatan->JawatanGroup;
                //Penetapan Markah Merit
                $transkrip_merit_program = DB::connection('conn_hep')->table('transkrip_merit_program') 
                //->where([   'JenisGroup'=>$pilih_JenisGroup, 'PeringkatID'=> $post_Peringkat,'JawatanGroup'=> $data_JawatanGroup  ]) 
                
                ->where([   'JenisID'=>$k, 'PeringkatID'=> $post_Peringkat,'JawatanID'=> $sel_table->JawatanID ])
                
                
                ->first(); 
                $MarkahMerit = $transkrip_merit_program->Markah;
                //Penerapan
                $update_transkrip_sub_committee = DB::connection('conn_hep')->table('transkrip_sub_committee')
                ->where('ID',$sel_table->ID)
                ->update(['Merit' => $MarkahMerit,]);
            }
            
            foreach($select_transkrip_member as $sel_table){
                //Penetapan data
                $select_transkrip_jawatan = DB::connection('conn_hep')->table('transkrip_jawatan')->where('JawatanID',$sel_table->JawatanID)->first();
                $data_JawatanGroup = $select_transkrip_jawatan->JawatanGroup;
                //Penetapan Markah Merit
                $transkrip_merit_program = DB::connection('conn_hep')->table('transkrip_merit_program') 
                //->where([   'JenisGroup'=>$pilih_JenisGroup, 'PeringkatID'=> $post_Peringkat,'JawatanGroup'=> $data_JawatanGroup  ]) 
                ->where([   'JenisID'=>$k, 'PeringkatID'=> $post_Peringkat,'JawatanID'=> $sel_table->JawatanID ])
                ->first(); 
                $MarkahMerit = $transkrip_merit_program->Markah;
                //Penerapan
                $update_transkrip_member = DB::connection('conn_hep')->table('transkrip_member')
                ->where('ID',$sel_table->ID)
                ->update(['Merit' => $MarkahMerit,]);
            }
            
            
            
        
        
        $transkrip_group = DB::connection('conn_hep')->table('transkrip_group')->get(); 
        
            return redirect('/TranskripKokurikulum/Pengesahan-Pendaftaran-Program-Oleh-Pelajar?k='.$Status) ;
        
        }
    
}








    
    
    
	
	
    
















/////////27052025


	
    
  

    public function Senarai_Pengesahan_Lain_Lain(Request $request){
        
        $MM_nostaff = $_SESSION['MM_nostaff'];//'0530';
          $KategoriID = $request->get('k');
          $Status = $request->get('s');
       
        
        if ( $KategoriID != ''  &&  $KategoriID != null ){
        
        if ($KategoriID ==12)
        {
            
            
            $data = DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar')
                    ->select('*','transkrip_aktiviti_luar_pelajar.ID AS ID_Member', 'transkrip_aktiviti_luar_pelajar.Status as ID_Status',)
            
            ->join('stud_students','stud_students.MatricNo','=','transkrip_aktiviti_luar_pelajar.MatricNo')
            
            ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
            ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
            ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
            
            ->where(['KategoriID'=>$KategoriID,'Status'=>$Status]) 
            
            ->orderBy('transkrip_aktiviti_luar_pelajar.ID', 'desc')->get();
        
            
            
        }
        
        
        }else 
        { $data=Array();}
        
        
        
        
        $array_keahlian_semasa = Array();
        $_semak_matrik_pelajar = '';
        $num=0;
        
        $senarai_keahlian_semasa = Array();
        foreach($array_keahlian_semasa as $aks){
            $senarai_keahlian_semasa[] = 
            Array(
                'MatricNo' => $aks['MatricNo'], 
                'Bilangan' => $aks['Bilangan'] ,
                'KategoriID' => $aks['KategoriID'] 
                );
        }
     
        $transkrip_group = DB::connection('conn_hep')->table('transkrip_group')  ->get();
        
         $transkrip_peringkat = DB::connection('conn_hep')->table('transkrip_peringkat')->get();
        $transkrip_tema = DB::connection('conn_hep')->Table('transkrip_tema')->get();
        $transkrip_tahap = DB::connection('conn_hep')->Table('transkrip_tahap')->get();
        $transkrip_jawatan = DB::connection('conn_hep')->table('transkrip_jawatan')->get();

         return view('TranskripKokurikulum/A_Senarai_Pengesahan_Lain_Lain_OlehPelajar',[
             //         return view('TranskripKokurikulum/A_Senarai_Pengesahan_Keahlian',[
             'transkrip_group' => $transkrip_group,
             'senarai_keahlian_semasa' =>$senarai_keahlian_semasa,
             'k'=>$KategoriID,
             's'=>$Status,
             'data' => $data, 
             'transkrip_tema' => $transkrip_tema, 
             'transkrip_peringkat'=>$transkrip_peringkat,
             'transkrip_tahap' => $transkrip_tahap, 
             'transkrip_jawatan'=>$transkrip_jawatan,
              ]);
        
    }  
    



    
public function Admin_Mengesahkan__Senarai_Pengesahan_Lain_Lain(Request $request){
    
//    echo "www";die();
    
	$Status= $request ->get('tindakan');
	$tahap= $request ->get('tahap');
    $Status=       $Status[0];  
    if ( $Status == 1 || $Status == 2){
    
    $Identiti_Pelajar = $request->post('pelajar');
    $k = $request->get('k');

    if($Status==1){
    $tema = $request->post('tema');
        
    }else {$tema[]='';}
    
    if($Status==2){
    $KeteranganPengesahan = $request->post('KeteranganPengesahan');
    
    }else {$KeteranganPengesahan[]='';}
   
    $inputJawatan= $request->post('jawatan');
    $pilih_JenisGroup=0;
    if ($k == 12 ){   $pilih_JenisGroup=7;    }
    $MarkahMerit=0;
    $transkrip_merit_keahlian = DB::connection('conn_hep')->table('transkrip_merit_keahlian') 
    ->where([   'JenisGroup'=>$pilih_JenisGroup, 'JawatanGroup'=>$inputJawatan   ]) 
    ->where([   'JenisID'=>$k, 'JawatanID'=>$inputJawatan   ]) 
    ->first(); 
    $MarkahMerit = $transkrip_merit_keahlian->Markah; //$transkrip_merit_keahlian->Merit;;
    
    $tr=0;
    foreach($Identiti_Pelajar as $IDP){
    
        $tr_data = DB::connection('conn_hep')->table('transkrip_aktiviti_luar_pelajar')
            ->where('ID', $IDP)
            ->update(['Status' => $Status, 'DateUpdate'=>Date('Y-M-D H:i:s'), 
            'TemaID'=> '',//$tema[$tr],
            'KeteranganPengesahan' => $KeteranganPengesahan[$tr],
            'TahapID'=>$tahap,
            'Merit'=>$MarkahMerit,
            
            
            ]);
    $tr++;
    }
    
    
 
         return redirect('/TranskripKokurikulum/Senarai-Pengesahan-Lain-Lain?k='.$k.'&s=3') ;
       
        }else{          }
    
}

















    public function Senarai_Pengesahan_Keahlian_Luar(Request $request){
        
        $MM_nostaf = $_SESSION['MM_nostaff'];//'0530';
          $KategoriID = $request->get('k');
          $Status = $request->get('s');
       
       $data=Array();
        if ( $KategoriID != ''  &&  $KategoriID != null ){
        
        if ($KategoriID ==16)
        
        {
            
            
            $data = DB::connection('conn_hep')->table('transkrip_keahlian_luar_pelajar')
                    ->select('*','transkrip_keahlian_luar_pelajar.ID AS ID_Member', 'transkrip_keahlian_luar_pelajar.Status as ID_Status',)
            
            ->join('stud_students','stud_students.MatricNo','=','transkrip_keahlian_luar_pelajar.MatricNo')
            
            ->join('stud_studentdetails','stud_studentdetails.StudentID','=','stud_students.StudentID')
            ->join('conf_structure', 'conf_structure.StructureID', '=','stud_students.StructID')
            ->join('conf_program','conf_program.ProgID','=','conf_structure.ProgID')
            
            ->where(['KategoriID'=>$KategoriID,'Status'=>$Status]) 
            
            ->orderBy('transkrip_keahlian_luar_pelajar.ID', 'desc')->get();
        
            
            
        }
        
        
        }else 
        { }
        
        
        
        
        $array_keahlian_semasa = Array();
        $_semak_matrik_pelajar = '';
        $num=0;
        
        $senarai_keahlian_semasa = Array();
        foreach($array_keahlian_semasa as $aks){
            $senarai_keahlian_semasa[] = 
            Array(
                'MatricNo' => $aks['MatricNo'], 
                'Bilangan' => $aks['Bilangan'] ,
                'KategoriID' => $aks['KategoriID'] 
                );
        }
     
        $transkrip_group = DB::connection('conn_hep')->table('transkrip_group')  ->get();
        
         $transkrip_peringkat = DB::connection('conn_hep')->table('transkrip_peringkat')->get();
        $transkrip_tema = DB::connection('conn_hep')->Table('transkrip_tema')->get();
        $transkrip_tahap = DB::connection('conn_hep')->Table('transkrip_tahap')->get();
        $transkrip_jawatan = DB::connection('conn_hep')->table('transkrip_jawatan')->get();

         return view('TranskripKokurikulum/A_Senarai_Pengesahan_Keahlian_Luar_OlehPelajar',[
             'transkrip_group' => $transkrip_group,
             'senarai_keahlian_semasa' =>$senarai_keahlian_semasa,
             'k'=>$KategoriID,
             's'=>$Status,
             'data' => $data, 
             'transkrip_tema' => $transkrip_tema, 
             'transkrip_peringkat'=>$transkrip_peringkat,
             'transkrip_tahap' => $transkrip_tahap, 
             'transkrip_jawatan'=>$transkrip_jawatan,
              ]);
        
    }  
    




    
public function Admin_Mengesahkan__Senarai_Pengesahan_Keahlian_Luar(Request $request){
    
//    echo "www";die();
    
	$Status= $request ->get('tindakan');
	$tahap= $request ->get('tahap');
    $Status=       $Status[0];  
    if ( $Status == 1 || $Status == 2){
    
    $Identiti_Pelajar = $request->post('pelajar');
    $k = $request->get('k');

    if($Status==1){
    $tema = $request->post('tema');
        
    }else {$tema[]='';}
    
    if($Status==2){
    $KeteranganPengesahan = $request->post('KeteranganPengesahan');
    
    }else {$KeteranganPengesahan[]='';}
   
    $inputJawatan= $request->post('U_jawatan');// post('jawatan');
    $pilih_JenisGroup=0;
    if ($k == 12 ){   $pilih_JenisGroup=7;    }
    $MarkahMerit=0;
    $transkrip_merit_keahlian = DB::connection('conn_hep')->table('transkrip_merit_keahlian') 
    // ->where([   'JenisGroup'=>$pilih_JenisGroup, 'JawatanGroup'=>$inputJawatan   ]) 
    ->where([   'JenisID'=>$k, 'JawatanID'=>$inputJawatan   ]) 
    ->first(); 
    $MarkahMerit = $transkrip_merit_keahlian->Markah; 
    
    $tr=0;
    foreach($Identiti_Pelajar as $IDP){
    
        $tr_data = DB::connection('conn_hep')->table('transkrip_keahlian_luar_pelajar')
            ->where('ID', $IDP)
            ->update([ 
                'Status'    =>  $Status, 
                'DateUpdate'=>  Date('Y-M-D H:i:s'), 
                'TemaID'    =>  '',//$tema[$tr],
                'KeteranganPengesahan' =>   $KeteranganPengesahan[$tr],
                'TahapID'   =>  $tahap,
                'Merit'     =>  $MarkahMerit,
                'JawatanID' => $inputJawatan,
            ]);
    $tr++;
    }
    
    
 
         return redirect('/TranskripKokurikulum/Senarai-Pengesahan-Keahlian-Luar?k='.$k.'&s=3') ;
       
        }else{          }
    
}


	
	
    










}