//----------------------------------------------------------------------------------- if (cShowRelatedQueries) { for ($i = 0; $i < 10; $i++) { traceHide("cShowRelatedQueries=true"); $relatedItem = getName($i); traceHide("relatedItem=" . $relatedItem); if ($relatedItem != "") { $relatedTitle = "Other Queries using " . $relatedItem; //Look for related enquiries, that is, where this user's query string variables // can be used in other adHocQuery records $relatedSelect = "SELECT m.menu_num, m.line_num, m.title, q.select_stmt" . " FROM queries q JOIN menus m ON m.main_query_num = q.query_num" . " WHERE q.select_stmt LIKE '%" . cParamDelimiter . $relatedItem . cParamDelimiter . "%'" . " AND m.hidden = 0" . " AND q.query_num <> " . $thisQuery . " AND (q.pre_select IS NULL OR q.pre_select = '')" . " AND EXISTS( SELECT * FROM menus mm WHERE mm.main_query_num = q.query_num GROUP BY mm.main_query_num" . " HAVING m.menu_num = MIN(mm.menu_num))" . " ORDER BY m.title"; traceHide("relatedSelect=" . $relatedSelect); $adhocStmt = pdoQuery($relatedSelect, $connAdHoc); $numRecords = pdoRowCount($adhocStmt); traceHide($relatedSelect); traceHide($numRecords . " records"); if ($numRecords > 0) { ?> <br/> <p class="ahTitleOtherLinks"><?php echo $relatedTitle; ?> (<?php echo $numRecords; ?> items)</p> <UL> <?php } foreach ($adhocStmt as $row) { $nextScript = hasAllParams(pdoData($row, "select_stmt")) ? "adHocQuery.php" : "adHocParam.php";
$siteNum = $_REQUEST["sitenum"]; } else { if (isset($_SESSION["sitenum"])) { $siteNum = $_SESSION["sitenum"]; } else { $siteNum = "1"; } } $_SESSION["sitenum"] = $siteNum; traceHide("sitenum=" . $siteNum); if (isset($_REQUEST["nextmenu"])) { $nextMenu = $_REQUEST["nextmenu"]; } else { $nextMenu = "1"; } traceHide("nextmenu=" . $nextMenu); $sql = " SELECT menu_num, line_num, title, sub_menu_num, select_stmt" . " FROM menus" . " LEFT JOIN queries ON main_query_num = query_num" . " WHERE menu_num = " . $nextMenu . " AND hidden = 0" . " ORDER BY menu_num, line_num"; $adHocStmt = pdoQuery($sql, $connAdHoc); $adHocRows = pdoFetch($adHocStmt); ?> <HTML> <HEAD> <?php echo cHeaderComment; ?> <TITLE>Ad Hoc Menu</TITLE> <LINK REL="stylesheet" HREF=<?php echo cStylesheet; ?> TYPE="text/css" /> </HEAD>
} else { $nextMenu = "1"; } traceHide("nextmenu=" . $nextMenu); if (isset($_REQUEST["menu_num"])) { $MenuNum = $_REQUEST["menu_num"]; } else { $MenuNum = "1"; } traceHide("menu_num=" . $MenuNum); if (isset($_REQUEST["line_num"])) { $LineNum = $_REQUEST["line_num"]; } else { $LineNum = "1"; } traceHide("line_num=" . $LineNum); /////////////////// // start of updates if (isset($_REQUEST['up'])) { $sql = "call sp_movemenu('u'," . $MenuNum . "," . $LineNum . ")"; pdoQuery($sql, $connAdHoc); } if (isset($_REQUEST['down'])) { $sql = "call sp_movemenu('d'," . $MenuNum . "," . $LineNum . ")"; pdoQuery($sql, $connAdHoc); } if (isset($_REQUEST['addm'])) { $sql = "call sp_addmenu(" . $MenuNum . ")"; pdoQuery($sql, $connAdHoc); } if (isset($_REQUEST['addq'])) {
function registerTotalFieldName($storageArray, $offsetArray, $fieldName, $fieldNameOffset) { for ($i = 0; $i < count($storageArray); $i++) { traceHide("storageArray[" . $i . "]=" . $storageArray[$i]); if ($storageArray[$i] == $fieldName) { $offsetArray[$i] = $fieldNameOffset; break; } } return $offsetArray; }
echo pdoData($row, "title"); ?> </span> </CENTER> <?php traceHide($sql); traceHide("menunum/linenum=" . $thisMenu . "/" . $thisLine); $selectStmt = pdoData($row, "select_stmt"); if (queryHasParams($selectStmt)) { $paramStr = explode(cParamDelimiter, $selectStmt); //step through the parameters and create corresponding form inputs //these are called '_n', where n is their index within array //splitParamStrArray $formInputsStr = ""; for ($i = 1; $i < count($paramStr); $i += 2) { traceHide("requestName=" . $paramStr[$i]); $formInputsStr = $formInputsStr . "<TR><TD class=\"ahParam\">" . $paramStr[$i] . "</TD>" . "<TD class=\"ahParam\"><INPUT TYPE=\"text\" NAME=\"" . $paramStr[$i] . "\" VALUE=\"" . requestValue($paramStr[$i]) . "\" class=\"text\"></TD><TD> </TD></TR>"; } } pdoDisconnect($connAdHoc); ?> <FORM ACTION="adHocQuery.php" NAME="InputForm" METHOD="POST"> <CENTER> <TABLE cellpadding="2"> <?php echo $formInputsStr; ?> <TR> <TD> </TD> <TD> </TD> <TD class="ahParam" valign="bottom">
$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> <LINK REL="stylesheet" HREF=<?php echo cStylesheet;
exit; } $sql = " SELECT q.query_num, title, q.heading_text AS heading, q.total_fields," . " q.link_field, q.select_stmt AS detail_select, q.pre_select, q.udb_num" . " FROM menus m" . " JOIN queries q ON m.main_query_num = q.query_num" . " WHERE m.menu_num = " . $curMenu . " AND m.line_num = " . $curLine; traceHide("main query=" . $sql); //=================================================================================== //Get the menu record pertaining to this query $stmt = pdoQuery($sql, $connAdHoc); $row = pdoFirstRow($stmt); $title = pdoData($row, 'title'); $heading = pdoData($row, 'heading'); $preselect = pdoData($row, 'pre_select'); $linkfield = pdoData($row, 'link_field'); $totalfields = pdoData($row, 'total_fields'); $udbnum = pdoData($row, 'udb_num'); $detailSelect = pdoData($row, 'detail_select'); traceHide("Raw detailSelect=" . $detailSelect); $curQuery = pdoData($row, "query_num"); pdoClose($stmt); //=================================================================================== //Get today's date $pageDate = dateNow(); ?> <HTML> <HEAD> <?php echo cHeaderComment; ?> <TITLE><?php echo $title; ?> </TITLE>