5 root = 'SELECT * FROM ' _ table.findvalue('tablename') _ ' WHERE parent_ou IS NULL ORDER BY name;';
6 q = 'SELECT * FROM ' _ table.findvalue('tablename') _ ' WHERE parent_ou = ? ORDER BY name;';
8 org_unit_type = DBI.tie('actor.org_unit_type', 'id')
12 <script language="javascript">
13 filters["[% input_prefix %]"] = "[% table_label _ ' -- ' _ field.findvalue('label') %]";
15 var hier_[% table_alias %] = [];
17 function change_hier_[% table_alias %] ( sel ) {
18 for (var i in hier_[% table_alias %]) {
19 if (hier_[% table_alias %][i] == sel.options[sel.selectedIndex].id) {
23 sel.selectedIndex = null;
30 WRAPPER select id=input_prefix name=input_prefix onchange='change_hier_' _ table_alias _ '(this);';
32 INCLUDE option value='' content='Select One';
33 INCLUDE option value='' content='----------';
34 FOR f = DBI.query(root);
35 INCLUDE option value=f.$fieldname;
36 INCLUDE next_level parent_ou = f.id depth;
45 FOR f = s.execute(parent_ou);
48 logme(["can_have_vols for ou_t", ,org_unit_type.$ou_t.can_have_vols]);
50 IF org_unit_type.$ou_t.can_have_vols == 1;
52 <script language="javascript">
53 hier_[% table_alias %].push("dr_[% f.id %]");
61 val = val _ ' ';
65 INCLUDE option value=f.name content=val _ f.name id='dr_' _ f.id;
66 INCLUDE next_level parent_ou = f.id;