Datagrid.php 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228
  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\Datagrid;
  11. use Sonata\AdminBundle\Datagrid\PagerInterface;
  12. use Sonata\AdminBundle\Datagrid\ProxyQueryInterface;
  13. use Sonata\AdminBundle\Filter\FilterInterface;
  14. use Sonata\AdminBundle\Admin\FieldDescriptionCollection;
  15. use Symfony\Component\Form\FormBuilder;
  16. class Datagrid implements DatagridInterface
  17. {
  18. /**
  19. *
  20. * The filter instances
  21. * @var array
  22. */
  23. protected $filters = array();
  24. protected $values;
  25. protected $columns;
  26. protected $pager;
  27. protected $bound = false;
  28. protected $query;
  29. protected $formBuilder;
  30. protected $form;
  31. protected $results;
  32. /**
  33. * @param ProxyQueryInterface $query
  34. * @param \Sonata\AdminBundle\Admin\FieldDescriptionCollection $columns
  35. * @param PagerInterface $pager
  36. * @param \Symfony\Component\Form\FormBuilder $formBuilder
  37. * @param array $values
  38. */
  39. public function __construct(ProxyQueryInterface $query, FieldDescriptionCollection $columns, PagerInterface $pager, FormBuilder $formBuilder, array $values = array())
  40. {
  41. $this->pager = $pager;
  42. $this->query = $query;
  43. $this->values = $values;
  44. $this->columns = $columns;
  45. $this->formBuilder = $formBuilder;
  46. }
  47. /**
  48. * @return \Sonata\AdminBundle\Datagrid\PagerInterface
  49. */
  50. public function getPager()
  51. {
  52. return $this->pager;
  53. }
  54. /**
  55. * @return array
  56. */
  57. public function getResults()
  58. {
  59. $this->buildPager();
  60. if (!$this->results) {
  61. $this->results = $this->pager->getResults();
  62. }
  63. return $this->results;
  64. }
  65. /**
  66. * @return void
  67. */
  68. public function buildPager()
  69. {
  70. if ($this->bound) {
  71. return;
  72. }
  73. foreach ($this->getFilters() as $name => $filter) {
  74. list($type, $options) = $filter->getRenderSettings();
  75. $this->formBuilder->add($filter->getFormName(), $type, $options);
  76. }
  77. $this->formBuilder->add('_sort_by', 'hidden');
  78. $this->formBuilder->add('_sort_order', 'hidden');
  79. $this->formBuilder->add('_page', 'hidden');
  80. $this->form = $this->formBuilder->getForm();
  81. $this->form->bind($this->values);
  82. $data = $this->form->getData();
  83. foreach ($this->getFilters() as $name => $filter) {
  84. $this->values[$name] = isset($this->values[$name]) ? $this->values[$name] : null;
  85. $filter->apply($this->query, $data[$filter->getFormName()]);
  86. }
  87. $this->query->setSortBy(isset($this->values['_sort_by']) ? $this->values['_sort_by'] : null);
  88. $this->query->setSortOrder(isset($this->values['_sort_order']) ? $this->values['_sort_order'] : null);
  89. $this->pager->setPage(isset($this->values['_page']) ? $this->values['_page'] : 1);
  90. $this->pager->setQuery($this->query);
  91. $this->pager->init();
  92. $this->bound = true;
  93. }
  94. /**
  95. * @param \Sonata\AdminBundle\Filter\FilterInterface $filter
  96. * @return void
  97. */
  98. public function addFilter(FilterInterface $filter)
  99. {
  100. $this->filters[$filter->getName()] = $filter;
  101. }
  102. /**
  103. * @param $name
  104. * @return bool
  105. */
  106. public function hasFilter($name)
  107. {
  108. return isset($this->filters[$name]);
  109. }
  110. /**
  111. * @param $name
  112. */
  113. public function removeFilter($name)
  114. {
  115. unset($this->filters[$name]);
  116. }
  117. /**
  118. * @param $name
  119. * @return null
  120. */
  121. public function getFilter($name)
  122. {
  123. return $this->hasFilter($name) ? $this->filters[$name] : null;
  124. }
  125. /**
  126. * @return array
  127. */
  128. public function getFilters()
  129. {
  130. return $this->filters;
  131. }
  132. public function reorderFilters(array $keys)
  133. {
  134. $this->filters = array_merge(array_flip($keys), $this->filters);
  135. }
  136. /**
  137. * @return array
  138. */
  139. public function getValues()
  140. {
  141. return $this->values;
  142. }
  143. /**
  144. * @param $name
  145. * @param $operator
  146. * @param $value
  147. */
  148. public function setValue($name, $operator, $value)
  149. {
  150. $this->values[$name] = array('type' => $operator, 'value' => $value);
  151. }
  152. /**
  153. * @return boolean
  154. */
  155. public function hasActiveFilters()
  156. {
  157. foreach ($this->filters as $name => $filter) {
  158. if ($filter->isActive()) {
  159. return true;
  160. }
  161. }
  162. return false;
  163. }
  164. /**
  165. * @return \Sonata\AdminBundle\Admin\FieldDescriptionCollection
  166. */
  167. public function getColumns()
  168. {
  169. return $this->columns;
  170. }
  171. /**
  172. * @return ProxyQueryInterface
  173. */
  174. public function getQuery()
  175. {
  176. return $this->query;
  177. }
  178. /**
  179. * @return \Symfony\Component\Form\Form
  180. */
  181. public function getForm()
  182. {
  183. $this->buildPager();
  184. return $this->form;
  185. }
  186. }