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);
}
