function openreport($idrep = false)
{
if ($idrep != false && $idrep > 0) {
$id_report = $idrep;
} else {
$id_report = $_SESSION['report_tempdata']['id_report'];
if ($id_report != false && $idrep > 0) {
load_filter($idrep, true, false);
}
}
$query_report = "\r\n\tSELECT r.class_name, r.file_name, r.report_name, f.filter_name, f.filter_data, f.author\r\n\tFROM %lms_report AS r\r\n\t\tJOIN %lms_report_filter AS f\r\n\t\tON ( r.id_report = f.id_report )\r\n\tWHERE f.id_filter = '" . $idrep . "'";
$re_report = sql_query($query_report);
list($class_name, $file_name, $report_name) = sql_fetch_row($re_report);
if (sql_num_rows($re_report) == 0) {
reportlist();
return;
}
require_once _lms_ . '/admin/modules/report/' . $file_name;
$obj_report = new $class_name($id_report);
return $obj_report;
}
function report_open_filter()
{
require_once _lms_ . '/lib/lib.report.php';
$url = 'index.php?modname=report&op=reportlist';
$filter_id = Get::req('idrep', DOTY_INT, false);
$action = Get::req('action', DOTY_STRING, '');
if (!$filter_id) {
Util::jump_to($url);
return false;
}
switch ($action) {
case 'schedule':
load_filter($filter_id, true);
Util::jump_to('index.php?modname=report&op=report_schedule');
break;
case 'open':
load_filter($filter_id, true);
Util::jump_to('index.php?modname=report&op=show_results');
break;
case 'modify':
load_filter($filter_id, true, true);
//will load it after the Util::jump_to
Util::jump_to('index.php?modname=report&op=modify_name&modid=' . $filter_id);
break;
case 'delete':
//delete filter from list and DB, than reload page
if (report_delete_filter($filter_id)) {
$success = '&fdel=1&idrep=' . $filter_id;
} else {
$success = '&fdel=0&idrep=' . $filter_id;
}
Util::jump_to($url . $success);
break;
default:
Util::jump_to($url);
}
}
