Index: openacs-4/packages/contacts/www/contact-rels.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/www/contact-rels.tcl,v diff -u -r1.8 -r1.9 --- openacs-4/packages/contacts/www/contact-rels.tcl 7 Jun 2005 07:45:40 -0000 1.8 +++ openacs-4/packages/contacts/www/contact-rels.tcl 7 Jun 2005 19:01:26 -0000 1.9 @@ -88,37 +88,90 @@ #set default_group_id [contacts::default_group_id] set title "Contacts" set context {} +set package_url [ad_conn package_url] +if { [exists_and_not_null query] } { - -set search_clause [list] -lappend search_clause "and party_id in ( select member_id from group_distinct_member_map where group_id = '-2' )" -if { [exists_and_not_null rel_type] } { - set rel_valid_p 0 - set group_id "-2" - db_foreach dbqd.contacts.www.index.get_rels {} { - if { $rel_type == $relation_type } { - set rel_valid_p 1 + set search_clause [list] + lappend search_clause "and party_id in ( select member_id from group_distinct_member_map where group_id = '-2' )" + if { [exists_and_not_null rel_type] } { + set rel_valid_p 0 + set group_id "-2" + db_foreach dbqd.contacts.www.index.get_rels {} { + if { $rel_type == $relation_type } { + set rel_valid_p 1 + } } + if { $rel_valid_p } { + lappend search_clause "and party_id in ( select member_id from group_member_map where rel_type = '$rel_type' )" + } else { + set rel_type "" + } } - if { $rel_valid_p } { - lappend search_clause "and party_id in ( select member_id from group_member_map where rel_type = '$rel_type' )" - } else { - set rel_type "" - } -} -if { [exists_and_not_null query] } { - set search [string trim $query] - foreach term $query { - if { [string is integer $query] } { - lappend search_clause "and party_id = $term" - } else { - lappend search_clause "and upper(contact__name(party_id)) like upper('%${term}%')" + if { [exists_and_not_null query] } { + set search [string trim $query] + foreach term $query { + if { [string is integer $query] } { + lappend search_clause "and party_id = $term" + } else { + lappend search_clause "and upper(contact__name(party_id)) like upper('%${term}%')" + } } } -} +<<<<<<< contact-rels.tcl + set search_clause [join $search_clause "\n"] + #ad_return_error "Error" $search_clause + + + set primary_party $party_id + + template::list::create \ + -html {width 100%} \ + -name "contacts" \ + -multirow "contacts" \ + -row_pretty_plural "$pretty_plural_list_name found in search, please try again or add a new contact" \ + -checkbox_name checkbox \ + -selected_format ${format} \ + -orderby_name "order_search" \ + -key party_id \ + -elements { + type { + label {} + display_template { + + } + } + contact { + label {} + display_template { + @contacts.party_id@">@contacts.name@ \[Select\] + @contacts.email@ + } + } + contact_id { + display_col party_id + } + first_names { + display_col first_names + } + last_name { + display_col last_name + } + organization { + display_col organization + } + email { + display_col email + } + } -filters { + } -orderby { + first_names { + label "First Name" + orderby_asc "lower(contact__name(party_id,'f')) asc" + orderby_desc "lower(contact__name(party_id,'f')) asc" +======= set search_clause [join $search_clause "\n"] #ad_return_error "Error" $search_clause @@ -139,14 +192,32 @@ label {} display_template { +>>>>>>> 1.8 } +<<<<<<< contact-rels.tcl + last_name { + label "Last Name" + orderby_asc "lower(contact__name(party_id,'t')) asc" + orderby_desc "lower(contact__name(party_id,'t')) asc" +======= } contact { label {} display_template { @contacts.party_id@">@contacts.name@ \[[_ contacts.Select]\] @contacts.email@ +>>>>>>> 1.8 } +<<<<<<< contact-rels.tcl + default_value first_names,asc + } -formats { + normal { + label "Table" + layout table + row { + contact {} + } +======= } contact_id { display_col party_id @@ -182,22 +253,34 @@ layout table row { contact {} +>>>>>>> 1.8 } } + + set original_party_id $party_id + db_multirow -extend {map_url} -unclobber contacts dbqd.contacts.www.index.contacts_select {} { + set map_url [export_vars -base "${package_url}relationship-add" -url {{party_one $original_party_id} {party_two $party_id} {role_two $role_two}}] } -set original_party_id $party_id -set package_url [ad_conn package_url] -db_multirow -extend {map_url} -unclobber contacts dbqd.contacts.www.index.contacts_select {} { - set map_url [export_vars -base "${package_url}relationship-add" -url {{party_one $original_party_id} {party_two $party_id} {role_two $role_two}}] + } set rel_options [list [list "[_ contacts.--select_one--]" ""]] +<<<<<<< contact-rels.tcl +set rel_options [db_list_of_lists get_rels {}] + +set rel_options "{{-Select One-} {}} $rel_options" + + + + +======= db_foreach get_rels {} { set pretty_name [lang::util::localize $pretty_name] lappend rel_options [list $pretty_name $role] } +>>>>>>> 1.8 ad_form -name "search" -method "GET" -export {party_id} -form { Index: openacs-4/packages/contacts/www/resources/contacts.css =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/www/resources/contacts.css,v diff -u -r1.7 -r1.8 --- openacs-4/packages/contacts/www/resources/contacts.css 27 May 2005 09:55:30 -0000 1.7 +++ openacs-4/packages/contacts/www/resources/contacts.css 7 Jun 2005 19:01:26 -0000 1.8 @@ -8,6 +8,9 @@ div#contact-info { clear: both; } +#contact-info h3 { + clear: both; +} #contact-info div.primary { width: 48%; float: left;