public function index(Request $request) { if ($request->input('name_en')) { $developer = Developer::where('name_en', $request->input('name_en'))->first(); return response()->json($developer); } // $developer = Developer::orderBy('name_en')->paginate(1000); // return response()->json($developer); $developer = Developer::orderBy('name_en')->get(); return response()->json(['data' => $developer]); }
public function add(NewMemberRequest $r, $project_id) { try { $Developer_id = Developer::where("email", $r->input("email"))->get()->first()->id; if ($Developer_id != null) { Member::create(["Developer_id" => $Developer_id, "project_id" => $project_id]); } } catch (\Illuminate\Database\QueryException $e) { } $members = DB::table('member')->where('project_id', $project_id)->join('Developer', 'member.Developer_id', '=', 'Developer.id')->get(); return view("member.show")->with('members', $members)->with('project_id', $project_id); }
<?php /* |-------------------------------------------------------------------------- | Application Routes |-------------------------------------------------------------------------- | | Here is where you can register all of the routes for an application. | It's a breeze. Simply tell Laravel the URIs it should respond to | and give it the controller to call when that URI is requested. | */ use Illuminate\Support\Facades\Route; use Laravel\Socialite\Facades\Socialite; use App\Developer; Route::get('/', function () { $developers = Developer::all(); return view("index", ["developers" => $developers]); }); Route::get("redirect/github", function () { return Socialite::with("github")->redirect(); }); Route::get("connect/github", function () { $data = Socialite::with("github")->user(); $developer = Developer::where("github_id", $data->id)->first(); if (!$developer) { Developer::create(["github_id" => $data->id, "github_nickname" => $data->nickname, "github_name" => $data->name, "github_email" => $data->email, "github_avatar" => $data->avatar]); } return redirect("/"); });