codepad
[
create a new paste
]
login
|
about
Language:
C
C++
D
Haskell
Lua
OCaml
PHP
Perl
Plain Text
Python
Ruby
Scheme
Tcl
<?php /** * Example backend class for a custom address book * * This one just holds a static list of address records * * @author Thomas Bruederli */ class example_addressbook_backend extends rcube_addressbook { public $primary_key = 'ID'; public $readonly = true; public $groups = false; public $lista = array(); private $filter; private $result; private $name; public $coltypes = array('name', 'firstname', 'surname', 'middlename', 'prefix', 'suffix', 'nickname', 'jobtitle', 'organization', 'department', 'assistant', 'manager', 'gender', 'maidenname', 'spouse', 'email', 'email:item', 'phone', 'address', 'birthday', 'anniversary', 'website', 'im', 'notes', 'photo', 'words'); public function __construct($name) { $this->ready = true; $this->name = $name; } public function get_name() { return $this->name; } public function set_search_set($filter) { $this->filter = $filter; } public function get_search_set() { return $this->filter; } public function reset() { $this->result = null; $this->filter = null; } function list_groups($search = null) { return array( ); } public function list_records($cols=null, $subset=0, $busca="") { // this is just for tests purposes $con = mysql_connect('localhost', 'login', 'pass') or die('Error'); mysql_selectdb('roundcube', $con) or die('Error on select'); $lista = mysql_query("SELECT * FROM custom_contact_table ".$busca." ORDER BY nome", $con); // $lista is the resource from datatabase $this->result = $this->count(); while ($contato = mysql_fetch_assoc($lista)) { $this->result->add( array( 'ID' => $contato['id'], 'name' => $contato['nome'], 'firstname' => current(explode(" ",$contato['nome'])), 'surname' => (isset($contato['vinculo']) && $contato['vinculo'] != "")?" (".$contato['vinculo'].")":"", 'department' => array($contato['lotacao']), 'email' => $contato['email'], 'user_id' => $contato['id'], ) ); } $cnt = count($this->result->records); $this->result->count = $cnt; $this->result->searchonly = true; return $this->result; } public function search($fields, $value, $strict=false, $select=true, $nocount=false, $required=array()) { $values = is_array($value)? implode("|", $value) : $value; $where = "WHERE nome REGEXP '" . $values ."' OR email REGEXP '" . $values ."' OR descricao REGEXP '" . $values ."' AND email IS NOT NULL"; return $this->list_records($fields, 0, $where); //return $this->result; } public function count() { return new rcube_result_set(1, ($this->list_page-1) * $this->page_size); } public function get_result() { return $this->result; } public function get_record($id, $assoc=false) { $this->list_records(); while($record = $this->result->iterate()){ if($record['ID'] == $id){ $contact = $record; break; }else{ $contact = null; } } if(isset($contact)){ $this->result = $this->count(); $this->result->add($contact); $this->result->next(); } return $contact; } function create_group($name) { $result = false; return $result; } function delete_group($gid) { return false; } function rename_group($gid, $newname) { return $newname; } function add_to_group($group_id, $ids) { return false; } function remove_from_group($group_id, $ids) { return false; } }
Private
[
?
]
Run code
Submit