public function afterConversion(DataGridEvent $event)
{
if (!$this->afterActivated) {
return;
}
$event->set("returnValue", "after;" . $event->get("returnValue"));
}
protected function applySort(QueryBuilder $gridQueryBuilder, Grid $grid, $sortField, $sortOrder)
{
if (!$sortField) {
return;
}
$event = new DataGridEvent();
$event->set("grid", $grid);
$event->set("gridQueryBuilder", $gridQueryBuilder);
$event->set("sortField", $sortField);
$event->set("sortOrder", $sortOrder);
$this->dispatcher->dispatch(KitpagesDataGridEvents::ON_APPLY_SORT, $event);
if (!$event->isDefaultPrevented()) {
$sortFieldObject = null;
$fieldList = $grid->getGridConfig()->getFieldList();
foreach ($fieldList as $field) {
if ($field->getFieldName() == $sortField) {
if ($field->getSortable() === true) {
$sortFieldObject = $field;
break;
}
}
}
if (!$sortFieldObject) {
return;
}
if ($sortOrder != "DESC") {
$sortOrder = "ASC";
}
$gridQueryBuilder->orderBy($sortField, $sortOrder);
$grid->setSortField($sortField);
$grid->setSortOrder($sortOrder);
}
$this->dispatcher->dispatch(KitpagesDataGridEvents::AFTER_APPLY_SORT, $event);
}
/**
* get Paginator object
*
* @param \Kitpages\DataGridBundle\Paginator\PaginatorConfig $paginatorConfig
* @param \Symfony\Component\HttpFoundation\Request $request
* @return \Kitpages\DataGridBundle\Paginator\Paginator
*/
public function getPaginator(PaginatorConfig $paginatorConfig, Request $request)
{
$queryBuilder = $paginatorConfig->getQueryBuilder();
// insert default values in paginator config
$paginatorConfig = clone $paginatorConfig;
if (is_null($paginatorConfig->getItemCountInPage())) {
$paginatorConfig->setItemCountInPage($this->paginatorParameterList["item_count_in_page"]);
}
if (is_null($paginatorConfig->getVisiblePageCountInPaginator())) {
$paginatorConfig->setVisiblePageCountInPaginator($this->paginatorParameterList["visible_page_count_in_paginator"]);
}
// create paginator object
$paginator = new Paginator();
$paginator->setPaginatorConfig($paginatorConfig);
$paginator->setUrlTool(new UrlTool());
$paginator->setRequestUri($request->getRequestUri());
// get currentPage
$paginator->setCurrentPage($request->query->get($paginatorConfig->getRequestQueryName("currentPage"), 1));
// calculate total object count
$countQueryBuilder = clone $queryBuilder;
$countQueryBuilder->select("count(DISTINCT " . $paginatorConfig->getCountFieldName() . ")");
$countQueryBuilder->setMaxResults(null);
$countQueryBuilder->setFirstResult(null);
$countQueryBuilder->resetDQLPart('groupBy');
$countQueryBuilder->resetDQLPart('orderBy');
// event to change paginator query builder
$event = new DataGridEvent();
$event->set("paginator", $paginator);
$event->set("paginatorQueryBuilder", $countQueryBuilder);
$event->set("request", $request);
$this->dispatcher->dispatch(KitpagesDataGridEvents::ON_GET_PAGINATOR_QUERY, $event);
if (!$event->isDefaultPrevented()) {
$query = $countQueryBuilder->getQuery();
$event->set("query", $query);
}
$this->dispatcher->dispatch(KitpagesDataGridEvents::AFTER_GET_PAGINATOR_QUERY, $event);
// hack : recover query from the event so the developper can build a new query
// from the paginatorQueryBuilder in the listener and reinject it in the event.
$query = $event->get("query");
try {
$totalCount = $query->getSingleScalarResult();
$paginator->setTotalItemCount($totalCount);
} catch (\Doctrine\ORM\NoResultException $e) {
$paginator->setTotalItemCount(0);
}
// calculate total page count
if ($paginator->getTotalItemCount() == 0) {
$paginator->setTotalPageCount(0);
} else {
$paginator->setTotalPageCount((int) (($paginator->getTotalItemCount() - 1) / $paginatorConfig->getItemCountInPage() + 1));
}
// change current page if needed
if ($paginator->getCurrentPage() > $paginator->getTotalPageCount()) {
$paginator->setCurrentPage(1);
}
// calculate nbPageLeft and nbPageRight
$nbPageLeft = (int) ($paginatorConfig->getVisiblePageCountInPaginator() / 2);
$nbPageRight = $paginatorConfig->getVisiblePageCountInPaginator() - 1 - $nbPageLeft;
// calculate lastPage to display
$maxPage = min($paginator->getTotalPageCount(), $paginator->getCurrentPage() + $nbPageRight);
// adapt minPage and maxPage
$minPage = max(1, $maxPage - ($paginatorConfig->getVisiblePageCountInPaginator() - 1));
$maxPage = min($paginator->getTotalPageCount(), $minPage + ($paginatorConfig->getVisiblePageCountInPaginator() - 1));
$paginator->setMinPage($minPage);
$paginator->setMaxPage($maxPage);
// calculate previousButton
if ($paginator->getCurrentPage() == 1) {
$paginator->setPreviousButtonPage(null);
} else {
$paginator->setPreviousButtonPage($paginator->getCurrentPage() - 1);
}
// calculate nextButton
if ($paginator->getCurrentPage() == $paginator->getTotalPageCount()) {
$paginator->setNextButtonPage(null);
} else {
$paginator->setNextButtonPage($paginator->getCurrentPage() + 1);
}
return $paginator;
}
public function displayGridValue($row, Field $field)
{
$value = null;
$fieldName = $field->getFieldName();
if (array_key_exists($fieldName, $row)) {
$value = $row[$fieldName];
}
// real treatment
if (is_callable($field->getFormatValueCallback())) {
$callback = $field->getFormatValueCallback();
$reflection = new \ReflectionFunction($callback);
if ($reflection->getNumberOfParameters() == 1) {
$value = $callback($value);
} elseif ($reflection->getNumberOfParameters() == 2) {
$value = $callback($value, $row);
} else {
throw new DataGridException("Wrong number of parameters in the callback for field " . $field->getFieldName());
}
}
// send event for changing grid query builder
$event = new DataGridEvent();
$event->set("value", $value);
$event->set("row", $row);
$event->set("field", $field);
$this->dispatcher->dispatch(KitpagesDataGridEvents::ON_DISPLAY_GRID_VALUE_CONVERSION, $event);
if (!$event->isDefaultPrevented()) {
$value = $event->get("value");
if ($value instanceof \DateTime) {
$returnValue = $value->format("Y-m-d H:i:s");
} else {
$returnValue = $value;
}
$event->set("returnValue", $returnValue);
}
$this->dispatcher->dispatch(KitpagesDataGridEvents::AFTER_DISPLAY_GRID_VALUE_CONVERSION, $event);
$returnValue = $event->get("returnValue");
// auto escape ? (if null, return null, without autoescape...)
if ($field->getAutoEscape() && !is_null($returnValue)) {
$returnValue = htmlspecialchars($returnValue);
}
return $returnValue;
}