function task_data($db_id)
{
global $dv_conf;
$dd = get_dd($db_id);
if (!authorize($dd)) {
print '<br /><p class="error">Sorry, you are not authorized to view this page.</p>';
return;
}
$filter = strtolower(Request::getVar('type', 'json'));
$file = JPATH_COMPONENT . DS . "filter/{$filter}.php";
if (file_exists($file)) {
require_once $file;
}
if ($dd) {
$link = get_db();
$sql = query_gen($dd);
$res = get_results($sql, $dd);
print filter($res, $dd);
exit(0);
} else {
print print "<p class=\"error\">Invalid Request</p>";
exit(1);
}
}
/**
* Get data as CSV file
*
* @param string $db_name
* @param integer $version
*
* @return string data
*/
public function getCsvData($db_name = '', $version = '', $tmpFile = '')
{
if (!$db_name || !$version) {
return false;
}
mb_internal_encoding('UTF-8');
// component path for "com_dataviewer"
$dv_com_path = PATH_CORE . DS . 'components' . DS . 'com_dataviewer';
require_once $dv_com_path . DS . 'dv_config.php';
require_once $dv_com_path . DS . 'lib' . DS . 'db.php';
require_once $dv_com_path . DS . 'modes' . DS . 'mode_dsl.php';
require_once $dv_com_path . DS . 'filter' . DS . 'csv.php';
$dv_conf = get_conf(NULL);
$dd = get_dd(NULL, $db_name, $version);
$dd['serverside'] = false;
$sql = query_gen($dd);
$result = get_results($sql, $dd);
ob_start();
filter($result, $dd, true);
$csv = ob_get_contents();
ob_end_clean();
if ($csv && $tmpFile) {
$handle = fopen($tmpFile, 'w');
fwrite($handle, $csv);
fclose($handle);
return true;
}
return $csv;
}
