function actionExportData($params = '')
{
$exportData = array();
if (!empty($params['form_id']) && !empty($params['doexport']) && !empty($params['startDate']) && !empty($params['endDate'])) {
$startDate = date("Y-m-d", strtotime($params['startDate']));
$endDate = date("Y-m-d", strtotime($params['endDate']));
$form_id = intval($params['form_id']);
$objForm = new FormModel();
$formData = $objForm->getSubmissions($form_id, $startDate, $endDate);
if (!empty($formData)) {
$formName = $formData[0]['form_name'];
foreach ($formData as $submission) {
$exportDataRecord = array();
$exportDataRecord['date'] = $submission['cDate'];
if (!empty($submission['fields'])) {
foreach ($submission['fields'] as $submitField) {
$exportDataRecord[$submitField['name']] = $submitField['value'];
}
}
$exportData[] = $exportDataRecord;
}
}
if (!empty($exportData)) {
$headers = array_keys($exportData[0]);
header("Content-type: application/CSV");
header("Content-disposition: attachment; filename=" . urlencode($formName) . "_export.csv");
foreach ($headers as $header) {
echo '"' . $header . '",';
}
echo "\r\n";
foreach ($exportData as $exportRecord) {
foreach ($exportRecord as $value) {
echo '"' . $value . '",';
}
echo "\r\n";
}
}
}
}
