/** * Display the specified resource. * * @param int $id * @return Response */ public function show(Request $request, $id) { // $data = $request->all(); //dd($data); $id_period = $data['id_period']; $id_company = $data['id_company']; if ($id == 1) { // Add code for load teacher whitout period /* $teachers = \App\RegistryStudent::Join('users','users.id','=','registry_students.id_student') ->leftJoin('registry_companies', 'users.id', '=', 'registry_companies.id_student') ->select('registry_students.id as id_registry_student','users.id','users.first_name','users.last_name','users.type') ->whereNull('registry_companies.id_student') ->Where('registry_students.id_period',$id_period) ->get()->toJson();*/ $teachers = \App\RegistryStudent::Join('users', function ($join) { $join->on('users.id', '=', 'registry_students.id_student'); })->leftJoin('registry_companies', function ($leftJoin) use($id_company, $id_period) { $leftJoin->on('users.id', '=', 'registry_companies.id_student')->Where('registry_companies.id_company', '=', $id_company)->Where('registry_companies.id_period', '=', $id_period); })->select('registry_students.id as id_registry_student', 'users.id', 'users.first_name', 'users.last_name', 'users.type')->whereNull('registry_companies.id_student')->Where('registry_students.id_period', $id_period)->get()->toJson(); //dd($teachers); //dd(count(json_decode($teachers,true))); } else { // Add code for load teacher whit period $teachers = \App\RegistryCompany::Join('users', 'users.id', '=', 'registry_companies.id_student')->select('registry_companies.id as id_registry_company', 'users.id', 'users.first_name', 'users.last_name', 'users.type')->Where('registry_companies.id_period', $id_period)->Where('registry_companies.id_company', $id_company)->get()->toJson(); } //dd(100); $status = count(json_decode($teachers, true)) > 0 ? true : false; if ($request->ajax()) { return response()->json(['status' => $status, 'data' => $teachers]); } }
/** * 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]); }