DatagridBuilder.php 8.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214
  1. <?php
  2. /*
  3. * This file is part of the Sonata package.
  4. *
  5. * (c) Thomas Rabaix <thomas.rabaix@sonata-project.org>
  6. *
  7. * For the full copyright and license information, please view the LICENSE
  8. * file that was distributed with this source code.
  9. */
  10. namespace Sonata\AdminBundle\Builder\ORM;
  11. use Sonata\AdminBundle\Admin\FieldDescriptionInterface;
  12. use Sonata\AdminBundle\Model\ModelManagerInterface;
  13. use Sonata\AdminBundle\Admin\AdminInterface;
  14. use Sonata\AdminBundle\Datagrid\DatagridInterface;
  15. use Sonata\AdminBundle\Datagrid\Datagrid;
  16. use Sonata\AdminBundle\Datagrid\ORM\Pager;
  17. use Sonata\AdminBundle\Datagrid\ORM\ProxyQuery;
  18. use Sonata\AdminBundle\Builder\DatagridBuilderInterface;
  19. use Symfony\Component\Form\FormFactory;
  20. use Doctrine\ORM\Mapping\ClassMetadataInfo;
  21. class DatagridBuilder implements DatagridBuilderInterface
  22. {
  23. protected $formFactory;
  24. /**
  25. * todo: put this in the DIC
  26. *
  27. * built-in definition
  28. *
  29. * @var array
  30. */
  31. protected $filterClasses = array(
  32. 'string' => 'Sonata\\AdminBundle\\Filter\\ORM\\StringFilter',
  33. 'text' => 'Sonata\\AdminBundle\\Filter\\ORM\\StringFilter',
  34. 'boolean' => 'Sonata\\AdminBundle\\Filter\\ORM\\BooleanFilter',
  35. 'integer' => 'Sonata\\AdminBundle\\Filter\\ORM\\IntegerFilter',
  36. 'tinyint' => 'Sonata\\AdminBundle\\Filter\\ORM\\IntegerFilter',
  37. 'smallint' => 'Sonata\\AdminBundle\\Filter\\ORM\\IntegerFilter',
  38. 'mediumint' => 'Sonata\\AdminBundle\\Filter\\ORM\\IntegerFilter',
  39. 'bigint' => 'Sonata\\AdminBundle\\Filter\\ORM\\IntegerFilter',
  40. 'decimal' => 'Sonata\\AdminBundle\\Filter\\ORM\\IntegerFilter',
  41. 'callback' => 'Sonata\\AdminBundle\\Filter\\ORM\\CallbackFilter',
  42. 'choice' => 'Sonata\\AdminBundle\\Filter\\ORM\\ChoiceFilter',
  43. );
  44. public function __construct(FormFactory $formFactory)
  45. {
  46. $this->formFactory = $formFactory;
  47. }
  48. /**
  49. * @throws \RuntimeException
  50. * @param \Sonata\AdminBundle\Admin\AdminInterface $admin
  51. * @param \Sonata\AdminBundle\Admin\FieldDescription $fieldDescription
  52. * @return void
  53. */
  54. public function fixFieldDescription(AdminInterface $admin, FieldDescriptionInterface $fieldDescription)
  55. {
  56. // set default values
  57. $fieldDescription->setAdmin($admin);
  58. if ($admin->getModelManager()->hasMetadata($admin->getClass())) {
  59. $metadata = $admin->getModelManager()->getMetadata($admin->getClass());
  60. // set the default field mapping
  61. if (isset($metadata->fieldMappings[$fieldDescription->getName()])) {
  62. $fieldDescription->setFieldMapping($metadata->fieldMappings[$fieldDescription->getName()]);
  63. }
  64. // set the default association mapping
  65. if (isset($metadata->associationMappings[$fieldDescription->getName()])) {
  66. $fieldDescription->setAssociationMapping($metadata->associationMappings[$fieldDescription->getName()]);
  67. }
  68. }
  69. $fieldDescription->setOption('code', $fieldDescription->getOption('code', $fieldDescription->getName()));
  70. $fieldDescription->setOption('label', $fieldDescription->getOption('label', $fieldDescription->getName()));
  71. $fieldDescription->setOption('filter_value', $fieldDescription->getOption('filter_value', null));
  72. $fieldDescription->setOption('filter_options', $fieldDescription->getOption('filter_options', null));
  73. $fieldDescription->setOption('filter_field_options', $fieldDescription->getOption('filter_field_options', null));
  74. $fieldDescription->setOption('name', $fieldDescription->getOption('name', $fieldDescription->getName()));
  75. if (!$fieldDescription->getTemplate()) {
  76. $fieldDescription->setTemplate(sprintf('SonataAdminBundle:CRUD:filter_%s.html.twig', $fieldDescription->getType()));
  77. if ($fieldDescription->getMappingType() == ClassMetadataInfo::MANY_TO_ONE) {
  78. $fieldDescription->setTemplate('SonataAdminBundle:CRUD:filter_many_to_one.html.twig');
  79. }
  80. if ($fieldDescription->getMappingType() == ClassMetadataInfo::MANY_TO_MANY) {
  81. $fieldDescription->setTemplate('SonataAdminBundle:CRUD:filter_many_to_many.html.twig');
  82. }
  83. }
  84. }
  85. /**
  86. * return the class associated to a FieldDescription if any defined
  87. *
  88. * @throws RuntimeException
  89. * @param \Sonata\AdminBundle\Admin\FieldDescriptionInterface $fieldDescription
  90. * @return bool|string
  91. */
  92. public function getFilterFieldClass(FieldDescriptionInterface $fieldDescription)
  93. {
  94. if ($fieldDescription->getOption('filter_field_widget', false)) {
  95. $class = $fieldDescription->getOption('filter_field_widget', false);
  96. } else {
  97. $class = array_key_exists($fieldDescription->getType(), $this->filterClasses) ? $this->filterClasses[$fieldDescription->getType()] : false;
  98. }
  99. if (!class_exists($class)) {
  100. throw new \RuntimeException(sprintf('The class `%s` does not exist for field `%s`', $class, $fieldDescription->getType()));
  101. }
  102. return $class;
  103. }
  104. /**
  105. * @param \Sonata\AdminBundle\Admin\FieldDescriptionInterface $fieldDescription
  106. * @return array
  107. */
  108. public function getChoices(FieldDescriptionInterface $fieldDescription)
  109. {
  110. $modelManager = $fieldDescription->getAdmin()->getModelManager();
  111. $targets = $modelManager->getEntityManager()
  112. ->createQueryBuilder()
  113. ->select('t')
  114. ->from($fieldDescription->getTargetEntity(), 't')
  115. ->getQuery()
  116. ->execute();
  117. $choices = array();
  118. foreach ($targets as $target) {
  119. // todo : puts this into a configuration option and use reflection
  120. foreach (array('getTitle', 'getName', '__toString') as $getter) {
  121. if (method_exists($target, $getter)) {
  122. $choices[$modelManager->getNormalizedIdentifier($target)] = $target->$getter();
  123. break;
  124. }
  125. }
  126. }
  127. return $choices;
  128. }
  129. /**
  130. * @param \Sonata\AdminBundle\Datagrid\DatagridInterface $datagrid
  131. * @param \Sonata\AdminBundle\Admin\FieldDescriptionInterface $fieldDescription
  132. * @return bool
  133. */
  134. public function addFilter(DatagridInterface $datagrid, $type = null, FieldDescriptionInterface $fieldDescription, AdminInterface $admin)
  135. {
  136. if ($type == null) {
  137. throw new \RunTimeException('type guesser on DatagridBuilder is not yet implemented');
  138. }
  139. $fieldDescription->setType($type);
  140. $this->fixFieldDescription($admin, $fieldDescription);
  141. $admin->addFilterFieldDescription($fieldDescription->getName(), $fieldDescription);
  142. switch($fieldDescription->getMappingType()) {
  143. case ClassMetadataInfo::MANY_TO_ONE:
  144. $options = $fieldDescription->getOption('filter_field_options');
  145. $filter = new \Sonata\AdminBundle\Filter\ORM\IntegerFilter($fieldDescription);
  146. break;
  147. case ClassMetadataInfo::MANY_TO_MANY:
  148. $options = $fieldDescription->getOption('filter_field_options');
  149. $options['choices'] = $this->getChoices($fieldDescription);
  150. $fieldDescription->setOption('filter_field_options', $options);
  151. $filter = new \Sonata\AdminBundle\Filter\ORM\ChoiceFilter($fieldDescription);
  152. break;
  153. default:
  154. $class = $this->getFilterFieldClass($fieldDescription);
  155. $filter = new $class($fieldDescription);
  156. }
  157. return $datagrid->addFilter($filter);
  158. }
  159. /**
  160. * @param \Sonata\AdminBundle\Admin\AdminInterface $admin
  161. * @param array $values
  162. * @return \Sonata\AdminBundle\Datagrid\DatagridInterface
  163. */
  164. public function getBaseDatagrid(AdminInterface $admin, array $values = array())
  165. {
  166. $queryBuilder = $admin->getModelManager()->createQuery($admin->getClass());
  167. $query = new ProxyQuery($queryBuilder);
  168. $pager = new Pager;
  169. $pager->setCountColumn($admin->getModelManager()->getIdentifierFieldNames($admin->getClass()));
  170. return new Datagrid(
  171. $query,
  172. $admin->getList(),
  173. $pager,
  174. $this->formFactory,
  175. $values
  176. );
  177. }
  178. }