- Added addressbook advanced search
1 files added
15 files modified
| | |
| | | CHANGELOG Roundcube Webmail |
| | | =========================== |
| | | |
| | | - Added addressbook advanced search |
| | | - Add popup with basic fields selection for addressbook search |
| | | - Case-insensitive matching in autocompletion (#1487933) |
| | | - Added option to force spellchecking before sending a message (#1485458) |
| | |
| | | /** |
| | | * Search contacts |
| | | * |
| | | * @param array List of fields to search in |
| | | * @param string Search value |
| | | * @param boolean True for strict (=), False for partial (LIKE) matching |
| | | * @param boolean True if results are requested, False if count only |
| | | * @param boolean True to skip the count query (select only) |
| | | * @param array List of fields that cannot be empty |
| | | * @param mixed $fields The field name of array of field names to search in |
| | | * @param mixed $value Search value (or array of values when $fields is array) |
| | | * @param boolean $strict True for strict (=), False for partial (LIKE) matching |
| | | * @param boolean $select True if results are requested, False if count only |
| | | * @param boolean $nocount True to skip the count query (select only) |
| | | * @param array $required List of fields that cannot be empty |
| | | * |
| | | * @return object rcube_result_set Contact records and 'count' value |
| | | */ |
| | | function search($fields, $value, $strict=false, $select=true, $nocount=false, $required=array()) |
| | |
| | | |
| | | $where = $and_where = array(); |
| | | |
| | | foreach ($fields as $col) { |
| | | foreach ($fields as $idx => $col) { |
| | | // direct ID search |
| | | if ($col == 'ID' || $col == $this->primary_key) { |
| | | $ids = !is_array($value) ? explode(',', $value) : $value; |
| | | $ids = $this->db->array2list($ids, 'integer'); |
| | | $where[] = 'c.' . $this->primary_key.' IN ('.$ids.')'; |
| | | continue; |
| | | } |
| | | // fulltext search in all fields |
| | | else if ($col == '*') { |
| | | $words = array(); |
| | | foreach(explode(" ", self::normalize_string($value)) as $word) |
| | | $words[] = $this->db->ilike('words', '%'.$word.'%'); |
| | | $where[] = '(' . join(' AND ', $words) . ')'; |
| | | } |
| | | else if ($strict) { |
| | | $where[] = $this->db->quoteIdentifier($col).' = '.$this->db->quote($value); |
| | | else { |
| | | $val = is_array($value) ? $value[$idx] : $value; |
| | | // table column |
| | | if (in_array($col, $this->table_cols)) { |
| | | if ($strict) { |
| | | $where[] = $this->db->quoteIdentifier($col).' = '.$this->db->quote($val); |
| | | } |
| | | else if (in_array($col, $this->table_cols)) { |
| | | $where[] = $this->db->ilike($col, '%'.$value.'%'); |
| | | else { |
| | | $where[] = $this->db->ilike($col, '%'.$val.'%'); |
| | | } |
| | | } |
| | | // vCard field |
| | | else { |
| | | if (in_array($col, $this->fulltext_cols)) { |
| | | foreach (explode(" ", self::normalize_string($val)) as $word) |
| | | $words[] = $this->db->ilike('words', '%'.$word.'%'); |
| | | $where[] = '(' . join(' AND ', $words) . ')'; |
| | | } |
| | | if (is_array($value)) |
| | | $post_search[$col] = $strict ? $val : mb_strtolower($val); |
| | | } |
| | | } |
| | | } |
| | | |
| | |
| | | $and_where[] = $this->db->quoteIdentifier($col).' <> '.$this->db->quote(''); |
| | | } |
| | | |
| | | if (!empty($where)) |
| | | $where = join(' OR ', $where); |
| | | if (!empty($where)) { |
| | | // use AND operator for advanced searches |
| | | $where = join(is_array($value) ? ' AND ' : ' OR ', $where); |
| | | } |
| | | |
| | | if (!empty($and_where)) |
| | | $where = ($where ? "($where) AND " : '') . join(' AND ', $and_where); |
| | | |
| | | // Post-searching in vCard data fields |
| | | // we will search in all records and then build a where clause for their IDs |
| | | if (!empty($post_search)) { |
| | | $ids = array(0); |
| | | // build key name regexp |
| | | $regexp = '/^(' . implode(array_keys($post_search), '|') . ')(:.*?)$/'; |
| | | // use initial WHERE clause, to limit records number if possible |
| | | if (!empty($where)) |
| | | $this->set_search_set($where); |
| | | |
| | | // count result pages |
| | | $cnt = $this->count(); |
| | | $pages = ceil($cnt / $this->page_size); |
| | | $scnt = count($post_search); |
| | | |
| | | // get (paged) result |
| | | for ($i=0; $i<$pages; $i++) { |
| | | $this->list_records(null, $i, true); |
| | | while ($row = $this->result->next()) { |
| | | $id = $row[$this->primary_key]; |
| | | $found = 0; |
| | | foreach (preg_grep($regexp, array_keys($row)) as $col) { |
| | | $pos = strpos($col, ':'); |
| | | $colname = $pos ? substr($col, 0, $pos) : $col; |
| | | $search = $post_search[$colname]; |
| | | foreach ((array)$row[$col] as $value) { |
| | | // composite field, e.g. address |
| | | if (is_array($value)) { |
| | | $value = implode($value); |
| | | } |
| | | if (($strict && $value == $search) |
| | | || (!$strict && strpos(mb_strtolower($value), $search) !== false) |
| | | ) { |
| | | $found++; |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | // all fields match |
| | | if ($found == $scnt) { |
| | | $ids[] = $id; |
| | | } |
| | | } |
| | | } |
| | | |
| | | // build WHERE clause |
| | | $ids = $this->db->array2list($ids, 'integer'); |
| | | $where = 'c.' . $this->primary_key.' IN ('.$ids.')'; |
| | | unset($this->cache['count']); |
| | | } |
| | | |
| | | if (!empty($where)) { |
| | | $this->set_search_set($where); |
| | | if ($select) |
| | |
| | | /** |
| | | * Search contacts |
| | | * |
| | | * @param array List of fields to search in |
| | | * @param string Search value |
| | | * @param boolean True for strict, False for partial (fuzzy) matching |
| | | * @param boolean True if results are requested, False if count only |
| | | * @param boolean (Not used) |
| | | * @param array List of fields that cannot be empty |
| | | * @param mixed $fields The field name of array of field names to search in |
| | | * @param mixed $value Search value (or array of values when $fields is array) |
| | | * @param boolean $strict True for strict, False for partial (fuzzy) matching |
| | | * @param boolean $select True if results are requested, False if count only |
| | | * @param boolean $nocount (Not used) |
| | | * @param array $required List of fields that cannot be empty |
| | | * |
| | | * @return array Indexed list of contact records and 'count' value |
| | | */ |
| | | function search($fields, $value, $strict=false, $select=true, $nocount=false, $required=array()) |
| | |
| | | return $result; |
| | | } |
| | | |
| | | $filter = '(|'; |
| | | // use AND operator for advanced searches |
| | | $filter = is_array($value) ? '(&' : '(|'; |
| | | $wc = !$strict && $this->prop['fuzzy_search'] ? '*' : ''; |
| | | |
| | | if ($fields == '*') |
| | | { |
| | | // search_fields are required for fulltext search |
| | |
| | | } |
| | | if (is_array($this->prop['search_fields'])) |
| | | { |
| | | foreach ($this->prop['search_fields'] as $k => $field) |
| | | foreach ($this->prop['search_fields'] as $field) { |
| | | $filter .= "($field=$wc" . $this->_quote_string($value) . "$wc)"; |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | foreach ((array)$fields as $field) |
| | | if ($f = $this->_map_field($field)) |
| | | $filter .= "($f=$wc" . $this->_quote_string($value) . "$wc)"; |
| | | foreach ((array)$fields as $idx => $field) { |
| | | $val = is_array($value) ? $value[$idx] : $value; |
| | | if ($f = $this->_map_field($field)) { |
| | | $filter .= "($f=$wc" . $this->_quote_string($val) . "$wc)"; |
| | | } |
| | | } |
| | | } |
| | | $filter .= ')'; |
| | | |
| | |
| | | } |
| | | } |
| | | |
| | | if ((this.env.action == 'add' || this.env.action == 'edit') && this.gui_objects.editform) { |
| | | if (this.gui_objects.editform) { |
| | | this.enable_command('save', true); |
| | | if (this.env.action == 'add' || this.env.action == 'edit') |
| | | this.init_contact_form(); |
| | | } |
| | | else if (this.gui_objects.qsearchbox) { |
| | | if (this.gui_objects.qsearchbox) { |
| | | this.enable_command('search', 'reset-search', 'moveto', true); |
| | | $(this.gui_objects.qsearchbox).select(); |
| | | } |
| | |
| | | if (this.contact_list && this.contact_list.rowcount > 0) |
| | | this.enable_command('export', true); |
| | | |
| | | this.enable_command('list', 'listgroup', true); |
| | | this.enable_command('list', 'listgroup', 'advanced-search', true); |
| | | break; |
| | | |
| | | |
| | |
| | | break; |
| | | |
| | | case 'save': |
| | | if (this.gui_objects.editform) { |
| | | var input_pagesize = $("input[name='_pagesize']"); |
| | | var input_name = $("input[name='_name']"); |
| | | var input_email = $("input[name='_email']"); |
| | | |
| | | var input, form = this.gui_objects.editform; |
| | | if (form) { |
| | | // adv. search |
| | | if (this.env.action == 'search') { |
| | | } |
| | | // user prefs |
| | | if (input_pagesize.length && isNaN(parseInt(input_pagesize.val()))) { |
| | | else if ((input = $("input[name='_pagesize']", form)) && input.length && isNaN(parseInt(input.val()))) { |
| | | alert(this.get_label('nopagesizewarning')); |
| | | input_pagesize.focus(); |
| | | input.focus(); |
| | | break; |
| | | } |
| | | // contacts/identities |
| | | else { |
| | | if (input_name.length && input_name.val() == '') { |
| | | if ((input = $("input[name='_name']", form)) &&input.length && input.val() == '') { |
| | | alert(this.get_label('nonamewarning')); |
| | | input_name.focus(); |
| | | input.focus(); |
| | | break; |
| | | } |
| | | else if (this.task == 'settings' && input_email.length && (this.env.identities_level % 2) == 0 && !rcube_check_email(input_email.val())) { |
| | | else if (this.task == 'settings' && (this.env.identities_level % 2) == 0 && |
| | | (input = $("input[name='_email']", form)) && input.length&& !rcube_check_email(input.val()) |
| | | ) { |
| | | alert(this.get_label('noemailwarning')); |
| | | input_email.focus(); |
| | | input.focus(); |
| | | break; |
| | | } |
| | | |
| | |
| | | $('input.placeholder').each(function(){ if (this.value == this._placeholder) this.value = ''; }); |
| | | } |
| | | |
| | | this.gui_objects.editform.submit(); |
| | | form.submit(); |
| | | } |
| | | break; |
| | | |
| | |
| | | if (mods) |
| | | mods = mods[mbox] ? mods[mbox] : mods['*']; |
| | | } else if (this.contact_list) { |
| | | this.contact_list.clear(true); |
| | | this.show_contentframe(false); |
| | | this.list_contacts_clear(); |
| | | } |
| | | |
| | | if (mods) { |
| | |
| | | this.list_contacts_remote = function(src, group, page) |
| | | { |
| | | // clear message list first |
| | | this.contact_list.clear(true); |
| | | this.show_contentframe(false); |
| | | this.enable_command('delete', 'compose', false); |
| | | this.list_contacts_clear(); |
| | | |
| | | // send request to server |
| | | var url = (src ? '_source='+urlencode(src) : '') + (page ? (src?'&':'') + '_page='+page : ''), |
| | |
| | | url += '&_search='+this.env.search_request; |
| | | |
| | | this.http_request('list', url, lock); |
| | | }; |
| | | |
| | | this.list_contacts_clear = function() |
| | | { |
| | | this.contact_list.clear(true); |
| | | this.show_contentframe(false); |
| | | this.enable_command('delete', 'compose', false); |
| | | }; |
| | | |
| | | // load contact record |
| | |
| | | this.enable_command('delete-photo', this.env.coltypes.photo && id != '-del-'); |
| | | }; |
| | | |
| | | // load advanced search page |
| | | this.advanced_search = function() |
| | | { |
| | | var add_url = '&_form=1', target = window; |
| | | |
| | | if (this.env.contentframe && window.frames && window.frames[this.env.contentframe]) { |
| | | add_url += '&_framed=1'; |
| | | target = window.frames[this.env.contentframe]; |
| | | this.contact_list.clear_selection(); |
| | | } |
| | | else if (framed) |
| | | return false; |
| | | |
| | | this.location_href(this.env.comm_path+'&_action=search'+add_url |
| | | +'&_source='+urlencode(this.env.source) |
| | | +(this.env.group ? '&_gid='+urlencode(this.env.group) : ''), target); |
| | | |
| | | return true; |
| | | }; |
| | | |
| | | |
| | | /*********************************************************/ |
| | | /********* user settings methods *********/ |
| | |
| | | $labels['assistant'] = 'Assistant'; |
| | | $labels['spouse'] = 'Spouse'; |
| | | $labels['allfields'] = 'All fields'; |
| | | $labels['search'] = 'Search'; |
| | | $labels['advsearch'] = 'Advanced Search'; |
| | | $labels['other'] = 'Other'; |
| | | |
| | | $labels['typehome'] = 'Home'; |
| | | $labels['typework'] = 'Work'; |
| | |
| | | $labels['typepager'] = 'Pager'; |
| | | $labels['typevideo'] = 'Video'; |
| | | $labels['typeassistant'] = 'Assistant'; |
| | | $labels['typehomepage'] = 'Home page'; |
| | | |
| | | $labels['addfield'] = 'Add field...'; |
| | | $labels['addcontact'] = 'Add new contact'; |
| | |
| | | $labels['typepager'] = 'Pager'; |
| | | $labels['typevideo'] = 'Wideo'; |
| | | $labels['typeassistant'] = 'Asystent'; |
| | | $labels['typehomepage'] = 'Strona domowa'; |
| | | $labels['addfield'] = 'Dodaj pole...'; |
| | | $labels['personalinfo'] = 'Informacje osobiste'; |
| | | $labels['addphoto'] = 'Dodaj'; |
| | |
| | | $labels['defaultaddressbook'] = 'Nowe kontakty dodawaj do wybranej książki adresowej'; |
| | | $labels['spellcheckbeforesend'] = 'Przed wysłaniem wiadomości sprawdzaj pisownię'; |
| | | $labels['allfields'] = 'Wszystkie pola'; |
| | | $labels['search'] = 'Szukaj'; |
| | | $labels['advsearch'] = 'Zaawansowane wyszukiwanie'; |
| | | $labels['other'] = 'Inne'; |
| | | |
| | | ?> |
| | |
| | | |
| | | // general definition of contact coltypes |
| | | $CONTACT_COLTYPES = array( |
| | | 'name' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('name')), |
| | | 'firstname' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('firstname')), |
| | | 'surname' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('surname')), |
| | | 'middlename' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('middlename')), |
| | | 'prefix' => array('type' => 'text', 'size' => 8, 'limit' => 1, 'label' => rcube_label('nameprefix')), |
| | | 'suffix' => array('type' => 'text', 'size' => 8, 'limit' => 1, 'label' => rcube_label('namesuffix')), |
| | | 'nickname' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('nickname')), |
| | | 'jobtitle' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('jobtitle')), |
| | | 'organization' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('organization')), |
| | | 'department' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('department')), |
| | | 'gender' => array('type' => 'select', 'limit' => 1, 'label' => rcube_label('gender'), 'options' => array('male' => rcube_label('male'), 'female' => rcube_label('female'))), |
| | | 'maidenname' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('maidenname')), |
| | | 'email' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('email'), 'subtypes' => array('home','work','other')), |
| | | 'phone' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('phone'), 'subtypes' => array('home','home2','work','work2','mobile','main','homefax','workfax','car','pager','video','assistant','other')), |
| | | 'name' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('name'), 'category' => 'main'), |
| | | 'firstname' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('firstname'), 'category' => 'main'), |
| | | 'surname' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('surname'), 'category' => 'main'), |
| | | 'email' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('email'), 'subtypes' => array('home','work','other'), 'category' => 'main'), |
| | | 'middlename' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('middlename'), 'category' => 'main'), |
| | | 'prefix' => array('type' => 'text', 'size' => 8, 'limit' => 1, 'label' => rcube_label('nameprefix'), 'category' => 'main'), |
| | | 'suffix' => array('type' => 'text', 'size' => 8, 'limit' => 1, 'label' => rcube_label('namesuffix'), 'category' => 'main'), |
| | | 'nickname' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('nickname'), 'category' => 'main'), |
| | | 'jobtitle' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('jobtitle'), 'category' => 'main'), |
| | | 'organization' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('organization'), 'category' => 'main'), |
| | | 'department' => array('type' => 'text', 'size' => 19, 'limit' => 1, 'label' => rcube_label('department'), 'category' => 'main'), |
| | | 'gender' => array('type' => 'select', 'limit' => 1, 'label' => rcube_label('gender'), 'options' => array('male' => rcube_label('male'), 'female' => rcube_label('female')), 'category' => 'personal'), |
| | | 'maidenname' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('maidenname'), 'category' => 'personal'), |
| | | 'phone' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('phone'), 'subtypes' => array('home','home2','work','work2','mobile','main','homefax','workfax','car','pager','video','assistant','other'), 'category' => 'main'), |
| | | 'address' => array('type' => 'composite', 'label' => rcube_label('address'), 'subtypes' => array('home','work','other'), 'childs' => array( |
| | | 'street' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('street')), |
| | | 'locality' => array('type' => 'text', 'size' => 28, 'label' => rcube_label('locality')), |
| | | 'zipcode' => array('type' => 'text', 'size' => 8, 'label' => rcube_label('zipcode')), |
| | | 'region' => array('type' => 'text', 'size' => 12, 'label' => rcube_label('region')), |
| | | 'country' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('country')), |
| | | )), |
| | | 'birthday' => array('type' => 'date', 'size' => 12, 'label' => rcube_label('birthday'), 'limit' => 1, 'render_func' => 'rcmail_format_date_col'), |
| | | 'anniversary' => array('type' => 'date', 'size' => 12, 'label' => rcube_label('anniversary'), 'limit' => 1, 'render_func' => 'rcmail_format_date_col'), |
| | | 'website' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('website'), 'subtypes' => array('homepage','work','blog','other')), |
| | | 'im' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('instantmessenger'), 'subtypes' => array('aim','icq','msn','yahoo','jabber','skype','other')), |
| | | 'street' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('street'), 'category' => 'main'), |
| | | 'locality' => array('type' => 'text', 'size' => 28, 'label' => rcube_label('locality'), 'category' => 'main'), |
| | | 'zipcode' => array('type' => 'text', 'size' => 8, 'label' => rcube_label('zipcode'), 'category' => 'main'), |
| | | 'region' => array('type' => 'text', 'size' => 12, 'label' => rcube_label('region'), 'category' => 'main'), |
| | | 'country' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('country'), 'category' => 'main'), |
| | | ), 'category' => 'main'), |
| | | 'birthday' => array('type' => 'date', 'size' => 12, 'label' => rcube_label('birthday'), 'limit' => 1, 'render_func' => 'rcmail_format_date_col', 'category' => 'personal'), |
| | | 'anniversary' => array('type' => 'date', 'size' => 12, 'label' => rcube_label('anniversary'), 'limit' => 1, 'render_func' => 'rcmail_format_date_col', 'category' => 'personal'), |
| | | 'website' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('website'), 'subtypes' => array('homepage','work','blog','other'), 'category' => 'main'), |
| | | 'im' => array('type' => 'text', 'size' => 40, 'label' => rcube_label('instantmessenger'), 'subtypes' => array('aim','icq','msn','yahoo','jabber','skype','other'), 'category' => 'main'), |
| | | 'notes' => array('type' => 'textarea', 'size' => 40, 'rows' => 15, 'label' => rcube_label('notes'), 'limit' => 1), |
| | | 'photo' => array('type' => 'image', 'limit' => 1), |
| | | 'assistant' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('assistant')), |
| | | 'manager' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('manager')), |
| | | 'spouse' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('spouse')), |
| | | 'photo' => array('type' => 'image', 'limit' => 1, 'category' => 'main'), |
| | | 'assistant' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('assistant'), 'category' => 'personal'), |
| | | 'manager' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('manager'), 'category' => 'personal'), |
| | | 'spouse' => array('type' => 'text', 'size' => 40, 'limit' => 1, 'label' => rcube_label('spouse'), 'category' => 'personal'), |
| | | // TODO: define fields for vcards like GEO, KEY |
| | | ); |
| | | |
| | |
| | | |
| | | // get default coltypes |
| | | $coltypes = $GLOBALS['CONTACT_COLTYPES']; |
| | | $coltype_lables = array(); |
| | | $coltype_labels = array(); |
| | | |
| | | foreach ($coltypes as $col => $prop) { |
| | | if ($prop['subtypes']) { |
| | |
| | | } |
| | | if ($prop['childs']) { |
| | | foreach ($prop['childs'] as $childcol => $cp) |
| | | $coltype_lables[$childcol] = array('label' => $cp['label']); |
| | | $coltype_labels[$childcol] = array('label' => $cp['label']); |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | |
| | | if ($edit_mode) { |
| | | $RCMAIL->output->set_env('coltypes', $coltypes + $coltype_lables); |
| | | $RCMAIL->output->set_env('coltypes', $coltypes + $coltype_labels); |
| | | $RCMAIL->output->set_env('delbutton', $del_button); |
| | | $RCMAIL->output->add_label('delete'); |
| | | } |
| | |
| | | | | |
| | | | This file is part of the Roundcube Webmail client | |
| | | | Copyright (C) 2005-2011, The Roundcube Dev Team | |
| | | | Copyright (C) 2011, Kolab Systems AG | |
| | | | Licensed under the GNU GPL | |
| | | | | |
| | | | PURPOSE: | |
| | | | Search step for address book contacts | |
| | | | Search action (and form) for address book contacts | |
| | | | | |
| | | +-----------------------------------------------------------------------+ |
| | | | Author: Thomas Bruederli <roundcube@gmail.com> | |
| | | | Author: Aleksander Machniak <machniak@kolabsys.com> | |
| | | +-----------------------------------------------------------------------+ |
| | | |
| | | $Id: search.inc 456 2007-01-10 12:34:33Z thomasb $ |
| | | |
| | | */ |
| | | |
| | | $CONTACTS->set_page(1); |
| | | $_SESSION['page'] = 1; |
| | | if (!isset($_GET['_form'])) { |
| | | rcmail_contact_search(); |
| | | } |
| | | |
| | | // get input |
| | | $OUTPUT->add_handler('searchform', 'rcmail_contact_search_form'); |
| | | $OUTPUT->send('contactsearch'); |
| | | |
| | | |
| | | function rcmail_contact_search() |
| | | { |
| | | global $RCMAIL, $OUTPUT, $CONTACTS, $CONTACT_COLTYPES, $SEARCH_MODS_DEFAULT; |
| | | |
| | | $adv = isset($_POST['_adv']); |
| | | |
| | | // get fields/values from advanced search form |
| | | if ($adv) { |
| | | foreach ($CONTACT_COLTYPES as $col => $colprop) { |
| | | $s = trim(get_input_value('_'.$col, RCUBE_INPUT_POST, true)); |
| | | if (strlen($s)) { |
| | | $search[] = $s; |
| | | $fields[] = $col; |
| | | } |
| | | } |
| | | |
| | | if (empty($fields)) { |
| | | // do nothing, show the form again |
| | | return; |
| | | } |
| | | } |
| | | // quick-search |
| | | else { |
| | | $search = trim(get_input_value('_q', RCUBE_INPUT_GET, true)); |
| | | $fields = explode(',', get_input_value('_headers', RCUBE_INPUT_GET)); |
| | | |
| | |
| | | $fields = $SEARCH_MODS_DEFAULT; |
| | | } |
| | | |
| | | $search_request = md5('addr'.$search.implode($fields, ',')); |
| | | |
| | | // update search_mods setting |
| | | $old_mods = $RCMAIL->config->get('addressbook_search_mods'); |
| | | $search_mods = array_fill_keys($fields, 1); |
| | | if ($old_mods != $search_mods) { |
| | | $RCMAIL->user->save_prefs(array('addressbook_search_mods' => $search_mods)); |
| | | } |
| | | |
| | | if ($fields['all'] || count($fields) == count($SEARCH_MODS_DEFAULT)) { |
| | | if ($fields['*'] || count($fields) == count($SEARCH_MODS_DEFAULT)) { |
| | | $fields = '*'; |
| | | } |
| | | } |
| | | |
| | | // search request ID |
| | | $search_request = md5('addr'.implode($fields, ',') |
| | | .(is_array($search) ? implode($search, ',') : $search)); |
| | | |
| | | // reset page |
| | | $CONTACTS->set_page(1); |
| | | $_SESSION['page'] = 1; |
| | | |
| | | // get contacts for this user |
| | | $result = $CONTACTS->search($fields, $search); |
| | | |
| | | // save search settings in session |
| | | $_SESSION['search'][$search_request] = $CONTACTS->get_search_set(); |
| | | |
| | | if ($adv) |
| | | $OUTPUT->command('list_contacts_clear'); |
| | | |
| | | if ($result->count > 0) { |
| | | // create javascript list |
| | |
| | | } |
| | | |
| | | // update message count display |
| | | $OUTPUT->set_env('search_request', $search_request); |
| | | $OUTPUT->set_env('pagecount', ceil($result->count / $CONTACTS->page_size)); |
| | | $OUTPUT->command('set_env', 'search_request', $search_request); |
| | | $OUTPUT->command('set_env', 'pagecount', ceil($result->count / $CONTACTS->page_size)); |
| | | $OUTPUT->command('set_rowcount', rcmail_get_rowcount_text()); |
| | | |
| | | // send response |
| | | $OUTPUT->send(); |
| | | $OUTPUT->send($adv ? 'iframe' : null); |
| | | } |
| | | |
| | | function rcmail_contact_search_form($attrib) |
| | | { |
| | | global $RCMAIL, $CONTACTS, $CONTACT_COLTYPES; |
| | | |
| | | $i_size = !empty($attrib['size']) ? $attrib['size'] : 30; |
| | | |
| | | $form = array( |
| | | 'main' => array( |
| | | 'name' => rcube_label('contactproperties'), |
| | | 'content' => array( |
| | | ), |
| | | ), |
| | | 'personal' => array( |
| | | 'name' => rcube_label('personalinfo'), |
| | | 'content' => array( |
| | | ), |
| | | ), |
| | | 'other' => array( |
| | | 'name' => rcube_label('other'), |
| | | 'content' => array( |
| | | ), |
| | | ), |
| | | ); |
| | | |
| | | foreach ($CONTACT_COLTYPES as $col => $colprop) |
| | | { |
| | | if ($colprop['type'] != 'image' && !$colprop['nosearch']) |
| | | { |
| | | $ftype = $colprop['type'] == 'select' ? 'select' : 'text'; |
| | | $label = isset($colprop['label']) ? $colprop['label'] : rcube_label($col); |
| | | $category = $colprop['category'] ? $colprop['category'] : 'other'; |
| | | |
| | | if ($ftype == 'text') |
| | | $colprop['size'] = $i_size; |
| | | |
| | | $content = html::div('row', html::div('contactfieldlabel label', Q($label)) |
| | | . html::div('contactfieldcontent', rcmail_get_edit_field($col, '', $colprop, $ftype))); |
| | | |
| | | $form[$category]['content'][] = $content; |
| | | } |
| | | } |
| | | |
| | | $hiddenfields = new html_hiddenfield(array( |
| | | 'name' => '_source', 'value' => get_input_value('_source', RCUBE_INPUT_GPC))); |
| | | $hiddenfields->add(array('name' => '_gid', 'value' => $CONTACTS->group_id)); |
| | | $hiddenfields->add(array('name' => '_adv', 'value' => 1)); |
| | | |
| | | $out = $RCMAIL->output->request_form(array( |
| | | 'name' => 'form', 'method' => 'post', |
| | | 'task' => $RCMAIL->task, 'action' => 'search', |
| | | 'noclose' => true) + $attrib, $hiddenfields->show()); |
| | | |
| | | $RCMAIL->output->add_gui_object('editform', $attrib['id']); |
| | | |
| | | unset($attrib['name']); |
| | | unset($attrib['id']); |
| | | |
| | | foreach ($form as $f) { |
| | | if (!empty($f['content'])) { |
| | | $content = html::div('contactfieldgroup', join("\n", $f['content'])); |
| | | |
| | | $out .= html::tag('fieldset', $attrib, |
| | | html::tag('legend', null, Q($f['name'])) |
| | | . $content) . "\n"; |
| | | } |
| | | } |
| | | |
| | | return $out . '</form>'; |
| | | } |
| | |
| | | background-position: -162px 0; |
| | | } |
| | | |
| | | #abooktoolbar a.search { |
| | | background-position: -170px 0; |
| | | } |
| | | |
| | | #abooktoolbar a.searchSel { |
| | | background-position: -170px -32px; |
| | | } |
| | | |
| | | #abookcountbar |
| | | { |
| | | margin-top: 4px; |
| | |
| | | border: none; |
| | | } |
| | | |
| | | #contact-details table td.title |
| | | { |
| | | font-weight: bold; |
| | | text-align: right; |
| | | } |
| | | |
| | | #contacttabs |
| | | { |
| | | position: relative; |
| | |
| | | position: absolute; |
| | | top: 0; |
| | | left: 2px; |
| | | width: 90px; |
| | | width: 110px; |
| | | white-space: nowrap; |
| | | overflow: hidden; |
| | | text-overflow: ellipsis; |
| | |
| | | |
| | | .contactfieldgroup .contactfieldcontent |
| | | { |
| | | padding-left: 100px; |
| | | padding-left: 120px; |
| | | min-height: 1em; |
| | | line-height: 1.3em; |
| | | } |
| | |
| | | <span class="separator"> </span> |
| | | <roundcube:button command="import" type="link" class="buttonPas import" classAct="button import" classSel="button importSel" title="importcontacts" content=" " /> |
| | | <roundcube:button command="export" type="link" class="buttonPas export" classAct="button export" classSel="button exportSel" title="exportvcards" content=" " /> |
| | | <roundcube:button command="advanced-search" type="link" class="buttonPas search" classAct="button search" classSel="button searchSel" title="advsearch" content=" " /> |
| | | <roundcube:container name="toolbar" id="abooktoolbar" /> |
| | | </div> |
| | | |
| | |
| | | <li><input type="checkbox" name="s_mods[]" value="surname" id="s_mod_surname" onclick="rcmail_ui.set_searchmod(this)" /><label for="s_mod_surname"><roundcube:label name="surname" /></label></li> |
| | | <li><input type="checkbox" name="s_mods[]" value="email" id="s_mod_email" onclick="rcmail_ui.set_searchmod(this)" /><label for="s_mod_email"><roundcube:label name="email" /></label></li> |
| | | <li><input type="checkbox" name="s_mods[]" value="*" id="s_mod_all" onclick="rcmail_ui.set_searchmod(this)" /><label for="s_mod_all"><roundcube:label name="allfields" /></label></li> |
| | | <!-- |
| | | <li class="separator_below"> |
| | | <li><roundcube:button command="advsearch" type="link" label="advsearch" style="padding-left: 0" classAct="active" /></li> |
| | | --> |
| | | </ul> |
| | | </div> |
| | | |
| | |
| | | </div> |
| | | <roundcube:object name="contactedithead" id="contacthead" size="16" form="editform" /> |
| | | <div style="clear:both"></div> |
| | | |
| | | <div id="contacttabs"> |
| | | <roundcube:object name="contacteditform" size="40" textareacols="60" deleteIcon="/images/icons/delete.png" form="editform" /> |
| | | </div> |
New file |
| | |
| | | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| | | <html xmlns="http://www.w3.org/1999/xhtml"> |
| | | <head> |
| | | <title><roundcube:object name="pagetitle" /></title> |
| | | <roundcube:include file="/includes/links.html" /> |
| | | <script type="text/javascript" src="/functions.js"></script> |
| | | </head> |
| | | <body class="iframe"> |
| | | |
| | | <div id="contact-title" class="boxtitle"><roundcube:label name="advsearch" /></div> |
| | | <div id="contact-details" class="boxcontent"> |
| | | <roundcube:object name="searchform" id="advsearchform" size=30 /> |
| | | <p><roundcube:button command="save" type="input" class="button mainaction" label="search" /></p> |
| | | </div> |
| | | <script type="text/javascript">rcube_init_tabs('advsearchform')</script> |
| | | |
| | | </body> |
| | | </html> |