function doexport()
{
$app =& JFactory::getApplication();
$cats = JRequest::getVar('categories', null, 'request', 'array');
JArrayHelper::toInteger($cats);
$venues = JRequest::getVar('venues', null, 'request', 'array');
JArrayHelper::toInteger($venues);
$model = $this->getModel('events');
$events = $model->exportEvents($cats, $venues);
header('Content-Type: text/x-csv');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Disposition: attachment; filename=events.csv');
header('Pragma: no-cache');
$k = 0;
$export = '';
$col = array();
$eventtablefields = array('id', 'title', 'alias', 'created_by', 'modified', 'modified_by', 'summary', 'datdescription', 'details_layout', 'meta_description', 'meta_keywords', 'datimage', 'author_ip', 'created', 'published', 'registra', 'unregistra', 'checked_out', 'checked_out_time', 'notify', 'notify_subject', 'notify_body', 'redform_id', 'juser', 'notify_on_list_body', 'notify_off_list_body', 'notify_on_list_subject', 'notify_off_list_subject', 'show_names', 'notify_confirm_subject', 'notify_confirm_body', 'review_message', 'confirmation_message', 'activate', 'showfields', 'submission_types', 'course_code', 'submission_type_email', 'submission_type_external', 'submission_type_phone', 'submission_type_webform', 'show_submission_type_webform_formal_offer', 'submission_type_webform_formal_offer', 'max_multi_signup', 'submission_type_formal_offer', 'submission_type_formal_offer_subject', 'submission_type_formal_offer_body', 'submission_type_email_body', 'submission_type_email_subject', 'submission_type_email_pdf', 'submission_type_formal_offer_pdf', 'send_pdf_form', 'pdf_form_data', 'paymentaccepted', 'paymentprocessing', 'enable_ical', '_tbl', '_tbl_key', '_db', '_errors');
if (count($events)) {
$header = current($events);
$export .= redEVENTHelper::writecsvrow(array_keys($header));
$current = 0;
// current event
foreach ($events as $data) {
if ($current == $data['id']) {
foreach ($data as $k => $v) {
if (in_array($k, $eventtablefields)) {
$data[$k] = null;
}
}
} else {
$current = $data['id'];
// first event id
}
$export .= redEVENTHelper::writecsvrow($data);
}
echo $export;
}
$app->close();
}
function export()
{
$app =& JFactory::getApplication();
$model = $this->getModel('customfields');
$rows = $model->export();
header('Content-Type: text/x-csv');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Disposition: attachment; filename=customfields.csv');
header('Pragma: no-cache');
$k = 0;
$export = '';
$col = array();
if (count($rows)) {
$header = current($rows);
$export .= redEVENTHelper::writecsvrow(array_keys($header));
$current = 0;
// current event
foreach ($rows as $data) {
$export .= redEVENTHelper::writecsvrow($data);
}
echo $export;
}
$app->close();
}
public function doexport()
{
$app =& JFactory::getApplication();
$cats = JRequest::getVar('categories', null, 'request', 'array');
JArrayHelper::toInteger($cats);
$model = $this->getModel('venues');
$rows = $model->export($cats);
header('Content-Type: text/x-csv');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Content-Disposition: attachment; filename=venues.csv');
header('Pragma: no-cache');
$k = 0;
$export = '';
$col = array();
if (count($rows)) {
$header = current($rows);
$export .= redEVENTHelper::writecsvrow(array_keys($header));
$current = 0;
// current event
foreach ($rows as $data) {
$export .= redEVENTHelper::writecsvrow($data);
}
echo $export;
}
$app->close();
}
