public function testGridBasic()
{
// create Request mock (ok this is not a mock....)
$_SERVER["REQUEST_URI"] = "/foo";
$request = new \Symfony\Component\HttpFoundation\Request();
// create gridManager instance
$gridManager = $this->getGridManager();
// create queryBuilder
$em = $this->getEntityManager();
$repository = $em->getRepository('Kitpages\\DataGridBundle\\Tests\\TestEntities\\Node');
$queryBuilder = $repository->createQueryBuilder("node");
$queryBuilder->select("node");
$gridConfig = new GridConfig();
$gridConfig->setCountFieldName("node.id");
$gridConfig->addField(new Field("node.createdAt", array("sortable" => true, "formatValueCallback" => function ($value) {
return $value->format("Y/m/d");
})));
$gridConfig->addField(new Field("node.content", array("formatValueCallback" => function ($value, $row) {
return $value . ":" . $row["node.createdAt"]->format("Y");
})));
// get paginator
$gridConfig->setQueryBuilder($queryBuilder);
$grid = $gridManager->getGrid($gridConfig, $request);
$paginator = $grid->getPaginator();
// tests paginator
$this->assertEquals(11, $paginator->getTotalItemCount());
// grid test
$itemList = $grid->getItemList();
$this->assertEquals(11, count($itemList));
$this->assertEquals(1, $itemList[0]["node.id"]);
// simple callback
$this->assertEquals("2010/04/24", $grid->displayGridValue($itemList[0], $gridConfig->getFieldByName("node.createdAt")));
$this->assertEquals("foobar:2010", $grid->displayGridValue($itemList[0], $gridConfig->getFieldByName("node.content")));
}
/**
* @return Grid
*/
protected function getGrid()
{
$queryBuilder = $this->getDoctrine()->getRepository('AppBundle:RegistrationEvent')->getGridQuery();
$gridConfig = new GridConfig();
$gridConfig->setQueryBuilder($queryBuilder)->setCountFieldName('rE.id')->addField(new Field('id', ['label' => 'admin.registration_event.field.id', 'sortable' => true, 'filterable' => true, 'entityFields' => ['rE.id']]))->addField(new Field('domain', ['label' => 'admin.registration_event.field.domain', 'sortable' => true, 'filterable' => true, 'entityFields' => ['rE.domain']]))->addField(new Field('venue', ['label' => 'admin.registration_event.field.venue', 'sortable' => true, 'filterable' => true, 'entityFields' => ['rE.venue']]))->addField(new Field('address', ['label' => 'admin.registration_event.field.address', 'sortable' => true, 'filterable' => true, 'entityFields' => ['rE.address']]))->addField(new Field('city.name', ['label' => 'admin.registration_event.field.city', 'sortable' => true, 'filterable' => true, 'entityFields' => ['cT.name']]))->addField(new Field('state.name', ['label' => 'admin.registration_event.field.state', 'sortable' => true, 'filterable' => true, 'entityFields' => ['s.name']]))->addField(new Field('country.name', ['label' => 'admin.registration_event.field.country', 'sortable' => true, 'filterable' => true, 'entityFields' => ['c.name']]))->addField(new Field('postalCode', ['label' => 'admin.registration_event.field.postal_code', 'sortable' => true, 'filterable' => true, 'entityFields' => ['rE.postalCode']]))->addField(new Field('date', ['label' => 'admin.registration_event.field.date', 'sortable' => true, 'filterable' => true, 'entityFields' => ['rE.date'], 'formatValueCallback' => function ($value) {
return $value->format('Y-m-d');
}]));
return $this->get('kitpages_data_grid.grid_manager')->getGrid($gridConfig, $this->getRequest());
}
