/** * Get the repository from the registry * We have to do this here because the call to registry::getRepository * requires the database to be setup which is a problem for using managers in console commands * * @return EntityRepository */ protected function getRepository() { if (!$this->repository) { $this->repository = $this->registry->getRepository($this->class); } return $this->repository; }
/** * @param Request $request * * @return bool|User */ public function tryAddUser(Request $request) { $params = $request->request->all(); if (!isset($params['user']['id'])) { return false; } $user = $this->_doctrine->getRepository('SiteBundle:User')->findOneBy(['vk' => $params['user']['id']]); if ($user) { return $user; } $user = new User(); $user->setName($params['user']['first_name']); $user->setLastname($params['user']['last_name']); $user->setVk($params['user']['id']); $user->setPassword($this->_generatePassword($params['user']['id'])); $user->setUsername($this->_generateUserName($params['user']['id'])); $user->setRole($this->_defaultRole()); $user->setPhone(''); $user->setPhoto(''); $user->setEmail(''); $em = $this->_doctrine->getManager(); $em->persist($user); $em->flush(); return $user; }
/** * Read available User/Host requirements from database * * @return array */ public function getRights() { /** @var UserHostRepository $repository */ $repository = $this->doctrine->getRepository($this->bundleName . ':UserHost'); $result = $repository->findAllSelect(); return $result; }
/** * @param $date * @param $item * @param $precision * @param $route_new * @param $route_show */ public function renderDay($date, $item, $project, $precision, $route_new, $route_show) { $start = new \DateTime($date); $end = (new \DateTime($date))->modify('+1 day'); $bookings = $this->doctrine->getRepository($this->entity)->createQueryBuilder('b')->select('b')->where('b.start <= :start and b.end >= :end')->orwhere('b.end >= :start and b.end <= :end')->orwhere('b.start >= :start and b.start <= :end')->andWhere('b.item = :item')->orderBy('b.start', 'ASC')->setParameters(array('start' => $start, 'end' => $end, 'item' => $item))->getQuery()->getResult(); return $this->environment->render('SladBookingBundle:Calendar:day.html.twig', array('date' => new \DateTime($date), 'item' => $item, 'project' => $project, 'bookings' => $bookings, 'precision' => $precision, 'route_new' => $route_new, 'route_show' => $route_show)); }
public function loadUserByUsername($username) { if (!$username) { return null; } return $this->_doctrine->getRepository('SiteBundle:User')->findOneBy(['username' => $username]); }
protected function execute(InputInterface $input, OutputInterface $output) { $this->output = $output; $this->institutionMediaService = $this->getContainer()->get('services.institution.media'); $this->fileSystem = $this->institutionMediaService->getFilesystem(); $this->logoSizes = $this->institutionMediaService->getSizesByType(InstitutionMediaService::LOGO_TYPE_IMAGE); $this->featuredMediaSizes = $this->institutionMediaService->getSizesByType(InstitutionMediaService::FEATURED_TYPE_IMAGE); $this->gallerySizes = $this->institutionMediaService->getSizesByType(InstitutionMediaService::GALLERY_TYPE_IMAGE); // loop through all institutions $this->doctrine = $this->getContainer()->get('doctrine'); $institutions = $this->doctrine->getRepository('InstitutionBundle:Institution')->findAll(); foreach ($institutions as $_institution) { $this->output->writeln('Migrating images of institution #' . $_institution->getId()); $this->output->write(" "); // migrate logo $this->migrateLogo($_institution); $this->output->write(" "); // migrate banner $this->migrateFeaturedMedia($_institution); $this->output->write(" "); // migrate gallery $this->migrateGallery($_institution); $this->output->write(" "); // migrate clinic logos foreach ($_institution->getInstitutionMedicalCenters() as $imc) { $this->migrateClinicLogo($imc); $this->output->write(" "); } $this->output->writeln('All Done.'); } $this->output->writeln('END OF SCRIPT'); }
public function getCode($bannerType, $place = null, $referenceId = null) { $bannerRepository = $this->doctrine->getRepository('AciliaBannerBundle:Banner'); $bannerTag = ''; if ($place == null) { $place = $this->place; } // If Place is not defined, Ad can't be shown if (null === $place) { return $bannerTag; } if ($referenceId === false) { $referenceId = null; } elseif ($referenceId == null) { $referenceId = $this->referenceId; } $context = $this->getContext(); // Get URL $currentUrl = $this->requestStack->getMasterRequest()->getPathInfo(); // Get resource and context $event = new ResourceBannerEvent(); $this->dispatcher->dispatch(ResourceBannerEvent::NAME, $event); if ($event->isAvailable()) { $resource = $event->getResource(); // Overwrite ad context if required if ($event->getContext() != null) { $context = $event->getContext(); } // Banner identifier key $key = 'Banner:' . $resource . ':' . $context . ':' . $place . ':' . $bannerType . ':' . $referenceId . ':' . sha1($currentUrl); if (isset($this->instances[$key])) { return $this->instances[$key]; } $bannerTag = $this->memcache->get($key); if ($this->memcache->notFound()) { // Create Banner Tag $bannerTag = new BannerTag(); $bannerTag->setResource($resource)->setBannerType($bannerType)->setPlace($place)->setContext($context)->setReferenceId($referenceId)->setCacheKey($key); if ($bannerRepository->isPageAvailable($bannerTag, $currentUrl, $this->getType('none'))) { return '<!-- BANNER BEGIN - This page has it\'s Ads Disabled - BANNER END -->'; } // Fill Banner Tag $bannerRepository->fillBannerTag($bannerTag, $currentUrl, $this->getType($bannerTag->getBannerType())); $fallbacks = $this->fallbacks; while ($bannerTag->isEmpty() && count($fallbacks) > 0) { $fallback = array_slice($fallbacks, 0, 1); array_shift($fallbacks); $place = key($fallback); $referenceId = $fallback[$place]; $bannerTag->setPlace($place)->setReferenceId($referenceId); // Fill Banner Tag $bannerRepository->fillBannerTag($bannerTag, $currentUrl, $this->getType($bannerTag->getBannerType())); } // Save on Memcache and internally $this->instances[$key] = $bannerTag; $this->memcache->set($key, $bannerTag, 60); } } return $bannerTag; }
/** * reverseTransform * * @param integer $idx * * @return \Erichard\DmsBundle\Entity\DocumentNode|null|object */ public function reverseTransform($idx) { if (null === $idx) { return null; } return $this->registry->getRepository('Erichard\\DmsBundle\\Entity\\DocumentNode')->find($idx); }
/** * @param Registry $manager, * @param RequestStack $requestStack, * @param ObjectManager $persistence * * @InjectParams({ * "manager" = @Inject("doctrine"), * "requestStack" = @Inject("request_stack"), * "persistence" = @Inject("claroline.persistence.object_manager") * }) */ public function __construct(Registry $manager, RequestStack $requestStack, ObjectManager $persistence) { $this->manager = $persistence; $this->request = $requestStack->getCurrentRequest(); $this->content = $manager->getRepository('ClarolineCoreBundle:Content'); $this->translations = $manager->getRepository('ClarolineCoreBundle:ContentTranslation'); }
/** * Looks for the object that corresponds to the selected 'id' of the current entity. * * @param array $entityConfig * @param mixed $itemId * * @return object The entity * * @throws EntityNotFoundException */ private function findCurrentItem(array $entityConfig, $itemId) { if (null === ($entity = $this->doctrine->getRepository($entityConfig['class'])->find($itemId))) { throw new EntityNotFoundException(array('entity' => $entityConfig, 'entity_id' => $itemId)); } return $entity; }
/** * @param int $nodeId * @param null|string $type * * @return NodeReferenceInterface */ public function loadNode($nodeId, $type = null) { if (is_null($type)) { $node = $this->registry->getRepository('ClasticNodeBundle:Node')->find($nodeId); $type = $node->getType(); } return $this->registry->getRepository($this->getEntityName($type))->findOneBy(array('node' => $nodeId)); }
private function canYouDoIt(Comment $comment, User $user) { $commentOwner = $this->doctrine->getRepository('AppBundle:User')->findOneBy(array('email' => $comment->getAuthorEmail())); if (in_array("ROLE_ADMIN", $commentOwner->getRoles()) || $comment->getArticle()->getAuthorEmail() !== $user->getEmail()) { return false; } return true; }
/** * @param RemoveDojoCommand $command */ public function handle(RemoveDojoCommand $command) { $dojo = $this->doctrine->getRepository('CoderDojoWebsiteBundle:Dojo')->find($command->getId()); $this->doctrine->remove($dojo); $this->doctrine->flush(); $event = new DojoRemovedEvent($command->getId()); $this->eventRecorder->record($event); }
/** * @param mixed $context */ protected function executeAction($context) { $settingsClass = $this->contextAccessor->getValue($context, $this->processType); $settingsClass = $this->processStorage->getProcess($settingsClass)->getSettingsEntityFQCN(); $email = $this->contextAccessor->getValue($context, $this->email); $results = $this->doctrine->getRepository('OroEmailBundle:Mailbox')->findBySettingsClassAndEmail($settingsClass, $email); $this->contextAccessor->setValue($context, $this->attribute, $results); }
/** * Fetches the data associated to the given parser parameters. * * @param string $function * @param string $parser * @param object $target * * @return mixed * Returns the associated cache data or null if it not exists. */ public function get($function, $parser, $target) { $cacheKey = $this->buildCacheKey($function, $parser, $target); $cacheEntry = $this->doctrine->getRepository('PHPSanitizer\\ProjectBundle\\Entity\\AnalysesParsersCache')->findOneBy(array('key' => $cacheKey)); if ($cacheEntry === null) { return null; } return $cacheEntry->getData(); }
/** * Sets search repository * * @param AbstractSearch $search */ protected function handleRepository(AbstractSearch $search) { $entityClass = $search->getOption('entityClass'); $entityManagerName = $search->getOption('entityManagerName'); if (null === $entityClass) { throw new \InvalidArgumentException('Option entityClass must be set'); } $search->setRepository($this->doctrine->getRepository($entityClass, $entityManagerName)); }
/** * Constructor * * @param Registry $doctrineRegistry * @param JiraService $jiraService */ public function __construct(Registry $doctrineRegistry, JiraService $jiraService, Filesystem $fileSystem) { $this->settingsRepository = $doctrineRegistry->getRepository('MDVPriorityBundle:Settings'); $this->issueRepository = $doctrineRegistry->getRepository('MDVPriorityBundle:Issue'); $this->voteRepository = $doctrineRegistry->getRepository('MDVPriorityBundle:Vote'); $this->stakeholderRepository = $doctrineRegistry->getRepository('MDVPriorityBundle:Stakeholder'); $this->priorityRepository = $doctrineRegistry->getRepository('MDVPriorityBundle:Priority'); $this->jiraService = $jiraService; $this->fileSystem = $fileSystem; }
public function printCategoriesList() { // żeby nie robiło dwuch zapytać o to samo if (!isset($this->categoriesList)) { $CategoryRepo = $this->doctrine->getRepository('AirBlogBundle:Category'); $this->categoriesList = $CategoryRepo->findAll(); } //renderowanie szablonu views/Template/categoriesList return $this->environment->render('AirBlogBundle:Template:categoriesList.html.twig', array('categoriesList' => $this->categoriesList)); }
/** * @param array $entityInf * @param int $parentId * @return array */ public function getEntities($entityInf, $parentId) { /** @var EntityRepository $repository */ $repository = $this->doctrine->getRepository($entityInf['class']); /** @var QueryBuilder $queryBuilder */ $queryBuilder = $repository->createQueryBuilder('e'); $queryBuilder->where($queryBuilder->expr()->eq('e.' . $entityInf['parent_property'], ':parentId'))->orderBy('e.' . $entityInf['order_property'], $entityInf['order_direction'])->setParameter('parentId', $parentId); $this->setCallback($repository, $queryBuilder, $entityInf); return $queryBuilder->getQuery()->getResult(); }
/** * {@inheritdoc} */ public function setDefaultOptions(OptionsResolverInterface $resolver) { $choices = function (Options $options) { if (empty($options['entity_class'])) { return []; } return $this->aclHelper->apply($this->doctrine->getRepository('OroTagBundle:Tag')->createQueryBuilder('t')->join('t.tagging', 'tagging')->where('tagging.entityName = :entity')->setParameter('entity', $options['entity_class']))->getResult(); }; $resolver->setDefaults(['class' => 'OroTagBundle:Tag', 'property' => 'name', 'entity_class' => null, 'choices' => $choices]); }
public function getAllianceCorps(Character $char, Registry $doctrine) { $leaderCorp = $doctrine->getRepository('AppBundle:Corporation')->findByCorpName($char->getCorporationName()); if ($leaderCorp === null) { // this is bad return false; } $registeredAllianceCorps = $doctrine->getRepository('AppBundle:Corporation')->findCorporationsByAlliance($leaderCorp->getCorporationDetails()->getAllianceName()); return $registeredAllianceCorps; }
/** * @dataProvider autoCompleteHandlerProvider * @param boolean $active * @param string $handlerName */ public function testAutoCompleteHandler($active, $handlerName, $query) { $user = $this->registry->getRepository('OroUserBundle:User')->findOneBy(['username' => 'simple_user2']); $user->setEnabled($active); $this->registry->getManager()->flush(); $this->client->request('GET', $this->getUrl('oro_email_mailbox_users_search', ['organizationId' => $user->getOrganization()->getId()]), array('page' => 1, 'per_page' => 10, 'name' => $handlerName, 'query' => $query)); $result = $this->client->getResponse(); $arr = $this->getJsonResponseContent($result, 200); $this->assertCount((int) $active, $arr['results']); }
public function validate($value, Constraint $constraint) { //$value = $entity->getName(); $institution = $this->doctrine->getRepository('InstitutionBundle:Institution')->findOneBy(array('name' => $value)); if (!$institution) { return; } $this->context->addViolation($constraint->message, array('{{ field }}' => $value)); return; }
/** * * @param array $inquiryIds * @param unknown_type $status */ public function updateInquiriesStatus(array $inquiryIds, $status) { $inquiries = $this->doctrine->getRepository('InstitutionBundle:InstitutionInquiry')->findById($inquiryIds); $em = $this->doctrine->getEntityManager(); foreach ($inquiries as $inquiry) { $inquiry->setStatus($status); $em->persist($inquiry); } return $em->flush(); }
/** * @param $item * @param string $start * @param int $months * @return string * @throws \InvalidArgumentException */ public function renderCalendar($item, $start = 'now', $months = 1) { if (intval($months) === 0) { throw new \InvalidArgumentException('Month number should be integer'); } $now = new \DateTime($start); $end = new \DateTime(); $end->add(new \DateInterval('P' . $months . 'M')); $bookings = $this->doctrine->getRepository($this->entity)->createQueryBuilder('b')->select('b')->where('b.start >= :now')->orWhere('b.start <= :end')->orWhere('b.end >= :now')->andWhere('b.item = :item')->orderBy('b.start', 'ASC')->setParameters(array('now' => $now, 'end' => $end, 'item' => $item))->getQuery()->getResult(); return $this->environment->render('MelifaroBookingBundle:Calendar:month.html.twig', array('bookings' => $bookings, 'start' => $start, 'months' => $months)); }
/** * @param mixed $value The value in the transformed representation * @return mixed The value in the original representation * @throws TransformationFailedException When the transformation fails. */ public function reverseTransform($username) { if (!$username) { return null; } $user = $this->registry->getRepository('AppBundle:User')->findOneBy(array('username' => $username)); if (!$user) { throw new TransformationFailedException($this->translator->trans('user.unknownusername')); } return $user; }
/** * et entity assuming the value is the id and then return it * @param type $sourceFieldValue * @param Reference $source * @param Reference $destination * @return type * @throws \Exception */ public function forward($sourceFieldValue, $field, $source, $destination) { $entityClass = $this->getEntityClass(); if (!$entityClass) { $entityClass = get_class($destination); } $repository = $this->doctrine->getRepository($entityClass); if (!$repository) { throw new TransformationException('Could not resolve doctrine entity from destination type'); } return $repository->find($sourceFieldValue); }
/** * Get email entities from owner entity * * @param object $entity * @return array */ public function getEmailsByOwnerEntity($entity) { $ownerColumnName = null; foreach ($this->emailOwnerStorage->getProviders() as $provider) { if ($this->activityListChainProvider->isSupportedTargetEntity($entity) && $provider->getEmailOwnerClass() === ClassUtils::getClass($entity)) { $ownerColumnName = $this->emailOwnerStorage->getEmailOwnerFieldName($provider); break; } } if ($ownerColumnName === null) { return []; } return $this->registry->getRepository('OroEmailBundle:Email')->getEmailsByOwnerEntity($entity, $ownerColumnName); }
/** * Apply custom ACL checks * * @param QueryBuilder $qb */ public function applyAcl(QueryBuilder $qb) { $user = $this->securityFacade->getLoggedUser(); $organization = $this->securityFacade->getOrganization(); $mailboxIds = $this->doctrine->getRepository('OroEmailBundle:Mailbox')->findAvailableMailboxIds($user, $organization); $uoCheck = $qb->expr()->andX($qb->expr()->eq('eu.owner', ':owner'), $qb->expr()->eq('eu.organization ', ':organization')); if (!empty($mailboxIds)) { $qb->andWhere($qb->expr()->orX($uoCheck, $qb->expr()->in('eu.mailboxOwner', ':mailboxIds'))); $qb->setParameter('mailboxIds', $mailboxIds); } else { $qb->andWhere($uoCheck); } $qb->setParameter('owner', $user->getId()); $qb->setParameter('organization', $organization->getId()); }
/** * @param string $ticket * @param string $email * @return bool */ public function validate($ticket, $email = null) { if (!$ticket) { throw new \InvalidArgumentException('Invalid ticket'); } /** @var RegistrationApplicationRepository $registrationApplicationRepo */ $registrationApplicationRepo = $this->doctrine->getRepository('RegistrarBundle:RegistrationApplication'); if ($registrationApplication = $registrationApplicationRepo->getUnexpired($email, $ticket)) { $this->expireRegistrationApplication($registrationApplication); return true; } else { throw new \RuntimeException('Invalid ticket'); } return false; }