src/Service/OtpuskDbService.php line 35

Open in your IDE?
  1. <?php
  3. namespace App\Service;
  5. use App\EntityOtpusk\Tcities;
  6. use App\EntityOtpusk\Tcountries;
  7. use App\EntityOtpusk\Tregions;
  8. use App\RepositoryOtpusk\CitiesRepository;
  9. use App\RepositoryOtpusk\CountriesRepository;
  10. use App\RepositoryOtpusk\RegionsRepository;
  11. use Doctrine\ORM\EntityManagerInterface;
  12. use Doctrine\Persistence\ManagerRegistry;
  14. class OtpuskDbService
  15. {
  17.     /**
  18.      * @var \App\RepositoryOtpusk\RegionsRepository
  19.      */
  20.     private RegionsRepository $regionsRepository;
  22.     public function __construct(
  23.         ManagerRegistry $doctrine,
  24.         CitiesRepository $citiesRepository,
  25.         CountriesRepository $countriesRepository,
  26.         RegionsRepository $regionsRepository
  27.     ) {
  28.         $this->doctrine            = $doctrine;
  29.         $this->citiesRepository    = $citiesRepository;
  30.         $this->countriesRepository = $countriesRepository;
  31.         $this->regionsRepository   = $regionsRepository;
  33.     }
  35.     public function findByRecId($id = null, $type)
  36.     {
  37.         $anotherEm = $this->doctrine->getManager('otpusk');
  38.         switch ($type) {
  39.             case 'country':
  40.                 return $anotherEm->getRepository(Tcountries::class)->findOneBy(['recId' => $id]);
  41.                 break;
  42.             case 'city':
  43.                 return $anotherEm->getRepository(Tcities::class)->findOneBy(['recId' => $id]);
  44.                 break;
  45.             case 'region':
  46.                 return $anotherEm->getRepository(Tregions::class)->findOneBy(['recId' => $id]);
  47.                 break;
  48.             default:
  50.                 break;
  51.         }
  52.     }
  54.     public function findAll($type)
  55.     {
  56.         $anotherEm = $this->doctrine->getManager('otpusk');
  57.         switch ($type) {
  58.             case 'country':
  59.                 return $anotherEm->getRepository(Tcountries::class)->findAll();
  60.                 break;
  61.             case 'city':
  62.                 return $anotherEm->getRepository(Tcities::class)->findAll();
  63.                 break;
  64.             case 'region':
  65.                 return $anotherEm->getRepository(Tregions::class)->findAll();
  66.                 break;
  67.             default:
  69.                 break;
  70.         }
  71.     }
  73.     public function findByName($name = null, $type)
  74.     {
  75.         $anotherEm = $this->doctrine->getManager('otpusk');
  76.         switch ($type) {
  77.             case 'country':
  78.                 return $this->countriesRepository->findOneByName($name);
  79.                 break;
  80.             case 'city':
  81.                 return $this->citiesRepository->findOneByName($name);
  82.                 break;
  83.             case 'region':
  84.                 return $this->regionsRepository->findOneByName($name);
  85.                 break;
  86.             default:
  88.                 break;
  89.         }
  90.     }
  93.     public function country($id = null)
  94.     {
  95.         $anotherEm = $this->doctrine->getManager('otpusk');
  97.         return $anotherEm->getRepository(Tcountries::class)
  98.                          ->findOneBy(['recId' => $id]);
  99.     }
  100. }