public function index() { $user_id = $this->user->id; $ownership = Projects::where('project_owner', $user_id)->where('status', '1')->get()->toArray(); $membership = DB::select("SELECT * FROM projects WHERE find_in_set({$user_id}, project_members) <> 0 AND status = 1"); return view('dashboard.index', compact('ownership', 'membership')); }
/** * Display the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function show($id) { $scenario = Scenarios::select('scenarios.*', 'context_scenario_ideal_way.context_name', 'context_scenario_ideal_way.full_name')->leftJoin('context_scenario_ideal_way', 'context_scenario_ideal_way.id', '=', 'scenarios.context_id')->where('scenarios.id', $id)->first(); $project = Projects::find($scenario->project_id); $requirements = Requirements::leftJoin('users', 'users.id', '=', 'requirements.user_id')->select('requirements.*', 'users.name as created_by')->where('scenario_id', $id)->latest()->get(); $breadcrumbs = array('Projects' => '/projects', 'Scenarios' => "/projects/{$scenario->project_id}"); return view('scenarios.details', compact('scenario', 'project', 'requirements', 'breadcrumbs')); }
/** * Display a listing of the resource. * * @return Response */ public function index() { $empactive = "class=active"; $title = 'Employees Page'; $cnt = 1; $employee = $this->employee->get(); $projects = Projects::get(); return view('employee.index', compact('title', 'employee', 'cnt', 'projects', 'empactive')); }
public function portfolio() { $portfolio = Projects::all(); $image_array = []; foreach ($portfolio as $images) { $image_array["{$images->id}"] = explode(",", $images->imgpath); } //dd($image_array); return view('main.portfolio', ['model' => $portfolio, 'images' => $image_array]); }
public function project(Request $request) { sleep(10); $project = Projects::where('projectsId', '=', $request->projectsId)->first(); array_add($project, 'slug', Handler::createSlug($project->title, '-')); if (count($project->movie) > 0) { foreach ($project->movie as $movie) { array_add($movie, 'embed', ProjectsMovie::embedVideo($movie->url)); } } $project->tags = str_replace(',', ', ', $project->tags); return view('website.project')->with(compact('project')); }
public function index(Request $request) { if ($request->getRequestUri() != '/') { $buttonClick = $request->getUri(); } //WEBSITE SETTINGS $websiteSettings = Handler::readFile("websiteSettings.json"); $projects = Projects::orderBy('sortorder', 'asc')->get(); $lastProject = 0; foreach ($projects as $key => $project) { array_add($project, 'bootstrapColumn', Projects::bootstrapColumns($key)); array_add($project, 'imagePrefixName', Projects::imagePrefixName($key)); array_add($project, 'slug', Handler::createSlug($project->title, '-')); $lastProject = $project->sortorder; } return view('website.index')->with(compact('websiteSettings', 'projects', 'lastProject', 'buttonClick')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { Projects::where('id', $id)->delete(); return back()->withSuccess('Project deleted successfully!'); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($project_id, $id) { $task = Tasks::findOrFail($id); $taskUsers = DB::table('taskUser')->join('users', 'users.id', '=', 'taskUser.user_id')->where('task_id', '=', $id)->get(); $projectInfo = Projects::findOrFail($project_id); $teams = DB::table('teams')->get(); $usersTask = DB::table('users')->get(); return view('admin.task.edit', ['projectInfo' => $projectInfo, 'teams' => $teams, 'usersTask' => $usersTask, 'task' => $task, 'taskUsers' => $taskUsers]); }
public function store() { if (Request::ajax()) { $inputData = Request::get('form#createProject'); parse_str($inputData, $formFields); $projectData = array('code' => $formFields['projectCode'], 'name' => $formFields['projectName'], 'version' => $formFields['projectVersion'], 'startDate' => $formFields['projectStartDate'], 'endDate' => $formFields['projectEndDate']); $rules = array('code' => 'required|min:3|alpha_num', 'name' => 'required|min:3', 'version' => 'required|min:1', 'startDate' => 'required|date', 'endDate' => 'required|date'); $validator = Validator::make($projectData, $rules); if ($validator->fails()) { return Response::json(array('fail' => true, 'errors' => withErrors($validator))); } else { Projects::create($projectData); $response = array('status' => 'success', 'msg' => 'Setting created successfully'); return Response::json($response); } } }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $data = Projects::findOrFail($id); $data->delete(); return redirect('project')->with('status', 'Delete Complete'); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $project = Projects::findOrFail($id); $projectTask = Projects::findOrFail($id)->taskProject()->count(); if ($projectTask > 0) { return redirect('admin/project')->withErrors("Sorry. You can't DELETE this project. You must DELETE all task of project"); } else { File::delete(base_path() . '/public/' . $project->projectCharter); $project->delete(); return redirect('admin/project')->withErrors("DELETED Project Done"); } }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $project = Projects::findOrFail($id); if ($project->project_owner != $this->user['id']) { Session::flash('flash_message_warning', 'Sorry, you do not have enough privilege to make this change!'); return redirect('projects'); } $project->delete(); Session::flash('flash_message', 'Project successfully deleted!'); return redirect("projects"); }
public function posteditportfolio(Request $request) { if (empty($request->input('updateid'))) { $model = new Projects(); if ($request->hasFile('image')) { $files = $request->file('image'); $medias = []; $errors = []; foreach ($files as $file) { $destenition = public_path() . "/img/"; $extension = $file->getClientOriginalExtension(); $fileName = rand(11111, 99999) . '.' . $extension; $file->move($destenition, $fileName); array_push($medias, $fileName); $images = implode(",", $medias); } } $model->name = $request->input('name'); $model->description = $request->input('description'); $model->additional_description = $request->input('additional_description'); $model->url = $request->input('url'); if (isset($images)) { $model->imgpath = $images; } if ($model->save()) { return redirect('/admin'); } } else { $model = Projects::find($request->input('updateid')); if ($request->hasFile('image')) { $files = $request->file('image'); $medias = []; foreach ($files as $file) { $destenition = public_path() . "/img/"; $extension = $file->getClientOriginalExtension(); $fileName = rand(11111, 99999) . '.' . $extension; $file->move($destenition, $fileName); array_push($medias, $fileName); $images = implode(",", $medias); } } $model->name = $request->input('name'); $model->description = $request->input('description'); $model->additional_description = $request->input('additional_description'); $model->url = $request->input('url'); if (isset($images)) { $model->imgpath = $images; } if ($model->save()) { return redirect('/admin'); } } }
public function projects() { $projects = Projects::all(); return view('page.projects')->with('projects', $projects); }
public function review(Request $request) { $requirement_id = $request->segment(2); $requirement = Requirements::find($requirement_id); $project = Projects::find($requirement->project_id); DB::enableQueryLog(); $context = ContextScenarioUserAppInteraction::leftJoin('users', 'users.id', '=', 'context_scenario_user_app_interaction.user_id')->leftJoin('context_scenario_ideal_way AS context', 'context.id', '=', 'context_scenario_user_app_interaction.context_id')->leftJoin('context_ratings as CR', 'CR.context_id', '=', 'context_scenario_user_app_interaction.id')->select('context_scenario_user_app_interaction.*', 'users.name AS user_name', 'context.context_name', 'context.full_name', DB::raw('avg(CR.rating) AS avg_rating, count(CR.id) AS rating_count'))->where('requirement_id', $requirement_id)->groupBy('context_scenario_user_app_interaction.id')->get()->toArray(); $context_voting = ContextScenarioUserAppInteraction::leftJoin('ways_of_interaction_voting as WOIV', 'WOIV.context_id', '=', 'context_scenario_user_app_interaction.id')->select('context_scenario_user_app_interaction.id', DB::raw('sum(WOIV.accompanying) as accompanying_count, sum(WOIV.intermittent) as intermittent_count, sum(WOIV.interrupting) as interrupting_count'))->where('requirement_id', $requirement_id)->groupBy('context_scenario_user_app_interaction.id')->get()->toArray(); foreach ($context as &$value1) { foreach ($context_voting as $value2) { if ($value1['id'] == $value2['id']) { $value1 = array_merge($value1, $value2); } } } usort($context, function ($i, $j) { $a = $i['avg_rating']; $b = $j['avg_rating']; if ($a == $b) { return 0; } elseif ($a > $b) { return 1; } else { return -1; } }); $context = array_reverse($context); $breadcrumbs = array('Projects' => '/projects', 'All Requirements' => "/projects/{$requirement->project_id}"); return view('requirements.review', compact('requirement', 'context', 'project', 'breadcrumbs')); }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $issues = Projects::lists('title', 'id'); $file = Modules::findOrFail($id); return view('modules.edit', compact('file', 'issues')); }
public function delete(Request $request) { if (!ACL::hasPermission('projects', 'delete')) { return redirect(route('projects'))->withErrors(['You don\'t have permission for delete the projects.']); } //DELETE FOLDER BEFORE DELETE IN DATABASE $directory = $this->folder . $request->get('projectsId'); File::deleteDirectory($directory); ProjectsGallery::deleteGalleryByProject($request->get('projectsId')); ProjectsMovie::deleteMoviesByProject($request->get('projectsId')); Projects::find($request->get('projectsId'))->delete(); $success = "Project deleted successfully."; return redirect(route('projects'))->with(compact('success')); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function public_modules($id) { $projectName = Projects::where('id', '=', $id)->pluck('title'); $moduleDara = Modules::whereproject_id($id)->get(); return view('public_journal.public_modules', compact('projectName', 'moduleDara')); }