README

使用示例

控制器

/** *

• @Route("/grid/ajax", name="cidade_grid")

• @Secure(roles="ROLE_CIDADE_SHOW") */ public function gridAction(Request $request) { $dataTable = $this->createDataTable($request);

  $dataTable ->addColumn('id') ->addColumn('nome') ->addColumn('estado.nome') ->addColumnAction($this->getDataTableActionsDefault()) ;

  $dataTable->setDqlPart('{estado.nome} = :estadoNome'); $dataTable->setDqlParam(array('estadoNome' => 'sc'));

  return $this->getDataTableResponse($dataTable); }

索引

Super控制器中必需的方法

/** *

• 创建新的DataTable以响应json

• @param \Symfony\Component\HttpFoundation\Request $request

• @param string $condition DQL条件

• @param arrray $paramCondition

• @param type $entity

• @return \Zuni\DataTableBundle\Entity\DataTable */ protected function createDataTable(Request $request, $condition = "", array $paramCondition = array(), $entity = null) { $entity = $entity ? $entity : $this->getNameEntity()." AS e";

  return new \Zuni\DataTableBundle\Entity\DataTable($request, $this->get("templating"), $this->getTwigLoaderString(), $entity); }

/** *

• 创建数据表响应

• @param \Zuni\DataTableBundle\Entity\DataTable $dataTable

• @return \Symfony\Component\HttpFoundation\JsonResponse */ protected function getDataTableResponse(\Zuni\DataTableBundle\Entity\DataTable $dataTable, $collectionsEntity = null ) { $arrayData = $dataTable->getData($this->getDoctrine()->getManager(), $collectionsEntity);

  return new JsonResponse($arrayData); }

/** *

• 克隆并修改symfony的twig以渲染字符串

• @return \Symfony\Bridge\Twig\TwigEngine */ protected function getTwigLoaderString() { $twigLoaderString = clone $this->get('twig'); $twigLoaderString->setLoader(new Twig_Loader_String());

  return $twigLoaderString; }

/** *

• 返回实体的默认操作

• @todo 将DataTable的操作改为bundle的类

• @return array */ protected function getDataTableActionsDefault() { $entity = $this->getAliasEntity(); $entityUpperCase = strtoupper($entity);

  return array( 'show' => array( 'route' => $entity.'show', 'role' => "ROLE{$entityUpperCase}_SHOW" ), 'edit' => array( 'route' => $entity.'edit', 'role' => "ROLE{$entityUpperCase}_EDIT" ), 'delete' => array( 'route' => $entity.'delete_ajax', 'role' => "ROLE{$entityUpperCase}_EDIT" ), ); }