/** * 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]); }
public function findMethodology() { return \App\Methodology::lists('name', 'id'); }