public function UpdateInfoPage(Request $request)
{
$user = \Auth::user();
$id = $user->id;
$email = $request->get('email');
$phone = $request->get('phone');
$c261 = $request->get('261');
$c262 = $request->get('262');
$c306 = $request->get('306');
$c406 = $request->get('406');
$python = $request->get('python_slide');
$java = $request->get('java_slide');
$c = $request->get('c_slide');
$pref = $request->get('team-style');
$std = User::find($id);
$std->email = $email;
$std->phoneNo = $phone;
$std->save();
$preferences = student_preferences::find($id);
$preferences->python = $python;
$preferences->java = $java;
$preferences->c = $c;
$preferences->teamStyle = $pref;
$preferences->save();
$classes = \DB::select(\DB::raw('(SELECT * FROM student_classes WHERE id = ' . $id . ')'));
if (count($classes) > 0) {
foreach ($classes as $c) {
$class = student_classes::find($c->id);
if ($class != null) {
$class->delete();
}
}
}
if ($c261 == 'on') {
student_classes::create(['id' => $id, 'classID' => 1]);
}
if ($c262 == 'on') {
student_classes::create(['id' => $id, 'classID' => 2]);
}
if ($c306 == 'on') {
student_classes::create(['id' => $id, 'classID' => 3]);
}
if ($c406 == 'on') {
student_classes::create(['id' => $id, 'classID' => 4]);
}
return redirect('home');
}
public function studentInfo()
{
$user = \Auth::user();
$classes = student_classes::where('id', '=', $user->id)->get(array('classID'));
$pref = student_preferences::where('id', '=', $user->id)->get();
return view('student\\studentInfo', compact('user', 'classes', 'pref'));
}
public function run()
{
DB::table('student_classes')->delete();
student_classes::create(['id' => '1', 'classID' => '1']);
student_classes::create(['id' => '1', 'classID' => '2']);
student_classes::create(['id' => '1', 'classID' => '3']);
student_classes::create(['id' => '1', 'classID' => '4']);
student_classes::create(['id' => '2', 'classID' => '1']);
student_classes::create(['id' => '2', 'classID' => '2']);
student_classes::create(['id' => '2', 'classID' => '3']);
student_classes::create(['id' => '3', 'classID' => '1']);
student_classes::create(['id' => '3', 'classID' => '2']);
student_classes::create(['id' => '4', 'classID' => '1']);
student_classes::create(['id' => '5', 'classID' => '1']);
student_classes::create(['id' => '5', 'classID' => '2']);
student_classes::create(['id' => '6', 'classID' => '1']);
student_classes::create(['id' => '6', 'classID' => '2']);
student_classes::create(['id' => '6', 'classID' => '3']);
student_classes::create(['id' => '7', 'classID' => '1']);
student_classes::create(['id' => '7', 'classID' => '2']);
student_classes::create(['id' => '7', 'classID' => '3']);
student_classes::create(['id' => '7', 'classID' => '4']);
student_classes::create(['id' => '8', 'classID' => '2']);
student_classes::create(['id' => '8', 'classID' => '3']);
student_classes::create(['id' => '8', 'classID' => '4']);
student_classes::create(['id' => '9', 'classID' => '2']);
student_classes::create(['id' => '9', 'classID' => '3']);
student_classes::create(['id' => '10', 'classID' => '2']);
student_classes::create(['id' => '11', 'classID' => '2']);
student_classes::create(['id' => '11', 'classID' => '3']);
student_classes::create(['id' => '12', 'classID' => '2']);
student_classes::create(['id' => '12', 'classID' => '3']);
student_classes::create(['id' => '12', 'classID' => '4']);
student_classes::create(['id' => '13', 'classID' => '3']);
student_classes::create(['id' => '13', 'classID' => '4']);
student_classes::create(['id' => '14', 'classID' => '3']);
student_classes::create(['id' => '15', 'classID' => '3']);
student_classes::create(['id' => '15', 'classID' => '4']);
student_classes::create(['id' => '16', 'classID' => '4']);
student_classes::create(['id' => '17', 'classID' => '3']);
student_classes::create(['id' => '17', 'classID' => '4']);
student_classes::create(['id' => '18', 'classID' => '2']);
student_classes::create(['id' => '18', 'classID' => '3']);
student_classes::create(['id' => '18', 'classID' => '4']);
student_classes::create(['id' => '19', 'classID' => '1']);
student_classes::create(['id' => '19', 'classID' => '2']);
student_classes::create(['id' => '19', 'classID' => '3']);
student_classes::create(['id' => '19', 'classID' => '4']);
student_classes::create(['id' => '20', 'classID' => '1']);
student_classes::create(['id' => '20', 'classID' => '2']);
student_classes::create(['id' => '20', 'classID' => '3']);
student_classes::create(['id' => '20', 'classID' => '4']);
student_classes::create(['id' => '21', 'classID' => '1']);
student_classes::create(['id' => '21', 'classID' => '2']);
student_classes::create(['id' => '21', 'classID' => '3']);
student_classes::create(['id' => '22', 'classID' => '1']);
student_classes::create(['id' => '22', 'classID' => '2']);
student_classes::create(['id' => '23', 'classID' => '1']);
student_classes::create(['id' => '24', 'classID' => '1']);
student_classes::create(['id' => '24', 'classID' => '2']);
student_classes::create(['id' => '25', 'classID' => '1']);
student_classes::create(['id' => '25', 'classID' => '2']);
student_classes::create(['id' => '25', 'classID' => '3']);
student_classes::create(['id' => '26', 'classID' => '1']);
student_classes::create(['id' => '26', 'classID' => '2']);
student_classes::create(['id' => '26', 'classID' => '3']);
student_classes::create(['id' => '26', 'classID' => '4']);
student_classes::create(['id' => '27', 'classID' => '2']);
student_classes::create(['id' => '27', 'classID' => '3']);
student_classes::create(['id' => '27', 'classID' => '4']);
student_classes::create(['id' => '28', 'classID' => '2']);
student_classes::create(['id' => '28', 'classID' => '3']);
student_classes::create(['id' => '29', 'classID' => '2']);
student_classes::create(['id' => '30', 'classID' => '2']);
student_classes::create(['id' => '30', 'classID' => '3']);
student_classes::create(['id' => '31', 'classID' => '2']);
student_classes::create(['id' => '31', 'classID' => '3']);
student_classes::create(['id' => '31', 'classID' => '4']);
student_classes::create(['id' => '32', 'classID' => '3']);
student_classes::create(['id' => '32', 'classID' => '4']);
student_classes::create(['id' => '33', 'classID' => '3']);
student_classes::create(['id' => '34', 'classID' => '3']);
student_classes::create(['id' => '34', 'classID' => '4']);
student_classes::create(['id' => '35', 'classID' => '4']);
student_classes::create(['id' => '36', 'classID' => '3']);
student_classes::create(['id' => '36', 'classID' => '4']);
student_classes::create(['id' => '37', 'classID' => '2']);
student_classes::create(['id' => '37', 'classID' => '3']);
student_classes::create(['id' => '37', 'classID' => '4']);
student_classes::create(['id' => '38', 'classID' => '1']);
student_classes::create(['id' => '38', 'classID' => '2']);
student_classes::create(['id' => '38', 'classID' => '3']);
student_classes::create(['id' => '38', 'classID' => '4']);
}
