/**
* @Route("/generate", name="fakeEntityGenerator")
* @Method("GET")
*/
public function generateAction()
{
$faker = Factory::create();
$em = $this->getDoctrine()->getManager();
foreach ($this->countryNames as $countryName) {
$country = new Country();
$country->setName($countryName);
$country->setFlag($countryName . '.png');
$country->setDescription($faker->text(3000));
$team = new Team();
$team->setName($countryName);
$team->setDescription($faker->text(3000));
$team->setCountry($country);
for ($i = 0; $i < 16; $i++) {
$player = new Player();
$player->setName($faker->name);
$player->setDescription($faker->text(3000));
$player->setTeam($team);
$em->persist($player);
}
for ($i = 0; $i < 4; $i++) {
$coach = new Coach();
$coach->setName($faker->name);
$coach->setDescription($faker->text(3000));
$coach->setTeam($team);
$em->persist($coach);
}
$em->persist($country);
$em->persist($team);
}
$em->flush();
return $this->redirectToRoute('homePage');
}
public function load(ObjectManager $manager)
{
$faker = Factory::create();
for ($i = 1; $i <= 24; $i++) {
$team = new Team();
$team->setInfo($faker->text(2000));
$country = $this->getReference("country {$i}");
$team->setCountry($country);
$this->setReference("team {$i}", $team);
$manager->persist($team);
$manager->flush();
for ($k = 1; $k <= 11; $k++) {
$player = new Player();
$player->setFirstName($faker->firstNameMale);
$player->setLastName($faker->lastName);
$player->setBiography($faker->text(200));
$player->setDateOfBirthday($faker->date('Y-m-d'));
$player->setTeam($team);
$team->getPlayers()->add($player);
$manager->persist($player);
}
// the same for coaches
for ($k = 1; $k <= 5; $k++) {
$coach = new Coach();
$coach->setName($faker->name);
$coach->setBiography($faker->text(200));
$coach->setTeam($team);
$team->getCoaches()->add($coach);
$manager->persist($coach);
}
}
$manager->flush();
}
public function load(ObjectManager $manager)
{
$teams = array(array('name' => 'Equipo Temporal 1'), array('name' => 'Equipo de nuevos'), array('name' => 'Ayudantes para web'));
foreach ($teams as $team) {
$entity = new Team();
$entity->setName($team['name']);
$manager->persist($entity);
}
$manager->flush();
}
public function testSetTeam()
{
// new entity
$wh = new WorkHistory();
// dummy entity
$team = new Team();
$team->setName("Hovedstyret");
// Use the setTeam method
$wh->setTeam($team);
// Assert the result
$this->assertEquals($team, $wh->getTeam());
}
public function createOrUpdate(Boat $boat, Race $race, LoggerInterface $logger)
{
/** @var Team $dbItem */
$dbItem = null;
// first try to find by ID
if (!empty($boat->id)) {
$dbItem = $this->findOneByDrvId($boat->id);
}
// if this does not help, do a fuzzy search
if (null == $dbItem) {
// TODO search by club + representative + name + race?
}
if (null != $dbItem) {
// TODO updating
$logger->warning("Implementation missing for updating teams in TeamRepository::createOrUpdate");
} else {
// create new team
$em = $this->getEntityManager();
$dbItem = new Team();
/** @var \AppBundle\Entity\Club $club */
$club = $this->getEntityManager()->getRepository('AppBundle:Club')->findOneByDrvId($boat->club_id);
if (null == $club) {
$message = "Found no club with DRV-ID {$boat->club_id}! No team created for " . "[{$boat->name}, {$boat->id}]";
$logger->warning($message);
throw new \Exception($message);
}
if ($race->getSections()->isEmpty()) {
/** @var \AppBundle\Repository\RaceRepository $raceRepo */
$raceRepo = $this->getEntityManager()->getRepository('AppBundle:Race');
// create initial section
$raceRepo->createSection($race, 1, $logger);
}
/** @var \AppBundle\Entity\RaceSection $raceSection */
$raceSection = $race->getSections()->last();
if (null == $raceSection) {
$message = "Found no section for race {$race->getId()}! No team created for " . "[{$boat->name}, {$boat->id}]";
$logger->warning($message);
throw new \Exception($message);
}
// save to DB - bugfix: lane for section is always 1 (because section does not exist yet)
$em->flush();
$dbItem->setClub($club)->setDrvId($boat->id)->setName($boat->name);
$em->persist($dbItem);
/** @var \AppBundle\Repository\RegistrationRepository $regRepo */
$regRepo = $this->getEntityManager()->getRepository('AppBundle:Registration');
$section = new Registration();
$section->setSection($raceSection)->setLane($regRepo->getNextLaneForSection($raceSection))->setTeam($dbItem);
$em->persist($section);
}
return $dbItem;
}
/**
* @Route("/remove/{team}", name="admin_team_remove")
* @param Team $team
* @return RedirectResponse
*/
public function teamRemoveAction(Team $team)
{
foreach ($team->getMembers() as $user) {
$team->setMembers(null);
$user->setTeam(null);
$this->getDoctrine()->getManager()->persist($user);
}
//Сохраняем изменения, что бы при удалении команды не удалить всех игроков
$this->getDoctrine()->getManager()->flush();
$this->getDoctrine()->getManager()->remove($team);
$this->getDoctrine()->getManager()->flush();
$this->addFlash('success', 'Команда удалена');
return $this->redirectToRoute('admin_team_list');
}
public function generateTeam()
{
$faker = Factory::create();
$team = new Team();
$arr = 'ABCDEIFG';
$em = $this->getDoctrine()->getManager();
for ($i = 0; $i < 10; $i++) {
$team->setGroups(substr($arr, rand(0, strlen($arr) - 1), 1));
$team->setCountry($faker->country);
$em->persist($team);
}
$em->flush();
return;
}
public function load(ObjectManager $manager)
{
$team1 = new Team();
$team1->setDepartment($this->getReference('dep-1'));
$team1->setName('Hovedstyret');
$manager->persist($team1);
$team2 = new Team();
$team2->setDepartment($this->getReference('dep-1'));
$team2->setName('IT');
$manager->persist($team2);
$manager->flush();
$this->addReference('team-1', $team1);
$this->addReference('team-2', $team2);
}
public function load(ObjectManager $manager)
{
$faker = \Faker\Factory::create();
$x = 0;
while ($x++ < 25) {
$country = $this->getReference("country-{$x}");
$team = new Team();
$team->setDescription($faker->text);
$team->setCountry($country);
$manager->persist($team);
$manager->flush();
$this->addReference("team-{$x}", $team);
}
}
protected function execute(InputInterface $input, OutputInterface $output)
{
$io = new SymfonyStyle($input, $output);
$em = $this->getContainer()->get('doctrine.orm.entity_manager');
$file = $input->getArgument('file');
$teams = json_decode(file_get_contents($file));
foreach ($teams as $team) {
$t = new Team();
$t->setName($team->name);
$t->setWsId($team->id);
$em->persist($t);
}
$em->flush();
$io->success('Added ' . count($teams) . ' teams.');
}
/**
* @dataProvider getValidTestData
*/
public function testForm($data)
{
$type = new CreateTeamType();
$form = $this->factory->create($type);
$object = new Team();
$object->fromArray($data);
// submit the data to the form directly
$form->submit($data);
$this->assertTrue($form->isSynchronized());
$this->assertEquals($object, $form->getData());
$view = $form->createView();
$children = $view->children;
foreach (array_keys($data) as $key) {
$this->assertArrayHasKey($key, $children);
}
}
public function testCreateTeam()
{
/** @var User $user */
$user = $this->getMock('AppBundle\\Entity\\User');
$team = Team::createTeam('DevTech', $user);
$this->assertInstanceOf('AppBundle\\Entity\\Team', $team);
$this->assertEquals('DevTech', $team->getName());
}
/**
* @param $count
* @return array
*/
public function generateTeam($count)
{
$data = Factory::create();
$teams = [];
for ($i = 1; $i < $count + 1; $i++) {
$team = new Team();
$team->setCountry($data->country);
$team->setName($data->company);
for ($j = 0; $j < 23; $j++) {
$player = $this->generatePlayer($team);
$team->addPlayer($player);
}
for ($k = 0; $k < 7; $k++) {
$trainer = $this->generateTrainer($team);
$team->addTrainer($trainer);
}
$teams[$i] = $team;
}
return $teams;
}
public function testRemoveSubforum()
{
// new entity
$team = new Team();
// New dummy entity
$subforum1 = new Subforum();
$subforum1->setName("subforum1");
$subforum2 = new Subforum();
$subforum2->setName("subforum2");
$subforum3 = new Subforum();
$subforum3->setName("subforum3");
// Use the addSubforum method
$team->addSubforum($subforum1);
$team->addSubforum($subforum2);
$team->addSubforum($subforum3);
// Remove $subforum1 from department
$team->removeSubforum($subforum1);
// subforums is stored in an array
$subforums = $team->getSubforums();
// Loop through the array
foreach ($subforums as $subforum) {
// Assert the result
$this->assertNotEquals($subforum1, $subforum);
}
}
/**
* @return array
*/
private function prepareAValidGameInDatabase()
{
$this->createPlayers(['Player_A', 'Player_B', 'Player_C', 'Player_D']);
$em = $this->getEntityManager();
$playerA = $em->getRepository('AppBundle:Player')->findOneById(1);
$playerB = $em->getRepository('AppBundle:Player')->findOneById(2);
$playerC = $em->getRepository('AppBundle:Player')->findOneById(3);
$playerD = $em->getRepository('AppBundle:Player')->findOneById(4);
$teamA = new Team();
$teamA->setPlayerA($playerA);
$teamA->setPlayerB($playerB);
$teamB = new Team();
$teamB->setPlayerA($playerC);
$teamB->setPlayerB($playerD);
$round = new Round();
$round->setDate(\DateTime::createFromFormat('Y-m-d', '1980-04-30'));
$this->getEntityManager()->persist($teamA);
$this->getEntityManager()->persist($teamB);
$this->getEntityManager()->persist($round);
$this->getEntityManager()->flush($teamA);
$this->getEntityManager()->flush($teamB);
$this->getEntityManager()->flush($round);
return [$round, $teamA, $teamB];
}
/**
* @Serializer\VirtualProperty()
* @Serializer\SerializedName("id_team_b")
*/
public function getIdTeamB()
{
return $this->teamB->getId();
}
public function load(\Doctrine\Common\Persistence\ObjectManager $manager)
{
$faker = \Faker\Factory::create();
$userManager = $this->container->get('fos_user.user_manager');
$addPlayer = function ($i, $team) use($manager, $userManager, $faker) {
/** @var User $user */
$user = $userManager->createUser();
$user->setUsername('player' . $i);
$user->setEmail('player' . $i . '@mailinator.com');
$user->setPlainPassword('123456');
$user->setEnabled(true);
$user->setRoles(array('ROLE_USER', 'ROLE_PLAYER'));
// $user->setGcmRegistrationId($faker->uuid);
$userManager->updateUser($user, true);
$player = new Player();
$player->setActive(true);
$player->setAlias($faker->name);
$player->setUser($user);
$this->addReference('player' . $i, $player);
$player->setImage($this->getReference('image' . rand(1, 19)));
$manager->persist($player);
$team->addPlayer($player);
};
$team1 = new Team();
$team1->setActive(true);
$team1->setName($faker->word);
$manager->persist($team1);
for ($i = 1; $i <= 5; $i++) {
$addPlayer($i, $team1);
}
$team2 = new Team();
$team2->setActive(true);
$team2->setName($faker->word);
$manager->persist($team2);
for ($i = 6; $i <= 10; $i++) {
$addPlayer($i, $team2);
}
$game = new Game();
$game->setTeam1($team1);
$game->setTeam2($team2);
$game->setActive(true);
$endTime = new DateTime();
$endTime->add(new DateInterval('PT15M'));
$game->setEndTimeStamp($endTime);
$this->addReference('game', $game);
$manager->persist($team1);
$manager->persist($team2);
$queue = new Team();
$queue->setActive(true);
$queue->setName('queue');
$manager->persist($queue);
$manager->persist($game);
for ($i = 1; $i < 10; $i++) {
$team = new Team();
$team->setName($faker->word);
$team->setActive(true);
$team->setPoints(rand(10, 400));
$manager->persist($team);
}
for ($i = 11; $i < 20; $i++) {
/** @var User $user */
$user = $userManager->createUser();
$user->setUsername('player' . $i);
$user->setEmail('player' . $i . '@mailinator.com');
$user->setPlainPassword('123456');
$user->setEnabled(true);
$user->setRoles(array('ROLE_USER', 'ROLE_PLAYER'));
$userManager->updateUser($user, true);
$player = new Player();
$player->setActive(true);
$player->setAlias($faker->name);
$player->setUser($user);
$this->addReference('player' . $i, $player);
$player->setImage($this->getReference('image' . rand(1, 19)));
$manager->persist($player);
}
$manager->flush();
}
/**
* @Route("/update-squad/{id}", name="squads")
*/
public function teamAction(Team $team)
{
$params = array('teamId' => $team->getId(), 'category' => 'summary', 'field' => 'Overall', 'subcategory' => 'all', 'statsAccumulationType' => 0, 'includeZeroValues' => 'true', 'isCurrent' => 'true');
$playerData = $this->get('app.whoscored')->loadStatistics('player-stats', $params);
return $this->render('', array());
}
/**
* Mark the given team as being not any longer part of the given race.
*
* @Route("/race/{race}/deregister/{team}", name="registration_delete")
* @Method("POST")
* @Security("has_role('ROLE_REGISTRATION')")
*/
public function deleteAction(Team $team, Race $race)
{
// sanity check
$races = array();
/** @var \AppBundle\Entity\Registration $registration */
foreach ($team->getRegistrations() as $registration) {
array_push($races, $registration->getSection()->getRace());
}
if (!in_array($race, $races)) {
$this->addFlash('error', 'Falsche Inputdaten!');
} else {
/** @var \AppBundle\Entity\Registration $myRegistrationForThisRace */
$myRegistrationForThisRace = null;
// find the "lane"
foreach ($team->getRegistrations() as $registration) {
if ($registration->getSection()->getRace() == $race) {
$myRegistrationForThisRace = $registration;
}
}
if (is_null($myRegistrationForThisRace)) {
$this->addFlash('error', 'Falsche Inputdaten! Konnte Startbahn nicht ermitteln...');
} else {
// mark the "lane" of the section as cancelled
$myRegistrationForThisRace->setDeregistered();
$this->getDoctrine()->getManager()->flush();
$this->addFlash('notice', 'Mannschaft abgemeldet!');
}
}
return $this->redirectToRoute('race_show', array('event' => $race->getEvent()->getId(), 'race' => $race->getId()));
}
/**
* Creates all possible team combination with the new player
*
* @param EntityManager $em
* @param Player $newPlayer
*/
private function createTeamsForNewPlayer(EntityManager $em, Player $newPlayer)
{
$players = $em->getRepository('AppBundle:Player')->findAll();
foreach ($players as $existingPlayer) {
if ($existingPlayer->getId() === $newPlayer->getId()) {
continue;
}
$team = new Team();
$team->setPlayerA($existingPlayer);
$team->setPlayerB($newPlayer);
$em->persist($team);
}
$em->flush();
}
/**
* Remove teams
*
* @param \AppBundle\Entity\Team $teams
*/
public function removeTeam(\AppBundle\Entity\Team $teams)
{
$teams->setSession(null);
$this->teams->removeElement($teams);
}
public function testRemoveTeam()
{
// new entity
$department = new Department();
$team1 = new Team();
$team1->setName("Team1");
$team2 = new Team();
$team2->setName("Team2");
$team3 = new Team();
$team3->setName("Team3");
// Use the addTeam method
$department->addTeam($team1);
$department->addTeam($team2);
$department->addTeam($team3);
// Remove $team1 from department
$department->removeTeam($team1);
// Teams are stored in an array
$teams = $department->getTeams();
// Loop through the array
foreach ($teams as $team) {
// Assert the result
$this->assertNotEquals($team1, $team);
}
}
/**
* @param Team $team
*/
public function addTeam(\AppBundle\Entity\Team $team)
{
$team->setGame($this);
$this->team[] = $team;
}
/**
* Creates a new Team entity.
*
* @Route("/team/new", name="team_new")
* @Method({"GET", "POST"})
*/
public function newAction(Request $request)
{
/** @var EntityManager $em */
$em = $this->getDoctrine()->getManager();
$maxTeamSize = 9;
$minAge = 0;
$maxAge = 100;
$gender = Competitor::GENDER_BOTH;
//$withCox = true;
/** @var Race $race */
$race = $request->get('race', null);
if (!is_null($race)) {
/** @var RaceRepository $raceRepo */
$raceRepo = $em->getRepository('AppBundle:Race');
/** @var Race|null $race */
$race = $raceRepo->find(intval($race));
if (!is_null($race)) {
$maxTeamSize = $race->getTeamsize();
$minAge = $race->getAgeMin();
$maxAge = $race->getAgeMax();
$gender = $race->getGender();
}
}
// get all potential candidates
/** @var MembershipRepository $memberRepo */
$memberRepo = $em->getRepository('AppBundle:Membership');
$memberships = $memberRepo->findAllCurrent($gender, $minAge, $maxAge);
if (0 == count($memberships)) {
$this->addFlash('error', 'Keine passenden Sportler gefunden, um neue Mannschaft anzulegen!');
return $this->redirect($request->headers->get('referer'));
} else {
/** @var ClubRepository $clubRepo */
$clubRepo = $em->getRepository('AppBundle:Club');
$clubs = $clubRepo->findAll();
usort($clubs, function ($a, $b) {
/** @var Club $a */
$left = $a->getCity() . '_' . $a->getAbbreviation();
/** @var Club $b */
$right = $b->getCity() . '_' . $b->getAbbreviation();
return strcmp($left, $right);
});
// no model
$data = array();
$fb = $this->createFormBuilder($data);
$fb->add('club', ChoiceType::class, array('label' => 'Meldender Club', 'required' => true, 'expanded' => false, 'multiple' => false, 'choices' => $clubs, 'choice_label' => function ($club, $key, $index) {
/** @var Club $club */
return $club->getName() . ' (' . $club->getCity() . ')';
}, 'group_by' => function ($club, $key, $index) {
/** @var Club $club */
return substr($club->getCity(), 0, 1);
}));
// team members at the positions
for ($i = 1; $i <= $maxTeamSize; $i++) {
$fb->add('members_' . $i, ChoiceType::class, array('label' => 'Platz ' . $i, 'required' => true, 'expanded' => false, 'multiple' => false, 'choices' => $memberships, 'choice_label' => function ($m, $key, $index) use($gender) {
/** @var Membership $m */
/** @var Competitor $p */
$p = $m->getPerson();
$result = $p->getFirstName() . ' ' . strtoupper($p->getLastName()) . ' (' . $p->getYearOfBirth() . ', ' . $p->getAge();
if (Competitor::GENDER_BOTH == $gender) {
$result .= ', ' . $p->getGenderSymbol();
}
$result .= ')';
return $result;
}, 'group_by' => function ($m, $key, $index) {
/** @var Membership $m*/
if (!empty(trim($m->getClub()->getShortname()))) {
return $m->getClub()->getShortname();
} else {
return $m->getClub()->getName();
}
}));
}
$form = $fb->getForm();
$form->handleRequest($request);
if ($form->isSubmitted()) {
$isGood = true;
if (!$form->isValid()) {
foreach ($form->getErrors() as $error) {
$this->addFlash('error', $error->getMessage());
}
$isGood = false;
}
if ($isGood) {
/** @var Club $club */
$club = $form->get('club')->getData();
if (is_null($club)) {
$this->addFlash('error', 'Kein Club angegeben!');
$isGood = false;
}
}
$team = null;
if ($isGood) {
$team = new Team();
$team->setClub($club);
$team->setName($club->getName());
$em->persist($team);
}
$found[] = array();
for ($i = 1; $i <= $maxTeamSize; $i++) {
/** @var Membership $m */
$m = $form->get('members_' . $i)->getData();
if (is_null($m)) {
$this->addFlash('error', sprintf("Kein Sportler an Position %d angegeben!", $i));
$isGood = false;
} else {
if (in_array($m->getId(), $found)) {
$this->addFlash('error', sprintf("Sportler an Position %d mehrfach angegeben!", $i));
$isGood = false;
} else {
$found[] = $m->getId();
$posInTeam = new TeamPosition();
$posInTeam->setTeam($team)->setPosition($i)->setIsCox(false)->setMembership($m);
$em->persist($posInTeam);
}
}
}
if ($isGood) {
$em->flush();
$this->addFlash('notice', 'Mannschaft erfolgreich angelegt!');
}
}
return $this->render('team/new.html.twig', array('race' => $race, 'form' => $form->createView()));
}
}
public function getAllAboutGames(\AppBundle\Entity\Team $team)
{
return $this->createQueryBuilder('game')->select('game, team, country')->where('game in (:status)')->join('game.teams', 'team')->join('team.country', 'country')->setParameter('status', $team->getGames())->getQuery()->getResult();
}
/**
* Creates a new Team entity.
*
* @Route("/create", name="team_create_ajax", options={"expose"=true})
* @Method("POST")
*/
public function createAction(Request $request)
{
$em = $this->getDoctrine()->getManager();
$team = new Team();
$team->setName($request->get('name'));
$em->persist($team);
$em->flush();
$result = "";
$response = new Response();
$response->setContent(json_encode(array('result' => $result)));
return $response;
}
public function getRegionTeams(Region $region)
{
$teams = $this->whoscored->loadStatistics('regionteams', array('id' => $region->getWsId()));
foreach ($teams as $team) {
if ($this->em->getRepository('AppBundle:Team')->findOneByWsId($team[0]) !== null) {
continue;
}
$ret = new Team();
$ret->setWsId($team[0]);
$ret->setName($team[1]);
$this->em->persist($ret);
unset($ret);
}
$this->em->flush();
}
/**
* Deletes a Team entity.
*
*/
public function deleteAction(Request $request, Team $team)
{
$em = $this->getDoctrine()->getManager();
$gameId = $team->getGame()->getId();
$query = $em->createQuery('SELECT u
FROM AppBundle:Application u
where u.team=' . $team->getId());
$applications = $query->getResult();
foreach ($applications as $application) {
$em->remove($application);
}
$query = $em->createQuery('SELECT u
FROM AppBundle:Player u
where u.team=' . $team->getId());
$players = $query->getResult();
foreach ($players as $player) {
$player->setTeam(null);
if ($player->getCapitain()) {
$player->setCapitain(null);
}
$em->persist($player);
}
$em->remove($team);
$em->flush();
return $this->forward('AppBundle:Game:show', array('id' => $gameId));
}
/**
* @Route("/Team/create")
*/
public function createActionTeam($teamName, $countryName)
{
$country = new Country();
$country->setCountryName($countryName);
$team = new Team();
$team->setCountryId($countryId);
$team->setTeamName($teamName);
// relate this product to the category
$team->setCountry($country);
$em = $this->getDoctrine()->getManager();
$em->persist($team);
$em->flush();
$teamArray[] = $team->getId();
$teamArray[] = $team->getCountryId();
$teamArray[] = $country->getId();
$teamArray[] = $country->getCountryName();
return new Response(json_encode($teamArray));
}
public function getGamesByTeam(Team $team)
{
return $this->createQueryBuilder('game')->select('game, team1, team2, country1, country2')->Where('game.team1 = :teamId')->orWhere('game.team2 = :teamId')->join('game.team1', 'team1')->join('game.team2', 'team2')->join('team1.country', 'country1')->join('team2.country', 'country2')->setParameter('teamId', $team->getId())->getQuery()->execute();
}
