src/Controller/AllegroDataAdsController.php line 505

Open in your IDE?
  1. <?php
  3. namespace App\Controller;
  5. use App\Entity\AllegroDataAds;
  6. use App\Entity\Project;
  7. use App\Entity\RaportAdsNew;
  8. use App\Entity\RaportDate;
  9. use App\Form\RaportAdsFilterType;
  10. use App\Form\RaportAdsNewType;
  11. use App\Form\RaportDateType;
  12. use App\Module\Slack\SlackManager;
  13. use App\Repository\AllegroDataAdsRepository;
  14. use App\Repository\ProjectRepository;
  15. use App\Repository\RaportAdsNewRepository;
  16. use App\Repository\RaportDateRepository;
  17. use App\Service\PaginationService;
  18. use Doctrine\Common\Collections\ArrayCollection;
  19. use PhpOffice\PhpSpreadsheet\Spreadsheet;
  20. use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
  21. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
  22. use Symfony\Component\HttpFoundation\JsonResponse;
  23. use Symfony\Component\HttpFoundation\Request;
  24. use Symfony\Component\HttpFoundation\Response;
  25. use Symfony\Component\HttpFoundation\StreamedResponse;
  26. use Symfony\Component\Routing\Annotation\Route;
  27. use Symfony\Component\Serializer\SerializerInterface;
  29. class AllegroDataAdsController extends AbstractController
  30. {
  31.     /**
  32.      * @Route("/allegro-data-ads", name="allegro_data_ads", methods={"POST"})
  33.      */
  34.     public function index(Request $request, AllegroDataAdsRepository $allegroDataAdsRepository, ProjectRepository $projectRepository): Response
  35.     {
  36.         return $this->json(["error" => false, "message" => "success"]);
  37.         if (!$request->getContent()) {
  38.             return $this->json(["error" => true, "message" => "request body don't have a data field"]);
  39.         }
  41.         $data = json_decode($request->getContent(), true);
  42.         if (!$data) {
  43.             return $this->json(["error" => true, "message" => "json not valid"]);
  44.         }
  45.         $project = $projectRepository->findProjectByAllegroName($data['nickname']);
  47.         $allegroDataAds = new AllegroDataAds();
  48.         $allegroDataAds->setData($data)
  49.             ->setProject($project[0] ?? null)
  50.             ->setDate(new \DateTimeImmutable($data['date']." 12:00"));
  52.         $allegroDataAdsRepository->save($allegroDataAds);
  53. //
  54. //        $allegroData = null;
  55. //        if(!isset($data['file'])) {
  56. //            $allegroData = $allegroDataAdsRepository->findData($data['nickname'], new \DateTimeImmutable($data['date']." 12:00"));
  57. //        }
  58. //
  59. //        if ($allegroData) {
  60. //            foreach($allegroData as $allData) {
  61. //                if (isset($data['file']) && isset($allData->getData['file']) ||
  62. //                    !isset($data['file']) && !isset($allData->getData['file'])) {
  63. //                    $allData->setData($data);
  64. //                    $allegroDataAdsRepository->save($allData);
  65. //
  66. //                    break;
  67. //                }
  68. //            }
  69. //        } else {
  70. //            $allegroDataAds = new AllegroDataAds();
  71. //            $allegroDataAds->setData($data)
  72. //                ->setProject($project[0] ?? null)
  73. //                ->setDate(new \DateTimeImmutable($data['date']." 12:00"));
  74. //
  75. //            $allegroDataAdsRepository->save($allegroDataAds);
  76. //        }
  78.         return $this->json(["error" => false, "message" => "success"]);
  79.     }
  81.     /**
  82.      * @Route("/raport-ads", name="allegro_ads_chart")
  83.      */
  84.     public function list(Request $request, RaportAdsNewRepository $raportAdsNewRepository, PaginationService $paginationService)
  85.     {
  86.         $page = $request->get("page") ?? 1;
  87.         $user = $this->getUser();
  88.         $leader = null;
  89.         if ($this->isGranted("ROLE_EMPLOYER") || $this->isGranted("ROLE_ADMIN")) {
  90.             $user = null;
  91.         }
  93.         $form = $this->createForm(RaportAdsFilterType::class, null, [
  94.             'user' => $this->getUser(),
  95.         ]);
  96.         $form->handleRequest($request);
  98.         if ($form->isSubmitted() && $form->isValid()) {
  99.             /** @var Project $project */
  100.             $project = $form->get('project')->getData();
  101.             if ($project) {
  102.                 $user = $project->getClient()->first();
  103.             }
  105.             if ($this->isGranted("ROLE_EMPLOYER")) {
  106.                 $leaderData = $form->get('users')->getData();
  107.                 if ($leaderData) {
  108.                     $leader = $leaderData;
  109.                 }
  110.             }
  111.         }
  113.         $raports = $raportAdsNewRepository->getRaportList($page, $user, $leader);
  116.         return $this->render('allegro_data_ads/index.html.twig', [
  117.             'raports'    => $raports,
  118.             'form'       => $form->createView(),
  119.             'page'       => $page,
  120.             'pagination' => $paginationService->paginate(
  121.                 $raportAdsNewRepository->countReportForUser($user),
  122.                 $page
  123.             ),
  124.         ]);
  125.     }
  127.     /**
  128.      * @Route("/data-raportu", name="allegro_ads_raport_date")
  129.      */
  130.     public function newRaportDate(Request $request, RaportDateRepository $raportDateRepository)
  131.     {
  132.         $raportDate = new RaportDate();
  134.         $form = $this->createForm(RaportDateType::class, $raportDate);
  135.         $form->handleRequest($request);
  137.         if ($form->isSubmitted() && $form->isValid()) {
  138.             $raportDateRepository->save($raportDate);
  140.             $this->addFlash("success", "Pomyślnie dodana data");
  142.             return $this->redirectToRoute('allegro_ads_raport_date');
  143.         }
  145.         return $this->render('allegro_data_ads/raport_date.html.twig', [
  146.             'form'           => $form->createView(),
  147.             'nextRaportList' => $raportDateRepository->getAllNextRaportDate(),
  148.         ]);
  149.     }
  151.     /**
  152.      * @Route("/data-raportu-usun/{date}", name="allegro_ads_raport_date_delete")
  153.      */
  154.     public function deleteRaportDateDelete(RaportDateRepository $raportDateRepository, RaportDate $date)
  155.     {
  156.         $raportDateRepository->remove($date);
  157.         $this->addFlash("info", "Pomyślnie usunięta data");
  159.         return $this->redirectToRoute('allegro_ads_raport_date');
  160.     }
  162.     /**
  163.      * @Route("/allegro-ads/nowy", name="allegro_ads_new")
  164.      */
  165.     public function new(Request $request, RaportAdsNewRepository $raportAdsNewRepository)
  166.     {
  167.         $allegroAdsNew = new RaportAdsNew();
  169.         $form = $this->createForm(RaportAdsNewType::class, $allegroAdsNew, [
  170.             'user'      => $this->getUser(),
  171.             'rangeDate' => "",
  172.         ]);
  173.         $form->handleRequest($request);
  175.         if ($form->isSubmitted() && $form->isValid()) {
  176.             $date = explode("do", $form->get("rangeDate")->getData());
  177.             $from = $date[0];
  178.             $to = $date[1];
  179.             $allegroAdsNew->setAccount($form->get('account')->getViewData())
  180.                 ->setDateFrom(new \DateTime($from))
  181.                 ->setDateTo(new \DateTime($to))
  182.                 ->setTypeGraphicStatistic($_REQUEST['type-graphic-statistic'])
  183.                 ->setTypeStatistic($_REQUEST['type-statistic']);
  184.             $raportAdsNewRepository->save($allegroAdsNew);
  186.             return $this->redirectToRoute('allegro_ads_chart');
  187.         }
  189.         return $this->render('allegro_data_ads/new.html.twig', [
  190.             'form' => $form->createView(),
  191.         ]);
  192.     }
  194.     /**
  195.      * @Route("/allegro-ads/edytuj/{allegroAdsNew}", name="allegro_ads_edit")
  196.      */
  197.     public function edit(Request $request, RaportAdsNewRepository $raportAdsNewRepository, RaportAdsNew $allegroAdsNew)
  198.     {
  199.         $form = $this->createForm(RaportAdsNewType::class, $allegroAdsNew, [
  200.             'user'      => $this->getUser(),
  201.             'rangeDate' => $allegroAdsNew->getDateFrom()->format("Y-m-d")." to ".$allegroAdsNew->getDateTo()->format("Y-m-d"),
  202.         ]);
  203.         $form->handleRequest($request);
  205.         if ($form->isSubmitted() && $form->isValid()) {
  206.             $date = explode("do", $form->get("rangeDate")->getData());
  207.             $from = $date[0];
  208.             $to = isset($date[1]) ? $date[1] : $date[0];
  209.             $allegroAdsNew->setAccount($form->get('account')->getViewData())
  210.                 ->setDateFrom(new \DateTime($from))
  211.                 ->setDateTo(new \DateTime($to));
  212.             $raportAdsNewRepository->save($allegroAdsNew);
  214.             return $this->redirectToRoute('allegro_ads_chart');
  215.         }
  217.         return $this->render('allegro_data_ads/new.html.twig', [
  218.             'form' => $form->createView(),
  219.         ]);
  220.     }
  222.     /**
  223.      * @Route("/allegro-ads/usun/{allegroAdsNew}", name="allegro_ads_remove")
  224.      */
  225.     public function remove(Request $request, RaportAdsNewRepository $raportAdsNewRepository, RaportAdsNew $allegroAdsNew)
  226.     {
  227.         $raportAdsNewRepository->remove($allegroAdsNew);
  229.         return $this->redirectToRoute('allegro_ads_chart');
  230.     }
  232.     /**
  233.      * @Route("/allegro-ads-slack/{allegroAdsNew}", name="allegro_ads_slack")
  234.      */
  235.     public function slack(SlackManager $slackManager, RaportAdsNew $allegroAdsNew)
  236.     {
  237.         $link = "<https://czas.qsell.pl".$this->generateUrl('allegro_ads_new_show', ["raportAdsNew" => $allegroAdsNew->getId()])."|".$allegroAdsNew->getAccount().">";
  238.         $slackManager->write(":chart_with_upwards_trend: *PRZYGOTOWANY ZOSTAŁ RAPORT ALLEGRO ADS DLA KONTA:* ".PHP_EOL.PHP_EOL."*".$allegroAdsNew->getAccount()."*".PHP_EOL.PHP_EOL.":arrow_right: KLIKNIJ (".$link.") ABY SPRAWDZIĆ", $allegroAdsNew->getProject()->getClientSlackChannelId());
  240.         return $this->redirectToRoute('allegro_ads_chart');
  241.     }
  243.     /**
  244.      * @Route("/allegro-ads/pobierz/{raportAdsNew}", name="allegro_ads_new_download")
  245.      */
  246.     public function download(RaportAdsNew $raportAdsNew, AllegroDataAdsRepository $allegroDataAdsRepository, SerializerInterface $serializer)
  247.     {
  248.         if ($this->isGranted("ROLE_CLIENT") && !$raportAdsNew->getProject()->getClient()->contains($this->getUser())) {
  249.             $this->addFlash("error", "Brak dostępu");
  251.             return $this->redirectToRoute('allegro_ads_chart');
  252.         }
  254.         $data = $allegroDataAdsRepository->findDataFile($raportAdsNew->getAccount(), $raportAdsNew->getDateFrom(), $raportAdsNew->getDateTo(), $raportAdsNew->getProject());
  256.         $arr = [];
  257.         $i = 0;
  258.         foreach ($data as $val) {
  259.             if ($raportAdsNew->getDateTo() < (new \DateTimeImmutable('2024-02-01 00:00:00'))) {
  261.                 $fileData = str_replace("''", "\'", $val->getData()['file']);
  262.                 $fileData = str_replace("'", "\"", $fileData);
  263.                 $fileData = preg_replace('/(?<=\d)"(?=(?![,:}]))/', '\'', $fileData);
  264.                 $file = $serializer->decode('['.$fileData.']', 'json');
  265.             } else {
  266.                 $file = $val->getData()['file'];
  267.             }
  268.             if (!$file) {
  269.                 continue;
  270.             }
  272.             foreach ($file as $f) {
  273.                 $a = [];
  274.                 foreach ($f as $key => $value) {
  275.                     if ($key == "Nazwa kampanii" || $key == "Nazwa grupy reklam") {
  276.                         continue;
  277.                     }
  278.                     if ($i == 0) {
  279.                         $arr[0][] = $key;
  280.                     }
  281.                     $a[] = $value;
  282.                 }
  283.                 $arr[] = $a;
  284.                 $i++;
  285.             }
  288.         }
  290.         $spreadsheet = new Spreadsheet();
  291.         $spreadsheet->getActiveSheet()->fromArray($arr);
  293.         $writer = new Xlsx($spreadsheet);
  295.         $response = new StreamedResponse(
  296.             function () use ($writer) {
  297.                 $writer->save('php://output');
  298.             }
  299.         );
  300.         $response->headers->set('Content-Type', 'application/vnd.ms-excel');
  301.         $response->headers->set('Content-Disposition', 'attachment;filename="raport.xlsx"');
  302.         $response->headers->set('Cache-Control', 'max-age=0');
  304.         return $response;
  305.     }
  308.     /**
  309.      * @Route("/allegro-ads/{raportAdsNew}", name="allegro_ads_new_show")
  310.      */
  311.     public function show(RaportAdsNew $raportAdsNew, AllegroDataAdsRepository $allegroDataAdsRepository)
  312.     {
  313.         if ($this->isGranted("ROLE_CLIENT") && !$raportAdsNew->getProject()->getClient()->contains($this->getUser())) {
  314.             $this->addFlash("error", "Brak dostępu");
  316.             return $this->redirectToRoute('allegro_ads_chart');
  317.         }
  319.         $file = false;
  321.         $data = $allegroDataAdsRepository->findDataFile($raportAdsNew->getAccount(), $raportAdsNew->getDateFrom(), $raportAdsNew->getDateTo(), $raportAdsNew->getProject());
  322.         if ($data) {
  323.             $file = true;
  324.         }
  326.         return $this->render('allegro_data_ads/show.html.twig', [
  327.             'raport' => $raportAdsNew,
  328.             'file'   => $file,
  329.         ]);
  330.     }
  332.     /**
  333.      * @Route("/raport/{raportAdsNew}/{account}", name="allegro_ads_new_show_last")
  334.      */
  335.     public function showLast(string $raportAdsNew, string $account, RaportAdsNewRepository $raportAdsNewRepository, ProjectRepository $projectRepository, AllegroDataAdsRepository $allegroDataAdsRepository)
  336.     {
  337.         $raport = $raportAdsNewRepository->findOneBy([
  338.             "project" => $projectRepository->findOneBy(["name" => $raportAdsNew, "type" => Project::TYPE_ACTIVE]),
  339.             "account" => $account,
  340.         ],
  341.             [
  342.                 "id" => "DESC",
  343.             ]);
  344. //        if (!$raport) {
  345. //            dd($projectRepository->findOneBy(["name" => $raportAdsNew, "type" => Project::TYPE_ACTIVE]), $raportAdsNewRepository->getLastRaport($projectRepository->findOneBy(["name" => $raportAdsNew]), $account));
  346. //        }
  347.         if ($this->isGranted("ROLE_CLIENT") && !$raport->getProject()->getClient()->contains($this->getUser())) {
  348.             $this->addFlash("error", "Brak dostępu");
  350.             return $this->redirectToRoute('allegro_ads_chart');
  351.         }
  353.         $file = false;
  355.         $data = $allegroDataAdsRepository->findDataFile($raport->getAccount(), $raport->getDateFrom(), $raport->getDateTo(), $raport->getProject());
  356.         if ($data) {
  357.             $file = true;
  358.         }
  360.         return $this->render('allegro_data_ads/show.html.twig', [
  361.             'raport' => $raport,
  362.             'file'   => $file,
  363.         ]);
  364.     }
  366.     /**
  367.      * @Route("/allegro-ads-project-account/{project}", name="allegro_ads_project_account")
  368.      */
  369.     public function dataAccountAllegro(Project $project): JsonResponse
  370.     {
  371.         return $this->json(explode(",", $project->getAllegroAccount()));
  372.     }
  374.     /**
  375.      * @Route("/allegro-ads-json/{project}", name="allegro_ads_json")
  376.      */
  377.     public function dataJson(Request $request, Project $project, RaportAdsNewRepository $raportAdsNewRepository): JsonResponse
  378.     {
  379.         $date = explode("do", $request->get("range"));
  380.         $from = $date[0];
  381.         $to = $date[1];
  382.         $datas = $project->getAllegroDataAds()->filter(function (AllegroDataAds $allegroDataAds) use ($from, $to) {
  383.             if ($allegroDataAds->getDate() >= new \DateTime($from) && $allegroDataAds->getDate() <= (new \DateTime($to))->modify("+1 day")) {
  384.                 return $allegroDataAds->getData();
  385.             }
  386.         });
  388.         $iterator = $datas->getIterator();
  389.         $iterator->uasort(function ($a, $b) {
  390.             return $a->getDate() <=> $b->getDate();
  391.         });
  393.         $datas = new ArrayCollection(iterator_to_array($iterator));
  395.         $ad = [];
  396.         $count = [];
  397.         if ($request->get("instant") || $request->get("week")) {
  398.             $raportAdsNew = null;
  399.             if ($request->get("instant")) {
  400.                 $raportAdsNew = $raportAdsNewRepository->find($request->get("raportId"));
  401.             }
  402.             if ($request->get("week") || $raportAdsNew->getTypeStatistic() == 1) {
  403.                 foreach ($datas as $data) {
  404.                     if (isset($data->getData()['file']) || isset($data->getData()['graphic-ads'])) {
  405.                         continue;
  406.                     }
  407.                     if (trim(strtolower($data->getData()['nickname'])) == trim(strtolower($request->get("nickname")))) {
  408.                         $date = (new \DateTimeImmutable())->setISODate($data->getDate()->format("Y"), $data->getDate()->format("W"))->format("Y-m-d");
  409.                         if (!isset($ad[$date])) {
  410.                             $ad[$date] = [];
  411.                             $count[$date] = 0;
  412.                         }
  414.                         $count[$date]++;
  416.                         $ad[$date] = [
  417.                             "nickname"        => $data->getData()['nickname'],
  418.                             "klikniecia"      => $this->stringToFloat($data->getData()['klikniecia']) + $this->getDataArray($date, $ad, 'klikniecia'),
  419.                             "odslony"         => $this->stringToFloat($data->getData()['odslony']) + $this->getDataArray($date, $ad, 'odslony'),
  420.                             "ctr"             => $this->stringToFloat($data->getData()['ctr']) + $this->getDataArray($date, $ad, 'ctr'),
  421.                             "cpc"             => $this->stringToFloat($data->getData()['cpc']) + $this->getDataArray($date, $ad, 'cpc'),
  422.                             "koszt"           => $this->stringToFloat($data->getData()['koszt']) + $this->getDataArray($date, $ad, 'koszt'),
  423.                             "zwrot"           => $this->stringToFloat($data->getData()['zwrot']) + $this->getDataArray($date, $ad, 'zwrot'),
  424.                             "zainteresowanie" => $this->stringToFloat($data->getData()['zainteresowanie']) + $this->getDataArray($date, $ad, 'zainteresowanie'),
  425.                             "sprzedane"       => $this->stringToFloat($data->getData()['sprzedane']) + $this->getDataArray($date, $ad, 'sprzedane'),
  426.                             "wartosc"         => $this->stringToFloat($data->getData()['wartosc']) + $this->getDataArray($date, $ad, 'wartosc'),
  427.                             "date"            => $date,
  428.                         ];
  429.                     }
  430.                 }
  432.                 $allegroData = [];
  433.                 foreach ($ad as $key => $data) {
  434.                     $data['ctr'] = $data['ctr'] / $count[$key];
  435.                     $data['cpc'] = $data['cpc'] / $count[$key];
  436.                     $data['zwrot'] = $data['zwrot'] / $count[$key];
  437.                     $allegroData[] = [
  438.                         "data" => $data,
  439.                         "date" => $key,
  440.                     ];
  441.                 }
  443.                 return $this->json($allegroData);
  444.             }
  445.         }
  447.         $allegroData = [];
  448.         foreach ($datas as $data) {
  449.             if (trim(strtolower($data->getData()['nickname'])) == trim(strtolower($request->get("nickname")))) {
  450.                 if (isset($data->getData()['klikniecia'])) {
  451.                     $dataParse = [
  452.                         "nickname"        => $data->getData()['nickname'],
  453.                         "klikniecia"      => (string)$data->getData()['klikniecia'],
  454.                         "odslony"         => (string)$data->getData()['odslony'],
  455.                         "ctr"             => (string)$data->getData()['ctr'],
  456.                         "cpc"             => (string)$data->getData()['cpc'],
  457.                         "koszt"           => (string)$data->getData()['koszt'],
  458.                         "zwrot"           => (string)$data->getData()['zwrot'],
  459.                         "zainteresowanie" => (string)$data->getData()['zainteresowanie'],
  460.                         "sprzedane"       => (string)$data->getData()['sprzedane'],
  461.                         "wartosc"         => (string)$data->getData()['wartosc'],
  462.                     ];
  463.                 } else {
  464.                     $dataParse = $data->getData();
  465.                 }
  466.                 $allegroData[] = [
  467.                     "data" => $dataParse,
  468.                     "date" => $data->getDate()->format("m-d"),
  469.                 ];
  470.             }
  471.         }
  474.         return $this->json($allegroData);
  475.     }
  477.     private function getDataArray(string $date, array $ad, string $name)
  478.     {
  479.         if (isset($ad[$date][$name])) {
  480.             $string = str_replace(" ", "", $ad[$date][$name]);
  481.             $string = str_replace("zł", "", $string);
  483.             return (float)str_replace(",", ".", $string);
  484.         }
  486.         return 0;
  487.     }
  489.     private function stringToFloat(string $string): float
  490.     {
  491.         $string = str_replace(" ", "", $string);
  492.         $string = str_replace("zł", "", $string);
  494.         return (float)str_replace(",", ".", $string);
  495.     }
  497.     private function floatToString(string $string): float
  498.     {
  499.         return (string)str_replace(".", ",", $string);
  500.     }
  502.     /**
  503.      * @Route("/allegro-ads-graphic-json/{project}", name="allegro_ads_graphic_json")
  504.      */
  505.     public function dataGrphicJson(Request $request, Project $project, RaportAdsNewRepository $raportAdsNewRepository): JsonResponse
  506.     {
  507.         $date = explode("do", $request->get("from"));
  508.         $from = $date[0];
  509.         $to = $date[1];
  510.         $datas = $project->getAllegroDataAds()->filter(function (AllegroDataAds $allegroDataAds) use ($from, $to) {
  511.             if ($allegroDataAds->getDate() >= new \DateTime($from) && $allegroDataAds->getDate() <= (new \DateTime($to))->modify("+1 day") && isset($allegroDataAds->getData()['graphic-ads'])) {
  512.                 return $allegroDataAds->getData();
  513.             }
  514.         });
  516.         $iterator = $datas->getIterator();
  517.         $iterator->uasort(function ($a, $b) {
  518.             return $a->getDate() <=> $b->getDate();
  519.         });
  521.         $datas = new ArrayCollection(iterator_to_array($iterator));
  523.         $ad = [];
  524.         $count = [];
  525.         if ($request->get("instant") || $request->get("week")) {
  526.             $raportAdsNew = null;
  527.             if ($request->get("instant")) {
  528.                 $raportAdsNew = $raportAdsNewRepository->find($request->get("raportId"));
  529.             }
  530.             if ($request->get("week") || $raportAdsNew->getTypeGraphicStatistic() == 1) {
  531.                 foreach ($datas as $data) {
  532.                     if (!isset($data->getData()['graphic-ads'])) {
  533.                         continue;
  534.                     }
  535.                     if (trim(strtolower($data->getData()['nickname'])) == trim(strtolower($request->get("nickname")))) {
  536.                         $date = (new \DateTimeImmutable())->setISODate($data->getDate()->format("Y"), $data->getDate()->format("W"))->format("Y-m-d");
  537.                         if (!isset($ad[$date])) {
  538.                             $ad[$date] = [];
  539.                             $count[$date] = 0;
  540.                         }
  542.                         $count[$date]++;
  544.                         $ad[$date] = [
  545.                             "nickname"         => $data->getData()['nickname'],
  546.                             "klikniecia"       => $this->stringToFloat($data->getData()['graphic-ads']['klikniecia']) + $this->getDataArray($date, $ad, 'klikniecia'),
  547.                             "odslony"          => $this->stringToFloat($data->getData()['graphic-ads']['odslony']) + $this->getDataArray($date, $ad, 'odslony'),
  548.                             "ctr"              => $this->stringToFloat($data->getData()['graphic-ads']['ctr']) + $this->getDataArray($date, $ad, 'ctr'),
  549.                             "cpm"              => $this->stringToFloat($data->getData()['graphic-ads']['cpm']) + $this->getDataArray($date, $ad, 'cpm'),
  550.                             "koszt"            => $this->stringToFloat($data->getData()['graphic-ads']['koszt']) + $this->getDataArray($date, $ad, 'koszt'),
  551.                             "zwroty"           => $this->stringToFloat($data->getData()['graphic-ads']['zwroty']) + $this->getDataArray($date, $ad, 'zwroty'),
  552.                             "zasieg"           => isset($data->getData()['graphic-ads']['zasieg']) ? $this->stringToFloat($data->getData()['graphic-ads']['zasieg']) + $this->getDataArray($date, $ad, 'zasieg') : "0",
  553.                             "zaitnteresowanie" => $this->stringToFloat($data->getData()['graphic-ads']['zaitnteresowanie'] ?? $data->getData()['graphic-ads']['zainteresowanie']) + $this->getDataArray($date, $ad, 'zainteresowanie'),
  554.                             "sprzedanewsp"     => isset($data->getData()['graphic-ads']['sprzedanewsp']) ? $this->stringToFloat($data->getData()['graphic-ads']['sprzedanewsp']) + $this->getDataArray($date, $ad, 'sprzedanewsp') : "0",
  555.                             "sprzedane"        => $this->stringToFloat($data->getData()['graphic-ads']['sprzedane']) + $this->getDataArray($date, $ad, 'sprzedane'),
  556.                             "wartosc"          => $this->stringToFloat($data->getData()['graphic-ads']['wartosc']) + $this->getDataArray($date, $ad, 'wartosc'),
  557.                             "date"             => $date,
  558.                         ];
  559.                     }
  560.                 }
  562.                 $allegroData = [];
  563.                 foreach ($ad as $key => $data) {
  564.                     $data['ctr'] = $data['ctr'] / $count[$key];
  565.                     $data['cpm'] = $data['cpm'] / $count[$key];
  566.                     $allegroData[] = [
  567.                         "data" => ["graphic-ads" => $data],
  568.                         "date" => $key,
  569.                     ];
  570.                 }
  572.                 return $this->json($allegroData);
  573.             }
  574.         }
  577.         $allegroData = [];
  578.         foreach ($datas as $data) {
  579.             if (trim(strtolower($data->getData()['nickname'])) == trim(strtolower($request->get("nickname")))) {
  580.                 $allegroData[] = [
  581.                     "data" => $data->getData(),
  582.                     "date" => $data->getDate()->format("m-d"),
  583.                 ];
  584.             }
  585.         }
  587.         return $this->json($allegroData);
  588.     }
  590. }