-
Notifications
You must be signed in to change notification settings - Fork 0
/
createNewAnalysis.html
189 lines (189 loc) · 7.03 KB
/
createNewAnalysis.html
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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
<html>
<head>
<link rel="stylesheet" type="text/css" href="Scripts/createNewAnalysis.css"></link>
<script type="text/javascript" src="Scripts/createNewAnalysis.js"></script>
<script type="text/javascript">
window.onload = setup;
</script>
</head>
<body>
<div class="FullArea">
<div class="stepTitle">
<div class="titleBorder fontBold">
Choose table and field
</div>
</div>
<div class="stepRows" id="joinSQL"><!-- stepRows will collapse, block, width100%-->
<div class="tableDiv">
<input type="button" class="inlineBlockDiv" disabled value="Select" id="selectTableNameAndField" onclick="SelectTableNameAndField();" />
<input type="button" class="inlineBlockDiv" value="Reset" onclick="resetTableNameAndField();" />
</div>
<div class="tableDiv"> <!--layers to be added -->
<div class ="inlineBlockDiv"><!--div for inline-block-->
<div class="textAlign blockDiv"> <!-- top div for the title, block, width100% -->
Choose a table
</div>
<div class="tableDiv"> <!-- bottom div for the selectbox, table -->
<select class="selectBox" onchange="chooseTableName();" size="10" id="joinSQLTableList"> <!-- selectBox class, size10, width150px -->
</select>
</div>
</div>
<div class="inlineBlockDiv">
<div class="blockDiv textAlign">
Choose a field
</div>
<div class="tableDiv">
<select class="selectBox" onchange="chooseFieldName();" size="10" id="joinSQLFieldList">
</select>
</div>
</div>
</div>
</div>
<div class="stepTitle">
<div class="titleBorder fontBold">
Choose/Build SQL Function
</div>
</div>
<div class="stepRows" id="functionSQL">
<div class="inlineBlockDiv"> <!-- div for creating function sql-->
<div class="sqlText"> <!-- div for holding the sql statement, inline-block, minwidth400px-->
<div class="inlineBlockDiv fontBold textAlignRight">
SQL Function:
</div>
<div class="inlineBlockDiv" id="functionLSQLSelected"></div>
<!-- divs for each section, all inline
use classes to show color and where the cursor is
| character is perfect-->
</div>
<div class="tableDiv"> <!-- div for dropdowns, table -->
<div class="inlineBlockDiv"> <!-- div for selectbox -->
<div class="blockDiv textAlign">
Current Functions
</div>
<div class="tableDiv">
<select class="selectBox" ondblclick="chooseCurrentFunctionSQL();" size="10" id="functionSQLList">
</select>
</div>
</div>
<div class="inlineBlockDiv"> <!-- div for an option-->
<div class="blockDiv textAlign" id="functionSQLAggregateTitle">
Aggregate Functions
</div>
<div class="tableDiv">
<select class="selectBox" ondblclick="chooseAggregateFunctionSQL();" size="10" id="functionSQLAggregateList">
</select>
</div>
</div>
<div class="inlineBlockDiv">
<div class="blockDiv textAlign" id="functionSQLFieldTitle">
Possible fields
</div>
<div class="tableDiv">
<select class="selectBox" ondblclick="chooseFieldNameFunctionSQL();" size="10" id="functionSQLFieldList"> <!-- only number fields-->
</select>
</div>
</div>
<div class="inlineBlockDiv">
<div class="blockDiv textAlign" id="functionSQLArithmeticTitle">
Arithmetic Functions
</div>
<div class="tableDiv">
<select class="selectBox" ondblclick="chooseArithmeticFunctionSQL();" size="10" id="functionSQLArithmeticList">
</select>
</div>
</div>
<div class="inlineBlockDiv"> <!-- div for button -->
<input type="button" class="button" onclick="selectFunctionSQL();" value="Select" />
<input type="button" class="button" onclick="resetFunctionSQL();" value="Reset" />
</div>
</div>
</div>
</div>
<div class="stepTitle">
<div class="titleBorder fontBold">
Choose values to be skipped
</div>
</div>
<div class="stepRows" id="skipList">
<div class="inlineBlockDiv"> <!-- div for each column, possible, buttons, selected -->
<div class="blockDiv textAlign">
Possible values to skip
</div>
<div class="tableDiv">
<select class="selectBox" size="10" id="skipListNewValues">
</select>
</div>
</div>
<div class="inlineBlockDiv">
<input type="button" class="button" onclick="addToSkipList();" value="-> Add ->" /> <!-- class for the button size, width100px, margin:15px, table -->
<input type="button" class="button" onclick="removeFromSkipList();" value="<- remove <-" />
</div>
<div class="inlineBlockDiv">
<div class="blockDiv textAlign">
Values being skipped
</div>
<div class="tableDiv">
<select class="selectBox" size="10" id="skipListCurrentValues">
</select>
</div>
</div>
</div>
<div class="stepTitle">
<div class="titleBorder fontBold">
Choose values to be consolidated into one
</div>
</div>
<div class="stepRows" id="consolidateList">
<div class="tableDiv">
<div class="inlineBlockDiv regExpMargin textAlignCenter">
Values selected<br/>by RegExp
</div>
<div class="inlineBlockDiv textAlignCenter">
Current Consolidated<br/>Values
</div>
<div class="inlineBlockDiv textAlignCenter">
Fields Consolidated<br/>by Selected
</div>
</div>
<div class="inlineBlockDiv"> <!-- used for adding consolidate values for all tables that use that fieldName -->
<div class="inlineBlockDiv"> <!-- add -->
<div class="button">
<div class="blockDiv textAlign" title="Type in here to see what values will be combined into one. Works from the start of the value. Example:
GE would combine GE, GECAFE, GEHOTPOINT, GEMONO, and GEPROFILE">
RegExp
</div>
<input type="text" onkeyup="consolidateListShowForNew();" id="consolidateListREGEXP" class="button noMargin" /> <!-- noMargin to remove the margins, margin:0px -->
</div>
<input type="button" class="button" onclick="addToConsolidateList();" value="Add" />
<div class="blockDiv textAlign" id="consolidateValueToBeUsed" title="This is the value to be used in the graphs in replacement of the original values. Example:
GE - ALL in replacement of GE, GECAFE, GEHOTPOINT, GEMONO, and GEPROFILE">GE - All
</div>
</div>
<div class="inlineBlockDiv"> <!-- values consolidated -->
<select class="selectBox" size="10" id="consolidateListForNewREGEXP">
</select>
</div>
<div class="inlineBlockDiv"> <!-- list of consolidated REGEXP added -->
<select class="selectBox" onchange="consolidateListViewCurrentREGEXP();" size="10" id="consolidateListCurrentREGEXP">
</select>
</div>
<div class="inlineBlockDiv"> <!-- list of values replaced by selected REGEXP -->
<select class="selectBox" size="10" id="consolidateListCurrentReplacedValues">
</select>
</div>
<div class="inlineBlockDiv"> <!-- remove selected consolidated value -->
<input type="button" class="button" value="Remove" onclick="removeFromConsolidateList();" />
</div>
</div>
</div>
<div class="stepTitle">
<div class="titleBorder fontBold">
Finish Button
</div>
</div>
<div class="stepRows" id="FinishButton">
<input type="button" class="inlineBlockDiv" value="Finish" onclick="saveEverything();">
</div>
</div>
</body>
</html>