/** * @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); }