src/Services/TranslationsImportService.php line 79

  1. <?php
  4. namespace App\Services;
  7. use App\Entity\Import;
  8. use App\Entity\Translation;
  9. use App\Repository\TranslationRepository;
  10. use Doctrine\ORM\EntityManagerInterface;
  11. use Symfony\Component\DependencyInjection\ContainerInterface;
  13. class TranslationsImportService
  14. {
  15.     public function importTranslations(string $fileName)
  16.     {
  17.         $filepath = $this->container->getParameter('translations_import_directory');
  18.         $fullpath = $filepath . $fileName;
  19.         $alldatatsFromCsv = [];
  20.         $row = 0;
  21.         if (($handle = fopen($fullpath, "r")) !== FALSE) {
  22.             while (($data = fgetcsv($handle, 10000, ",")) !== FALSE) {
  23.                 if ($row == 0) {
  24.                     $row++;
  25.                     continue;
  26.                 }
  27.                 $num = count($data);
  28.                 $row++;
  29.                 for ($c = 0; $c < $num; $c++) {
  30.                     $alldatatsFromCsv[$row][] = $data[$c];
  31.                 }
  32.             }
  33.             fclose($handle);
  34.         }
  36.         foreach ($alldatatsFromCsv as $oneLineFromCsv) {
  37.             $entity = trim($oneLineFromCsv[0]);
  38.             $english = trim($oneLineFromCsv[1]);
  39.             $french = trim($oneLineFromCsv[2]);
  40.             $german = trim($oneLineFromCsv[3]);
  41.             $spanish = trim($oneLineFromCsv[4]);
  42.             $russian = trim($oneLineFromCsv[5]);
  43.             $old_translation = $this->translationRepository->findOneBy(['english' => $english]);
  44.             if ($old_translation) {
  45.                 if (
  46.                     $old_translation->getEntity() == $entity &&
  47.                     $old_translation->getEnglish() == $english &&
  48.                     $old_translation->getFrench() == $french &&
  49.                     $old_translation->getGerman() == $german &&
  50.                     $old_translation->getSpanish() == $spanish &&
  51.                     $old_translation->getRussian() == $russian
  52.                 ) {
  53.                     continue;
  54.                 } else {
  55.                     $old_translation
  56.                         ->setEntity($entity)
  57.                         ->setFrench($french)
  58.                         ->setGerman($german)
  59.                         ->setSpanish($spanish)
  60.                         ->setRussian($russian);
  61.                     $this->manager->flush();
  62.                 }
  63.             } else {
  64.                 $new_translation = new Translation();
  65.                 $new_translation->setEntity($entity)
  66.                     ->setEnglish($english)
  67.                     ->setFrench($french)
  68.                     ->setGerman($german)
  69.                     ->setSpanish($spanish)
  70.                     ->setRussian($russian);
  71.                 $this->manager->persist($new_translation);
  72.                 $this->manager->flush();
  73.             }
  74.         }
  75.         return null;
  76.     }
  78.     public function __construct(ContainerInterface $container, TranslationRepository $translationRepository, EntityManagerInterface $manager)
  79.     {
  80.         $this->container = $container;
  81.         $this->manager = $manager;
  82.         $this->translationRepository = $translationRepository;
  83.     }
  84. }