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;