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
|
<SCRIPT Language="JavaScript">
function ClearList( l )
{
var i;
for( i = 0; i < l.options.length; i++ )
{
if( l.options[i].value != -1 )
l.options[i] = null;
}
}
function UpdateMenu( f, sel_t )
{
var field_names = new Array();
var field_values = new Array();
var table_names = new Array();
<?
for( $i = 0; list( #i, $table ) = each( $table_list ); $i++ )
{
echo "\ttable_names[$i] = \"$table\";\n";
print "field_names[\"$table\"] = new Array();\n";
print "field_values[\"$table\"] = new Array();\n";
$fields = $table_fields[$table];
for( $j = 0; list( $value, $name) = each( $fields ); $j++ )
{
echo "\t\tfield_names[\"$table\"][$j] = \"$name\";\n";
echo "\t\tfield_values[\"$table\"][$j] = \"$value\";\n";
}
}
?>
var opArray = sel_t.options;
var index = sel_t.selectedIndex;
var selOp = opArray[index];
var Table = selOp.value;
var re = /table/i;
var foo = sel_t.name.replace( re, "field" );
var sel_f = f.elements[foo];
if( ! Table )
{
Table = selOp.text;
}
if( Table == -1 )
{
ClearList( sel_f );
history.go(0);
return;
}
ClearList( sel_f );
var empty = new Option( '-', -1 );
sel_f.options[0] = empty;
for( var i = 1; i < field_values[Table].length; i++ )
{
var temp = new Option( field_names[Table][i-1], field_values[Table][i-1] );
sel_f.options[i] = temp;
}
history.go(0);
}
function PutText( what )
{
var f = what.form;
if( what.options[what.selectedIndex].value == -1 )
{
// alert( "return" );
return;
}
// alert( what.selectedIndex );
var fields = what.options;
var re = /field_sel2/i;
var foo = what.name.replace( re, "input" );
var target = f.elements[foo];
re = /field/i;
foo = what.name.replace( re, "table" );
var table = f.elements[foo];
var tables = table.options;
// target is a text box
var theText = tables[table.selectedIndex].value + "." + fields[what.selectedIndex].value;
target.value = theText;
}
}
</SCRIPT>
|
