/**
* @param string $login
* @param waAuth $auth
* @return waContact|bool
*/
protected function findContact($login, $auth)
{
$contact_model = new waContactModel();
$is_user = $auth->getOption('is_user');
if (strpos($login, '@')) {
$sql = "SELECT c.* FROM wa_contact c\n JOIN wa_contact_emails e ON c.id = e.contact_id\n WHERE " . ($is_user ? "c.is_user = 1 AND " : "") . "e.email LIKE s:email AND e.sort = 0\n ORDER BY c.id LIMIT 1";
$contact_info = $contact_model->query($sql, array('email' => $login))->fetch();
} else {
$contact_info = $contact_model->getByField('login', $login);
}
if ($contact_info && (!$is_user || $contact_info['is_user'])) {
$contact = new waContact($contact_info['id']);
$contact->setCache($contact_info);
return $contact;
}
return false;
}
public function execute()
{
$this->prepare();
if ($query = trim(waRequest::post('query'), '/')) {
if (strpos($query, '/') === false) {
$h = $hash = 'search/' . $query;
} else {
$h = $hash = $query;
if (substr($hash, 0, 14) == 'import/results') {
$h = str_replace('import/results', 'import', $hash);
}
}
} else {
$h = $hash = '';
}
$h_parts = explode('/', $h, 2);
$add_fields = array();
if ($h_parts[0] == 'explore') {
$collection = new contactsCollection();
$event_params = array('collection' => $collection, 'hash' => $h_parts[1]);
$result = wa()->event('explore', $event_params);
if ($result) {
$result = reset($result);
$add_fields = ifset($result['fields']);
$this->response['add_fields'] = $add_fields;
$this->response['name'] = $result['name'];
}
} else {
$collection = new contactsCollection($h);
}
$this->response['fields'] = array();
$fields = '*,photo_url_32,photo_url_96';
if ($h_parts[0] === 'users') {
$fields .= ',_access';
$this->response['fields']['_access'] = array('id' => '_access', 'name' => _w('Access'), 'type' => 'Access', 'vertical' => true);
}
$collection->orderBy($this->sort, $this->order);
$this->response['count'] = $collection->count();
$view = waRequest::post('view');
if ($view == 'list') {
// Preload info to cache to avoid excess DB access
$cm = new waCountryModel();
$cm->preload();
}
$this->response['contacts'] = array_values($collection->getContacts($fields, $this->offset, $this->limit));
$this->workupContacts($this->response['contacts']);
$this->response['total_count'] = $collection->count();
foreach ($this->response['contacts'] as $i => &$c) {
$c['offset'] = $this->offset + $i;
}
unset($c);
if ($view == 'list') {
// Need to format field values correctly for this view.
foreach ($this->response['contacts'] as &$cdata) {
$c = new waContact($cdata['id']);
$c->setCache($cdata);
$data = $c->load('list,js') + $cdata;
contactsHelper::normalzieContactFieldValues($data, waContactFields::getInfo($c['is_company'] ? 'company' : 'person', true));
if (isset($data['photo'])) {
$data['photo'] = $c->getPhoto();
}
$c->removeCache(array_keys($cdata));
$cdata = $data;
}
$this->response['fields'] = array_merge($this->response['fields'], contactsHelper::getFieldsDescription(array('title', 'name', 'photo', 'firstname', 'middlename', 'lastname', 'locale', 'timezone', 'jobtitle', 'company', 'sex', 'company_contact_id'), true));
unset($cdata);
}
// for companies set name to company name
// for contacts with empty name, set it to <no name>
foreach ($this->response['contacts'] as &$c) {
if (isset($c['name']) && trim($c['name'])) {
continue;
}
if (isset($c['company']) && trim($c['company'])) {
$c['name'] = $c['company'];
unset($c['company']);
continue;
}
$c['name'] = '<' . _w('no name') . '>';
}
unset($c);
$title = $collection->getTitle();
$hm = new contactsHistoryModel();
if ($hash) {
$type = explode('/', $hash);
$hash = substr($hash, 0, 1) == '/' ? $hash : '/contacts/' . $hash;
$type = $type[0];
// if search query looks like a quick search then remove field name from header
if ($type == 'search' && preg_match('~^/contacts/search/(name\\*=[^/]*|email\\*=[^/]*@[^/]*)/?$~i', $hash)) {
$title = preg_replace("~^[^=]+=~", '', $title);
}
// save history
if ($type == 'search') {
$hm->save($hash, $title, $type, $this->response['count']);
$this->logAction('search');
}
// Information about system category in categories view
if (substr($hash, 0, 19) === '/contacts/category/') {
$category_id = (int) substr($hash, 19);
$cm = new waContactCategoryModel();
$category = $cm->getById($category_id);
if ($category && $category['system_id']) {
$this->response['system_category'] = $category['system_id'];
}
}
}
// Update history in user's browser
$this->response['history'] = $hm->get();
$this->response['title'] = $title;
}
public function execute()
{
$this->prepare();
if ($query = trim(waRequest::post('query'), '/')) {
if (strpos($query, '/') === false) {
$h = $hash = 'search/' . $query;
} else {
$h = $hash = $query;
if (substr($hash, 0, 14) == 'import/results') {
$h = str_replace('import/results', 'import', $hash);
}
}
} else {
$h = $hash = '';
}
$collection = $this->getCollection($h);
$collection->orderBy($this->sort, $this->order);
$this->response['count'] = $collection->count();
$view = waRequest::post('view');
switch ($view) {
case 'list':
$fields = '*';
break;
case 'thumbs':
$fields = 'id,name,photo';
break;
case 'table':
default:
$fields = waRequest::post('fields');
}
if ($view == 'list') {
// Preload info to cache to avoid excess DB access
$cm = new waCountryModel();
$cm->preload();
}
if ($hash && $fields != '*') {
if ($wf = $collection->getWhereFields()) {
$fields = $fields . "," . implode(",", $wf);
}
$this->response['fields'] = explode(',', $fields);
}
$this->response['contacts'] = array_values($collection->getContacts($fields, $this->offset, $this->limit));
if ($view == 'list') {
// Need to format field values correctly for this view.
foreach ($this->response['contacts'] as &$cdata) {
$c = new waContact($cdata['id']);
$c->setCache($cdata);
$data = $c->load('list,js') + $cdata;
if (isset($data['photo'])) {
$data['photo'] = $c->getPhoto();
}
$c->removeCache(array_keys($cdata));
$cdata = $data;
}
unset($cdata);
}
// for companies set name to company name
// for contacts with empty name, set it to <no name>
foreach ($this->response['contacts'] as &$c) {
if (isset($c['name']) && trim($c['name'])) {
continue;
}
if (isset($c['company']) && trim($c['company'])) {
$c['name'] = $c['company'];
unset($c['company']);
continue;
}
$c['name'] = '<' . _w('no name') . '>';
}
unset($c);
$title = $collection->getTitle();
if ($hash) {
$type = explode('/', $hash);
$hash = substr($hash, 0, 1) == '/' ? $hash : '/contacts/' . $hash;
$type = $type[0];
// if search query looks like a quick search then remove field name from header
if ($type == 'search' && preg_match('~^/contacts/search/(name\\*=[^/]*|email\\*=[^/]*@[^/]*)/?$~i', $hash)) {
$title = preg_replace("~^[^=]+=~", '', $title);
}
// save history
if ($type == 'search' || $type == 'import') {
$history = new contactsHistoryModel();
if ($history->save($hash, $title, $type, $this->response['count'])) {
// new search performed, save to statistics log
$this->log('search', 1);
}
}
// Information about system category in categories view
if (substr($hash, 0, 19) === '/contacts/category/') {
$category_id = (int) substr($hash, 19);
$cm = new waContactCategoryModel();
$category = $cm->getById($category_id);
if ($category && $category['system_id']) {
$this->response['system_category'] = $category['system_id'];
}
}
}
// Update history in user's browser
$historyModel = new contactsHistoryModel();
$this->response['history'] = $historyModel->get();
$this->response['title'] = $title;
}