public function UpdateSignup(Request $request)
{
$user = \Auth::user();
$id = $user->id;
$team = team_contents::where('studentID', '=', $user->id)->get(array('teamID'));
$c = array();
foreach ($team as $t) {
$a = team::where('teamID', '=', $t->teamID)->first(array('competition'));
array_push($c, $a->competition);
}
$cc = student_competition::where('studentID', '=', $user->id)->get(array('compID'));
foreach ($cc as $b) {
array_push($c, $b->compID);
}
$competition = competition::whereNotIn('compID', $c)->get();
foreach ($competition as $a) {
$numberwang = $request->get($a->compID);
if ($numberwang == "on") {
student_competition::create(['studentID' => $id, 'compID' => $a->compID]);
}
}
return redirect('home');
}
public function run()
{
DB::table('student_competition')->delete();
student_competition::create(['studentID' => '1', 'compID' => '1']);
student_competition::create(['studentID' => '2', 'compID' => '1']);
student_competition::create(['studentID' => '3', 'compID' => '1']);
student_competition::create(['studentID' => '4', 'compID' => '1']);
student_competition::create(['studentID' => '5', 'compID' => '1']);
student_competition::create(['studentID' => '6', 'compID' => '1']);
student_competition::create(['studentID' => '7', 'compID' => '1']);
student_competition::create(['studentID' => '8', 'compID' => '1']);
student_competition::create(['studentID' => '9', 'compID' => '1']);
student_competition::create(['studentID' => '10', 'compID' => '1']);
student_competition::create(['studentID' => '11', 'compID' => '1']);
student_competition::create(['studentID' => '12', 'compID' => '1']);
student_competition::create(['studentID' => '13', 'compID' => '1']);
student_competition::create(['studentID' => '14', 'compID' => '1']);
student_competition::create(['studentID' => '15', 'compID' => '1']);
student_competition::create(['studentID' => '1', 'compID' => '2']);
student_competition::create(['studentID' => '2', 'compID' => '2']);
student_competition::create(['studentID' => '3', 'compID' => '2']);
student_competition::create(['studentID' => '4', 'compID' => '2']);
student_competition::create(['studentID' => '5', 'compID' => '2']);
student_competition::create(['studentID' => '16', 'compID' => '2']);
student_competition::create(['studentID' => '17', 'compID' => '2']);
student_competition::create(['studentID' => '18', 'compID' => '2']);
student_competition::create(['studentID' => '19', 'compID' => '2']);
student_competition::create(['studentID' => '20', 'compID' => '2']);
student_competition::create(['studentID' => '21', 'compID' => '2']);
student_competition::create(['studentID' => '22', 'compID' => '2']);
student_competition::create(['studentID' => '23', 'compID' => '2']);
student_competition::create(['studentID' => '24', 'compID' => '2']);
student_competition::create(['studentID' => '25', 'compID' => '2']);
}
