src/Controller/SKOverlayController.php line 94

  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\CoreConfigData;
  6. use App\Kernel;
  7. use App\Service\CardImageService;
  8. use Doctrine\ORM\EntityManagerInterface;
  9. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  10. use Symfony\Component\DependencyInjection\Attribute\Autowire;
  11. use Symfony\Component\Filesystem\Filesystem;
  12. use Symfony\Component\Filesystem\Path;
  13. use Symfony\Component\Finder\Finder;
  14. use Symfony\Component\HttpFoundation\JsonResponse;
  15. use Symfony\Component\HttpFoundation\Request;
  16. use Symfony\Component\HttpFoundation\Response;
  17. use App\Service\MercurePublisher;
  18. use Symfony\Component\Routing\Attribute\Route;
  19. use Symfony\Component\Routing\Generator\UrlGeneratorInterface;
  20. use Symfony\Component\Serializer\Encoder\CsvEncoder;
  21. use Symfony\Component\Serializer\Encoder\JsonEncoder;
  22. use Symfony\Component\Serializer\Normalizer\ObjectNormalizer;
  23. use Symfony\Component\Serializer\Serializer;
  24. use Symfony\Contracts\HttpClient\Exception\TransportExceptionInterface;
  25. use Symfony\Contracts\HttpClient\HttpClientInterface;
  27. #[Route('/skoverlay')]
  28. class SKOverlayController extends AbstractController
  29. {
  31. #[Route('/', name: 'app_skoverlay_index')]
  32. public function app_skoverlay_index (
  33. ): Response {
  35. return $this->render("sk_overlay/index.html.twig");
  36. }
  38. #[Route('/set/{id<\w+>}/{context}', name: 'app_skoverlay_set')]
  39. public function app_skoverlay_set (
  40. EntityManagerInterface $entityManager,
  41. Request $request,
  42. string $id,
  43. string $context = ""
  44. ): Response {
  45. $core_config_data_repository = $entityManager->getRepository(CoreConfigData::class);
  47. $config_key = "app_coverage_engine_overlay";
  48. if ($id) $config_key .= "_{$id}";
  49. if ($context) $config_key .= "_{$context}";
  50. $config_key .= "_data";
  52. $processed = $core_config_data_repository->findOneBy([
  53. "config_key" => $config_key
  54. ]);
  56. if (!$processed) $processed = new CoreConfigData();
  58. $processed->setConfigKey("app_coverage_engine_overlay_{$id}_data")->setConfigValue($request->getContent());
  60. $entityManager->persist($processed);
  62. $entityManager->flush();
  64. return new JsonResponse(
  65. [
  66. "success" => true,
  67. ]
  68. );
  69. }
  71. #[Route('/push/{topic<\w+>}', name: 'app_skoverlay_push')]
  72. public function app_skoverlay_push (
  73. Request $request,
  74. MercurePublisher $mercurePublisher,
  75. $topic = "ANZID",
  76. ): Response {
  77. $mercurePublisher->publishRaw($topic, $request->getContent());
  79. return new JsonResponse(
  80. [
  81. "success" => true,
  82. "data" => $request->getContent(),
  83. ]
  84. );
  85. }
  87. #[Route('/get/{id<^\w+$>}/{context}', name: 'app_skoverlay_get')]
  88. public function app_skoverlay_get (
  89. EntityManagerInterface $entityManager,
  90. Request $request,
  91. string $id,
  92. string $context = ""
  93. ): Response {
  95. $core_config_data_repository = $entityManager->getRepository(CoreConfigData::class);
  97. $config_key = "app_coverage_engine_overlay";
  98. if ($id) $config_key .= "_{$id}";
  99. if ($context) $config_key .= "_{$context}";
  100. $config_key .= "_data";
  102. $processed = $core_config_data_repository->findOneBy([
  103. "config_key" => $config_key
  104. ]);
  106. if (!$processed) {
  107. return new JsonResponse(
  108. [
  109. "success" => false,
  110. "message" => "No configuration set for given string."
  111. ]
  112. );
  113. }
  115. return new JsonResponse(
  116. [
  117. "success" => true,
  118. "data" => json_decode($processed->getConfigValue())
  119. ]
  120. );
  122. }
  124. #[Route('/edit/{engine<^\w+$>}/{id<^\w+$>}/{delay<\d+>}', name: 'app_skoverlay_edit')]
  125. public function app_skoverlay_edit (
  126. $engine = "anzid",
  127. $id = "ANZID",
  128. $delay = 10000
  129. ): Response {
  130. $cardsearch = [];
  132. if ($engine == "cardoverlay") {
  133. $serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder()]);
  134. $cardsearch = json_encode($serializer->decode(file_get_contents("library/fab_cardlist.csv"), "csv"));
  135. }
  137. return $this->render("sk_overlay/edit/{$engine}.html.twig", [
  138. "console" => $id,
  139. "delay" => $delay,
  140. "cardsearch" => $cardsearch,
  141. ]);
  142. }
  145. #[Route('/view/{engine<^\w+$>}/{id<^\w+$>}/{delay<\d+>}', name: 'app_skoverlay_view')]
  146. public function app_skoverlay_view (
  147. Request $request,
  148. $engine = "anzid",
  149. $id = "ANZID",
  150. $delay = 10000
  151. ): Response {
  153. $safari = $request->query->get("safari") ?: 0;
  155. return $this->render("sk_overlay/view/{$engine}.html.twig", [
  156. "console" => $id,
  157. "delay" => $delay,
  158. "safari" => $safari,
  159. "get" => $request->query->all()
  160. ]);
  161. }
  163. #[Route('/cardsearch/{game}', name: 'app_skoverlay_cardsearch')]
  164. public function app_skoverlay_cardsearch (
  165. HttpClientInterface $client,
  166. Kernel $kernel,
  167. Request $request,
  168. CardImageService $cardImageService,
  169. #[Autowire('%env(PLAYERLINK_AC_TOURNAMENT_FORMAT)%')] string $tournamentFormat,
  170. $game = "fab"
  171. ): Response {
  172. $query = $request->query->get("q");
  173. if (strlen($query) < 2) return new JsonResponse([]);
  174. if ($game === "lorcana") {
  175. $serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder()]);
  176. $cardsearch = ($serializer->decode(file_get_contents("library/lorcana_cardlist.csv"), "csv"));
  178. return new JsonResponse($cardsearch);
  179. } else if ($game === "fab") {
  180. $serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder()]);
  181. $cardsearch = ($serializer->decode(file_get_contents("library/fab_cardlist.csv"), "csv"));
  183. return new JsonResponse($cardsearch);
  184. } else {
  185. $req = null;
  186. if ($game === "mtgarena") {
  187. $req = "https://api.scryfall.com/cards/search?q=$query+(f:$tournamentFormat)";
  188. } else {
  189. $req = "https://api.scryfall.com/cards/search?include_extras=true&unique=prints&q=$query";
  190. }
  191. try {
  192. $response = $client->request('GET', $req, [
  193. // 'headers' => [
  194. // 'Accept' => 'application/json',
  195. // ],
  196. 'timeout' => 5
  197. ]);
  198. } catch (TransportExceptionInterface $e) {
  199. return new JsonResponse([]);
  200. }
  201. $json = json_decode($response->getContent());
  203. $response_json = [];
  205. if ($game === "mtgarena") {
  206. foreach ($json->data as $element) {
  207. $cardNameTemp = $element->name;
  208. $setCodeTemp = strtoupper($element->set);
  210. $cardNameArray = [];
  212. if (str_contains($cardNameTemp, "//")) {
  213. $cardNameArray = explode("//", $cardNameTemp);
  214. } else {
  215. $cardNameArray[] = $cardNameTemp;
  216. }
  218. $time = time();
  220. foreach ($cardNameArray as $cardName) {
  221. // Use CardImageService to get the card image URL (tries CDN first, falls back to local)
  222. $cardImageRelativePath = $cardImageService->getCardImageUrl(trim($cardName), $setCodeTemp);
  224. if (!property_exists($element, "image_uris") && !property_exists($element, "card_faces")) continue;
  225. $response_json[] = [
  226. "cardname" => explode("//", $cardName, 2)[0] . " (" . $element->set_name . ")",
  227. "url" => $cardImageRelativePath
  228. ];
  229. }
  231. }
  232. } else {
  233. foreach ($json->data as $element) {
  234. if (!property_exists($element, "image_uris")) continue;
  235. $cardImageRelativePath = $element->image_uris->png;
  237. $response_json[] = [
  238. "cardname" => $element->name . " (" . $element->set_name . ")",
  239. "url" => $cardImageRelativePath
  240. ];
  241. }
  242. }
  245. return new JsonResponse($response_json);
  246. }
  247. }
  249. #[Route('/playerview/{id}', name: 'app_skoverlay_playerview')]
  250. public function app_skoverlay_playerview (
  251. $id = 1943
  252. ): Response {
  253. $serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder()]);
  254. $demographics = ($serializer->decode(file_get_contents("library/fab_ptdemographics.csv"), "csv"));
  256. foreach ($demographics as $demographic) {
  257. if ($demographic["player_id"] == $id) {
  258. return $this->render("sk_overlay/view/playerview.html.twig", [
  259. "player" => $demographic
  260. ]);
  261. }
  262. }
  264. var_dump($demographics);
  266. return new Response();
  268. }
  270. #[Route('/playerhistory/{id}', name: 'app_skoverlay_playerhistory')]
  271. public function app_skoverlay_playerhistory (
  272. $id = 1943
  273. ): Response {
  274. $serializer = new Serializer([new ObjectNormalizer()], [new CsvEncoder()]);
  275. $demographics = ($serializer->decode(file_get_contents("library/fab_ptdemographics.csv"), "csv"));
  277. foreach ($demographics as $demographic) {
  278. if ($demographic["player_id"] == $id) {
  280. $history = [];
  281. for ($i = 1; $i <= 14; $i++) {
  282. if (array_key_exists("m" . $i . "_opponent", $demographic)) {
  283. $history[$i] = [
  284. "round" => $i,
  285. "opponent" => $demographic["m" . $i . "_opponent"],
  286. "hero" => $demographic["m" . $i . "_opp_hero"],
  287. "result" => $demographic["m" . $i . "_result"],
  288. ];
  289. }
  290. }
  292. return $this->render("sk_overlay/view/playerhistory.html.twig", [
  293. "player" => $demographic,
  294. "history" => $history,
  295. ]);
  296. }
  297. }
  299. var_dump($demographics);
  301. return new Response();
  303. }
  305. #[Route('/standings/{page}', name: 'app_skoverlay_standings')]
  306. public function app_skoverlay_standings (
  307. Kernel $kernel,
  308. HttpClientInterface $httpClient,
  309. Request $request,
  310. EntityManagerInterface $entityManager,
  311. Int $page,
  312. ): Response {
  314. $core_config_data_repository = $entityManager->getRepository(CoreConfigData::class);
  316. $config_key = "app_coverlay_eventdata";
  318. $value = $core_config_data_repository->findOneBy([
  319. "config_key" => $config_key
  320. ]);
  322. $event_json = json_decode($value->getConfigValue());
  324. $round_id = ($event_json->standings_round);
  326. $standings_response = $httpClient->request(
  327. 'GET',
  328. $this->generateUrl("app_coverlay_fn_cachestandings", array("id" => $round_id),UrlGeneratorInterface::ABSOLUTE_URL
  329. )
  330. );
  332. $json = json_decode($standings_response->getContent());
  334. return $this->render('c_overlay/view/magicanzid_standings.html.twig', [
  335. "standings" => array_slice($json, ($page - 1) * 16, 16),
  336. "page" => $page - 1,
  337. ]);
  339. }
  341. #[Route('/standingsnyse/{round}/{page}', name: 'app_skoverlay_standingsnyse')]
  342. public function app_skoverlay_standingsnyse (
  343. Kernel $kernel,
  344. HttpClientInterface $httpClient,
  345. Request $request,
  346. EntityManagerInterface $entityManager,
  347. Int $round,
  348. Int $page,
  349. ): Response {
  351. $standings_response = $httpClient->request(
  352. 'GET',
  353. $this->generateUrl("app_coverlay_fn_cachestandings", array("id" => $round),UrlGeneratorInterface::ABSOLUTE_URL
  354. )
  355. );
  357. $json = json_decode($standings_response->getContent());
  359. return $this->render('c_overlay/view/magicnyse_standings.html.twig', [
  360. "standings" => array_slice($json, ($page - 1) * 16, 16),
  361. "page" => $page - 1,
  362. ]);
  364. }
  367. #[Route('/newstandings/{page}/{round}', name: 'app_skoverlay_newstandings')]
  368. public function app_skoverlay_newstandings (
  369. Kernel $kernel,
  370. HttpClientInterface $httpClient,
  371. Request $request,
  372. EntityManagerInterface $entityManager,
  373. Int $page,
  374. Int $round = -1
  375. ): Response {
  377. $standings_export_path = $this->getParameter('kernel.project_dir') . '/private/lorcana_standings.csv';
  379. $filesystem = new Filesystem();
  381. $standings = [];
  383. if ($filesystem->exists($standings_export_path)) {
  384. $standings_file = file_get_contents($standings_export_path);
  385. $encoder = new CsvEncoder();
  386. $standings = $encoder->decode($standings_file, "csv");
  387. }
  389. // $standings = [];
  390. //
  391. // for ($i = 1; $i < 100; $i++) {
  392. //
  393. // $standings[] = (object) [
  394. // "FirstName" => "Player",
  395. // "LastName" => "Player",
  396. // "Points" => 10
  397. // ];
  398. //
  399. // }
  401. return $this->render('c_overlay/view/lorcana_standings.html.twig', [
  402. "standings" => array_slice($standings, ($page - 1) * 16, 16),
  403. "page" => $page - 1,
  404. ]);
  406. }
  408. private function usort_helper($a, $b) {
  409. if ($a < $b) { return 1; }
  410. if ($a > $b) { return -1; }
  411. return 0;
  412. }
  414. #[Route('/playerstowatch/{page}/{round}', name: 'app_skoverlay_playerstowatch')]
  415. public function app_skoverlay_playerstowatch (
  416. Kernel $kernel,
  417. HttpClientInterface $httpClient,
  418. Request $request,
  419. EntityManagerInterface $entityManager,
  420. Int $page,
  421. Int $round = -1
  422. ): Response {
  424. $playerdata = $this->_getDecklistPlayerData();
  426. $core_config_data_repository = $entityManager->getRepository(CoreConfigData::class);
  428. $config_key = "app_coverlay_eventdata";
  430. $value = $core_config_data_repository->findOneBy([
  431. "config_key" => $config_key
  432. ]);
  434. $event_json = json_decode($value->getConfigValue());
  436. $current_round = substr($event_json->broadcast_round,1);
  437. if ($round > -1) $current_round = $round;
  439. $current_round = max(1, $current_round - 1);
  441. $standings_api_path = $this->getParameter('kernel.project_dir') . '/private/tournament_standings_'.$current_round.'_api.json';
  442. $standings_export_path = $this->getParameter('kernel.project_dir') . '/private/tournament_standings_'.$current_round.'_export.csv';
  444. $filesystem = new Filesystem();
  446. $standings = [];
  448. if ($filesystem->exists($standings_export_path)) {
  449. $standings_file = file_get_contents($standings_export_path);
  450. $encoder = new CsvEncoder();
  451. $standings = $encoder->decode($standings_file, "csv");
  452. } else if ($filesystem->exists($standings_api_path)) {
  453. $standings_file = file_get_contents($standings_api_path);
  454. $encoder = new JsonEncoder();
  455. $standings = $encoder->decode($standings_file, "json");
  456. } else {
  458. }
  462. return $this->render('c_overlay/view/magicanzid_playerstowatch.html.twig', [
  463. "standings" => $standings,
  464. "playerlist" => [
  465. "Aintrazi, Ali",
  466. "Anderson, Todd",
  467. "Baeckstrom, Andrew",
  468. "Brodie, Daniel",
  469. // "Bursavich, Austin",
  470. "Clark, Mason",
  471. "Corrigan, Michael",
  472. "Kiihne, Zachary",
  473. "Krueger, Will",
  474. "Loveman, Eli",
  475. "Malka, Sol",
  476. "mcvety, max",
  477. "Merriam, Ross",
  478. "Nettles, Logan",
  479. "Pardee, Carolyn",
  480. "Pardee, Samuel",
  481. "Rabin, Noah",
  482. "Snook, Adam",
  483. "Stein, Abraham",
  484. "Steuer, Nathan",
  485. "Syed, Zan",
  486. "Taylor, Robert",
  487. "Warfield, Skyler",
  488. "Yu, Jarvis",
  489. ]
  490. ]);
  492. }
  494. #[Route('/archetypes/{page}/{format}', name: 'app_skoverlay_archetypes')]
  495. public function app_skoverlay_archetypes (
  496. Kernel $kernel,
  497. HttpClientInterface $httpClient,
  498. Request $request,
  499. EntityManagerInterface $entityManager,
  500. Int $page,
  501. $format = "Pioneer"
  502. ): Response {
  504. $archetypes = [];
  505. $total = 0;
  507. $playerdata = $this->_getDecklistPlayerData();
  509. foreach ($playerdata as $player) {
  511. foreach ($player->Decklists as $decklist) {
  512. if ($decklist->Format == $format) {
  513. if (!array_key_exists($decklist->Name, $archetypes)) {
  514. $archetypes[$decklist->Name] = [
  515. "archetype" => $decklist->Name,
  516. "count" => 0,
  517. "percent" => 0,
  518. "keycards" => []
  519. ];
  520. }
  521. $archetypes[$decklist->Name]["count"]++;
  522. $total++;
  523. }
  524. }
  525. }
  527. foreach ($archetypes as &$archetype) {
  528. $archetype["percent"] = $archetype["count"] / $total;
  529. }
  531. usort($archetypes, function($a, $b) {
  532. return $b["count"] - $a["count"];
  533. });
  535. return $this->render('c_overlay/view/magicanzid_archetypes.html.twig', [
  536. "archetypes" => array_slice($archetypes, ($page - 1) * 12, 12),
  537. "format" => $format
  538. ]);
  540. }
  543. private function _getDecklistPlayerData() {
  544. $player_path = $this->getParameter('kernel.project_dir') . '/private/tournament_players.json';
  545. $player_file = file_get_contents($player_path);
  546. $player_json = json_decode($player_file);
  548. $players = [];
  550. foreach ($player_json as $element) {
  551. $players[$element->ID] = $element;
  552. }
  554. $decklist_path = $this->getParameter('kernel.project_dir') . '/private/tournament_decklists.json';
  555. $decklist_file = file_get_contents($decklist_path);
  556. $decklist_json = json_decode($decklist_file);
  558. foreach ($decklist_json as $element) {
  559. if (!array_key_exists($element->PlayerId, $players)) { continue; }
  560. foreach ($players[$element->PlayerId]->Decklists as $decklist) {
  561. if ($decklist->ID === $element->ID) {
  562. if ($element->Format == "Draft") {
  563. $colors = [
  564. "W" => false,
  565. "U" => false,
  566. "B" => false,
  567. "R" => false,
  568. "G" => false,
  569. ];
  571. foreach ($element->Cards as $card) {
  572. if (!$card->IsSideboard) {
  573. foreach (["W", "U", "B", "R", "G"] as $color) {
  574. if (str_contains($card->CardManaCost, $color)) {
  575. $colors[$color] = true;
  576. }
  577. }
  578. }
  579. }
  581. $element->IsWhite = $colors["W"];
  582. $element->IsBlue = $colors["U"];
  583. $element->IsBlack = $colors["B"];
  584. $element->IsRed = $colors["R"];
  585. $element->IsGreen = $colors["G"];
  587. $element->White = $colors["W"] ? 1 : 0;
  588. $element->Blue = $colors["U"] ? 1 : 0;
  589. $element->Black = $colors["B"] ? 1 : 0;
  590. $element->Red = $colors["R"] ? 1 : 0;
  591. $element->Green = $colors["G"] ? 1 : 0;
  593. }
  595. $decklist->Decklist = $element;
  596. }
  597. }
  598. }
  600. ksort($players);
  602. return $players;
  603. }
  605. private function _getPlayerData() {
  606. $player_path = $this->getParameter('kernel.project_dir') . '/private/tournament_players.json';
  607. $player_file = file_get_contents($player_path);
  608. $player_json = json_decode($player_file);
  610. $players = [];
  612. foreach ($player_json as $element) {
  613. $players[$element->ID] = $element;
  614. }
  618. $decklist_path = $this->getParameter('kernel.project_dir') . '/private/tournament_decklists.json';
  619. $decklist_file = file_get_contents($decklist_path);
  620. $decklist_json = json_decode($decklist_file);
  622. if (!$decklist_json->Error) {
  624. foreach ($decklist_json as $element) {
  625. foreach ($players[$element->PlayerId]->Decklists as $decklist) {
  626. if ($decklist->ID === $element->ID) {
  627. $decklist->Decklist = $element;
  628. }
  629. }
  630. }
  632. }
  634. return $players;
  635. }
  637. #[Route('/anziddecklist/{match}/{player}', name: 'app_coverlay_anziddecklist')]
  638. public function app_coverlay_decksideboard (
  639. Kernel $kernel,
  640. HttpClientInterface $httpClient,
  641. Request $request,
  642. EntityManagerInterface $entityManager,
  643. String $match,
  644. String $player
  645. ): Response {
  647. $core_config_data_repository = $entityManager->getRepository(CoreConfigData::class);
  649. $config_key = "app_coverlay_eventdata";
  651. $value = $core_config_data_repository->findOneBy([
  652. "config_key" => $config_key
  653. ]);
  655. $event_json = json_decode($value->getConfigValue());
  657. $config_key = "app_coverlay_matchdata_" . $event_json->broadcast_round . "_m" .$match;
  659. $value = $core_config_data_repository->findOneBy([
  660. "config_key" => $config_key
  661. ]);
  663. $match_json = json_decode($value->getConfigValue());
  665. $playerdata = $this->_getDecklistPlayerData();
  667. $deck = [
  668. "main" => [],
  669. "side" => []
  670. ];
  672. $decklist_player = null;
  674. $colors = [
  675. "W" => false,
  676. "U" => false,
  677. "B" => false,
  678. "R" => false,
  679. "G" => false,
  680. ];
  682. foreach ($playerdata[$match_json->{"p".$player."_name"}]->Decklists as $decklist) {
  683. if ($decklist->Format == $match_json->format) {
  684. $decklist_player = $decklist->Decklist;
  685. foreach (array_merge($decklist->Decklist->Cards, $decklist->Decklist->Sideboard) as $card) {
  686. if ($card->IsSideboard) {
  687. $deck["side"][] = [
  688. "cardname" => explode(" // ", $card->CardName)[0],
  689. "quantity" => $card->Quantity,
  690. ];
  691. } else {
  692. $deck["main"][] = [
  693. "cardname" => explode(" // ", $card->CardName)[0],
  694. "quantity" => $card->Quantity,
  695. ];
  696. foreach (["W", "U", "B", "R", "G"] as $color) {
  697. if (str_contains($card->CardManaCost, $color)) {
  698. $colors[$color] = true;
  699. }
  700. }
  701. }
  702. }
  703. }
  704. }
  706. if (strtoupper($decklist_player->Archetype) == "ALL OTHER DECKLISTS") {
  707. $decklist_player->Archetype = "";
  708. }
  710. return $this->render("c_overlay/view/magicanzid_decklist.html.twig", [
  711. "player" => $decklist_player,
  712. "decklist" => $deck,
  713. "colors" => $colors
  714. ]);
  715. }
  717. }