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