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