/** * 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; }