foreach ($_REQUEST as $key => $val) {
traceHide("key:" . $key . " / val:" . $val);
}
$connAdHoc = pdoConnect(cAdHocServer, cAdHocDatabase, cAdHocUsername, cAdHocPassword);
$thisMenu = $_REQUEST["menunum"];
$thisLine = $_REQUEST["linenum"];
$sql = " SELECT title, select_stmt" . " FROM menus" . " JOIN queries q1 ON main_query_num = query_num" . " WHERE menu_num = " . $thisMenu . " AND line_num = " . $thisLine;
$stmt = pdoQuery($sql, $connAdHoc);
$siteNum = $_SESSION["sitenum"];
$sqlSite = "SELECT site_name FROM sites WHERE site_num = " . $siteNum;
$siteStmt = pdoQuery($sqlSite, $connAdHoc);
$siteRow = pdoFirstRow($siteStmt);
$siteName = pdoData($siteRow, "site_name");
//get today's date
$pageDate = dateNow();
$row = pdoFirstRow($stmt);
?>
<HTML>
<HEAD>
<?php
echo cHeaderComment;
?>
<TITLE><?php
echo pdoData($row, "title");
?>
adHoc Query - Parameter Entry</TITLE>
<LINK REL="stylesheet" HREF=<?php
echo cStylesheet;
?>
TYPE="text/css" />
<script language="javascript">
foreach ($udbRows as $row) {
foreach ($row as $fieldName => $dataItem) {
$paramTitle = $paramTitle . "<span class=\"ahTitle\">" . $fieldName . ": " . $dataItem . "</span><br />";
}
break;
}
}
//===================================================================================
//This section constructs and runs the preselect query if necessary.
//do this before building the detail query, so that query string
//variables get inserted into this as well
if (queryHasParams($preSelect)) {
$preSelect = buildSQLQuery($preSelect);
traceHide("preSelect=" . $preSelect);
$udbResult = pdoQuery($preSelect, $conn_udb);
$row = pdoFirstRow($udbResult);
$subQuery = pdoData($row, "sub_query");
traceHide("sub_query=" . $subQuery);
$detailSelect = mergeSQLQuery($detailSelect, $subQuery);
}
//===================================================================================
//This section constructs the detail query if necessary
if (queryHasParams($detailSelect)) {
$paramStr = buildParamTitle($detailSelect);
traceHide("queryParamTitle=" . $paramStr);
traceHide("before builtSQLQuery=" . $detailSelect);
$detailSelect = buildSQLQuery($detailSelect);
traceHide("after builtSQLQuery=" . $detailSelect);
} else {
traceHide("query has no parameters");
}
}
$curMenu = $_REQUEST["menu_num"];
$curLine = $_REQUEST["line_num"];
if (isset($_REQUEST['upd'])) {
$sql = "call sp_updatemenu(" . $_REQUEST["parent_menu"] . ',' . $curMenu . ',' . $curLine . ',' . sqlLiteral($_REQUEST['title']) . ")";
traceHide($sql);
pdoQuery($sql, $connAdHoc);
header("Location: adHocAdmin.php?nextmenu=" . $curMenu);
exit;
}
$sql = " SELECT title" . " FROM menus" . " WHERE menu_num = " . $curMenu . " AND line_num = " . $curLine;
traceHide("main query=" . $sql);
//===================================================================================
//Get the menu record pertaining to this query
$adhocStmt = pdoQuery($sql, $connAdHoc);
$row = pdoFirstRow($adhocStmt);
$title = pdoData($row, 'title');
traceHide('Title: ' . $title);
//===================================================================================
//Get today's date
$pageDate = dateNow();
?>
<HTML>
<HEAD>
<?php
echo cHeaderComment;
?>
<TITLE><?php
echo $title;
?>
</TITLE>
