src/Services/TranslationsImportService.php line 78

  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_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.             $english = trim($oneLineFromCsv[0]);
  38.             $french = trim($oneLineFromCsv[1]);
  39.             $german = trim($oneLineFromCsv[2]);
  40.             $spanish = trim($oneLineFromCsv[3]);
  41.             $russian = trim($oneLineFromCsv[4]);
  42.             $old_translation = $this->translationRepository->findOneBy(['english' => $english ]);
  43.             if ($old_translation) {
  44.                 if ($old_translation->getEnglish() == $english &&
  45.                     $old_translation->getFrench() == $french &&
  46.                     $old_translation->getGerman() == $german &&
  47.                     $old_translation->getSpanish() == $spanish &&
  48.                     $old_translation->getRussian() == $russian
  49.                 ) {
  50.                    continue;
  51.                 } else {
  52.                     $old_translation
  53.                         ->setFrench($french)
  54.                         ->setGerman($german)
  55.                         ->setSpanish($spanish)
  56.                         ->setRussian($russian);
  58.                     $this->manager->flush();
  59.                 }
  60.             }
  61.             else{
  62.                 $new_translation = new Translation();
  63.                 $new_translation->setEnglish($english)
  64.                     ->setFrench($french)
  65.                     ->setGerman($german)
  66.                     ->setSpanish($spanish)
  67.                     ->setRussian($russian);
  68.                 $this->manager->persist($new_translation);
  69.                 $this->manager->flush();
  70.             }
  71.         }
  72.         return null;
  73.     }
  75.     public function __construct(ContainerInterface $container, TranslationRepository $translationRepository, EntityManagerInterface $manager)
  76.     {
  77.         $this->container = $container;
  78.         $this->manager = $manager;
  79.         $this->translationRepository = $translationRepository;
  80.     }
  81. }