/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
RelationDeRo::create(['degree_id' => '1', 'challenge_id' => '1', 'robot_id' => '1']);
RelationDeRo::create(['degree_id' => '1', 'challenge_id' => '2', 'robot_id' => '2']);
RelationDeRo::create(['degree_id' => '2', 'challenge_id' => '3', 'robot_id' => '1']);
RelationDeRo::create(['degree_id' => '2', 'challenge_id' => '4', 'robot_id' => '2']);
RelationDeRo::create(['degree_id' => '3', 'challenge_id' => '5', 'robot_id' => '3']);
RelationDeRo::create(['degree_id' => '4', 'challenge_id' => '5', 'robot_id' => '3']);
RelationDeRo::create(['degree_id' => '3', 'challenge_id' => '6', 'robot_id' => '4']);
RelationDeRo::create(['degree_id' => '4', 'challenge_id' => '6', 'robot_id' => '4']);
RelationDeRo::create(['degree_id' => '5', 'challenge_id' => '7', 'robot_id' => '5']);
RelationDeRo::create(['degree_id' => '6', 'challenge_id' => '8', 'robot_id' => '5']);
}
public function relationChalle(Request $request)
{
$degree = $request->degree_id;
$data = RelationDeRo::join('rb_challenges', 'rb_challenges.id', '=', 'relation_de_ro.challenge_id')->select('relation_de_ro.*', 'rb_challenges.*')->where('relation_de_ro.degree_id', $degree)->lists('rb_challenges.name', 'rb_challenges.id');
return $data;
}
