X-Git-Url: https://git.rapsys.eu/airbundle/blobdiff_plain/9d4b25a60ff36b21f841ad7bf785186f270c91ef..0157506456243f8e0ee762b7a7b4a84da0446909:/Repository/Repository.php?ds=sidebyside diff --git a/Repository/Repository.php b/Repository/Repository.php deleted file mode 100644 index fcf7d6a..0000000 --- a/Repository/Repository.php +++ /dev/null @@ -1,173 +0,0 @@ - - * - * For the full copyright and license information, please view the LICENSE - * file that was distributed with this source code. - */ - -namespace Rapsys\AirBundle\Repository; - -use Doctrine\ORM\EntityManagerInterface; -use Doctrine\ORM\EntityRepository; -use Doctrine\ORM\Mapping\ClassMetadata; -use Symfony\Component\Routing\RouterInterface; -use Symfony\Contracts\Translation\TranslatorInterface; - -use Rapsys\PackBundle\Util\SluggerUtil; - -/** - * Repository - * - * {@inheritdoc} - */ -class Repository extends EntityRepository { - /** - * The RouterInterface instance - * - * @var RouterInterface - */ - protected RouterInterface $router; - - /** - * The SluggerUtil instance - * - * @var SluggerUtil - */ - protected SluggerUtil $slugger; - - /** - * The table keys array - * - * @var array - */ - protected array $tableKeys; - - /** - * The table values array - * - * @var array - */ - protected array $tableValues; - - /** - * The TranslatorInterface instance - * - * @var TranslatorInterface - */ - protected TranslatorInterface $translator; - - /** - * The list of languages - * - * @var string[] - */ - protected array $languages = []; - - /** - * The current locale - * - * @var string - */ - protected string $locale; - - /** - * Initializes a new LocationRepository instance - * - * @param EntityManagerInterface $manager The EntityManagerInterface instance - * @param ClassMetadata $class The ClassMetadata instance - * @param RouterInterface $router The router instance - * @param SluggerUtil $slugger The SluggerUtil instance - * @param TranslatorInterface $translator The TranslatorInterface instance - * @param array $languages The languages list - * @param string $locale The current locale - */ - public function __construct(EntityManagerInterface $manager, ClassMetadata $class, RouterInterface $router, SluggerUtil $slugger, TranslatorInterface $translator, array $languages, string $locale) { - //Call parent constructor - parent::__construct($manager, $class); - - //Set languages - $this->languages = $languages; - - //Set locale - $this->locale = $locale; - - //Set router - $this->router = $router; - - //Set slugger - $this->slugger = $slugger; - - //Set translator - $this->translator = $translator; - - //Get quote strategy - $qs = $manager->getConfiguration()->getQuoteStrategy(); - $dp = $manager->getConnection()->getDatabasePlatform(); - - //Set quoted table names - //XXX: this allow to make this code table name independent - //XXX: remember to place longer prefix before shorter to avoid strange replacings - $tables = [ - 'RapsysAirBundle:UserDance' => $qs->getJoinTableName($manager->getClassMetadata('RapsysAirBundle:User')->getAssociationMapping('dances'), $manager->getClassMetadata('RapsysAirBundle:User'), $dp), - 'RapsysAirBundle:UserGroup' => $qs->getJoinTableName($manager->getClassMetadata('RapsysAirBundle:User')->getAssociationMapping('groups'), $manager->getClassMetadata('RapsysAirBundle:User'), $dp), - 'RapsysAirBundle:UserLocation' => $qs->getJoinTableName($manager->getClassMetadata('RapsysAirBundle:User')->getAssociationMapping('locations'), $manager->getClassMetadata('RapsysAirBundle:User'), $dp), - 'RapsysAirBundle:Application' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Application'), $dp), - 'RapsysAirBundle:Civility' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Civility'), $dp), - 'RapsysAirBundle:Country' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Country'), $dp), - 'RapsysAirBundle:Dance' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Dance'), $dp), - 'RapsysAirBundle:Group' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Group'), $dp), - 'RapsysAirBundle:Location' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Location'), $dp), - 'RapsysAirBundle:Session' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Session'), $dp), - 'RapsysAirBundle:Slot' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Slot'), $dp), - 'RapsysAirBundle:Snippet' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:Snippet'), $dp), - 'RapsysAirBundle:User' => $qs->getTableName($manager->getClassMetadata('RapsysAirBundle:User'), $dp), - //Set accuweather max number of daily pages - ':accudaily' => 12, - //Set accuweather max number of hourly pages - ':accuhourly' => 3, - //Set guest delay - ':guestdelay' => 2 * 24 * 3600, - //Set regular delay - ':regulardelay' => 3 * 24 * 3600, - //Set senior delay - ':seniordelay' => 4 * 24 * 3600, - //Set guest group id - ':guestid' => 2, - //Set regular group id - ':regularid' => 3, - //Set senior group id - ':seniorid' => 4, - //Set afternoon slot id - ':afternoonid' => 2, - //Set evening slot id - ':eveningid' => 3, - //Set after slot id - ':afterid' => 4, - //XXX: days since last session after which guest regain normal priority - ':guestwait' => 30, - //XXX: session count until considered at regular delay - ':scount' => 5, - //XXX: pn_ratio over which considered at regular delay - ':pnratio' => 1, - //XXX: tr_ratio diff over which considered at regular delay - ':trdiff' => 5, - //Set locale - //XXX: or $manager->getConnection()->quote($this->locale) ??? - ':locale' => $dp->quoteStringLiteral($this->locale), - //XXX: Set limit used to workaround mariadb subselect optimization - ':limit' => PHP_INT_MAX, - "\t" => '', - "\n" => ' ' - ]; - - //Set quoted table name keys - $this->tableKeys = array_keys($tables); - - //Set quoted table name values - $this->tableValues = array_values($tables); - } -}