<?php
namespace App\Http\Controllers;
use Auth;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;
use App\Http\Controllers\User;
use App\MongoStudents;

class secretar extends Controller
{
    public function home(){

        // $userId = Auth::user()->id;

        $users['users'] = DB::table('users')->select('id', 'name')->get();
        // print_r($users['users']);
        // echo "<br>";

        $dateStudenti = array();
        $userIdStudent = array();

        foreach($users['users'] as $user){

        // print_r($user->id); - afiseaza id-ul userilor 1:1138

        $studentsId['students'] = DB::table('Student2User')->where([
            ['idStudent',$user->id],
            ['idUser', '<>', '', 'and'],
            ])->get();

           foreach($studentsId['students'] as $studentId)
           {
              // print($studentId->idUser);
              // print($studentId->idStudent);
              // echo "<hr>";
              // afiseaza id-ul studentilor 445:6065
              // Cred ca trebuie folosita si functia in_array

              array_push($dateStudenti, $studentId);
              array_push($userIdStudent, $studentId->idStudent);
            }
        }

        // echo "<hr>";
        // print_r($dateStudenti);


        // echo "<br>";
        $nrStudenti = count($dateStudenti);
        // print_r($nrStudenti);

        // 800 801 802
        // $studentId->idStudent

        // select from user name where id = studentId->idStudent[$i]

        // print_r($userIdStudent);

        if($nrStudenti > 0)
        {
            // foreach($idStudenti as $idStudent)
            for($i=0; $i<$nrStudenti; $i++)
            {

                // print($dateStudenti[$i]->idUser);
                $studentName = DB::table('users')->select('name')->where('id', $userIdStudent[$i])->get();
                $MongoStudents = new MongoStudents();
                $sstud = (int)$dateStudenti[$i]->idUser;
                $mongo['student'] = MongoStudents::where('_id', $sstud)->get();
                $facAdmis = $mongo['student'][0]->admitereCandidat['facAdmis'];

                $domeniuAdmis = $mongo['student'][0]->admitereCandidat['domeniuAdmis'];
                $domeniuAdmis = explode('-',$domeniuAdmis);
                $domeniu = $domeniuAdmis[0];
                $finantare = $domeniuAdmis[1];

             //    print_r($userIdStudent[$i]);

             //    print_r($studentName);
             //    print_r($facAdmis);
             //    print_r($mongo['student'][0]->_id);
                // print_r($domeniu);
                // print_r($finantare);

                // print "<hr>";

                $arrData[$i] = array(
                         'id'=>$mongo['student'][0]->_id,
                         'nume'=> $studentName[0]->name,
                         'facAdmis'=> $mongo['student'][0]->admitereCandidat['facAdmis'],
                         'domeniu'=> $domeniu,
                         'finantare'=> $finantare,
                 );

            }
            $data=array(
                 'nrStudenti'=>$nrStudenti,
                 'informatii'=>$arrData
            );
        return view('secretari/acasaSecretar')->with('data', $data);
        } else{
            $data=array(
                'nrStudenti'=>0
            );
        return view('secretari/acasaSecretar')->with('data', $data);
        }

        // print_r($data['informatii'][0]['nume']);

}


// $mongo = new MongoStudents();
//      $userId = Auth::user()->id;
//         $idStudentAll = DB::table('Student2User')->select('idStudent')->where('idUser', $userId)->get();
//         $rol = DB::table('AsignareRol')->select('idRol')->where('idUser', $userId)->get();
//          $idStudent = $idStudentAll[0]->idStudent;
//      $mongo['student'] = MongoStudents::where('_id', $idStudent)->get();
//      $facAdmis = $mongo['student'][0]->admitereCandidat['facAdmis'];
//      $domeniuAdmis = $mongo['student'][0]->admitereCandidat['domeniuAdmis'];

    public function adeverinte(){
        return view('secretari/adeverinte');
    }
}

// <!--  <?php
// namespace App\Http\Controllers;
// use Auth;
// use Illuminate\Http\Request;
// use Illuminate\Support\Facades\DB;
// use App\Http\Controllers\User;
// use App\MongoStudents;
// use Illuminate\Database\Eloquent\Model;
// use Jenssegers\Mongodb\Eloquent\Model as Eloquent;
// use Illuminate\Support\Facades\Route;
// class secretar extends Controller
// {
   // public function home(){
   // 	$mongo = new MongoStudents();
   //   //  $userId = Auth::user()->id;

   //     $usersId['users'] = DB::table('users')->select('id','name')->where('id',800)->get();
   //     // print_r($usersId['users'][0]->id);
   //     // echo "<br>";
   //     $userIdd = $usersId['users'][0]->id;





//        $ids = DB::table('Student2User')->pluck('idUser');

//        foreach ($ids as $idUser) {
//  		   echo "<br>".$idUser;
// }

       // $studentsId['students']= DB::table('Student2User')->select('idUser')->where('idStudent',$userIdd)->get();
       // $stud=(int)$studentsId['students'][0]->idUser;
       // print_r($stud);

       // $mongo['student'] = MongoStudents::where('_id', '=', $stud)->get();
       // print_r($mongo['student'][0]->admitereCandidat['facAdmis']);
       // // $facAdmis = $mongo['student'][0]->admitereCandidat['facAdmis'];
       // $domeniuAdmis =  $mongo['student'][0]->admitereCandidat['domeniuAdmis'];
       // $domeniuAdmis = explode('-',$domeniuAdmis);
       // $domeniu = $domeniuAdmis[0];
       // $finantare = $domeniuAdmis[1];

       // print_r($finantare);
      // $justUsersId['users'] = $usersId['users']->

       // $idStudenti = array();
       // foreach($usersId['users'] as $user){
       //     // print_r($user->id);
       //     echo "<br>";
       //     $studentsId['students'] = DB::table('Student2User')->select('idUser')->where('idStudent','=',$user->id)->get();
       //     // Cred ca trebuie folosita si functia in_array
       //     array_push($idStudenti, $studentsId['students']);
       // }
       // // $justUsersId['users'] = $usersId['users']->
       //     // $studentsId['students'] = DB::table('Student2User')->select('idUser')->where('idStudent','=',$userrId['users'][0]->id)->get();
       //     // print_r($studentsId['students']);
       // // In coloana asta avem toti studentii din anu 1
       // // $idStudentAll = DB::table('Student2User')->select('idStudent')->where('idUser', $userId)->get();
       // echo "<hr>";
      // $nrStudenti = count($idStudenti);
       // print_r($nrStudenti);
       // // $mongo = new MongoStudents();
    //    $mongo['student'] = MongoStudents::where('_id', $studentsId['students'])->get();
    //    $facAdmis = $mongo['student'][0]->admitereCandidat['facAdmis'];
    //    $domeniuAdmis = $mongo['student'][0]->admitereCandidat['domeniuAdmis'];
    //    $domeniuAdmis = explode('-',$domeniuAdmis);
    //    $domeniu = $domeniuAdmis[0];
    //    $finantare = $domeniuAdmis[1];
       // $nrStudenti= count($students['datePersonale']);
   //     if($nrStudenti > 0){
   //      for( $i=0; $i< $nrStudenti; $i++)
   //      {
   //          $idStudent = ($i+1);
   //          $numeStudent = DB::table('datePersonale') -> where('idStudent',$idArticol)->get();
   //     }
   // }
   // return view('secretari/acasaSecretar')->with('nr', $nrStudenti);
//    public function adeverinte(){
//        return view('secretari/adeverinte');
//    }
// } --> -->