public function index()
{
$usersData = [];
$usersData['count'] = User::all()->count();
$usersData['incompleteCount'] = User::where('status', 0)->count();
$picsData = [];
$picsData['count'] = Pic::all()->count();
$clubsData = [];
$clubsData['count'] = Club::all()->count();
$badgesData = [];
$badgesData['count'] = Badge::all()->count();
$fixtures = Fixture::all();
$fixturesData = [];
$fixturesData['count'] = $fixtures->count();
$fixturesData['overCount'] = $fixtures->filter(function ($fxt) {
return $fxt->isOver();
})->count();
$fixturesData['closedNotOverCount'] = $fixtures->filter(function ($fxt) {
return $fxt->isClosed() and !$fxt->isOver();
})->count();
$gameweeks = Gameweek::all();
$gameweeksData = [];
$gameweeksData['count'] = $gameweeks->count();
$gameweeksData['completeCount'] = Gameweek::complete()->get()->count();
$gameweeksData['pendingCount'] = Gameweek::incomplete()->get()->filter(function ($gw) {
return $gw->hasCompletedFixture();
})->count();
$adminsData = [];
$adminsData['count'] = Admin::all()->count();
return view('admin.dashboard.index', compact('usersData', 'picsData', 'clubsData', 'badgesData', 'fixturesData', 'gameweeksData', 'adminsData'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
$id = $request->club;
$club = Club::findOrFail($id);
$asociados_al_club = Trayectoria::with('socio')->select('trayectorias.*')->join('clubes', 'clubes.id', '=', 'trayectorias.club_id')->where('club_id', $id)->whereNull('trayectorias.baja')->get();
/* foreach ($asociados_al_club as $asociado){
$condicion = true;
$torneos_participados = TorneoPlantel::where('socios.id' , $asociado->id)
->join('temporadas_planteles','torneos_planteles.jugador_id','=','temporadas_planteles.id')
->join('socios','socios.id','=','temporadas_planteles.jugador_id')
->join('torneos_clubes','torneos_planteles.torneo_club_id','=','torneos_clubes.id')
->join('torneos','torneos_clubes.torneo_id','=','torneos.id')
->get();
foreach ($torneos_participados as $torneo)
if ($condicion) { $condicion = (is_null($torneo->finalizado)) ? false : $torneo->finalizado; }
$asociado->activo = $condicion;
}
*/
$this->data = array_merge(['webpage' => $this->webpage, 'club' => $club, 'plantel' => $asociados_al_club]);
//dd($this->data);
return view('admin.roster.trayectoria.show', $this->data);
}
/**
* show list of clubs
*
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function index()
{
//
$clubs = Club::take(5)->get();
$clubs_count = Club::count();
return view('welcome.index', compact('clubs', 'clubs_count'));
}
/**
* Get the validation rules that apply to the request.
*
* @return array
*/
public function rules()
{
$parent_rules = parent::rules();
$club = Club::findOrFail($this->route->getParameter('clubes'));
$my_rules = array('nombre_club' => ['required', 'unique:clubes,nombre,' . $club->id], 'documento' => ['required', 'min:4', 'unique_with:personas,documento,' . $club->persona_id . ',id,tipo_doc_id,' . $this->request->get('tipo_doc_id')], 'tipo_doc_id' => ['required', 'numeric', 'unique_with:personas,tipo_doc_id,' . $club->persona_id . ',id,documento,' . $this->request->get('documento')]);
$rules = array_merge($parent_rules, $my_rules);
return $rules;
}
/**
* Adds a new member to the Club
*/
public function storeMember(Request $request)
{
$this->setRequestValidator(new \App\Http\Requests\StoreClubMemberRequest());
$this->validateRequest($request);
$club = \App\Club::find($request->input('club_id'));
$member = \App\User::find($request->input('user_id'));
$club->members()->attach($member->id);
return \Fractal::collection($club->members, new \App\Transformers\UserTransformer())->getArray();
}
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]);
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
if (!Auth::check()) {
return redirect()->action("WelcomeController@requestLogin");
}
$club = Club::findOrFail($request->club);
if (Auth::user() != $club->creator) {
return "You don't have access to do this";
}
return $next($request);
}
/**
* Handle an incoming request.
*
* @param \Illuminate\Http\Request $request
* @param \Closure $next
* @return mixed
*/
public function handle($request, Closure $next)
{
if (!Auth::check()) {
return redirect()->action("WelcomeController@requestLogin");
}
$club = Club::findOrFail($request->club);
$user = Auth::user();
if (!$club->managers->contains($user)) {
return redirect()->action('WelcomeController@index');
}
return $next($request);
}
public function demote($club, $member)
{
$club = Club::findOrFail($club);
if (!$club->managers->contains($member)) {
return "不是管理";
}
if ($club->creator->id == $member) {
return "这是创造者";
}
if (!$club->managers()->detach($member)) {
return "Demote succeed";
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$gameweek = Gameweek::findOrFail($id);
$gameweek->overFixtures = $gameweek->fixtures()->over()->get();
$gameweek->pendingFixtures = $gameweek->fixtures()->get()->filter(function ($fxt) {
return $fxt->isClosed() and !$fxt->isOver();
});
$gameweek->upcomingFixtures = $gameweek->fixtures()->get()->filter(function ($fxt) {
return !$fxt->isClosed();
});
$gameweek->fxtCnt = $gameweek->overFixtures->count() + $gameweek->pendingFixtures->count() + $gameweek->upcomingFixtures->count();
$clubs = Club::lists('name', 'id')->toArray();
return view('admin.gameweek.show', compact('gameweek', 'clubs'));
}
public function edit(Request $request, $id)
{
$review = Screv::find($id);
if ($review->user_id == $request->user()->id) {
if ($review->model == 0) {
$model = Sc::find($review->model_id, ['name']);
} else {
$model = Club::find($review->model_id, ['name']);
}
return view('screv.edit', ['review' => $review, 'model' => $model]);
} else {
return redirect()->back();
}
}
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');
}
private function approveJoin($join_id)
{
$join_requests = JoinAudit::findOrFail($join_id);
try {
DB::transaction(function () use($join_requests) {
$club_id = $join_requests->club_id;
$user_id = $join_requests->user_id;
$user = User::findOrFail($user_id);
$club = Club::findOrFail($club_id);
$club->members()->attach($user);
$join_requests->status = 1;
$join_requests->save();
});
} catch (\Exception $e) {
throw $e;
}
return True;
}
// Roles
$roles_rs = Role::orderBy('name', 'asc')->get();
$roles = [];
$roles[0] = 'Choose a roles';
foreach ($roles_rs as $r) {
$roles[$r->id] = $r->name;
}
// Genders
$genders_rs = Gender::orderBy('name', 'asc')->get();
$genders = [];
$genders[0] = 'Choose a gender';
foreach ($genders_rs as $g) {
$genders[$g->id] = $g->name;
}
// Clubs
$clubs_rs = Club::orderBy('name', 'asc')->get();
$clubs = [];
$clubs[0] = 'Choose a club';
foreach ($clubs_rs as $c) {
$clubs[$c->id] = $c->name;
}
$users = User::orderBy('created_at', 'asc')->get();
return view('users', ['title' => 'Users', 'clubs' => $clubs, 'genders' => $genders, 'roles' => $roles, 'users' => $users]);
});
/**
* Add A New User
*/
Route::post('/user', function (Request $request) {
$validator = Validator::make($request->all(), ['first_name' => 'required|max:100', 'last_name' => 'required|max:100', 'email' => 'email|max:255', 'birth_date' => 'date', 'gender_id' => 'required|exists:genders,id', 'club_id' => 'required|exists:clubs,id', 'active' => 'required|boolean']);
if ($validator->fails()) {
return redirect('/users')->withInput()->withErrors($validator);
public function search_in_plantilla()
{
$result = array();
//DB::enableQueryLog();
$search_text = Input::get("text");
$club_id = Input::get("club_id");
$club = Club::with('jugadores')->where("id", $club_id)->first();
$plantilla = $club->jugadores;
$socios = Socio::with(['persona', 'persona.tipo_documento'])->whereHas('persona', function ($q) use($search_text) {
$q->where("documento", 'LIKE', '%' . $search_text . '%')->orWhere("apellido", 'LIKE', '%' . $search_text . '%')->orWhere("nombre", 'LIKE', '%' . $search_text . '%');
})->orWhere("carnet", 'LIKE', '%' . $search_text . '%')->get();
$delegados = $plantilla->pluck('socio_id');
$socios_ids = $socios->pluck('id');
$delegados_filtered_ids = $delegados->intersect($socios_ids)->toArray();
//dd($socios_ids);
$delegados = $socios->whereIn("id", $delegados_filtered_ids);
foreach ($delegados as $socio) {
$socio->persona->full_name = $socio->persona->full_name;
$socio->persona->inverse_full_name = $socio->persona->inverse_full_name;
$result[] = $socio;
}
//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);
}
public function destroy($id)
{
Club::findOrFail($id)->delete();
return redirect('/admin/clubs')->with('status', 'Klub törölve');
}
public function versions($id)
{
$club = Club::find($id, ['id', 'name']);
$versions = Clubver::with(['user' => function ($query) {
$query->select('id', 'name');
}])->select('user_id', 'first', 'name', 'information', 'created_at', 'updated_at')->where('club_id', $id)->orderBy('updated_at', 'desc')->get();
return view('club.versions', ['club' => $club, 'versions' => $versions]);
}
/**
* Remove the specified club from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Club::findOrFail($id)->delete();
\Session::flash('alert-success', 'Club deleted.');
return redirect('/clubs');
}
/**
* 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);
}
/**
* Can a user edit the current club
*
* @return boolean
*/
public function canEdit($club)
{
$editor = Club::with('users')->find($club->id)->users->toArray();
return in_array($this->id, array_flatten($editor));
}
/**
* Create Activity
* @param Request $request
* @param $club
* @return \Illuminate\Http\RedirectResponse
*/
public function storeActivity(Request $request, $club)
{
$this->validate($request, ['title' => 'required|max:32|min:2', 'content' => 'required|max:300|min:10']);
$club = Club::findOrFail($club);
if ($club->activities()->create($request->all())) {
return redirect()->action("ClubManageController@activityList", ['club' => $club]);
} else {
return redirect()->back()->withErrors(["Servers error , try again later ~"]);
}
}
/**
*
* @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;
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$torneo = Torneo::findOrFail($id);
/*$torneo = Torneo::with('temporada')
->with('division.categoria.genero')
->with('fases.grupos.clubes.torneo_club.club')
->with('fechas.partidos.clubes.torneo_grupo_club.torneo_grupo.fase')
->with('fechas.partidos.clubes.torneo_grupo_club.torneo_club.club')
->with('clubes.jugadores')
->with('clubes.club')
->findOrFail($id);*/
$this->webpage['whereAmI'] = $this->BreadcrumbRoot($torneo->temporada, $torneo);
$this->webpage['whereAmI'] .= $this->listOneBreadcrumb('editar');
$this->webpage['tab_title'] = $torneo->maximal_full_name . ' - Editar';
$equipos = Club::with(['divisiones' => function ($q) use($torneo) {
$q->where("division_id", $torneo->division);
}])->get();
$tipo_primera_fase = TipoTorneoFase::where('fase_numero', 1)->where('tipo_torneo_id', $torneo->tipo_torneo_id)->first();
$torneo_clubes = TorneoClub::with(['club', 'torneo_grupos'])->whereHas('torneo_grupos', function ($q = '') {
$q->whereHas('torneo_grupo', function ($subq) {
$subq->where("fase_id", 1);
});
})->where("torneo_id", $torneo->id)->get();
// OJO; DIF ENTRE EQUIPOS Y TORNEOS CLUBES, VERIFICAR
$equipos = $equipos->diff($torneo_clubes->pluck('club'));
// dd($equipos);
/*$partidos = Partido::with('fecha')->whereHas('fecha',function ($q) use ($id) {
$q->where('torneo_id',$id);
})->whereIn('estado_id',[3,4,5,6])->get();
$torneo->comenzado = false;
if ($partidos->count()) {
$torneo->comenzado = true;
}*/
$this->data = array_merge(['webpage' => $this->webpage, 'equipos' => $equipos, 'torneo_clubes' => $torneo_clubes, 'torneo' => $torneo, 'tipo_primera_fase' => $tipo_primera_fase], $this->data);
return view('admin.seasons.torneos.edit', $this->data);
}
public function getStats($season)
{
$pairs = $this->pairs()->where('season_id', '=', $season->id)->get();
foreach ($pairs as $pair) {
$matches = array();
$firstMatches = $pair->firstMatches()->get();
foreach ($firstMatches as $match) {
$dataMatch = ['id' => $match->id, 'home' => Club::find($match->home_id)->name, 'away' => Club::find($match->away_id)->name, 'round_id' => $match->round_id, 'type' => 0];
array_push($matches, $dataMatch);
}
$secondMatches = $pair->secondMatches()->get();
foreach ($secondMatches as $match) {
$dataMatch = ['id' => $match->id, 'home' => Club::find($match->home_id)->name, 'away' => Club::find($match->away_id)->name, 'round_id' => $match->round_id, 'type' => 1];
array_push($matches, $dataMatch);
}
$pair['ref1'] = Person::find($pair->ref1_id);
$pair['ref2'] = Person::find($pair->ref2_id);
$pair['countFall'] = count($firstMatches);
$pair['countSpring'] = count($secondMatches);
$pair['matches'] = $matches;
}
$courts = $this->referees()->wherePivot('type', '=', 1)->wherePivot('season_id', '=', $season->id)->get();
foreach ($courts as $court) {
$matches = array();
$firstMatches = $court->firstMatchesAsCourt()->get();
foreach ($firstMatches as $match) {
$dataMatch = ['id' => $match->id, 'home' => Club::find($match->home_id)->name, 'away' => Club::find($match->away_id)->name, 'round_id' => $match->round_id, 'type' => 0];
array_push($matches, $dataMatch);
}
$secondMatches = $court->secondMatchesAsCourt()->get();
foreach ($secondMatches as $match) {
$dataMatch = ['id' => $match->id, 'home' => Club::find($match->home_id)->name, 'away' => Club::find($match->away_id)->name, 'round_id' => $match->round_id, 'type' => 1];
array_push($matches, $dataMatch);
}
$court['countFall'] = count($firstMatches);
$court['countSpring'] = count($secondMatches);
$court['matches'] = $matches;
}
$response = array('pairs' => $pairs, 'courts' => $courts);
return $response;
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(ClubRequest $request, $id)
{
$club = Club::findOrFail($id);
$club->update($request->all());
return redirect("clubs");
}
public function update(Request $request, $id)
{
$this->validate($request, ['name' => 'required|max:255', 'alias' => 'max:255']);
$sc = Sc::find($id);
$sc->name = $request->input('name');
$sc->alias = $request->input('alias');
if ($club = Club::select('id')->where('name', $request->input('club'))->first()) {
$sc->club_id = $club->id;
} else {
$sc->club_id = 0;
}
$sc->jobs = $request->input('jobs');
$sc->information = $request->input('information');
if ($sc->save()) {
$user_id = $request->user()->id;
$version = Scver::where('sc_id', $id)->where('user_id', $user_id)->first();
if (!$version) {
$version = new Scver();
$version->sc_id = $id;
$version->user_id = $user_id;
$version->first = 0;
}
$version->name = $sc->name;
$version->alias = $sc->alias;
$version->club_id = $sc->club_id;
$version->jobs = $sc->jobs;
$version->information = $sc->information;
$version->save();
//获取sc当前job数组
$jobs = DB::table('sc_job')->select('job_id')->where('sc_id', $id)->get();
$job_old = [];
foreach ($jobs as $row) {
$job_old[$row->job_id] = 1;
}
//获取输入job数组
$job_input = [];
if ($request->has('job')) {
foreach ($request->input('job') as $job) {
$job_input[$job] = 1;
}
}
//对比两个数组判断需要添加和删除的职位
$adds = [];
$removes = [];
for ($i = 0; $i <= 11; $i++) {
if (isset($job_input[$i]) && !isset($job_old[$i])) {
$adds[] = ['sc_id' => $id, 'job_id' => $i];
//若输入有，原来没有，则添加职位
} else {
if (isset($job_old[$i]) && !isset($job_input[$i])) {
$removes[] = $i;
//若原来有，输入没有，则删除职位
}
}
}
DB::table('sc_job')->insert($adds);
DB::table('sc_job')->where('sc_id', $id)->whereIn('job_id', $removes)->delete();
return redirect()->route('sc.show', [$sc]);
} else {
return redirect()->back()->withInput()->withErrors('修改失败');
}
}
/**
* destroy existing activity
* @param $club
* @param $activity
* @return \Illuminate\Http\RedirectResponse|\Illuminate\Routing\Redirector
*/
public function destroy($club, $activity)
{
$activity = ClubActivities::findOrFail($activity);
$club = Club::findOrFail($club);
if ($club->activities->contains($activity)) {
$activity->delete();
}
return redirect(action('Manage\\ActivityController@index', ['club' => $club]));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$fixture = Fixture::findOrFail($id);
$clubs = Club::lists('name', 'id')->toArray();
return view('admin.fixture.edit', compact('fixture', 'clubs'));
}
