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()); }