PHP Datagrid\DatagridMapper類代碼示例

 /**
  * @param \Sonata\AdminBundle\Datagrid\DatagridMapper $datagridMapper
  *
  * @return void
  */
 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $container = $this->getConfigurationPool()->getContainer();
     $entityManager = $container->get('doctrine.orm.default_entity_manager');
     $datagridMapper->add('locale', 'doctrine_orm_callback', ['label' => 'Langue', 'callback' => function (ProxyQuery $queryBuilder, $alias, $field, $value) {
         if (!$value['value']) {
             return false;
         }
         $queryBuilder->andWhere($alias . '.locale = :locale')->setParameter('locale', $value['value']);
         return true;
     }], 'choice', ['choices' => $this->getRealLocales()])->add('title', null, ['label' => 'Page'])->add('published', null, ['label' => 'Publié'])->add('node', 'doctrine_orm_callback', ['label' => 'Type de contenu', 'callback' => function (ProxyQuery $queryBuilder, $alias, $field, $value) use($entityManager) {
         if (!$value['value']) {
             return false;
         }
         // We can't query the type from the AlpixelCMSBundle:Node repository (InheritanceType) because of that
         // we try to get the repository in AppBundle with the value which is the class name of entity. :pig:
         try {
             $repository = $entityManager->getRepository(sprintf('AppBundle:%s', ucfirst($value['value'])));
         } catch (\Doctrine\Common\Persistence\Mapping\MappingException $e) {
             return false;
         }
         $data = $repository->findAll();
         if (empty($data)) {
             return false;
         }
         $queryBuilder->andWhere($alias . '.id IN (:ids)')->setParameter('ids', $data);
         return true;
     }], 'choice', ['choices' => $this->getCMSEntityTypes()]);
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $container = $this->getConfigurationPool()->getContainer();
     $roles = $container->getParameter('security.role_hierarchy.roles');
     $rolesChoices = self::flattenRoles($roles);
     $datagridMapper->add('username')->add('firstname')->add('lastname');
 }

 /**
  * {@inheritdoc}
  */
 protected function configureDatagridFilters(DatagridMapper $filter)
 {
     $filter->add('current')->add('type', null, array(), 'sonata_customer_address_types', array('translation_domain' => 'SonataCustomerBundle'));
     if (!$this->isChild()) {
         $filter->add('customer');
     }
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $datagridMapper
         ->add('title', 'doctrine_phpcr_string')
         ->add('name',  'doctrine_phpcr_nodename')
     ;
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $datagridMapper->add('id', null, array('label' => 'order_id'));
     if (!$this->isChild()) {
         $datagridMapper->add('partner', null, array('label' => 'customer'));
     }
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     // Getting the container parameters set in the config file that exist
     $commentSettings = $this->getConfigurationPool()->getContainer()->getParameter('comment_settings');
     $commentTypeChoice = $commentSettings['commenttypes'];
     $datagridMapper->add('title')->add('commentType', 'doctrine_orm_string', array(), 'choice', array('choices' => $commentTypeChoice))->add('blogPost')->add('created', 'doctrine_orm_date_range', array('input_type' => 'date'), 'sonata_type_date_range')->add('username')->add('approved', 'doctrine_orm_string', array(), 'choice', array('choices' => array('0' => 'Hide', '1' => 'Show')));
 }

 /**
  * {@inheritdoc}
  */
 protected function configureDatagridFilters(DatagridMapper $datagridMapper, $context = '')
 {
     $datagridMapper->add('name', 'networking_init_cms_simple_string')->add('enabled', null, array('hidden' => true));
     if ($context) {
         $datagridMapper->add('context', null, array('hidden' => true));
     }
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $em = $this->modelManager->getEntityManager('Vidal\\MainBundle\\Entity\\User');
     $cityChoices = $em->getRepository('VidalMainBundle:City')->getChoices();
     $regionChoices = $em->getRepository('VidalMainBundle:Region')->getChoices();
     $countryChoices = $em->getRepository('VidalMainBundle:Country')->getChoices();
     $datagridMapper->add('id')->add('username', null, array('label' => 'E-mail'))->add('lastName', null, array('label' => 'Фамилия'))->add('primarySpecialty', null, array('label' => 'Основная специальность'))->add('city', 'doctrine_orm_choice', array('label' => 'Город'), 'choice', array('choices' => $cityChoices))->add('region', 'doctrine_orm_choice', array('label' => 'Область'), 'choice', array('choices' => $regionChoices))->add('country', 'doctrine_orm_choice', array('label' => 'Страна'), 'choice', array('choices' => $countryChoices))->add('emailConfirmed', null, array('label' => 'e-mail подтвержден'))->add('oldUser', null, array('label' => 'Со старого сайта'))->add('confirmationHas', null, array('label' => 'Со сканами'));
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     // Getting the container parameters set in the config file that exist
     $tagSettings = $this->getConfigurationPool()->getContainer()->getParameter('tag_settings');
     // Setting up the available tag categories and preffered choice
     $tagcategoriesChoices = $tagSettings['tagcategories'];
     $datagridMapper->add('title')->add('tagCategory', 'doctrine_orm_string', array(), 'choice', array('choices' => $tagcategoriesChoices));
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $datagridMapper->add('quizset')->add('content')->add('type');
     //    ->add('quizset','many_to_one', array())
     //    ->add('dateStart','doctrine_orm_datetime', array('label' => 'Data startu'))
     //    ->add('dateEnd', 'doctrine_orm_datetime', array('label' => 'Data końca'))
     //;
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     // Getting the container parameters set in the config file that exist
     $contentblockSettings = $this->getConfigurationPool()->getContainer()->getParameter('contentblock_settings');
     // Setting up the available content types and preffered choice
     $contentTypeChoices = $contentblockSettings['contenttypes'];
     $datagridMapper->add('title')->add('availability', 'doctrine_orm_string', array(), 'choice', array('choices' => array('page' => 'Page Only', 'global' => 'Global')))->add('publishState', 'doctrine_orm_string', array(), 'choice', array('choices' => array('0' => 'Unpublished', '1' => 'Published')))->add('contentType', 'doctrine_orm_string', array(), 'choice', array('choices' => $contentTypeChoices))->add('className');
 }

 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     // Getting the container parameters set in the config file that exist
     $skeletonSettings = $this->getConfigurationPool()->getContainer()->getParameter('skeleton_settings');
     // Setting up the available page types and preffered choice
     $pagetypeChoices = $skeletonSettings['pagetypes'];
     $datagridMapper->add('title')->add('publishState', 'doctrine_orm_string', array(), 'choice', array('choices' => array('0' => 'Unpublished', '1' => 'Published', '2' => 'Preview')))->add('pagetype', 'doctrine_orm_string', array(), 'choice', array('choices' => $pagetypeChoices))->add('categories')->add('tags')->add('author')->add('date', 'doctrine_orm_date_range', array('input_type' => 'date'), 'sonata_type_date_range');
 }

 /**
  * {@inheritdoc}
  */
 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $datagridMapper->add('id');
     if (interface_exists('Sonata\\ClassificationBundle\\Model\\CategoryInterface')) {
         $datagridMapper->add('category');
     }
     $datagridMapper->add('permalink')->add('isCommentable');
 }

 /**
  * {@inheritdoc}
  */
 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $options = array();
     if (1 === $this->getPersistentParameter('hide_context')) {
         $options['disabled'] = true;
     }
     $datagridMapper->add('context', null, array(), null, $options);
 }

 /**
  * @param \Sonata\AdminBundle\Datagrid\DatagridMapper $datagridMapper
  * @return void
  */
 protected function configureDatagridFilters(DatagridMapper $datagridMapper)
 {
     $datagridMapper->add('name')->add('providerReference')->add('enabled')->add('context');
     $providers = array();
     foreach ($this->pool->getProviderNamesByContext('default') as $name) {
         $providers[$name] = $name;
     }
     $datagridMapper->add('providerName', 'doctrine_orm_choice', array('field_options' => array('choices' => $providers, 'required' => false, 'multiple' => false, 'expanded' => false), 'field_type' => 'choice'));
 }