ernieg
committed
on 08 Dec 05
LAMS Integration documentation
/admin/component-ae.tcl (+2 -2)
39 39         -label "Description" \
40 40         -optional \
41 41         -html { cols 50 rows 8 }
42 42
43 43 element create component url_name \
44 44         -datatype text \
45 45         -html { size 50 } \
46 46         -label "Name in shortcut URL" \
47 47         -optional
48 48
49 49 element create component maintainer \
50 50         -widget search \
51 51         -datatype search \
52 52         -result_datatype integer \
53 53         -label "Maintainer" \
54 54         -options [bug_tracker::users_get_options] \
55 55         -optional \
56 56         -search_query {
57 57     select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
58 58     from   dir_all_users u
59       where  upper(coalesce(u.first_names || ' ', '')  || coalesce(u.last_name || ' ', '') || u.email || ' ' || coalesce(u.screen_name, '')) like upper('%'||:value||'%')
  59     where  upper(coalesce(u.first_names || ' ', '')  || coalesce(u.last_name || ' ', '') || u.email) like upper('%'||:value||'%')
60 60     order  by name
61 61 }
62 62 element create component component_id \
63 63         -datatype integer \
64 64         -widget hidden
65 65
66 66 if { [form is_request component] } {
67 67     if { ![info exists component_id] } {
68 68         element set_properties component component_id -value [db_nextval "acs_object_id_seq"]
69 69     } else {
70 70         db_1row component_info {
71 71             select component_id,
72 72                    component_name as name,
73 73                    description,
74 74                    maintainer,
75 75                    url_name
76 76             from   bt_components
77 77             where  component_id = :component_id
78 78         } -column_array component_info
79 79         form set_values component component_info