DatagridBuilder.php 8.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216
  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. );
  43. public function __construct(FormFactory $formFactory)
  44. {
  45. $this->formFactory = $formFactory;
  46. }
  47. /**
  48. * @throws \RuntimeException
  49. * @param \Sonata\AdminBundle\Admin\AdminInterface $admin
  50. * @param \Sonata\AdminBundle\Admin\FieldDescription $fieldDescription
  51. * @return void
  52. */
  53. public function fixFieldDescription(AdminInterface $admin, FieldDescriptionInterface $fieldDescription)
  54. {
  55. // set default values
  56. $fieldDescription->setAdmin($admin);
  57. if ($admin->getModelManager()->hasMetadata($admin->getClass())) {
  58. $metadata = $admin->getModelManager()->getMetadata($admin->getClass());
  59. // set the default field mapping
  60. if (isset($metadata->fieldMappings[$fieldDescription->getName()])) {
  61. $fieldDescription->setFieldMapping($metadata->fieldMappings[$fieldDescription->getName()]);
  62. }
  63. // set the default association mapping
  64. if (isset($metadata->associationMappings[$fieldDescription->getName()])) {
  65. $fieldDescription->setAssociationMapping($metadata->associationMappings[$fieldDescription->getName()]);
  66. }
  67. }
  68. if (!$fieldDescription->getType()) {
  69. throw new \RuntimeException(sprintf('Please define a type for field `%s` in `%s`', $fieldDescription->getName(), get_class($admin)));
  70. }
  71. $fieldDescription->setOption('code', $fieldDescription->getOption('code', $fieldDescription->getName()));
  72. $fieldDescription->setOption('label', $fieldDescription->getOption('label', $fieldDescription->getName()));
  73. $fieldDescription->setOption('filter_value', $fieldDescription->getOption('filter_value', null));
  74. $fieldDescription->setOption('filter_options', $fieldDescription->getOption('filter_options', null));
  75. $fieldDescription->setOption('filter_field_options', $fieldDescription->getOption('filter_field_options', null));
  76. $fieldDescription->setOption('name', $fieldDescription->getOption('name', $fieldDescription->getName()));
  77. // set the default type if none is set
  78. if (!$fieldDescription->getType()) {
  79. $fieldDescription->setType('string');
  80. }
  81. if (!$fieldDescription->getTemplate()) {
  82. $fieldDescription->setTemplate(sprintf('SonataAdminBundle:CRUD:filter_%s.html.twig', $fieldDescription->getType()));
  83. if ($fieldDescription->getType() == ClassMetadataInfo::MANY_TO_ONE) {
  84. $fieldDescription->setTemplate('SonataAdminBundle:CRUD:filter_many_to_one.html.twig');
  85. }
  86. if ($fieldDescription->getType() == ClassMetadataInfo::MANY_TO_MANY) {
  87. $fieldDescription->setTemplate('SonataAdminBundle:CRUD:filter_many_to_many.html.twig');
  88. }
  89. }
  90. }
  91. /**
  92. * return the class associated to a FieldDescription if any defined
  93. *
  94. * @throws RuntimeException
  95. * @param \Sonata\AdminBundle\Admin\FieldDescriptionInterface $fieldDescription
  96. * @return bool|string
  97. */
  98. public function getFilterFieldClass(FieldDescriptionInterface $fieldDescription)
  99. {
  100. if ($fieldDescription->getOption('filter_field_widget', false)) {
  101. $class = $fieldDescription->getOption('filter_field_widget', false);
  102. } else {
  103. $class = array_key_exists($fieldDescription->getType(), $this->filterClasses) ? $this->filterClasses[$fieldDescription->getType()] : false;
  104. }
  105. if (!class_exists($class)) {
  106. throw new \RuntimeException(sprintf('The class `%s` does not exist for field `%s`', $class, $fieldDescription->getType()));
  107. }
  108. return $class;
  109. }
  110. /**
  111. * @param \Sonata\AdminBundle\Admin\FieldDescriptionInterface $fieldDescription
  112. * @return array
  113. */
  114. public function getChoices(FieldDescriptionInterface $fieldDescription)
  115. {
  116. $targets = $fieldDescription->getAdmin()->getModelManager()
  117. ->getEntityManager()
  118. ->createQueryBuilder()
  119. ->select('t')
  120. ->from($fieldDescription->getTargetEntity(), 't')
  121. ->getQuery()
  122. ->execute();
  123. $choices = array();
  124. foreach ($targets as $target) {
  125. // todo : puts this into a configuration option and use reflection
  126. foreach (array('getTitle', 'getName', '__toString') as $getter) {
  127. if (method_exists($target, $getter)) {
  128. $choices[$target->getId()] = $target->$getter();
  129. break;
  130. }
  131. }
  132. }
  133. return $choices;
  134. }
  135. /**
  136. * @param \Sonata\AdminBundle\Datagrid\DatagridInterface $datagrid
  137. * @param \Sonata\AdminBundle\Admin\FieldDescriptionInterface $fieldDescription
  138. * @return bool
  139. */
  140. public function addFilter(DatagridInterface $datagrid, FieldDescriptionInterface $fieldDescription)
  141. {
  142. if (!$fieldDescription->getType()) {
  143. return false;
  144. }
  145. switch($fieldDescription->getType()) {
  146. case ClassMetadataInfo::MANY_TO_ONE:
  147. $options = $fieldDescription->getOption('filter_field_options');
  148. $filter = new \Sonata\AdminBundle\Filter\ORM\IntegerFilter($fieldDescription);
  149. break;
  150. case ClassMetadataInfo::MANY_TO_MANY:
  151. $options = $fieldDescription->getOption('filter_field_options');
  152. $options['choices'] = $this->getChoices($fieldDescription);
  153. $fieldDescription->setOption('filter_field_options', $options);
  154. $filter = new \Sonata\AdminBundle\Filter\ORM\ChoiceFilter($fieldDescription);
  155. break;
  156. default:
  157. $class = $this->getFilterFieldClass($fieldDescription);
  158. $filter = new $class($fieldDescription);
  159. }
  160. return $datagrid->addFilter($filter);
  161. }
  162. /**
  163. * @param \Sonata\AdminBundle\Admin\AdminInterface $admin
  164. * @param array $values
  165. * @return \Sonata\AdminBundle\Datagrid\DatagridInterface
  166. */
  167. public function getBaseDatagrid(AdminInterface $admin, array $values = array())
  168. {
  169. $queryBuilder = $admin->getModelManager()->createQuery($admin->getClass());
  170. $query = new ProxyQuery($queryBuilder);
  171. return new Datagrid(
  172. $query,
  173. $admin->getList(),
  174. new Pager,
  175. $this->formFactory,
  176. $values
  177. );
  178. }
  179. }