src/Command/ReportMissingSlugTranslationsCommand.php line 15

Open in your IDE?
  1. <?php
  3. namespace App\Command;
  5. use App\Entity\Language;
  6. use App\Entity\ProductLangParam;
  7. use App\Entity\CategoryLangParam;
  8. use App\Entity\FurnitureTypeLangParam;
  9. use Doctrine\ORM\EntityManagerInterface;
  10. use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
  11. use Symfony\Component\Console\Input\InputInterface;
  12. use Symfony\Component\Console\Output\OutputInterface;
  13. use Symfony\Component\Console\Helper\Table;
  15. class ReportMissingSlugTranslationsCommand extends ContainerAwareCommand
  16. {
  17.     protected function configure()
  18.     {
  19.         $this->setName('app:report:missing-slugs')
  20.             ->setDescription('Report missing or non-unique slugs and titles in products, categories, and furniture types');
  21.     }
  23.     protected function execute(InputInterface $input, OutputInterface $output)
  24.     {
  25.         $em = $this->getContainer()->get('doctrine')->getManager();
  26.         $twig = $this->getContainer()->get('twig');
  28.         $languageRepo = $em->getRepository('App:Language');
  29.         $productLangParamRepo = $em->getRepository('App:ProductLangParam');
  30.         $categoryLangParamRepo = $em->getRepository('App:CategoryLangParam');
  31.         $furnitureLangParamRepo = $em->getRepository('App:FurnitureTypeLangParam');
  33.         $languages = $languageRepo->createQueryBuilder('l')->where('l.id != 1')->getQuery()->getResult();
  35.         $productReport = [];
  36.         $categoryReport = [];
  37.         $furnitureReport = [];
  39.         foreach ($languages as $language) {
  40.             // ----------- PRODUCTS -----------
  41.             $productLangParams = $productLangParamRepo->createQueryBuilder('plp')
  42.                 ->join('plp.product', 'p')
  43.                 ->where('plp.language = :lang')
  44.                 ->andWhere('plp.visible = true')
  45.                 ->andWhere('p.deletedBy IS NULL')
  46.                 ->setParameter('lang', $language)
  47.                 ->getQuery()->getResult();
  49.             foreach ($productLangParams as $param) {
  50.                 $product = $param->getProduct();
  51.                 $pl = $product->translate('pl');
  52.                 $lang = $product->translate($language->getLocale());
  54.                 $slugReason = null;
  55.                 $titleReason = null;
  57.                 if (!$lang || !$lang->getSlug()) {
  58.                     $slugReason = 'Missing';
  59.                 } elseif ($lang->getSlug() === $pl->getSlug()) {
  60.                     $slugReason = 'Not unique';
  61.                 }
  63.                 if (!$lang || !$lang->getMetaTitle()) {
  64.                     $titleReason = 'Missing';
  65.                 } elseif ($lang->getMetaTitle() === $pl->getMetaTitle()) {
  66.                     $titleReason = 'Not unique';
  67.                 }
  69.                 if ($slugReason || $titleReason) {
  70.                     $productReport[] = [
  71.                         'type' => 'Product',
  72.                         'id' => $product->getId(),
  73.                         'language' => $language->getLocale(),
  74.                         'name' => $pl->getName(),
  75.                         'pl_slug' => $pl->getSlug() ?: '---',
  76.                         'lang_slug' => $lang ? $lang->getSlug() : '---',
  77.                         'pl_title' => $pl->getMetaTitle() ?: '---',
  78.                         'lang_title' => $lang ? $lang->getMetaTitle() : '---',
  79.                         'slug_reason' => $slugReason ?: '',
  80.                         'title_reason' => $titleReason ?: '',
  81.                     ];
  82.                 }
  83.             }
  85.             // ----------- CATEGORIES -----------
  86.             $categoryLangParams = $categoryLangParamRepo->createQueryBuilder('clp')
  87.                 ->join('clp.category', 'c')
  88.                 ->where('clp.language = :lang')
  89.                 ->andWhere('clp.visible = true')
  90.                 ->setParameter('lang', $language)
  91.                 ->getQuery()->getResult();
  93.             foreach ($categoryLangParams as $param) {
  94.                 $category = $param->getCategory();
  95.                 if ($category->getDeletedBy()) continue;
  97.                 $pl = $category->translate('pl');
  98.                 $lang = $category->translate($language->getLocale());
  100.                 $plSlug = $pl->getSlug();
  101.                 if (in_array($plSlug, ['premium', 'outlet', 'outlet-1', 'outlet-2'], true)) continue;
  103.                 $slugReason = null;
  104.                 $titleReason = null;
  106.                 if (!$lang || !$lang->getSlug()) {
  107.                     $slugReason = 'Missing';
  108.                 } elseif ($lang->getSlug() === $pl->getSlug()) {
  109.                     $slugReason = 'Not unique';
  110.                 }
  112.                 if (!$lang || !$lang->getMetaTitle()) {
  113.                     $titleReason = 'Missing';
  114.                 } elseif ($lang->getMetaTitle() === $pl->getMetaTitle()) {
  115.                     $titleReason = 'Not unique';
  116.                 }
  118.                 if ($slugReason || $titleReason) {
  119.                     $categoryReport[] = [
  120.                         'type' => 'Category',
  121.                         'id' => $category->getId(),
  122.                         'language' => $language->getLocale(),
  123.                         'name' => $pl->getName(),
  124.                         'pl_slug' => $plSlug ?: '---',
  125.                         'lang_slug' => $lang ? $lang->getSlug() : '---',
  126.                         'pl_title' => $pl->getMetaTitle() ?: '---',
  127.                         'lang_title' => $lang ? $lang->getMetaTitle() : '---',
  128.                         'slug_reason' => $slugReason ?: '',
  129.                         'title_reason' => $titleReason ?: '',
  130.                     ];
  131.                 }
  132.             }
  134.             // ----------- FURNITURE TYPES -----------
  135.             $furnitureLangParams = $furnitureLangParamRepo->createQueryBuilder('flp')
  136.                 ->join('flp.furnitureType', 'f')
  137.                 ->where('flp.language = :lang')
  138.                 ->andWhere('flp.visible = true')
  139.                 ->setParameter('lang', $language)
  140.                 ->getQuery()->getResult();
  142.             foreach ($furnitureLangParams as $param) {
  143.                 $furniture = $param->getFurnitureType();
  144.                 if ($furniture->getDeletedBy()) continue;
  146.                 $pl = $furniture->translate('pl');
  147.                 $lang = $furniture->translate($language->getLocale());
  149.                 $slugReason = null;
  150.                 $titleReason = null;
  152.                 if (!$lang || !$lang->getSlug()) {
  153.                     $slugReason = 'Missing';
  154.                 } elseif ($lang->getSlug() === $pl->getSlug()) {
  155.                     $slugReason = 'Not unique';
  156.                 }
  158.                 if (!$lang || !$lang->getMetaTitle()) {
  159.                     $titleReason = 'Missing';
  160.                 } elseif ($lang->getMetaTitle() === $pl->getMetaTitle()) {
  161.                     $titleReason = 'Not unique';
  162.                 }
  164.                 if ($slugReason || $titleReason) {
  165.                     $furnitureReport[] = [
  166.                         'type' => 'FurnitureType',
  167.                         'id' => $furniture->getId(),
  168.                         'language' => $language->getLocale(),
  169.                         'name' => $pl->getName(),
  170.                         'pl_slug' => $pl->getSlug() ?: '---',
  171.                         'lang_slug' => $lang ? $lang->getSlug() : '---',
  172.                         'pl_title' => $pl->getMetaTitle() ?: '---',
  173.                         'lang_title' => $lang ? $lang->getMetaTitle() : '---',
  174.                         'slug_reason' => $slugReason ?: '',
  175.                         'title_reason' => $titleReason ?: '',
  176.                     ];
  177.                 }
  178.             }
  179.         }
  181.         // -------- RENDER EMAIL --------
  182.         $htmlBody = $twig->render('emails/missing_slug_report.html.twig', [
  183.             'productRows' => $productReport,
  184.             'categoryRows' => $categoryReport,
  185.             'furnitureRows' => $furnitureReport,
  186.         ]);
  188.         // -------- CSV --------
  189.         $csvPath = getcwd() . '/missing-slugs-report.csv';
  190.         $fp = fopen($csvPath, 'w');
  191.         fputcsv($fp, ['Type', 'ID', 'Lang', 'Name', 'PL Slug', 'Lang Slug', 'Slug Reason', 'PL Title', 'Lang Title', 'Title Reason']);
  193.         foreach (array_merge($productReport, $categoryReport, $furnitureReport) as $row) {
  194.             fputcsv($fp, [
  195.                 $row['type'], $row['id'], $row['language'], $row['name'],
  196.                 $row['pl_slug'], $row['lang_slug'], $row['slug_reason'],
  197.                 $row['pl_title'], $row['lang_title'], $row['title_reason']
  198.             ]);
  199.         }
  200.         fclose($fp);
  202.         $this->sendEmailViaGetResponse($htmlBody, $csvPath);
  203.         $output->writeln('<info>Report generated and sent.</info>');
  204.     }
  206.     private function sendEmailViaGetResponse($htmlBody, $csvPath)
  207.     {
  208.         $csvFile = base64_encode(file_get_contents($csvPath));
  209.         $filename = basename($csvPath);
  211.         $content = [
  212.             'fromField' => ['fromFieldId' => 'f'],
  213.             'subject' => 'Slug & Title Report :: Missing or Non-Unique Translations',
  214.             'content' => [
  215.                 'html' => $htmlBody,
  216.                 'plain' => strip_tags($htmlBody),
  217.             ],
  218.             'recipients' => [
  219.                 'to' => ['email' => 'm.krupicka@centrumkrzesel.pl']
  220.             ],
  221.             'attachments' => [
  222.                 [
  223.                     'content' => $csvFile,
  224.                     'mimeType' => 'text/csv',
  225.                     'fileName' => $filename
  226.                 ]
  227.             ]
  228.         ];
  230.         $body = json_encode($content);
  232.         $ch = curl_init();
  233.         curl_setopt($ch, CURLOPT_URL, "https://api3.getresponse360.pl/v3/transactional-emails");
  234.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
  235.         curl_setopt($ch, CURLOPT_POSTFIELDS, $body);
  236.         curl_setopt($ch, CURLOPT_POST, 1);
  237.         curl_setopt($ch, CURLOPT_HTTPHEADER, [
  238.             "Content-Type: application/json",
  239.             "X-Auth-Token: api-key gs478s9uv59n5ekulmpmgn5p0uqpepbn",
  240.             "X-Domain: echairs.eu"
  241.         ]);
  242.         curl_exec($ch);
  243.         curl_close($ch);
  244.     }
  245. }