public function post($request)
{
// to Receive POST Params (use $this->params)
parent::post($request);
if ($this->isLoggedIn()) {
$contact = array();
$contactID = $this->getParam('contactID');
// User Contact
if ($this->getParam('contactType') == 1 && $contactID != null) {
$query = 'select A.id_contact, A.photo from phpgw_cc_contact A where A.id_contact=' . $contactID . ' and A.id_owner=' . $this->getUserId();
if (!$this->getDb()->query($query)) {
return false;
}
if ($this->getDb()->next_record()) {
$row = $this->getDb()->row();
if ($row['photo'] != null) {
$contact[] = array('contactID' => $row['id_contact'], 'contactImagePicture' => $row['photo'] != null ? base64_encode($row['photo']) : "");
}
}
} elseif ($this->getParam('contactType') == 2) {
if (!$contactID) {
$contactID = $GLOBALS['phpgw_info']['user']['account_dn'];
}
$photo = $this->getUserLdapPhoto(urldecode($contactID));
$contact[] = array('contactID' => $contactID, 'contactImagePicture' => $photo != null ? base64_encode($photo[0]) : "");
}
$result = array('contacts' => $contact);
$this->setResult($result);
}
//to Send Response (JSON RPC format)
return $this->getResponse();
}
public function post($request)
{
// to Receive POST Params (use $this->params)
parent::post($request);
if ($this->isLoggedIn()) {
if ($this->getParams()) {
$search = trim($this->getParam('search'));
$search = $search ? mb_convert_encoding($search, "ISO_8859-1", "UTF8") : "";
if ($this->getParam('contactType') == 1) {
if ($search != "") {
$query_contact = "(A.alias ilike '%{$search}%' or A.names_ordered ilike '%{$search}%' or C.connection_value ilike '%{$search}%') and";
} elseif ($this->getParam('contactID') > 0) {
$query_contact = 'A.id_contact=' . $this->getParam('contactID') . ' and';
}
} elseif ($this->getParam('contactType') == 2) {
if ($this->getMinArgumentSearch() <= strlen($search)) {
return $this->getGlobalContacts($search, $this->getParam('contactID'));
} else {
Errors::runException("CATALOG_MIN_ARGUMENT_SEARCH", $this->getMinArgumentSearch());
}
}
}
$query = 'select B.id_typeof_contact_connection, A.photo, A.id_contact, A.alias, A.given_names, A.family_names, A.names_ordered, A.birthdate, A.notes, C.connection_value from phpgw_cc_contact A, ' . 'phpgw_cc_contact_conns B, phpgw_cc_connections C where A.id_contact = B.id_contact and B.id_connection = C.id_connection ' . ' and ' . $query_contact . ' A.id_owner=' . $this->getUserId() . ' group by ' . ' B.id_typeof_contact_connection, A.photo, A.id_contact, A.alias, A.given_names, A.family_names,A.names_ordered,A.birthdate, A.notes,C.connection_value order by lower(A.names_ordered)';
if (!$this->getDb()->query($query)) {
return false;
}
$contacts = array();
while ($this->getDb()->next_record()) {
$row = $this->getDb()->row();
$id = $row['id_contact'];
$contactType = $row['id_typeof_contact_connection'] == 2 ? 'contactPhones' : 'contactMails';
if ($contacts[$id] != null) {
$contacts[$id][$contactType][] = $row['connection_value'];
} else {
$contacts[$id] = array('contactID' => $row['id_contact'], $contactType => array($row['connection_value']), 'contactAlias' => $row['alias'] != null ? mb_convert_encoding($row['alias'], "UTF8", "ISO_8859-1") : "", 'contactFirstName' => $row['given_names'] != null ? mb_convert_encoding($row['given_names'], "UTF8", "ISO_8859-1") : "", 'contactLastName' => $row['family_names'] != null ? mb_convert_encoding($row['family_names'], "UTF8", "ISO_8859-1") : "", 'contactFullName' => $row['names_ordered'] != null ? mb_convert_encoding($row['names_ordered'], "UTF8", "ISO_8859-1") : "", 'contactBirthDate' => $row['birthdate'] != null ? $row['birthdate'] : "", 'contactNotes' => $row['notes'] != null ? mb_convert_encoding($row['notes'], "UTF8", "ISO_8859-1") : "", 'contactHasImagePicture' => $row['photo'] != null ? 1 : 0);
}
}
$result = array('contacts' => array_values($contacts));
$this->setResult($result);
}
//to Send Response (JSON RPC format)
return $this->getResponse();
}
