public function index(Request $request) { $keyword = $request->input('keyword'); if ($keyword == '') { return redirect()->route('drama.index'); } $dramas = Drama::where('title', 'LIKE', '%' . $keyword . '%')->orWhere('alias', 'LIKE', '%' . $keyword . '%')->get(); $scs = Sc::where('name', 'LIKE', '%' . $keyword . '%')->orWhere('alias', 'LIKE', '%' . $keyword . '%')->get(); $clubs = Club::where('name', 'LIKE', '%' . $keyword . '%')->get(); return view('search.search', ['keyword' => $keyword, 'dramas' => $dramas, 'scs' => $scs, 'clubs' => $clubs]); }
public function update(CompetitorFormRequest $request, $id) { $competitor = Competitor::findOrFail($id); $competitor->first_name = $request->get('first_name'); $competitor->last_name = $request->get('last_name'); $competitor->sex = $request->get('sex'); $competitor->birthday = $request->get('birthday'); $competitor->country_id = $request->get('country_id'); $competitor->club_id = $request->get('club_id'); $competitor->full_name = $request->get('last_name') . ' ' . $request->get('first_name'); $competitor->save(); $club = Club::where('id', '=', $request->get('club_id'))->firstOrFail(); $club->in_competition = 1; $club->save(); return redirect('/admin/competitors')->with('status', 'Versenyző adatai módosítva'); }
public function search() { //DB::enableQueryLog(); $search_text = Input::get("text"); $result = Club::where("nombre", 'LIKE', '%' . $search_text . '%')->limit('10')->get(); //dd(DB::getQueryLog()); return response()->json(['result' => 'Ok', 'response' => $result]); }
/** * Determine if the user is authorized to make this request. * * @return bool */ public function authorize() { return Club::where(['slug' => $this->slug])->exists(); }
/** * Add a placeholder * * @param string $slug * @param Request $request */ public function addPlaceholder($slug, AddPlaceholderRequest $request) { $placeholder = Placeholder::fromFile($request->file('placeholder')); Club::where(compact('slug'))->firstOrFail()->addPlaceholder($placeholder); }
/** * * @return integer */ public function esAlgo($es_que = '') { $persona_id = $this->id; switch ($es_que) { case 'socio': $existe = Socio::where('persona_id', $persona_id)->first(); break; case 'arbitro': $existe = Arbitro::where('persona_id', $persona_id)->first(); break; case 'veedor': $existe = Veedor::where('persona_id', $persona_id)->first(); break; case 'club': $existe = Club::where('persona_id', $persona_id)->first(); break; default: $existe = NULL; break; } return $existe; }
/** * Necessary show data * * @param $persona : el objeto persona que se va a mostrar * @param $entidad : el objeto entidad que se va a mostrar * @param string $entidad_nombre : a que entidad hacemos referencia */ public function showData($persona, $entidad, $entidad_nombre) { $club = null; $plantilla = []; $socio = null; $trayectoria = []; $arbitro = null; $veedor = null; $active_section = 'info_persona'; if ($entidad_nombre != 'club') { $active_section = 'info_persona'; if ($entidad_nombre == 'persona') { $club = Club::where('persona_id', $persona->id)->first(); } // Si estoy tratando de mostrar los datos del club, no necesito estos datos if (is_null($club)) { $veedor = $entidad; if ($entidad_nombre != 'veedor') { $veedor = Veedor::where('persona_id', $persona->id)->first(); if ($veedor) { $active_section = 'info_veedor'; } } $arbitro = $entidad; if ($entidad_nombre != 'arbitro') { $arbitro = Arbitro::where('persona_id', $persona->id)->first(); if ($arbitro) { $active_section = 'info_arbitro'; } } $socio = $entidad; if ($entidad_nombre != 'socio') { $socio = Socio::where('persona_id', $persona->id)->first(); if ($socio) { $trayectoria = $socio->trayectoria; $active_section = 'info_socio'; } } } else { $active_section = 'info_club'; } } else { $club = $entidad; $active_section = 'info_club'; } $delegados = []; if ($club) { $plantilla = $club->plantilla; $delegados = $club->delegados; } $this->webpage['active_section'] = $active_section; $this->data = array_merge(['webpage' => $this->webpage, 'persona' => $persona, 'domicilio' => $persona->domicilio, 'telefonos' => $persona->telefonos, 'emails' => $persona->emails, 'web_pages' => $persona->webpages, 'club' => $club, 'plantilla' => $plantilla, 'delegados' => $delegados, 'socio' => $socio, 'trayectoria' => $trayectoria, 'arbitro' => $arbitro, 'veedor' => $veedor], $this->data); }