src/Network/Controller/NetworkTabNavigationController.php line 55

Open in your IDE?
  1. <?php
  3. namespace App\Network\Controller;
  5. use App\Network\Service\NetworkProfileService;
  6. use App\Profile\Model\Profile;
  7. use App\Profile\Service\ProfileService;
  8. use Carbon\Carbon;
  9. use Doctrine\DBAL\Query\QueryBuilder;
  10. use Pimcore\Controller\FrontendController;
  11. use Pimcore\Model\DataObject\Auction;
  12. use Pimcore\Model\DataObject\Raceday;
  13. use Symfony\Component\HttpFoundation\Request;
  14. use Symfony\Component\HttpFoundation\Response;
  15. use Symfony\Component\Routing\Annotation\Route;
  17. #[Route([
  18.   'name' => 'profile_tab_navigation_',
  19.   'localizedPaths' => [
  20.     'en' => '/{_locale}/tabnav',
  21.     'de' => '/{_locale}/tabnav',
  22.     'fr' => '/{_locale}/tabnav',
  23.   ],
  24. ])]
  25. class NetworkTabNavigationController extends FrontendController
  26. {
  27.   #[Route('/{id}/timeline', name: 'timeline')]
  28.   public function timeline(Request $request, $id, NetworkProfileService $networkProfileService, ProfileService $profileService): Response
  29.   {
  30.     $profile = Profile::getById($id);
  32.     $subprofileKeys = $profileService->getActiveSubProfileIdentifiers($profile);
  34.     $horses = $networkProfileService->getAssociatedHorsesByProfile($subprofileKeys, $profile);
  35.     $auctionEvents = $networkProfileService->getFutureAuctionsByProfile($profile);
  36.     $raceEvents = $networkProfileService->getFutureRacedaysByProfile($profile);
  37.     $marketplacePosts = $networkProfileService->getLatestMarketplacePostsByProfile($profile);
  38.     // dd();
  40.     $request->setRequestFormat('text/html');
  42.     return $this->renderForm('network/profile/sections/profile_section_timeline.html.twig', [
  43.       'user' => $this->getUser(),
  44.       'profile' => Profile::getById($id),
  45.       'highlightedPost' => $request->get('highlightedPost'),
  46.       'horses' => $horses,
  47.       'raceEvents' => $raceEvents,
  48.       'auctionEvents' => $auctionEvents,
  49.       'marketplacePosts' => $marketplacePosts,
  50.       // 'horseEvents' => ['auctions' => $horseAuctions, 'racedays' => $horseRacedays],
  51.     ]);
  52.   }
  54.   #[Route('/{id}/achievements', name: 'achievements')]
  55.   public function achievements(Request $request, $id, NetworkProfileService $networkProfileService, ProfileService $profileService): Response
  56.   {
  57.     $profile = Profile::getById($id);
  58.     $achievementCategories = $networkProfileService->getAchievementCategoriesByProfile($profile);
  60.     // dd();
  61.     $request->setRequestFormat('text/html');
  63.     return $this->renderForm('network/profile/sections/profile_section_achievements.html.twig', [
  64.       'user' => $this->getUser(),
  65.       'profile' => $profile,
  66.       'categories' => $achievementCategories,
  68.       // 'horseEvents' => ['auctions' => $horseAuctions, 'racedays' => $horseRacedays],
  69.     ]);
  70.   }
  72.   #[Route('/{id}/news', name: 'news')]
  73.   public function news(Request $request, $id): Response
  74.   {
  75.     $request->setRequestFormat('text/html');
  77.     return $this->renderForm('network/profile/sections/profile_section_news.html.twig', [
  78.       'user' => $this->getUser(),
  79.       'profile' => Profile::getById($id),
  81.       // 'horseEvents' => ['auctions' => $horseAuctions, 'racedays' => $horseRacedays],
  82.     ]);
  83.   }
  85.   #[Route('/{id}/network', name: 'network')]
  86.   public function network(Request $request, $id): Response
  87.   {
  88.     return $this->renderForm('network/profile/sections/profile_section_network.html.twig', [
  89.       'user' => $this->getUser(),
  90.       'profile' => Profile::getById($id),
  91.     ]);
  92.   }
  94.   #[Route('/{id}/references', name: 'references')]
  95.   public function references(Request $request, $id): Response
  96.   {
  97.     return $this->renderForm('network/profile/sections/profile_section_references.html.twig', [
  98.       'user' => $this->getUser(),
  99.       'profile' => Profile::getById($id),
  100.     ]);
  101.   }
  103.   #[Route('/{id}/team', name: 'team')]
  104.   public function team(Request $request, $id): Response
  105.   {
  106.     return $this->renderForm('network/profile/sections/profile_section_team.html.twig', [
  107.       'user' => $this->getUser(),
  108.       'profile' => Profile::getById($id),
  109.     ]);
  110.   }
  112.   #[Route('/{id}/horse-lists', name: 'horse_lists')]
  113.   public function horses(Request $request, $id, NetworkProfileService $networkProfileService, ProfileService $profileService): Response
  114.   {
  115.     $profile = Profile::getById($id);
  116.     $subprofileKeys = $profileService->getActiveSubProfileIdentifiers($profile);
  118.     $horses = $networkProfileService->getAssociatedHorsesByProfile($subprofileKeys, $profile);
  120.     $profile = Profile::getById($id);
  122.     $horseRacedays = Raceday::getList();
  124.     $horseRacedays->onCreateQueryBuilder(function (QueryBuilder $queryBuilder) use ($profile) {
  125.       $queryBuilder->join('object_raceday', 'object_horse', 'horse', 'horses LIKE CONCAT("%", `horse`.`oo_id` , "%")');
  126.       $queryBuilder->where('object_raceday.date >= "'.Carbon::now()->format('Y-m-d').'" AND object_raceday.horses IS NOT NULL AND (horse.racingmanager__id ='.$profile->getId().' OR horse.jockey__id ='.$profile->getId().' OR horse.owner__id ='.$profile->getId().' OR horse.breeder__id ='.$profile->getId().' OR horse.trainer__id ='.$profile->getId().')');
  127.       $queryBuilder->orderBy('object_raceday.date', 'ASC');
  128.       $queryBuilder->distinct();
  129.       $queryBuilder->setMaxResults(3);
  130.     });
  132.     $horseAuctions = Auction::getList();
  133.     $horseAuctions->onCreateQueryBuilder(function (QueryBuilder $queryBuilder) use ($profile) {
  134.       $queryBuilder->innerJoin('object_auction', 'object_horse', 'horse', 'horses LIKE CONCAT("%", `horse`.`oo_id` , "%")');
  135.       $queryBuilder->where('end >="'.Carbon::now()->format('Y-m-d').'" AND horses IS NOT NULL AND (horse.racingmanager__id ='.$profile->getId().' OR horse.jockey__id ='.$profile->getId().' OR horse.owner__id ='.$profile->getId().' OR horse.breeder__id ='.$profile->getId().' OR horse.trainer__id ='.$profile->getId().')');
  136.       $queryBuilder->distinct();
  137.       $queryBuilder->setMaxResults(3);
  138.     });
  140.     return $this->renderForm('network/profile/sections/profile_section_horses.html.twig', [
  141.       'user' => $this->getUser(),
  142.       'profile' => $profile,
  143.       'managedHorses' => $horses['managedHorses'],
  144.       'trainedHorses' => $horses['trainedHorses'],
  145.       'ownedHorses' => $horses['ownedHorses'],
  146.       'bredHorses' => $horses['bredHorses'],
  147.       'auctionEvents' => $horseAuctions,
  148.       'racedayEvents' => $horseRacedays,
  149.     ]);
  150.   }
  152.   // #[Route('/{id}/horse-events', name: 'horse_events')]
  153.   // public function horseEvents(Request $request, $id, NetworkProfileService $networkProfileService, ProfileService $profileService): Response
  154.   // {
  155.   //   $profile = Profile::getById($id);
  157.   //   $horseRacedays = Raceday::getList();
  159.   //   $horseRacedays->onCreateQueryBuilder(function (QueryBuilder $queryBuilder) use ($profile) {
  160.   //     $queryBuilder->join('object_raceday', 'object_horse', 'horse', 'horses LIKE CONCAT("%", `horse`.`oo_id` , "%")');
  161.   //     $queryBuilder->where('object_raceday.date >= "'.Carbon::now()->format('Y-m-d').'" AND object_raceday.horses IS NOT NULL AND (horse.racingmanager__id ='.$profile->getId().' OR horse.jockey__id ='.$profile->getId().' OR horse.owner__id ='.$profile->getId().' OR horse.breeder__id ='.$profile->getId().' OR horse.trainer__id ='.$profile->getId().')');
  162.   //     $queryBuilder->orderBy('object_raceday.date', 'ASC');
  163.   //     $queryBuilder->distinct();
  164.   //     $queryBuilder->setMaxResults(3);
  165.   //   });
  167.   //   $horseAuctions = Auction::getList();
  168.   //   $horseAuctions->onCreateQueryBuilder(function (QueryBuilder $queryBuilder) use ($profile) {
  169.   //     $queryBuilder->innerJoin('object_auction', 'object_horse', 'horse', 'horses LIKE CONCAT("%", `horse`.`oo_id` , "%")');
  170.   //     $queryBuilder->where('end >="'.Carbon::now()->format('Y-m-d').'" AND horses IS NOT NULL AND (horse.racingmanager__id ='.$profile->getId().' OR horse.jockey__id ='.$profile->getId().' OR horse.owner__id ='.$profile->getId().' OR horse.breeder__id ='.$profile->getId().' OR horse.trainer__id ='.$profile->getId().')');
  171.   //     $queryBuilder->distinct();
  172.   //     $queryBuilder->setMaxResults(3);
  173.   //   });
  175.   //   return $this->renderForm('network/profile/sections/profile_section_horse_events.html.twig', [
  176.   //     'user' => $this->getUser(),
  177.   //     'profile' => $profile,
  178.   //     'auctionEvents' => $horseAuctions,
  179.   //     'racedayEvents' => $horseRacedays,
  180.   //   ]);
  181.   // }
  183.   #[Route('/{id}/auctions', name: 'auctions')]
  184.   public function auctions(Request $request, $id): Response
  185.   {
  186.     $profile = Profile::getById($id);
  188.     return $this->renderForm('network/profile/sections/profile_section_auctions.html.twig', [
  189.       'user' => $this->getUser(),
  190.       'profile' => $profile,
  191.     ]);
  192.   }
  194.   #[Route('/{id}/racedays', name: 'raceday_list')]
  195.   public function racedays(Request $request, $id): Response
  196.   {
  197.     $profile = Profile::getById($id);
  199.     return $this->renderForm('network/profile/sections/profile_section_racedays.html.twig', [
  200.       'user' => $this->getUser(),
  201.       'profile' => $profile,
  202.     ]);
  203.   }
  204. // {% do tab_navigation_add({ name: 'network', action: 'network' }) %}
  205. // {% do tab_navigation_add({ name: 'references', action: 'references_list' }) %}
  206. // {% do tab_navigation_add({ name: 'team', action: 'team' }) %}
  207. }