echo "OK";
exit;
}
if (postvalue("name") == "viewsql") {
$arr = array();
$arr = array(0, "", postvalue("output"));
$customSQL = $arr[2];
$_SESSION["customSQL"] = $customSQL;
$_SESSION["idSQL"] = $arr[0];
$_SESSION["nameSQL"] = $arr[1];
$_SESSION["object_sql"] = $customSQL;
echo $customSQL;
exit;
}
if (postvalue("name") == "getcustomsql") {
$arr = array();
$arr = WRgetCurrentCustomSQL(postvalue("output"));
$customSQL = $arr[2];
$_SESSION["customSQL"] = $customSQL;
$_SESSION["idSQL"] = $arr[0];
$_SESSION["nameSQL"] = $arr[1];
$_SESSION["object_sql"] = $customSQL;
echo $customSQL;
exit;
}
$arr = my_json_decode(DecodeUTF8(postvalue("output")));
$_connection->exec("delete from " . $_connection->addTableWrappers("webreport_admin"));
foreach ($arr as $val) {
$_connection->exec("insert into " . $_connection->addTableWrappers("webreport_admin") . " (" . $_connection->addFieldWrappers("tablename") . "," . $_connection->addFieldWrappers("db_type") . "," . $_connection->AddFieldWrappers("group_name") . ")" . " values (" . $_connection->prepareString($val["table"]) . ",'" . $val["db_type"] . "'," . $_connection->prepareString($val["group"]) . ")");
}
echo "OK";
unset($root['type']);
comlete_chart_session_default_values(true);
save_sql("webcharts");
}
}
} else {
if ($_POST['web'] == "webreports") {
save_sql("webreports");
}
if ($_POST['web'] == "webcharts") {
save_sql("webcharts");
}
}
echo "OK";
} elseif (isset($_POST['str_xml']) && isset($_POST['web']) && isset($_POST['save'])) {
$arr = my_json_decode(DecodeUTF8(postvalue('str_xml')));
if (count($arr["parameters"]) < 2 && $_POST['web'] == 'webcharts' && $_POST['name'] == 'parameters') {
echo "Debe seleccionar al menos una serie";
return;
}
if ($_POST['web'] == "webreports") {
Check_Crosstable_Group($arr, isset($_POST['save']));
$is_crosstable = $root["group_fields"][count($root["group_fields"]) - 1]["cross_table"];
Check_Crosstable_Totals($arr, $is_crosstable);
}
$saveas = false;
if (isset($_POST['saveas'])) {
$saveas = true;
}
foreach ($arr as $key => $val) {
$root[$key] = $val;
