1. <?php
3. namespace App\Controller;
5. use App\Entity\Expense;
6. use App\Entity\FinancialPart;
7. use App\Entity\FixedPages;
8. use App\Entity\Letter;
9. use App\Entity\News;
10. use App\Entity\Page;
11. use App\Entity\PictureLead;
12. use App\Entity\Santa;
13. use App\Entity\Services;
14. use App\Entity\User;
15. use App\Entity\UserTemplate;
16. use App\Enum\IncomeEnum;
17. use App\Enum\PdfConverter;
18. use App\Enum\SantaEnum;
19. use App\Repository\MetaRepository;
20. use App\Repository\PageRepository;
21. use App\Services\SpacesUploader;
22. use GuzzleHttp\ClientInterface;
23. use Symfony\Bridge\Twig\Mime\TemplatedEmail;
24. use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
25. use Symfony\Component\DependencyInjection\ParameterBag\ParameterBagInterface;
26. use Symfony\Component\HttpFoundation\JsonResponse;
27. use Symfony\Component\HttpFoundation\Request;
28. use Symfony\Component\HttpFoundation\RequestStack;
29. use Symfony\Component\HttpFoundation\Response;
30. use Symfony\Component\Mime\Address;
31. use Symfony\Component\Mime\Email;
32. use Symfony\Component\Routing\Annotation\Route;
33. use Symfony\Component\Mailer\MailerInterface;
34. use App\Entity\Gallery;
35. use Doctrine\ORM\EntityManagerInterface;
36. use Liip\ImagineBundle\Imagine\Cache\CacheManager;
37. use Symfony\Component\Validator\Constraints\Uuid;
38. use Symfony\Contracts\HttpClient\HttpClientInterface;
39. use Symfony\Contracts\Translation\TranslatorInterface;
40. use Gedmo\Translatable\TranslatableListener;
41. use PhpOffice\PhpSpreadsheet\IOFactory;
44. class MainController extends AbstractController
45. {
47.     private EntityManagerInterface $entityManager;
48.     private TranslatableListener $translatableListener;
50.     public function __construct(EntityManagerInterface $entityManager,
51.                                 TranslatableListener $translatableListener
52.     )
53.     {
54.         $this->translatableListener = $translatableListener;
55.         $this->entityManager = $entityManager;
56.     }
58.     #[Route('/{_locale}/ipad', name: 'page_ipad', requirements: ['_locale' => 'en|ru|hy'], defaults: ['_locale' => 'en'])]
59.     public function iphone(MetaRepository $metaRepository, PageRepository $pageRepository)
60.     {
62.         $page = $pageRepository->find(11);
63.         $editable = false;
64.         $pantum = false;
66.         return $this->render('@web/page/template.html.twig', [
67.             'page' => $page,
68.             'editable' => $editable,
69.             'ipad' => true,
70.         ]);
72.     }
75.     #[Route('/{_locale}/links', name: 'page_links', requirements: ['_locale' => 'en|ru|hy'], defaults: ['_locale' => 'en'])]
76.     public function links()
77.     {
79.         return $this->render('@web/page/links.html.twig', [
81.         ]);
83.     }
86.     #[Route('/{_locale}/pantum', name: 'page_pantum', requirements: ['_locale' => 'en|ru|hy'], defaults: ['_locale' => 'en'])]
87.     public function pantum(MetaRepository $metaRepository, PageRepository $pageRepository)
88.     {
90.         $page = $pageRepository->find(11);
91.         $editable = false;
92.         $pantum = true;
94.         return $this->render('@web/page/template.html.twig', [
95.             'page' => $page,
96.             'editable' => $editable,
97.             'pantum' => $pantum
98.         ]);
100.     }
102.     #[Route('/{_locale}/ipad/may', name: 'page_mayis9', requirements: ['_locale' => 'en|ru|hy'], defaults: ['_locale' => 'en'])]
103.     public function page_mayis9(MetaRepository $metaRepository, PageRepository $pageRepository)
104.     {
106.         $page = $pageRepository->find(4);
107.         $editable = false;
109.         return $this->render('@web/page/template.html.twig', [
110.             'page' => $page,
111.             'editable' => $editable
112.         ]);
114.     }
117.     #[Route('/iphone', name: 'page_iphone', requirements: ['_locale' => 'en|ru|hy'], defaults: ['_locale' => 'en'])]
118.     public function ipad(MetaRepository $metaRepository)
119.     {
120.         return $this->render('@web/page/iphone.html.twig');
121.     }
123.     #[Route('/gallery', name: 'page_gallery')]
124.     public function index(MetaRepository $metaRepository)
125.     {
126.         $gallery = $this->entityManager->getRepository(Gallery::class)->findBy(['isShow' => true], ['id' => 'DESC'], 20);
128.         return $this->render('@web/page/gallery.html.twig', ['gallery' => $gallery]);
129.     }
131.     #[Route('/{_locale}', name: 'page_index', requirements: ['_locale' => 'en|ru|hy|es|it|fr|el|ua|ka|de'], defaults: ['_locale' => 'hy'])]
132.     public function empty(MetaRepository $metaRepository)
133.     {
134.         $banner = $this->entityManager->getRepository(FixedPages::class)->find(1);
135.         $services = $this->entityManager->getRepository(Services::class)->findAll();
136.         $news = $this->entityManager->getRepository(News::class)->findAll();
138.         return $this->render('@web/page/index.html.twig', [
139.             'banner' => $banner,
140.             'services' => $services,
141.             'news' => $news
142.         ]);
143.     }
145.     #[Route('{_locale}/services', name: 'page_services')]
146.     public function services(MetaRepository $metaRepository)
147.     {
148.         $services = $this->entityManager->getRepository(Services::class)->findAll();
150.         return $this->render('@web/page/services.html.twig', [
151.             'services' => $services
152.         ]);
153.     }
155.     #[Route('{_locale}/service/view/{id}', name: 'page_service')]
156.     public function service(Services $services)
157.     {
159.         return $this->render('@web/page/service.html.twig', [
160.             'service' => $services
161.         ]);
162.     }
164.     #[Route('{_locale}/partner/managment', name: 'page_partner_nviraberir')]
165.     public function partnerNviraberir()
166.     {
168.         return $this->render('@web/page/partner-nviraberir.html.twig');
169.     }
171.     #[Route('{_locale}/wine', name: 'page_wine')]
172.     public function wine()
173.     {
175.         return $this->render('@web/page/wine.html.twig', [
176.             'editable' => false
177.         ]);
178.     }
180.     #[Route('{_locale}/privacy-policy', name: 'page_policy')]
181.     public function policy()
182.     {
184.         $page = $this->entityManager->getRepository(FixedPages::class)->find(2);
186.         return $this->render('@web/page/fixed.html.twig', [
187.             'page' => $page
188.         ]);
189.     }
191.     #[Route('{_locale}/terms-of-use', name: 'page_terms')]
192.     public function terms()
193.     {
195.         $page = $this->entityManager->getRepository(FixedPages::class)->find(3);
197.         return $this->render('@web/page/fixed.html.twig', [
198.             'page' => $page
199.         ]);
200.     }
202.     #[Route('{_locale}/about-us', name: 'page_about')]
203.     public function aboutUs(MetaRepository $metaRepository)
204.     {
206.         $page = $this->entityManager->getRepository(FixedPages::class)->find(4);
208.         return $this->render('@web/page/about.html.twig', [
209.             'page' => $page
210.         ]);
211.     }
213.     #[Route('{_locale}/support', name: 'page_contact_us')]
214.     public function contactUs(MetaRepository $metaRepository)
215.     {
217.         return $this->render('@web/page/contact-us.html.twig');
218.     }
221.     #[Route('/pyunik/view', name: 'page_pyunik_view', requirements: ['_locale' => 'en|ru|hy'], defaults: ['_locale' => 'ru'])]
222.     public function pagePyunik(PageRepository $pageRepository)
223.     {
225.         $editable = false;
226.         return $this->render('@web/page/template-pyunik.html.twig', [
227.             'editable' => $editable
228.         ]);
229.     }
231.     #[Route('{_locale}/view-image', name: 'page_view_image', requirements: ['_locale' => 'en|ru|hy'], defaults: ['_locale' => 'en'])]
232.     public function page_view_image(Request $request)
233.     {
234.         $template = null;
235.         $image = null;
237.         $code = $request->get('code');
238.         if ($code) {
239.             $image = $this->entityManager
240.                 ->getRepository(Gallery::class)
241.                 ->findOneBy(['documentNumber' => $code]);
243.             if ($image) {
244.                 $template = $this->entityManager
245.                     ->getRepository(Page::class)
246.                     ->find($image->getTemplateId());
247.             } else {
248.                 return $this->redirectToRoute('page_index');
249.             }
250.         }
252.         // Redirect to Armenian locale if template ID is 62 and current locale is not hy
253.         if ($template->getId() == 62 && $request->getLocale() !== $image->getLocale()) {
254.             return $this->redirectToRoute('page_view_image', [
255.                 '_locale' => $image->getLocale(),
256.                 'code' => $code
257.             ]);
258.         }
260.         // Render templates
261.         [$templateName, $params] = $this->resolveViewImageTemplateData($template, $image);
263.         return $this->render($templateName, $params);
264.     }
266.     private function resolveViewImageTemplateData(Page $template, Gallery $image): array
267.     {
268.         if ($template->getId() == 62) {
269.             $letter = $this->entityManager->getRepository(Letter::class)->find($image->getLetterId());
270.             return ['@web/page/template-christmas.html.twig', [
271.                 'editable' => false,
272.                 'viewImage' => true,
273.                 'page' => $template,
274.                 'letter' => $letter,
275.                 'image' => $image
276.             ]];
277.         } elseif ($template->getId() == 56) {
278.             return ['@web/page/template-dalma.html.twig', [
279.                 'editable' => false,
280.                 'dalma' => true,
281.                 'page' => $template,
282.                 'image' => $image
283.             ]];
284.         } elseif ($template->getId() == 60) {
285.             return ['@web/page/template-sherep.html.twig', [
286.                 'editable' => false,
287.                 'dalma' => true,
288.                 'page' => $template,
289.                 'image' => $image
290.             ]];
291.         } elseif (str_contains($template->getSlug(), 'violations')) {
292.             return ['@web/page/view-violations.html.twig', [
293.                 'editable' => false,
294.                 'dalma' => true,
295.                 'page' => $template,
296.                 'image' => $image
297.             ]];
298.         }elseif (str_contains($template->getSlug(), 'engagement')) {
299.             return ['@web/page/view-engagement.html.twig', [
300.                 'editable' => false,
301.                 'dalma' => true,
302.                 'page' => $template,
303.                 'image' => $image
304.             ]];
305.         } else {
306.             return ['@web/page/view-image.html.twig', [
307.                 'editable' => false,
308.                 'page' => $template,
309.                 'image' => $image
310.             ]];
311.         }
312.     }
314.     #[Route('{_locale}/request-picture-email', name: 'page_request_picture_email', methods: ['POST'])]
315.     public function requestPictureEmail(Request $request, MailerInterface $mailer, ParameterBagInterface $parameterBag): JsonResponse
316.     {
317.         $code = trim((string)$request->request->get('code'));
318.         $email = trim((string)$request->request->get('email'));
320.         if (!$code || !$email || !filter_var($email, FILTER_VALIDATE_EMAIL)) {
321.             return new JsonResponse(['success' => false, 'error' => 'invalid'], 400);
322.         }
324.         $image = $this->entityManager->getRepository(Gallery::class)->findOneBy(['documentNumber' => $code]);
325.         if (!$image) {
326.             return new JsonResponse(['success' => false, 'error' => 'not_found'], 404);
327.         }
329.         $template = $this->entityManager->getRepository(Page::class)->find($image->getTemplateId());
330.         if (!$template) {
331.             return new JsonResponse(['success' => false, 'error' => 'not_found'], 404);
332.         }
334.         [$templateName, $params] = $this->resolveViewImageTemplateData($template, $image);
335.         $html = $this->renderView($templateName, $params);
337.         // Capture the lead first so a PDF/mail hiccup never loses the email address.
338.         $lead = new PictureLead();
339.         $lead->setEmail($email);
340.         $lead->setCode($code);
341.         $lead->setLocale($request->getLocale());
342.         $this->entityManager->persist($lead);
343.         $this->entityManager->flush();
345.         try {
346.             $filename = 'lead_' . time() . '_' . bin2hex(random_bytes(4));
347.             $htmlDir = $parameterBag->get('kernel.project_dir') . '/public/uploads/html/' . $filename . '.html';
348.             file_put_contents($htmlDir, $html);
350.             $pdfDir = $parameterBag->get('kernel.project_dir') . '/public/uploads/pdf/' . $filename . '.pdf';
351.             PdfConverter::convertHtmlToPdf($htmlDir, $pdfDir);
353.             $mail = (new Email())
354.                 ->from(new Address('support@infinitemoment.life', 'The Infinite Moment'))
355.                 ->to($email)
356.                 ->subject('Your Infinite Moment Gazette')
357.                 ->html($this->renderView('email/picture_delivery.html.twig', ['code' => $code]))
358.                 ->attachFromPath($pdfDir, $filename . '.pdf', 'application/pdf');
360.             $mailer->send($mail);
361.         } catch (\Throwable $e) {
362.             return new JsonResponse(['success' => false, 'error' => 'mail_failed'], 200);
363.         }
365.         return new JsonResponse(['success' => true]);
366.     }
368.     #[Route('/image/test')]
369.     public function test(ParameterBagInterface $parameterBag, CacheManager $cacheManager)
370.     {
372.         $imagePath = 'https://infinitemoment.nyc3.cdn.digitaloceanspaces.com/691df26f50fe7.jpg';
374.         $filteredPath = $cacheManager->resolve($imagePath, 'small_thumb');
377.         $page = $this->entityManager->getRepository(Page::class)->find(10);
379.         $origFile = "https://infinitemoment.nyc3.cdn.digitaloceanspaces.com/6912214177e31.jpg";
380.         $imgName = pathinfo($origFile, PATHINFO_BASENAME);
381.         $destImg = '/var/www/infinitemoment/public/uploads/img/' . $imgName;
382.         PdfConverter::resizeImage($origFile, $destImg);
384.         $html = $this->renderView('@web/page/template-tmp.html.twig', [
385.             'page' => $page,
386.             'preview' => false,
387.             'image' => 'https://infinitemoment.am/uploads/img/' . $imgName,
388.             'editable' => false
389.         ]);
391.         $filename = (string)time();
392.         $htmlDir = $parameterBag->get('kernel.project_dir') . '/public/uploads/html/' . $filename . '.html';
393.         file_put_contents($htmlDir, $html);
395.         $pdfDir = $parameterBag->get('kernel.project_dir') . '/public/uploads/pdf/' . $filename . '.pdf';
396.         PdfConverter::convertHtmlToPdf($htmlDir, $pdfDir);
398.     }
400.     #[Route('/image/delete', name: 'image_delete', methods: ['GET'])]
401.     public function delete(Request $request)
402.     {
405.         $ids = ['54302020250427', '21442120250427', '05461720250501', '14131420250509', '15221620250601', '45452020250811', '48002120250901', '35391420250904'];
407.         if (!empty($ids)) {
408.             foreach ($ids as $id) {
409.                 $image = $this->entityManager->getRepository(Gallery::class)->findOneBy(['documentNumber' => $id]);
411.                 if ($image) {
412.                     // Delete file from filesystem
413.                     $filePath = $this->getParameter('brochures_directory') . '/' . $image->getImage();
414.                     if (file_exists($filePath)) {
415.                         unlink($filePath);
416.                     }
418.                     // Remove entity
419.                     $this->entityManager->remove($image);
420.                 }
421.             }
423.             $this->entityManager->flush();
424.             $this->addFlash('success', 'Selected images deleted successfully.');
425.         } else {
426.             $this->addFlash('warning', 'No images selected.');
427.         }
429.         die;
430.     }
433.     #[Route('{_locale}/santa', name: 'page_santa', requirements: ['_locale' => 'en|ru|hy|es|it|fr|el|ua|ka|de'], defaults: ['_locale' => 'hy'])]
434.     public function pageSanta(
435.         Request $request,
436.                 $_locale,
437.         SpacesUploader $spacesUploader,
438.         TranslatorInterface $translator,
439.         MetaRepository $metaRepository,
440.         MailerInterface $mailer
441.     ) {
442.         if ($request->isMethod('POST')) {
444.             $action = $request->request->get('action');
447.             $santa = new Santa();
449.             $brochureFile = $request->files->get('image');
450.             $brochureFileName = $spacesUploader->upload($brochureFile);
452.             $gift = $request->get('gift') ?: time();
454.             $santa->setEmail($request->get('email'));
455.             $santa->setFromName($request->get('fromName'));
456.             $santa->setFromEmail($request->get('fromEmail'));
457.             $santa->setGift($gift);
458.             $santa->setPhone($request->get('phone'));
459.             $santa->setMessage($request->get('comment'));
460.             $santa->setImage($brochureFileName);
461.             $santa->setLocale($_locale);
462.             $santa->setStatus(SantaEnum::SANTA_PROGRESS);
463.             $santa->setName($request->get('name'));
465.             $this->entityManager->persist($santa);
466.             $this->entityManager->flush();
468.             if ($action === 'pay_now') {
470.                 if ($this->getUser()) {
471.                     return $this->redirect('/payment/confirm?santa_id=' . $santa->getId());
472.                 }
474.                 $message = empty($request->get('comment')) ? 1 : 2;
476.                 return $this->redirect(
477.                     'https://anyrentalcars.com/armenia/infinite?' .
478.                     'santa_id=' . $santa->getId() .
479.                     '&locale=' . $santa->getLocale() .
480.                     '&message=' . $message
481.                 );
482.             }
484.             if ($action === 'request') {
486.                 $santa->setStatus(SantaEnum::SANTA_REQUEST);
487.                 $this->entityManager->flush();
489.                 $this->addFlash('success', $translator->trans('Your request has been sent successfully!'));
492.                 return $this->redirectToRoute('page_index');
493.             }
494.         }
496.         return $this->render('@web/page/santa.html.twig');
497.     }
499.     #[Route('/payment/reject', name: 'page_reject')]
500.     public function pageReject(Request $request)
501.     {
503.         if ($request->get('santa_id')) {
505.             $santa = $this->entityManager->getRepository(Santa::class)->find($request->get('santa_id'));
506.             $santa->setStatus(SantaEnum::SANTA_REJECTED);
508.             return $this->render('@web/page/payment_reject.html.twig');
509.         }
511.         return $this->redirectToRoute('page_index');
512.     }
514.     #[Route('/payment/confirm', name: 'page_confirm')]
515.     public function pageConfirm(Request $request, HttpClientInterface $client)
516.     {
518.         if ($request->get('santa_id')) {
519.             $santa = $this->entityManager->getRepository(Santa::class)->find($request->get('santa_id'));
520.             $santa->setStatus(SantaEnum::SANTA_PAID);
521.             $this->entityManager->flush();
523.             $payload = [
524.                 'id' => $santa->getId(),
525.                 'name' => $santa->getName(),
526.                 'locale' => $santa->getLocale(),
527.                 'gift' => $santa->getGift(),
528.                 'message' => $santa->getMessage(),
529.             ];
531.             // Pass the payload to Twig
532.             return $this->render('@web/page/payment_confirm.html.twig', [
533.                 'payload' => json_encode($payload),
534.             ]);
535.         }
537.         return $this->redirectToRoute('page_index');
538.     }
540.     #[Route('/send_santa_api', name: 'send_santa_api')]
541.     public function sendSantaApi(Request $request, HttpClientInterface $client, RequestStack $requestStack, ParameterBagInterface $parameterBag, MailerInterface $mailer, TranslatorInterface $translator)
542.     {
543.         $payload = json_decode($request->getContent(), true);
545.         $santa = $this->entityManager->getRepository(Santa::class)->find($payload['id']);
546.         $santa->setStatus(SantaEnum::SANTA_PROCESS);
547.         $this->entityManager->flush();
548. // Call the other API
549.         $response = $client->request('POST', 'https://santa2025.store/receive_letter_api', [
550.             'json' => $payload,
551.             'headers' => [
552.                 'Accept' => 'application/json',
553.                 'Content-Type' => 'application/json',
554.                 'User-Agent' => 'Mozilla/5.0 (Symfony Server)',
555.                 'Referer' => 'https://santa2025.store',
556.             ],
557.             'timeout' => 1500,
558.         ]);
562.         $data = $response->toArray(); // The API response
563.         $videoUrl = $data['video_url'] ?? null;
564.         $santa->setStatus(SantaEnum::SANTA_COMPLETED);
565.         $this->entityManager->flush();
567.         $letter = $this->entityManager->getRepository(Letter::class)->findOneBy(['externalId' => $data['letter_id']]);
568.         $gallery = $this->entityManager->getRepository(Gallery::class)->findOneBy(['letterId' => $letter->getId()]);
572.         $this->entityManager->persist($gallery);
573.         $this->entityManager->flush();
574.         $preview = false;
575.         $viewImage = false;
576.         $current = $requestStack->getCurrentRequest();
577.         $main = $requestStack->getMainRequest(); // Symfony 5.3+; may be null
578.         $locale = $gallery->getLocale();
580.         $this->translatableListener->setTranslatableLocale($locale);
582.         $page = $this->entityManager->getRepository(Page::class)
583.             ->createQueryBuilder('p')
584.             ->where('p.id = :id')
585.             ->setParameter('id', $gallery->getTemplateId())
586.             ->getQuery()
587.             ->getOneOrNullResult();
590.         $requestToUse = $main ?? $current ?? $request; // fallback to injected $request param
592.         if ($requestToUse) {
593.             // The important one: attributes _locale (LocaleListener checks this)
594.             $requestToUse->attributes->set('_locale', $locale);
596.             // Also set request locale and session (if available)
597.             $requestToUse->setLocale($locale);
598.             if ($requestToUse->hasSession()) {
599.                 $requestToUse->getSession()->set('_locale', $locale);
600.             }
601.         }
603. // 2) Set translator locale
604.         $translator->setLocale($locale);
606. // Optional: also set locale on PHP intl (not usually required)
607.         \Locale::setDefault($locale);
609.         $html = $this->renderView('@web/page/template-santa-tmp.html.twig', [
610.             'page' => $page,
611.             'preview' => $preview,
612.             'viewImage' => $viewImage,
613.             'letter' => $letter,
614.             'gallery' => $gallery,
615.             'image' => $gallery->getImage(),
616.             'editable' => false
617.         ]);
619.         $filename = (string)time();
620.         $htmlDir = $parameterBag->get('kernel.project_dir') . '/public/uploads/html/' . $filename . '.html';
621.         file_put_contents($htmlDir, $html);
623.         $pdfDir = $parameterBag->get('kernel.project_dir') . '/public/uploads/pdf/' . $filename . '.pdf';
624.         PdfConverter::convertHtmlToPdf($htmlDir, $pdfDir);
626.         $subject = $translator->trans('email_subject', [
627.             '%number%' => $gallery->getDocumentNumber(),
628.             '%name%' => $santa->getName(),
629.         ]);
633.         $email = (new Email())
634.             ->from(new Address('support@infinitemoment.life', 'Infinite Moment Santa'))
635.             ->to($santa->getEmail())
636.             ->subject($subject)
637.             ->html(
638.                 $this->renderView(
639.                     'email/santa_'.$santa->getLocale().'.html.twig',
640.                     ['subject' => $santa, 'video_url' => $videoUrl]
641.                 )
642.             )
643.         ->attachFromPath($pdfDir, $filename . '.pdf', 'application/pdf');
645.         $mailer->send($email);
648.         if ($santa->getFromEmail()) {
649.             $email = (new Email())
650.                 ->from(new Address('support@infinitemoment.life', 'Infinite Moment Santa'))
651.                 ->to(
652.                     $santa->getFromEmail(),
653.                     'developerhovsepyan@gmail.com'
654.                 )
655.                 ->subject($subject)
656.                 ->html(
657.                     $this->renderView(
658.                         'email/santa_'.$santa->getLocale().'.html.twig',
659.                         [
660.                             'subject' => $santa,
661.                             'video_url' => $videoUrl
662.                         ]
663.                     )
664.                 )
665.                 ->attachFromPath($pdfDir, $filename . '.pdf', 'application/pdf');
667.             $mailer->send($email);
668.         }
671.         return new JsonResponse([
672.             'video_url' => $videoUrl
673.         ]);
674.     }
677.     private const ADMIN_ID = 7;
679.     #[Route('/import-excel-public', name: 'import_excel_public')]
680.     public function importFromPublic(EntityManagerInterface $em): Response
681.     {
682.         $filePath = $this->getParameter('kernel.project_dir') . '/public/uploads/Infinite July.xlsx';
683.         // $filePath = '/mnt/data/Infinite July.xlsx'; // sandbox
685.         if (!file_exists($filePath)) {
686.             return new Response("Excel NOT FOUND: " . $filePath);
687.         }
689.         $spreadsheet = IOFactory::load($filePath);
691.         // ✅ Your file has sheet name "July"
692.         $sheet = $spreadsheet->getSheetByName('July') ?? $spreadsheet->getSheet(0);
694.         $maxRow = (int)$sheet->getHighestRow();
696.         // coin value => index in entity fields
697.         $coinIndexMap = [
698.             20000 => 1, 10000 => 2, 5000 => 3, 2000 => 4, 1000 => 5,
699.             500 => 6, 200 => 7, 100 => 8, 50 => 9, 20 => 10, 10 => 11, 1 => 15
700.         ];
702.         $userAliases = [
703.             'anahit' => 'anahit old',
704.         ];
706.         $created = 0;
707.         $skippedNoLocation = 0;
708.         $skippedNoDate = 0;
709.         $skippedNoPage = 0;
710.         $skippedDuplicate = 0;
711.         $skippedNoUserMatch = 0;
713.         /**
714.          * ✅ Your Excel structure is fixed blocks:
715.          * Header row: 2,17,32,... (step 15)
716.          * Coins: row+1..row+11 (10 AMD row is row+11)
717.          * Total row: row+12
718.          */
719.         for ($row = 2; $row <= $maxRow; $row += 15) {
721.             // Location is in C(row)
722.             $location = trim((string)($sheet->getCell("C$row")->getValue() ?? ''));
723.             if ($location === '') {
724.                 $skippedNoLocation++;
725.                 continue;
726.             }
728.             // Date is in E(row)
729.             $rawDate = $sheet->getCell("E$row")->getValue();
731.             // fallback for formulas / calculated cells
732.             if ($rawDate === null || $rawDate === '') {
733.                 $rawDate = $sheet->getCell("E$row")->getCalculatedValue();
734.             }
736.             $currentDay = $this->parseExcelDate2025($rawDate);
737.             if (!$currentDay) {
738.                 $skippedNoDate++;
739.                 continue;
740.             }
742.             // Find Page by name = location
743.             $page = $em->getRepository(Page::class)
744.                 ->createQueryBuilder('p')
745.                 ->where('LOWER(p.name) = LOWER(:name)')
746.                 ->setParameter('name', $location)
747.                 ->setMaxResults(1)
748.                 ->getQuery()
749.                 ->getOneOrNullResult();
751.             if (!$page) {
752.                 $skippedNoPage++;
753.                 continue;
754.             }
756.             $type = 1; // Day
758.             // Skip duplicates
759.             $existing = $em->getRepository(FinancialPart::class)->findOneBy([
760.                 'page' => $page,
761.                 'currentDay' => $currentDay,
762.                 'type' => $type,
763.             ]);
764.             if ($existing) {
765.                 $skippedDuplicate++;
766.                 continue;
767.             }
769.             $fp = new FinancialPart();
770.             $fp->setCreatedAt(new \DateTime());
771.             $fp->setCurrentDay($currentDay);
772.             $fp->setType($type);
773.             $fp->setPage($page);
775.             // currency like admin
776.             $this->setCurrency($fp);
778.             // init quantities
779.             foreach ([1,2,3,4,5,6,7,8,9,10,11,15] as $i) {
780.                 $setCash = "setCoinQuantity$i";
781.                 $setTr   = "setTransferQuantity$i";
782.                 if (method_exists($fp, $setCash)) $fp->$setCash(0);
783.                 if (method_exists($fp, $setTr))   $fp->$setTr(0);
784.             }
786.             // ✅ Coins are on next rows: row+1 .. row+11
787.             for ($r = $row + 1; $r <= $row + 11 && $r <= $maxRow; $r++) {
789.                 $coinType = $this->toIntDigits($sheet->getCell("C$r")->getValue());
790.                 $qty      = $this->toIntDigits($sheet->getCell("D$r")->getValue());
792.                 // Some rows have qty empty but value 0 -> ignore
793.                 if ($coinType <= 0 || $qty <= 0) continue;
794.                 if (!isset($coinIndexMap[$coinType])) continue;
796.                 $idx = $coinIndexMap[$coinType];
797.                 $setCash = "setCoinQuantity$idx";
798.                 if (method_exists($fp, $setCash)) {
799.                     $fp->$setCash($qty);
800.                 }
801.             }
803.             // ✅ Users are on row+1 in columns H..K
804.             $userNames = [];
805.             $usersRow = $row + 1;
807.             if ($usersRow <= $maxRow) {
808.                 foreach (['H','I','J','K'] as $col) {
809.                     $name = trim((string)($sheet->getCell($col . $usersRow)->getValue() ?? ''));
810.                     if ($name !== '') $userNames[] = $name;
811.                 }
812.             }
814.             $userNames = array_values(array_unique($userNames));
815.             $userCount = count($userNames);
817.             $percentPerUser = match ($userCount) {
818.                 1 => 66,
819.                 2 => 33,
820.                 3 => 25,
821.                 default => 0,
822.             };
824.             $matchedUsers = 0;
825.             $managerUser = null; // first matched = manager
827.             foreach ($userNames as $excelUserName) {
828.                 $user = $this->findUserByExcelName($em, $excelUserName, $userAliases);
829.                 if (!$user) continue;
831.                 if ($managerUser === null) $managerUser = $user;
833.                 $us = new UserSalary();
834.                 $us->setUser($user);
835.                 $us->setPercent($percentPerUser);
836.                 $us->setSalary(0);
837.                 $us->setExpense(0);
839.                 $fp->addUserSalary($us);
840.                 $em->persist($us);
842.                 $matchedUsers++;
843.             }
845.             if ($matchedUsers === 0 || $managerUser === null) {
846.                 $skippedNoUserMatch++;
847.                 continue;
848.             }
850.             // ✅ same as FinancialPartAdmin
851.             $this->ensureAdminAndManager($fp, $em, $managerUser);
852.             $this->calculateSalaryLikeAdmin($fp, $managerUser);
854.             $em->persist($fp);
855.             $created++;
856.         }
858.         $em->flush();
860.         return new Response(sprintf(
861.             "Import done. Created: %d | Skipped(no Location): %d | Skipped(no Date): %d | Skipped(no Page): %d | Skipped(duplicate): %d | Skipped(no user match): %d",
862.             $created, $skippedNoLocation, $skippedNoDate, $skippedNoPage, $skippedDuplicate, $skippedNoUserMatch
863.         ));
864.     }
866.     private function ensureAdminAndManager(FinancialPart $fp, EntityManagerInterface $em, User $managerUser): void
867.     {
868.         $adminExists = false;
869.         $managerExists = false;
871.         foreach ($fp->getUserSalary() as $salary) {
872.             $uid = $salary->getUser()?->getId();
873.             if ($uid === self::ADMIN_ID) $adminExists = true;
874.             if ($uid === $managerUser->getId()) $managerExists = true;
875.         }
877.         if (!$adminExists) {
878.             $adminSalary = new UserSalary();
879.             $adminSalary->setUser($em->getReference(User::class, self::ADMIN_ID));
880.             $adminSalary->setPercent(40);
881.             $adminSalary->setSalary(0);
882.             $adminSalary->setExpense(0);
884.             $fp->addUserSalary($adminSalary);
885.             $em->persist($adminSalary);
886.         }
888.         if (!$managerExists) {
889.             $managerSalary = new UserSalary();
890.             $managerSalary->setUser($em->getReference(User::class, $managerUser->getId()));
891.             $managerSalary->setPercent(60);
892.             $managerSalary->setSalary(0);
893.             $managerSalary->setExpense(0);
895.             $fp->addUserSalary($managerSalary);
896.             $em->persist($managerSalary);
897.         }
898.     }
900.     private function calculateSalaryLikeAdmin(FinancialPart $fp, User $managerUser): void
901.     {
902.         $this->setCurrency($fp);
904.         foreach ($fp->getUserSalary() as $salary) {
905.             $salary->setSalary(0);
906.             $salary->setExpense(0);
907.         }
909.         $coins = [
910.             1 => 20000, 2 => 10000, 3 => 5000, 4 => 2000, 5 => 1000,
911.             6 => 500, 7 => 200, 8 => 100, 9 => 50, 10 => 20, 11 => 10, 15 => 1,
912.         ];
914.         $totalPrice = 0;
915.         foreach ($coins as $i => $value) {
916.             $cash = method_exists($fp, "getCoinQuantity$i") ? ((int)($fp->{"getCoinQuantity$i"}() ?? 0)) : 0;
917.             $transfer = method_exists($fp, "getTransferQuantity$i") ? ((int)($fp->{"getTransferQuantity$i"}() ?? 0)) : 0;
918.             $totalPrice += ($cash + $transfer) * $value;
919.         }
921.         $adminExpense = $totalPrice * 0.05;
922.         $currentPrice = $totalPrice - $adminExpense;
923.         $managerProportion = $currentPrice * 0.60;
924.         $managerSalaryPrice = $managerProportion;
926.         $managerSalaryRow = null;
928.         foreach ($fp->getUserSalary() as $salary) {
929.             $uid = $salary->getUser()?->getId();
931.             if ($uid === self::ADMIN_ID) {
932.                 $salary->setSalary($currentPrice - $managerProportion);
933.                 $salary->setExpense($adminExpense);
934.                 continue;
935.             }
937.             if ($uid === $managerUser->getId()) {
938.                 $managerSalaryRow = $salary;
939.                 continue;
940.             }
942.             $userSalaryPrice = $managerProportion * (((int)($salary->getPercent() ?? 0)) / 100);
943.             $salary->setSalary($userSalaryPrice);
944.             $managerSalaryPrice -= $userSalaryPrice;
945.         }
947.         if ($managerSalaryRow) {
948.             $managerSalaryRow->setSalary($managerSalaryPrice);
949.         }
951.         $fp->setTotalPrice((int)$totalPrice);
952.     }
954.     private function setCurrency(FinancialPart $fp): void
955.     {
956.         $fp->setCoinType1(20000);
957.         $fp->setCoinType2(10000);
958.         $fp->setCoinType3(5000);
959.         $fp->setCoinType4(2000);
960.         $fp->setCoinType5(1000);
961.         $fp->setCoinType6(500);
962.         $fp->setCoinType7(200);
963.         $fp->setCoinType8(100);
964.         $fp->setCoinType9(50);
965.         $fp->setCoinType10(20);
966.         $fp->setCoinType11(10);
967.         $fp->setCoinType15(1);
968.     }
970.     private function toIntDigits(mixed $v): int
971.     {
972.         if ($v === null) return 0;
973.         if (is_int($v)) return $v;
974.         if (is_float($v)) return (int)round($v);
976.         $s = trim((string)$v);
977.         if ($s === '') return 0;
979.         $digits = preg_replace('/\D+/', '', $s);
980.         if ($digits === '' || $digits === null) return 0;
982.         return (int)$digits;
983.     }
985.     private function normalizeName(string $s): string
986.     {
987.         $s = mb_strtolower(trim($s));
988.         $s = preg_replace('/\s+/', ' ', $s);
989.         return $s ?? '';
990.     }
992.     private function findUserByExcelName(EntityManagerInterface $em, string $excelName, array $aliases): ?User
993.     {
994.         $norm = $this->normalizeName($excelName);
996.         if (isset($aliases[$norm])) {
997.             $target = $aliases[$norm];
998.             $u = $em->getRepository(User::class)->createQueryBuilder('u')
999.                 ->where('LOWER(u.name) = LOWER(:name)')
1000.                 ->setParameter('name', $target)
1001.                 ->setMaxResults(1)
1002.                 ->getQuery()
1003.                 ->getOneOrNullResult();
1004.             if ($u) return $u;
1005.         }
1007.         $u = $em->getRepository(User::class)->createQueryBuilder('u')
1008.             ->where('LOWER(u.name) = LOWER(:name)')
1009.             ->setParameter('name', $excelName)
1010.             ->setMaxResults(1)
1011.             ->getQuery()
1012.             ->getOneOrNullResult();
1013.         if ($u) return $u;
1015.         return $em->getRepository(User::class)->createQueryBuilder('u')
1016.             ->where('LOWER(u.name) LIKE :q')
1017.             ->setParameter('q', '%' . $norm . '%')
1018.             ->setMaxResults(1)
1019.             ->getQuery()
1020.             ->getOneOrNullResult();
1021.     }
1023.     // ✅ Works for your file (Excel numeric dates + DateTime + strings)
1024.     private function parseExcelDate2025(mixed $raw): ?\DateTime
1025.     {
1026.         if ($raw === null || $raw === '') return null;
1028.         if ($raw instanceof \DateTimeInterface) {
1029.             $dt = new \DateTime($raw->format('Y-m-d'));
1030.             $dt->setDate(2025, (int)$dt->format('m'), (int)$dt->format('d'));
1031.             $dt->setTime(0, 0, 0);
1032.             return $dt;
1033.         }
1035.         if (is_numeric($raw)) {
1036.             try {
1037.                 $dt = ExcelDate::excelToDateTimeObject((float)$raw);
1038.                 $dt->setDate(2025, (int)$dt->format('m'), (int)$dt->format('d'));
1039.                 $dt->setTime(0, 0, 0);
1040.                 return $dt;
1041.             } catch (\Throwable) {}
1042.         }
1044.         $s = trim((string)$raw);
1045.         if ($s === '') return null;
1047.         $formats = ['d.m.Y','d/m/Y','Y-m-d','d-m-Y','m/d/Y'];
1048.         foreach ($formats as $fmt) {
1049.             $dt = \DateTime::createFromFormat($fmt, $s);
1050.             if ($dt instanceof \DateTime) {
1051.                 $dt->setDate(2025, (int)$dt->format('m'), (int)$dt->format('d'));
1052.                 $dt->setTime(0, 0, 0);
1053.                 return $dt;
1054.             }
1055.         }
1057.         $ts = strtotime($s);
1058.         if ($ts !== false) {
1059.             $dt = (new \DateTime())->setTimestamp($ts);
1060.             $dt->setDate(2025, (int)$dt->format('m'), (int)$dt->format('d'));
1061.             $dt->setTime(0, 0, 0);
1062.             return $dt;
1063.         }
1065.         return null;
1066.     }
1070.     #[Route('/user-account', name: 'user_account', methods: ['GET'])]
1071.     public function userAccount(Request $request): Response
1072.     {
1074.         if (!$this->getUser()){
1076.             return $this->redirectToRoute('app_login');
1077.         }
1079.         $templates = $this->entityManager->getRepository(UserTemplate::class)->findBy(['user' => $this->getUser()]);
1082.         return $this->render('@web/page/user-account.html.twig',[
1083.             'templates' => $templates,
1084.             'editable' => false,
1085.         ]);
1086.     }
1089.     #[Route('/user-gallery', name: 'user_gallery', methods: ['GET'])]
1090.     public function userGallery(Request $request): Response
1091.     {
1093.         if (!$this->getUser()){
1095.             return $this->redirectToRoute('app_login');
1096.         }
1098.         $gallery = $this->entityManager->getRepository(Gallery::class)->findBy(['user' => $this->getUser()],['id' => 'DESC'],20);
1101.         return $this->render('@web/page/user-gallery.html.twig',[
1102.             'gallery' => $gallery,
1103.             'editable' => false,
1104.         ]);
1105.     }
1107.     #[Route('/user-sallary', name: 'user_sallary', methods: ['GET'])]
1108.     public function userSallary(Request $request): Response
1109.     {
1111.         if (!$this->getUser()){
1113.             return $this->redirectToRoute('app_login');
1114.         }
1118.         $stats = $this->entityManager->getRepository(FinancialPart::class)->searchStats($request->query->all(), [IncomeEnum::TYPE_DAILY, IncomeEnum::TYPE_ADDITIONAL]);
1119.         $statsDebt = $this->entityManager->getRepository(FinancialPart::class)->searchStats($request->query->all(), [IncomeEnum::TYPE_DEBT]);
1120.         $statsExpense = $this->entityManager->getRepository(Expense::class)->searchStats($request->query->all());
1124.         return $this->render('@web/page/user-sallary.html.twig',[
1125.             'editable' => false,
1126.             'stats' => $stats,
1127.             'statsDebt' => $statsDebt,
1128.             'statsExpense' => $statsExpense,
1129.         ]);
1130.     }
1132.     #[Route('/setData', name: 'setData', methods: ['POST'])]
1133.     public function setData(Request $request): Response
1134.     {
1135.         $json = $request->getContent();
1137.         $file = $this->getParameter('kernel.project_dir')
1138.             . '/var/data_' . date('Y-m-d_H-i-s') . '.json';
1140.         file_put_contents($file, $json);
1142.         return new Response('Saved to ' . basename($file));
1143.     }
1145. }