} $tmp = split(":", $_SESSION['ses_database']); $sys_dbType = 'postgres'; $sys_dbIP = $tmp[0]; $sys_dbPort = $tmp[1]; $sys_dbLogin = $tmp[2]; $sys_dbPass = $tmp[3]; $sys_dbName = $lstParams['db']; $db = new phpDBConnection($sys_dbType); $db->connect($sys_dbIP, $sys_dbLogin, $sys_dbPass, $sys_dbName, $sys_dbPort); require "features.php"; switch ($lstParams['req_name'] . "::" . $lstParams['req_cmd']) { case "viewScript::edit_get_data": $vw = split("\\.", $lstParams['view']); $sql = "SELECT definition FROM pg_views\n\t\t\t\tWHERE viewname = '" . $vw[2] . "'\n\t\t\t\t\tAND schemaname = '" . $vw[1] . "'"; $rs = $db->execute($sql); $sql = $rs->fields[0]; // -- process edit print "document.getElementById('sql').value = \"CREATE OR REPLACE VIEW " . $lstParams['view'] . " AS \\n" . addslashes($sql) . "\";"; print "top.elements['viewScript'].dataReceived();"; break; case "viewData::lst_get_data": $tbl = split("\\.", $lstParams['view']); // -- get fields $sql = "SELECT * FROM " . $lstParams['view'] . " LIMIT 1"; $rs = $db->execute($sql); $fields = $db->res_fields; print "top.elements.viewData.columns = [];\n"; foreach ($fields as $k => $v) { print "top.elements.viewData.addColumn('{$v}', '', 'Text', '');\n"; }
$db_time = round(((double) $t2 - (double) $t1) * 1000) / 1000; if (!$rs) { $msg = "<span style='color: red'>" . $db->res_errMsg . "</span> "; } else { $msg = "Query Time: " . $db_time . "<br>Affected Rows: " . $db->res_affectedRows . "<br> Rows Returned: " . $db->res_rowCount . "<br> Fields Returned: " . $db->res_fieldCount . ""; } print $msg; print "</textarea>"; print "<script>\n\t\t\t\twindow.onload = pload;\n\t\t\t\tfunction pload() {\n\t\t\t\t\tparent.document.getElementById('display').innerHTML = '<div style=\"padding: 10px; line-height: 135%;\">'+ document.getElementById('data').value +'</div>';\n\t\t\t\t}\n\t\t\t</script>"; die; break; case 'p': // -- get fields $_SESSION['tmp_sql'] = $sql; $sql = "SELECT * FROM ({$sql}) list1 LIMIT 1"; $rs = $db->execute($sql); if (!is_array($db->res_fields)) { print "<script>\n\t\t\t\t\twindow.onload = pload;\n\t\t\t\t\tfunction pload() {\n\t\t\t\t\t\tparent.document.getElementById('display').innerHTML = '<div style=\"padding: 10px; color: red;\">" . $db->res_errMsg . "</div>';\n\t\t\t\t\t}\n\t\t\t\t</script>"; die; } else { print "<script>\n\t\t\t\t\t\t\twindow.onload = pload;\n\t\t\t\t\t\t\tfunction pload() {"; } // -- list $fields = $db->res_fields; print "top.elements.execData.columns = [];\n"; foreach ($fields as $k => $v) { print "top.elements.execData.addColumn('{$v}', '', 'Text', '');\n"; } // -- edit print "top.elements.execDataAdd.fieldIndex = 0;\n" . "top.elements.execDataAdd.groups[0].fields = [];\n" . "var group = top.elements.execDataAdd.groups[0];\n"; foreach ($fields as $k => $v) {