/**
* Export Category entities to Excel.
*
* @Route("/export/sort/{sort}/direction/{direction}/", defaults={"sort"="ck.id", "direction"="asc"}, name="admin_category_export")
* @Method("GET")
* @Template()
* @Secure(roles="ROLE_CEKURTEZCPEBUNDLE_CATEGORY, ROLE_USER")
*
* @param string $sort
* @param string $direction
* @return StreamedResponse
*
* @author João Paulo Cercal <*****@*****.**>
* @version 0.1
*/
public function exportAction($sort, $direction)
{
$form = $this->createForm(new CategoryFormType(), new Category(), array('search' => true));
if ($this->get('session')->has('search_category')) {
$form->bind($this->get('session')->get('search_category'));
}
$query = $this->getEntityRepository()->getQuery($form->getData(), $sort, $direction);
$translator = $this->get('translator');
$office = new CekurtePHPExcel(sprintf('%s %s', $translator->trans('Report of'), $translator->trans('Category')));
$office->setHeader(array('question' => $translator->trans('Question'), 'deletedBy' => $translator->trans('Deletedby'), 'updatedBy' => $translator->trans('Updatedby'), 'createdBy' => $translator->trans('Createdby'), 'title' => $translator->trans('Title'), 'description' => $translator->trans('Description'), 'deleted' => $translator->trans('Deleted'), 'deletedAt' => $translator->trans('Deletedat'), 'updatedAt' => $translator->trans('Updatedat'), 'createdAt' => $translator->trans('Createdat')))->setData($query->getArrayResult())->build();
return $office->createResponse();
}
