コード例 #1
0
 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function show($id)
 {
     $requirement = Requirements::find($id);
     $scenario = Scenarios::find($requirement->scenario_id);
     $project = Projects::find($scenario->project_id);
     $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')->leftJoin('context_ratings as CR1', function ($join) {
         $join->on('CR1.context_id', '=', 'context_scenario_user_app_interaction.id');
         $join->where('CR1.user_id', '=', $this->user['id']);
     })->leftJoin('ways_of_interaction_voting as WOIV', function ($join) {
         $join->on('WOIV.context_id', '=', 'context_scenario_user_app_interaction.id');
         $join->where('WOIV.user_id', '=', $this->user['id']);
     })->select('context_scenario_user_app_interaction.*', 'users.name AS user_name', 'context.context_name', 'context.full_name', 'CR1.rating', DB::raw('avg(CR.rating) AS avg_rating, count(CR.id) AS rating_count'), 'WOIV.accompanying', 'WOIV.intermittent', 'WOIV.interrupting')->where('requirement_id', $id)->groupBy('context_scenario_user_app_interaction.id')->orderBy('context_id', 'asc')->get();
     $context_arr = $context->toArray();
     if ($context_arr) {
         foreach ($context_arr as &$c) {
             $cid = $c['id'];
             $context_scene = ContextSceneRelation::select('context_scene_relation.user_id AS context_scene_user', 'context_scene_relation.scene', 'users.name AS user_name')->leftJoin('users', 'users.id', '=', 'context_scene_relation.user_id')->where('context_id', $cid)->get()->toArray();
             $c['scenes'] = $context_scene;
             $c = (object) $c;
         }
     }
     $context_arr = (object) $context_arr;
     $breadcrumbs = array('Projects' => '/projects', 'All Requirements' => "/scenarios/{$requirement->scenario_id}");
     return view('requirements.details', compact('requirement', 'context_arr', 'project', 'breadcrumbs'));
 }
コード例 #2
0
 /**
  * Update the specified resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @param  int  $id
  * @return \Illuminate\Http\Response
  */
 public function update(Request $request, $id)
 {
     $this->validate($request, $this->rules);
     $scenario = Scenarios::find($id);
     $updateData = $request->all();
     $scenario->update($updateData);
     Session::flash('flash_message', 'Congratulations, Scenario updated successfully!');
     return redirect("projects/{$request->project_id}");
 }