public function finalizeProject($id)
{
$user = Auth::user();
$name = $user->name;
$user_id = $user->id;
$project = Project::where("id", $id)->get();
$project_id = $project[0]->id;
$project_name = $project[0]->name;
$finalizedProject = new FinalizedProjects();
$finalizedProject->user_id = $user_id;
$finalizedProject->user = $name;
$finalizedProject->project_id = $project_id;
$finalizedProject->project_name = $project_name;
$finalizedProject->save();
$finalizedProject = FinalizedProjects::where('user', $name)->get();
//Get finalized project
$finalized_pn = "";
if (sizeof($finalizedProject) != 0) {
$finalized_pn = $finalizedProject[0]->project_name;
}
$reservation = Reservations::where('user', $name)->get();
//Get reserved projects from the verified user
$reserved = array();
//Create array to store reserved project ids
foreach ($reservation as $res) {
array_push($reserved, $res->project_id);
//Save each reserved project id to the array
}
$projectR = Project::whereNotIn('id', $reserved)->get();
//Get projects which are not reserved from the Project table
return view('pages.ViewProjectsStudent', compact('projectR', 'reservation', 'finalized_pn'));
//Show finalized project
}
public function checkDuplicate(Request $request)
{
$project = $request->id ? Project::whereNotIn('id', [$request->id])->where('name', $request->name)->where('department_id', $request->department_id)->first() : Project::where('name', $request->name)->where('department_id', $request->department_id)->first();
return response()->json($project ? true : false);
}
