protected function addToolbar($layout = null) {
switch ($layout) {
case 'export':
JToolbarHelper::title(JText::_('COM_PRP') . ': ' . JText::_('COM_PRP_VIEW_EXPORT_TABLE_EXPORT'));
JToolbarHelper::back('JTOOLBAR_BACK', JRoute::_('index.php?option=com_prp&view=exports'), false);
JToolbarHelper::custom('export.xlsx', 'xlsx', 'xlsx', '', false);
JToolbarHelper::custom('export.xls', 'xls', 'xls', '', false);
JFactory::getDocument()->addStyleDeclaration(
PRPHelperExport::getStyleDeclaration('xls')
. "\n\n" .
PRPHelperExport::getStyleDeclaration('xlsx')
);
JFactory::getDocument()->addStyleSheet(JUri::root().'/media/com_prp/css/export.css');
break;
default:
JFactory::getApplication()->input->set('hidemainmenu', true);
$isNew = ($this->item->id == 0);
$title_sufix = ($isNew)?'_NEW':'_EDIT';
JToolbarHelper::title(JText::_('COM_PRP') . ': ' . JText::_('COM_PRP_VIEW_EXPORT'.$title_sufix));
JToolbarHelper::save('export.save');
JToolbarHelper::save2new('export.save2new');
if ($isNew) {
JToolbarHelper::cancel('export.cancel');
} else {
JToolbarHelper::cancel('export.cancel', 'JTOOLBAR_CLOSE');
}
break;
}
}
public function xls() {
$app = JFactory::getApplication();
$inp = $app->input;
JLoader::register('PRPHelperExport', JPATH_ADMINISTRATOR . '/helpers/export.php');
$model = $this->getModel('Export', 'PRPModel');
$data = $model->getExportTable($inp->getInt('table'), PRPModelExport::PRP_EXPORT_TYPE_ASSOCLIST);
PRPHelperExport::downloadSpreadSheet($data, 'xls', 'Testador', 'Teste 1');
$app->close();
}
public function xlsx() {
$app = JFactory::getApplication();
$token = JSession::getFormToken();
if (!$app->input->get($token, 0) ) {
$this->setRedirect(JRoute::_('index.php?option=com_prp&view=exports', false), JText::_('COM_PRP_EXPORT_ERROR_INVALID'), 'error');
} else {
$model = $this->getModel();
$table = $model->getExportTable($app->input->getInt('id'), PRPModelExport::PRP_EXPORT_TYPE_ASSOCLIST);
$model->setExportCount($app->input->getInt('id'));
PRPHelperExport::downloadSpreadSheet($table, 'xlsx', $app->input->getString('user_name'), $app->input->getString('title'));
// Finaliza código para baixar o arquivo
exit;
}
}
