/**
* Get the homepagevisibilities
*
* @return array
*/
function getHomepageVisibilities()
{
$visibilities = get_local_visibility_by_id($this->current_user->user_id, 'homepage');
if (is_array(json_decode($visibilities, true))) {
return json_decode($visibilities, true);
}
return array();
}
/**
*
**/
public function routes(&$router)
{
//
$router->get('/user(/:user_id)', function ($user_id) use($router) {
$user_id = $user_id ?: $GLOBALS['user']->id;
$user = User::find($user_id);
if (!$user) {
$router->halt(404, sprintf('User %s not found', $user_id));
return;
}
$visibilities = get_local_visibility_by_id($user_id, 'homepage');
if (is_array(json_decode($visibilities, true))) {
$visibilities = json_decode($visibilities, true);
} else {
$visibilities = array();
}
$get_field = function ($field, $visibility) use($user_id, $user, $visibilities) {
if (!$user[$field] || !is_element_visible_for_user($GLOBALS['user']->id, $user_id, $visibilities[$visibility])) {
return '';
}
return $user[$field];
};
$avatar = function ($size) use($user_id, $visibilities) {
static $avatar;
if (!$avatar) {
$avatar_id = is_element_visible_for_user($GLOBALS['user']->id, $user_id, $visibilities['picture']) ? $user_id : 'nobody';
$avatar = Avatar::getAvatar($avatar_id);
}
return $avatar->getURL($size);
};
$user = array('user_id' => $user_id, 'username' => $user['username'], 'perms' => $user['perms'], 'title_pre' => $user['title_front'], 'forename' => $user['Vorname'], 'lastname' => $user['Nachname'], 'title_post' => $user['title_rear'], 'email' => get_visible_email($user_id), 'avatar_small' => $avatar(Avatar::SMALL), 'avatar_medium' => $avatar(Avatar::MEDIUM), 'avatar_normal' => $avatar(Avatar::NORMAL), 'phone' => $get_field('privatnr', 'private_phone'), 'homepage' => $get_field('Home', 'homepage'), 'privadr' => $get_field('privadr', 'privadr'));
$query = "SELECT value\n FROM user_config\n WHERE field = ? AND user_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array('SKYPE_NAME', $user_id));
$user['skype'] = $statement->fetchColumn() ?: '';
$statement->closeCursor();
if ($user['skype']) {
$statement->execute(array('SKYPE_ONLINE_STATUS', $user_id));
$user['skype_show'] = (bool) $statement->fetchColumn();
} else {
$user['skype_show'] = false;
}
$router->render(compact('user'));
});
// Deletes a user
$router->delete('/user/:user_id', function ($user_id) use($router) {
$user = new \UserManagement($user_id . '.');
if (empty($user->user_data['auth_user_md5.user_id'])) {
$router->halt(404, sprintf('User id "%s" not found', $user_id));
die;
}
$router->halt($user->deleteUser() ? 200 : 500);
});
}
/**
* Export of a single user
*
* @param User $user Userobject
* @return String vCard export string
*/
private static function exportUser(User $user)
{
// If user is not visible export nothing
if (!get_visibility_by_id($user->id)) {
return "";
}
// vCard exportheader
$vCard['BEGIN'] = 'VCARD';
$vCard['VERSION'] = '3.0';
$vCard['PRODID'] = 'Stud.IP//' . $GLOBALS['UNI_NAME_CLEAN'] . '//DE';
$vCard['REV'] = date('Y-m-d H:i:s');
$vCard['TZ'] = date('O');
// User specific data
//Fullname
$vCard['FN'] = studip_utf8encode($user->getFullname());
//Name
$vCard['N'][] = studip_utf8encode($user->Nachname);
$vCard['N'][] = studip_utf8encode($user->Vorname);
$vCard['N'][] = studip_utf8encode($user->info->title_rear);
$vCard['N'][] = studip_utf8encode($user->info->title_front);
// Adress
if (Visibility::verify('privadr', $user->id)) {
$vCard['ADR;TYPE=HOME'] = studip_utf8encode($user->info->privadr);
}
// Tel
if (Visibility::verify('private_phone', $user->id)) {
$vCard['TEL;TYPE=HOME'] = studip_utf8encode($user->info->privatnr);
}
if (Visibility::verify('private_cell', $user->id)) {
$vCard['TEL;TYPE=CELL'] = studip_utf8encode($user->info->privatcell);
}
// Email
if (get_local_visibility_by_id($user->id, 'email')) {
$vCard['EMAIL'] = studip_utf8encode($user->email);
}
// Photo
if (Visibility::verify('picture', $user->id)) {
// Fetch avatar
$avatar = Avatar::getAvatar($user->id);
// Only export if
if ($avatar->is_customized()) {
$vCard['PHOTO;JPEG;ENCODING=BASE64'] = base64_encode(file_get_contents($avatar->getFilename(Avatar::NORMAL)));
}
}
// vCard end
$vCard['END'] = 'VCARD';
// Produce string
foreach ($vCard as $index => $value) {
$exportString .= $value ? $index . ':' . (is_array($value) ? join(';', $value) : $value) . "\r\n" : "";
}
return $exportString;
}
/**
* getUser - retrieves data of a user
*
* @get /user/:user_id
* @get /user
*/
public function getUser($user_id = '')
{
$user_id = $user_id ?: $GLOBALS['user']->id;
$user = \User::find($user_id);
if (!$user) {
$this->halt(404, sprintf('User %s not found', $user_id));
}
$visibilities = get_local_visibility_by_id($user_id, 'homepage');
if (is_array(json_decode($visibilities, true))) {
$visibilities = json_decode($visibilities, true);
} else {
$visibilities = array();
}
$get_field = function ($field, $visibility) use($user_id, $user, $visibilities) {
if (!$user[$field] || !is_element_visible_for_user($GLOBALS['user']->id, $user_id, $visibilities[$visibility])) {
return '';
}
return $user[$field];
};
$avatar = \Avatar::getAvatar($user_id);
$user = array('user_id' => $user_id, 'username' => $user['username'], 'name' => self::getNamesOfUser($user), 'perms' => $user['perms'], 'email' => get_visible_email($user_id), 'avatar_small' => $avatar->getURL(\Avatar::SMALL), 'avatar_medium' => $avatar->getURL(\Avatar::MEDIUM), 'avatar_normal' => $avatar->getURL(\Avatar::NORMAL), 'avatar_original' => $avatar->getURL(\Avatar::ORIGINAL), 'phone' => $get_field('privatnr', 'private_phone'), 'homepage' => $get_field('Home', 'homepage'), 'privadr' => strip_tags($get_field('privadr', 'privadr')));
$query = "SELECT value\n FROM user_config\n WHERE field = ? AND user_id = ?";
$statement = \DBManager::get()->prepare($query);
$statement->execute(array('SKYPE_NAME', $user_id));
$user['skype'] = $statement->fetchColumn() ?: '';
$statement->closeCursor();
if ($user['skype']) {
$statement->execute(array('SKYPE_ONLINE_STATUS', $user_id));
$user['skype_show'] = (bool) $statement->fetchColumn();
} else {
$user['skype_show'] = false;
}
// Data fields
$datafields = array();
foreach (\DataFieldEntry::getDataFieldEntries($user_id, 'user') as $entry) {
if (!$entry->isVisible()) {
continue;
}
if (!\Visibility::verify($entry->getID(), $user_id)) {
continue;
}
$datafields[] = array('type' => $entry->getType(), 'id' => $entry->getId(), 'name' => $entry->getName(), 'value' => $entry->getValue());
}
$user['datafields'] = $datafields;
$this->etag(md5(serialize($user)));
return $user;
}
/**
* Displays the privacy settings of a user.
*/
public function index_action()
{
// Get visibility settings from database.
$this->global_visibility = get_global_visibility_by_id($this->user->user_id);
$this->online_visibility = get_local_visibility_by_id($this->user->user_id, 'online');
$this->search_visibility = get_local_visibility_by_id($this->user->user_id, 'search');
$this->email_visibility = get_local_visibility_by_id($this->user->user_id, 'email');
// Get default visibility for homepage elements.
$this->default_homepage_visibility = Visibility::get_default_homepage_visibility();
$this->NOT_HIDEABLE_FIELDS = $GLOBALS['NOT_HIDEABLE_FIELDS'];
$this->user_perm = $GLOBALS['perm']->get_perm($this->user->user_id);
$this->user_domains = UserDomain::getUserDomains();
// Calculate colWidth and colCount for different visibilities
$this->colCount = Visibility::getColCount();
$this->colWidth = 67 / $this->colCount;
$this->visibilities = Visibility::getVisibilities();
$this->homepage_elements = Visibility::getHTMLArgs();
}
/**
* Sets the visibility of a homepage element to the given value.
*
* @param string $user_id whose homepage is it?
* @param string $element_name unique name of the homepage element to change
* @param int $visibility new value for element visibility
* @return int Number of affected database rows.
*/
function set_homepage_element_visibility($user_id, $element_name, $visibility) {
$visibilities = get_local_visibility_by_id($user_id, 'homepage');
$visibilities = json_decode($visibilities, true);
$visibilities[$element_name] = $visibility;
$query = "UPDATE user_visibility SET homepage = ? WHERE user_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array(
json_encode($visibilities),
$user_id,
));
return $statement->rowCount();
}
/**
* Builds an array containing all available elements that are part of a
* user's homepage together with their visibility. It isn't sufficient to
* just load the visibility settings from database, because if the user
* has added some data (e.g. CV) but not yet assigned a special visibility
* to that field, it wouldn't show up.
*
* @return array An array containing all available homepage elements
* together with their visibility settings in the form
* $name => $visibility.
*/
public function get_homepage_elements()
{
global $NOT_HIDEABLE_FIELDS;
$query = "SELECT user_info.*, auth_user_md5.*\n FROM auth_user_md5\n LEFT JOIN user_info USING (user_id)\n WHERE user_id = ?";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($this->auth_user['user_id']));
$my_data = $statement->fetch(PDO::FETCH_ASSOC);
$homepage_visibility = get_local_visibility_by_id($this->auth_user['user_id'], 'homepage');
if (is_array(json_decode($homepage_visibility, true))) {
$homepage_visibility = json_decode($homepage_visibility, true);
} else {
$homepage_visibility = array();
}
// News
$news = StudipNews::GetNewsByRange($this->auth_user['user_id'], true);
// Non-private dates.
if (Config::get()->CALENDAR_ENABLE) {
$dates = CalendarEvent::countBySql('range_id = ?', array($this->auth_user['user_id']));
}
// Votes
if (Config::get()->VOTE_ENABLE) {
//$voteDB = new VoteDB();
$activeVotes = Questionnaire::countBySQL("user_id = ? AND visible = '1'", array($this->auth_user['user_id']));
$stoppedVotes = Questionnaire::countBySQL("user_id = ? AND visible = '0'", array($this->auth_user['user_id']));
}
// Evaluations
$evalDB = new EvaluationDB();
$activeEvals = $evalDB->getEvaluationIDs($this->auth_user['user_id'], EVAL_STATE_ACTIVE);
// Literature
$lit_list = StudipLitList::GetListsByRange($this->auth_user['user_id']);
// Free datafields
$data_fields = DataFieldEntry::getDataFieldEntries($this->auth_user['user_id'], 'user');
// Homepage plugins
//$homepageplugins = PluginEngine::getPlugins('HomepagePlugin');
// Deactivate plugin visibility settings because they aren't working now.
$homepageplugins = array();
$user_domains = count(UserDomain::getUserDomains());
// Now join all available elements with visibility settings.
$homepage_elements = array();
if (Avatar::getAvatar($this->auth_user['user_id'])->is_customized() && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['picture']) {
$homepage_elements["picture"] = array("name" => _("Eigenes Bild"), "visibility" => $homepage_visibility["picture"] ?: get_default_homepage_visibility($this->auth_user['user_id']), "extern" => true, 'category' => 'Allgemeine Daten');
}
if ($my_data["motto"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['motto']) {
$homepage_elements["motto"] = array("name" => _("Motto"), "visibility" => $homepage_visibility["motto"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Private Daten');
}
if (Config::get()->ENABLE_SKYPE_INFO) {
if ($GLOBALS['user']->cfg->getValue('SKYPE_NAME') && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['skype_name']) {
$homepage_elements["skype_name"] = array("name" => _("Skype Name"), "visibility" => $homepage_visibility["skype_name"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Private Daten');
if ($GLOBALS['user']->cfg->getValue('SKYPE_ONLINE_STATUS')) {
$homepage_elements["skype_online_status"] = array("name" => _("Skype Online Status"), "visibility" => $homepage_visibility["skype_online_status"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Private Daten');
}
}
}
if ($my_data["privatnr"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['Private Daten_phone']) {
$homepage_elements["private_phone"] = array("name" => _("Private Telefonnummer"), "visibility" => $homepage_visibility["private_phone"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Private Daten');
}
if ($my_data["privatcell"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['private_cell']) {
$homepage_elements["private_cell"] = array("name" => _("Private Handynummer"), "visibility" => $homepage_visibility["private_cell"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Private Daten');
}
if ($my_data["privadr"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['privadr']) {
$homepage_elements["privadr"] = array("name" => _("Private Adresse"), "visibility" => $homepage_visibility["privadr"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Private Daten');
}
if ($my_data["Home"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['homepage']) {
$homepage_elements["homepage"] = array("name" => _("Homepage-Adresse"), "visibility" => $homepage_visibility["homepage"] ?: get_default_homepage_visibility($this->auth_user['user_id']), "extern" => true, 'category' => 'Private Daten');
}
if ($news && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['news']) {
$homepage_elements["news"] = array("name" => _("Ankündigungen"), "visibility" => $homepage_visibility["news"] ?: get_default_homepage_visibility($this->auth_user['user_id']), "extern" => true, 'category' => 'Allgemeine Daten');
}
if (Config::get()->CALENDAR_ENABLE && $dates && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['dates']) {
$homepage_elements["termine"] = array("name" => _("Termine"), "visibility" => $homepage_visibility["termine"] ?: get_default_homepage_visibility($this->auth_user['user_id']), "extern" => true, 'category' => 'Allgemeine Daten');
}
if (Config::get()->VOTE_ENABLE && ($activeVotes || $stoppedVotes || $activeEvals) && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['votes']) {
$homepage_elements["votes"] = array("name" => _("Fragebögen"), "visibility" => $homepage_visibility["votes"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Allgemeine Daten');
}
$query = "SELECT 1\n FROM user_inst\n LEFT JOIN Institute USING (Institut_id)\n WHERE user_id = ? AND inst_perms = 'user'";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($this->auth_user['user_id']));
if ($statement->fetchColumn() && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['studying']) {
$homepage_elements["studying"] = array("name" => _("Wo ich studiere"), "visibility" => $homepage_visibility["studying"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Studien-/Einrichtungsdaten');
}
if ($lit_list && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['literature']) {
$homepage_elements["literature"] = array("name" => _("Literaturlisten"), "visibility" => $homepage_visibility["literature"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Allgemeine Daten');
}
if ($my_data["lebenslauf"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['lebenslauf']) {
$homepage_elements["lebenslauf"] = array("name" => _("Lebenslauf"), "visibility" => $homepage_visibility["lebenslauf"] ?: get_default_homepage_visibility($this->auth_user['user_id']), "extern" => true, 'category' => 'Private Daten');
}
if ($my_data["hobby"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['hobby']) {
$homepage_elements["hobby"] = array("name" => _("Hobbies"), "visibility" => $homepage_visibility["hobby"] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Private Daten');
}
if ($my_data["publi"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['publi']) {
$homepage_elements["publi"] = array("name" => _("Publikationen"), "visibility" => $homepage_visibility["publi"] ?: get_default_homepage_visibility($this->auth_user['user_id']), "extern" => true, 'category' => 'Private Daten');
}
if ($my_data["schwerp"] && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']]['schwerp']) {
$homepage_elements["schwerp"] = array("name" => _("Arbeitsschwerpunkte"), "visibility" => $homepage_visibility["schwerp"] ?: get_default_homepage_visibility($this->auth_user['user_id']), "extern" => true, 'category' => 'Private Daten');
}
if ($data_fields) {
foreach ($data_fields as $key => $field) {
if ($field->getValue() && $field->isEditable($this->auth_user['perms']) && !$NOT_HIDEABLE_FIELDS[$this->auth_user['perms']][$key]) {
$homepage_elements[$key] = array('name' => $field->getName(), 'visibility' => $homepage_visibility[$key] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'extern' => true, 'category' => 'Zusätzliche Datenfelder');
}
}
}
$query = "SELECT kategorie_id, name\n FROM kategorien\n WHERE range_id = ?\n ORDER BY priority";
$statement = DBManager::get()->prepare($query);
$statement->execute(array($this->auth_user['user_id']));
while ($category = $statement->fetch(PDO::FETCH_ASSOC)) {
$homepage_elements["kat_" . $category["kategorie_id"]] = array("name" => $category["name"], "visibility" => $homepage_visibility["kat_" . $category["kategorie_id"]] ?: get_default_homepage_visibility($this->auth_user['user_id']), "extern" => true, 'category' => 'Eigene Kategorien');
}
if ($homepageplugins) {
foreach ($homepageplugins as $plugin) {
$homepage_elements['plugin_' . $plugin->getPluginId()] = array("name" => $plugin->getPluginName(), "visibility" => $homepage_visibility["plugin_" . $plugin->getPluginId()] ?: get_default_homepage_visibility($this->auth_user['user_id']), 'category' => 'Plugins');
}
}
return $homepage_elements;
}
function getContent ($args = NULL, $raw = FALSE) {
if ($raw) {
$this->setRawOutput();
}
if (!$all_groups = get_all_statusgruppen($this->config->range_id)) {
die($GLOBALS["EXTERN_ERROR_MESSAGE"]);
} else {
$all_groups = array_keys($all_groups);
}
if (!$group_ids = $this->config->getValue('Main', 'groupsvisible')) {
die($GLOBALS["EXTERN_ERROR_MESSAGE"]);
} else {
$group_ids = array_intersect($all_groups, $group_ids);
}
if (!is_array($group_ids)) {
die($GLOBALS["EXTERN_ERROR_MESSAGE"]);
}
if (!$visible_groups = get_statusgruppen_by_id($this->config->range_id, $group_ids)) {
die($GLOBALS["EXTERN_ERROR_MESSAGE"]);
}
$sort = $this->config->getValue('Main', 'sort');
$query_order = '';
foreach ($sort as $key => $position) {
if ($position > 0) {
$query_order[$position] = $this->data_fields[$key];
}
}
if ($query_order) {
ksort($query_order, SORT_NUMERIC);
$query_order = ' ORDER BY ' . implode(',', $query_order);
}
$grouping = $this->config->getValue("Main", "grouping");
if (!$nameformat = $this->config->getValue('Main', 'nameformat')) {
$nameformat = 'full_rev';
}
if(!$grouping) {
$query = "SELECT DISTINCT ui.raum, ui.sprechzeiten, ui.Telefon, inst_perms, Email, aum.user_id, ";
$query .= 'username, aum.Vorname, title_front, title_rear, ';
$query .= $GLOBALS['_fullname_sql'][$nameformat] . " AS fullname, aum.Nachname ";
if ($query_order != '') {
$query .= "FROM statusgruppe_user LEFT JOIN auth_user_md5 aum USING(user_id) ";
$query .= "LEFT JOIN user_info USING(user_id) LEFT JOIN user_inst ui USING(user_id) ";
$query .= "WHERE statusgruppe_id IN (?) AND Institut_id = ? AND ".get_ext_vis_query()."$query_order";
} else {
$query .= "FROM statusgruppen s LEFT JOIN statusgruppe_user su USING(statusgruppe_id) ";
$query .= "LEFT JOIN auth_user_md5 aum USING(user_id) ";
$query .= "LEFT JOIN user_info USING(user_id) LEFT JOIN user_inst ui USING(user_id) ";
$query .= "WHERE su.statusgruppe_id IN (?) AND Institut_id = ? ";
$query .= "' AND ".get_ext_vis_query()." ORDER BY ";
$query .= "s.position ASC, su.position ASC";
}
$parameters = array($this->config->getValue('Main', 'groupsvisible'), $this->config->range_id);
$statement = DBManager::get()->prepare($query);
$statement->execute($parameters);
$row = $statement->fetch(PDO::FETCH_ASSOC);
$visible_groups = array('');
}
// generic data fields
$generic_datafields = $this->config->getValue('TemplateGeneric', 'genericdatafields');
$data['data_fields'] = $this->data_fields;
$defaultaddress = $this->config->getValue('Main', 'defaultadr');
if (! $defaultaddress) {
$db_out =& $row;
}
$content = null;
$i = 0;
$aliases_groups = $this->config->getValue('Main', 'groupsalias');
foreach ($visible_groups as $group_id => $group) {
if ($grouping) {
if ($query_order == '') {
$query_order = ' ORDER BY su.position';
}
$query = 'SELECT ui.raum, ui.sprechzeiten, ui.Telefon, inst_perms, Email, aum.user_id, ';
$query .= 'username, aum.Vorname, title_front, title_rear, ';
$query .= $GLOBALS['_fullname_sql'][$nameformat] . " AS fullname, aum.Nachname ";
$query .= 'FROM statusgruppe_user su LEFT JOIN auth_user_md5 aum USING(user_id) ';
$query .= 'LEFT JOIN user_info USING(user_id) LEFT JOIN user_inst ui USING(user_id) ';
$query .= "WHERE su.statusgruppe_id = ? AND ".get_ext_vis_query()." AND Institut_id = ? $query_order";
$parameters = array($group_id, $this->config->range_id );
$statement = DBManager::get()->prepare($query);
$statement->execute($parameters);
$row = $statement->fetch(PDO::FETCH_ASSOC);
if($aliases_groups[$group_id]) {
$group = $aliases_groups[$group_id];
}
}
if ($row !== false) {
if($aliases_groups[$group_id]) {
$content['PERSONS']['GROUP'][$i]['GROUPTITLE-SUBSTITUTE'] = ExternModule::ExtHtmlReady($aliases_groups[$group_id]);
}
$content['PERSONS']['GROUP'][$i]['GROUPTITLE'] = ExternModule::ExtHtmlReady($group);
$content['PERSONS']['GROUP'][$i]['GROUP-NO'] = $i + 1;
$j = 0;
do{
$visibilities = get_local_visibility_by_id($row['user_id'], 'homepage', true);
$user_perm = $visibilities['perms'];
$visibilities = json_decode($visibilities['homepage'], true);
if ($defaultaddress) {
$query = 'SELECT ui.raum, ui.sprechzeiten, ui.Telefon, inst_perms, Email, ';
$query .= 'title_front, title_rear, ';
$query .= 'aum.user_id, username, ' . $GLOBALS['_fullname_sql'][$nameformat];
$query .= ' AS fullname, aum.Nachname, aum.Vorname FROM auth_user_md5 aum LEFT JOIN ';
$query .= 'user_info USING(user_id) LEFT JOIN ';
$query .= "user_inst ui USING(user_id) WHERE aum.user_id = '" . $row['user_id'];
$query .= "' AND ".get_ext_vis_query().' AND externdefault = 1';
$statement2 = DBManager::get()->prepare($query);
$statement2->execute();
$db_out = $statement2->fetch(PDO::FETCH_ASSOC);
//no default
if ($db_out === false) {
$query = 'SELECT ui.raum, ui.sprechzeiten, ui.Telefon, inst_perms, Email, ';
$query .= 'title_front, title_rear, ';
$query .= 'aum.user_id, username, ' . $GLOBALS['_fullname_sql'][$nameformat];
$query .= ' AS fullname, aum.Nachname, aum.Vorname FROM auth_user_md5 aum LEFT JOIN ';
$query .= 'user_info USING(user_id) LEFT JOIN ';
$query .= "user_inst ui USING(user_id) WHERE aum.user_id = '" . $row['user_id'];
$query .= "' AND ".get_ext_vis_query()." AND Institut_id = ? " ;
$statement2 = DBManager::get()->prepare($query);
$params = array($this->config->range_id);
$statement2->execute($params);
$db_out = $statement2->fetch(PDO::FETCH_ASSOC);
}
}
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['FULLNAME'] = ExternModule::ExtHtmlReady($db_out['fullname']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['LASTNAME'] = ExternModule::ExtHtmlReady($db_out['Nachname']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['FIRSTNAME'] = ExternModule::ExtHtmlReady($db_out['Vorname']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['TITLEFRONT'] = ExternModule::ExtHtmlReady($db_out['title_front']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['TITLEREAR'] = ExternModule::ExtHtmlReady($db_out['title_rear']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['PERSONDETAIL-HREF'] = $this->elements['LinkInternTemplate']->createUrl(array('link_args' => 'username='******'username']));
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['USERNAME'] = $db_out['username'];
if (is_element_visible_externally( $row['user_id'], $user_perm, 'picture', $visibilities['picture'])) {
$avatar = Avatar::getAvatar($db_out['user_id']);
} else {
$avatar = Avatar::getNobody();
}
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['IMAGE-URL-SMALL'] = $avatar->getURL(Avatar::SMALL);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['IMAGE-URL-MEDIUM'] = $avatar->getURL(Avatar::MEDIUM);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['IMAGE-URL-NORMAL'] = $avatar->getURL(Avatar::NORMAL);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['PHONE'] = ExternModule::ExtHtmlReady($db_out['Telefon']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['ROOM'] = ExternModule::ExtHtmlReady($db_out['raum']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL'] = get_visible_email($row['user_id']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL-LOCAL'] = array_shift(explode('@', $content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL']));
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL-DOMAIN'] = array_pop(explode('@', $content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL']));
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['OFFICEHOURS'] = ExternModule::ExtHtmlReady($db_out['sprechzeiten']);
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['PERSON-NO'] = $j + 1;
// generic data fields
if (is_array($generic_datafields)) {
$localEntries = DataFieldEntry::getDataFieldEntries($db_out['user_id'], 'user');
#$datafields = $datafields_obj->getLocalFields($db_out->f('user_id'));
$k = 1;
foreach ($generic_datafields as $datafield) {
if (isset($localEntries[$datafield]) &&
is_object($localEntries[$datafield] &&
is_element_visible_externally($db_out['user_id'],
$user_perm, $localEntries[$datafield]->getId(),
$visibilities[$localEntries[$datafield]->getId()]))) {
if ($localEntries[$datafield]->getType() == 'link') {
$localEntry = ExternModule::extHtmlReady($localEntries[$datafield]->getValue());
} else {
$localEntry = $localEntries[$datafield]->getDisplayValue();
}
if ($localEntry) {
$content['PERSONS']['GROUP'][$i]['PERSON'][$j]['DATAFIELD_' . $k] = $localEntry;
}
}
$k++;
}
}
$j++;
}while ($row = $statement->fetch(PDO::FETCH_ASSOC));
}
$i++;
}
return $content;
}
