/
adHocParam.php
128 lines (118 loc) · 3.64 KB
/
adHocParam.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
<?php
//adHocParam.php
session_start();
require("adHocConst.php");
require("adHocInclude.php");
traceHide("Passed keys / value");
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>
<? echo cHeaderComment;?>
<TITLE><? echo pdoData($row,"title");?> adHoc Query - Parameter Entry</TITLE>
<LINK REL="stylesheet" HREF=<? echo cStylesheet;?> TYPE="text/css" />
<script language="javascript">
<!--
function doInputForm() {
document.InputForm.submit();
}
//-->
</script>
</HEAD>
<BODY BGCOLOR="#000000">
<!-- Header table -->
<TABLE BORDER="0" WIDTH="600" CELLPADDING="0" CELLSPACING="0">
<TR><TD WIDTH="3"> </TD><TD WIDTH="597">
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%"><TR>
<TD><P CLASS="title">Ad Hoc Parameter <? echo $thisMenu;?> / <? echo $thisLine;?></P></TD>
<TD><P CLASS="title"><?echo $siteName;?></TD>
<TD><P CLASS="date"><? echo $pageDate;?></P></TD>
</TR></TABLE>
<CENTER>
<IMG SRC="<? echo cHeaderImagePath;?>" ALT="" BORDER="0" WIDTH="299" HEIGHT="95"></A>
<BR><BR>
<span class="header18"><? echo pdoData($row,"title");?></span>
</CENTER>
<?
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">
<? echo $formInputsStr;?>
<TR>
<TD> </TD>
<TD> </TD>
<TD class="ahParam" valign="bottom">
<a href="javascript:doInputForm()">next...</a>
<!--INPUT TYPE="Submit" VALUE="Next"-->
</TD>
</TR>
</TABLE>
</CENTER>
<INPUT TYPE="hidden" NAME="sitenum" VALUE="<? echo $thisSite;?>">
<INPUT TYPE="hidden" NAME="menunum" VALUE="<? echo $thisMenu;?>">
<INPUT TYPE="hidden" NAME="linenum" VALUE="<? echo $thisLine;?>">
</FORM>
<BR />
<BR />
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0" WIDTH="100%"><TR><TD ALIGN="right">
<TABLE CELLPADDING="0" CELLSPACING="0" BORDER="0"><TR>
<TD>
<P CLASS="navBar">
<A HREF="javascript:history.back()">Back</A>
·
<A HREF="adHocMenu.php">Ad Hoc Home</A>
</P>
</TD>
</TR></TABLE>
</TD></TR></TABLE>
</TD>
</TR></TABLE>
<!-- Header table -->
<BR /><BR />
<SCRIPT LANGUAGE="JavaScript">
<!--
document.InputForm.elements[0].focus();
document.InputForm.elements[0].select();
// -->
</SCRIPT>
</BODY>
</HTML>