/**
* @param string $sWhere
* @param bool $bIgnoreHideInGab = false
* @param int $iSharedTenantId = null
* @return string
*/
protected function getContactByWhere($sWhere, $bIgnoreHideInGab = false, $iSharedTenantId = null)
{
$aMap = api_AContainer::DbReadKeys(CContact::GetStaticMap());
$aMap = array_map(array($this, 'escapeColumn'), $aMap);
$sShared = is_int($iSharedTenantId) ? 'AND shared_to_all = 1' : 'AND shared_to_all = 0';
$sHideInGab = $bIgnoreHideInGab ? '' : ' AND hide_in_gab = 0';
$sSql = 'SELECT %s FROM %sawm_addr_book WHERE deleted = 0 AND auto_create = 0 ' . $sShared . $sHideInGab . ' AND %s';
return sprintf($sSql, implode(', ', $aMap), $this->Prefix(), $sWhere);
}
/**
* @param int|null $iIdUser
* @param string $sWhere
* @param bool $bIgnoreHideInGab = false
* @param int $iSharedTenantId = null
* @return string
*/
protected function getContactByWhere($iIdUser, $sWhere, $bIgnoreHideInGab = false, $iSharedTenantId = null)
{
$aMap = api_AContainer::DbReadKeys(CContact::GetStaticMap());
$aMap = array_map(array($this, 'escapeColumn'), $aMap);
$sHideInGab = $bIgnoreHideInGab ? '' : ' AND hide_in_gab = 0';
$sUserWhere = $this->sharedItemsSqlHelper($iIdUser, 999, is_int($iSharedTenantId));
/// 999 - hack
$sSql = 'SELECT %s FROM %sawm_addr_book WHERE deleted = 0 AND auto_create = 0 ' . ($sUserWhere ? ' AND ' . $sUserWhere : '') . $sHideInGab . ' AND %s';
return sprintf($sSql, implode(', ', $aMap), $this->Prefix(), $sWhere);
}
