id;
$users['users'] = DB::table('users')->select('id', 'name')->get();
// print_r($users['users']);
// echo "
";
$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 "
";
// afiseaza id-ul studentilor 445:6065
// Cred ca trebuie folosita si functia in_array
array_push($dateStudenti, $studentId);
array_push($userIdStudent, $studentId->idStudent);
}
}
// echo "
";
// print_r($dateStudenti);
// echo "
";
$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 "
";
$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');
}
}
// -->