}
if (isset($params['keyword'])) {
$data['keyword'] = $params['keyword'];
}
if (isset($params['for_module'])) {
$data['module_name'] = $params['for_module'];
}
$custom_fields = array();
$data_paging = $data;
$data_paging['page_count'] = 1;
$data_paging = get_form_entires($data_paging);
if (url_param('current_page') != false) {
$data['current_page'] = url_param('current_page');
}
$custom_fields = array();
$data = get_form_entires($data);
if (is_array($data)) {
foreach ($data as $item) {
if (isset($item['custom_fields'])) {
foreach ($item['custom_fields'] as $k => $value) {
$custom_fields[$k] = $value;
}
}
}
}
?>
<table id="table_data_<?php
print $params['id'];
?>
" cellspacing="0" cellpadding="0" width="100%" class="mw-ui-table">
public function export_to_excel($params)
{
//this function is experimental
set_time_limit(0);
$adm = $this->app->user_manager->is_admin();
if ($adm == false) {
return array('error' => 'Error: not logged in as admin.' . __FILE__ . __LINE__);
}
if (!isset($params['id'])) {
return array('error' => 'Please specify list id! By posting field id=the list id ');
} else {
$lid = intval($params['id']);
$data = get_form_entires('limit=100000&list_id=' . $lid);
$surl = $this->app->url_manager->site();
$csv_output = '';
if (is_array($data)) {
$csv_output = 'id,';
$csv_output .= 'created_at,';
$csv_output .= 'user_ip,';
foreach ($data as $item) {
if (isset($item['custom_fields'])) {
foreach ($item['custom_fields'] as $k => $v) {
$csv_output .= $this->app->format->no_dashes($k) . ",";
$csv_output .= "\t";
}
}
}
$csv_output .= "\n";
foreach ($data as $item) {
if (isset($item['custom_fields'])) {
$csv_output .= $item['id'] . ",";
$csv_output .= "\t";
$csv_output .= $item['created_at'] . ",";
$csv_output .= "\t";
$csv_output .= $item['user_ip'] . ",";
$csv_output .= "\t";
foreach ($item['custom_fields'] as $item1 => $val) {
$output_val = $val;
$output_val = str_replace('{SITE_URL}', $surl, $output_val);
$csv_output .= $output_val . ",";
$csv_output .= "\t";
}
$csv_output .= "\n";
}
}
}
$filename = 'export' . "_" . date("Y-m-d_H-i", time()) . uniqid() . '.csv';
$filename_path = userfiles_path() . 'export' . DS . 'forms' . DS;
$filename_path_index = userfiles_path() . 'export' . DS . 'forms' . DS . 'index.php';
if (!is_dir($filename_path)) {
mkdir_recursive($filename_path);
if (!is_file($filename_path_index)) {
@touch($filename_path_index);
}
}
$filename_path_full = $filename_path . $filename;
file_put_contents($filename_path_full, $csv_output);
$download = $this->app->url_manager->link_to_file($filename_path_full);
return array('success' => 'Your file has been exported!', 'download' => $download);
}
}
