Example #1
0
 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show($id)
 {
     //
     $user = \Auth::user();
     //dd($user);
     $rArtifacts = array();
     $rMethodology = array();
     $rCompany = \App\RegistryCompany::where('id_period', $id)->where('id_student', $user->id)->get();
     if (count($rCompany) > 0) {
         $rMethodology = \App\RegistryMethodology::where('id_period', $id)->where('id_company', $rCompany[0]->id_company)->get();
         if (count($rMethodology) > 0) {
             //dd($rMethodology[0]->id_methodology);
             $rArtifacts = \App\Methodology::Join('phases', function ($join) {
                 $join->on('phases.id_methodology', '=', 'methodologies.id');
             })->join('artifacts', function ($join) {
                 $join->on('artifacts.id_phase', '=', 'phases.id');
             })->leftJoin('calendars', function ($leftJoin) use($user, $rCompany, $id) {
                 $leftJoin->on('calendars.id_phase', '=', 'phases.id')->where('calendars.id_artifact', '=', 'artifacts.id')->where('calendars.id_methodology', '=', 'methodologies.id')->where('calendars.id_student', '=', $user->id)->where('calendars.id_period', '=', $id)->where('calendars.id_company', '=', $rCompany[0]->id_company);
             })->select('methodologies.id as meth_id', 'methodologies.name as meth_name', 'phases.id as pha_id', 'phases.name as pha_name', 'artifacts.id as art_id', 'artifacts.name as art_name', 'artifacts.start as art_start', 'artifacts.delivery as art_delivery', 'calendars.id_calendar as id_calendar', 'calendars.htmlLink as htmlLink')->where('artifacts.active', true)->where('phases.active', true)->where('methodologies.active', true)->where('methodologies.id', $rMethodology[0]->id_methodology)->orderBy('artifacts.delivery', 'asce')->get();
             //	dd($rArtifacts);
         } else {
             $rMethodology = array();
         }
     } else {
         $rCompany = array();
     }
     //$artifacts = \App\Artifact::orderBy('delivery','asc')->get();//all()->orderBy('delivery', 'asce');
     return view('Admin.Course.Advance.advance', ['rMethodology' => $rMethodology, 'rArtifacts' => $rArtifacts, 'rCompany' => $rCompany, 'id' => $id]);
     /*$artifact = \App\Artifact::findOrFail($id);
     		return view('Admin.Course.Advance.show',
     		[
     			'artifact'=>$artifact
     			]
     		);*/
 }
 /**
  * Update the specified resource in storage.
  *
  * @param  int  $id
  * @return Response
  */
 public function update(Request $request, $id)
 {
     //
     $data = $request->all();
     $rMethodology = \App\RegistryMethodology::findOrFail($data['id']);
     $rMethodology->fill($data);
     $rMethodology->save();
     if ($request->ajax()) {
         return response()->json(['status' => 'true', 'data' => 'The Config methodology was save successful']);
     }
 }
 /**
  * Show the form for editing the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function edit($id)
 {
     //period.company
     $data = explode('.', $id);
     $rArtifacts = array();
     $rMethodology = array();
     $rMethodology = \App\RegistryMethodology::where('id_period', $data[0])->where('id_company', $data[1])->get();
     if (count($rMethodology) > 0) {
         //dd($rMethodology[0]->id_methodology);
         $rArtifacts = \App\Methodology::Join('phases', function ($join) {
             $join->on('phases.id_methodology', '=', 'methodologies.id');
         })->join('artifacts', function ($join) {
             $join->on('artifacts.id_phase', '=', 'phases.id');
         })->select('methodologies.id as meth_id', 'methodologies.name as meth_name', 'phases.id as pha_id', 'phases.name as pha_name', 'artifacts.id as art_id', 'artifacts.name as art_name', 'artifacts.start as art_start', 'artifacts.delivery as art_delivery')->where('artifacts.active', true)->where('phases.active', true)->where('methodologies.active', true)->where('methodologies.id', $rMethodology[0]->id_methodology)->orderBy('artifacts.delivery', 'asce')->get();
         //	dd($rArtifacts);
     } else {
         $rMethodology = array();
     }
     return view('Admin.Evaluation.advance', ['rMethodology' => $rMethodology, 'rArtifacts' => $rArtifacts, 'data' => $data]);
     //
 }
Example #4
0
 /**
  * Display the specified resource.
  *
  * @param  int  $id
  * @return Response
  */
 public function show($id)
 {
     //
     $methodology = \App\Methodology::lists('name', 'id');
     $currentuser = $this->user;
     $company = \App\RegistryCompany::Join('companies', function ($join) use($currentuser) {
         $join->on('companies.id', '=', 'registry_companies.id_company')->where('registry_companies.id_student', '=', $currentuser->id);
     })->select('companies.id', 'companies.name')->where('id_period', $id)->get();
     //dd($company[0]->name);
     if (count($company) > 0) {
         $teamwork = \App\RegistryCompany::Join('users', function ($join) use($company) {
             $join->on('users.id', '=', 'registry_companies.id_student')->where('registry_companies.id_company', '=', $company[0]->id);
         })->select('users.id', 'users.first_name', 'users.last_name', 'users.email')->where('id_period', $id)->get();
     } else {
         $teamwork = array();
     }
     if (count($company) > 0 && count($teamwork) > 0) {
         $account = \App\ConfigCorreo::where('id_company', '=', $company[0]->id)->where('id_period', '=', $id)->get();
         if (count($account) > 0) {
             $account = $account[0];
         } else {
             $account = array();
         }
     } else {
         $account = array();
     }
     if (count($company) > 0 && count($teamwork) > 0) {
         $methodology_use = \App\RegistryMethodology::where('id_company', '=', $company[0]->id)->where('id_period', '=', $id)->get();
         if (count($methodology_use) > 0) {
             $methodology_use = $methodology_use[0];
         } else {
             $methodology_use = array();
         }
     } else {
         $methodology_use = array();
     }
     //dd();
     return view("Admin.Course.Settings.setting", ['company' => $company, 'teamwork' => $teamwork, 'id' => $id, 'account' => $account, 'methodology' => $methodology, 'methodology_use' => $methodology_use]);
 }