/**
*
*/
function getDefaultConfig () {
if ($groups = get_all_statusgruppen($this->config->range_id))
$groups = "|" . implode("|", array_keys($groups));
else
$groups = "";
$config = array(
"name" => "",
"order" => "|0|1|2|3|4",
"visible" => "|1|1|1|1|1",
"aliases" => "|"._("Name")."|"._("Telefon")."|"._("Raum")."|"._("Email")."|"._("Sprechzeiten"),
"width" => "|30%|15%|15%|20%|20%",
"widthpp" => "",
"sort" => "|1|0|0|0|0",
"groupsalias" => "",
"groupsvisible" => $groups,
"grouping" => "1",
"wholesite" => "",
"nameformat" => "",
"repeatheadrow" => "",
"urlcss" => "",
"title" => _("MitarbeiterInnen"),
"nodatatext" => "",
"config" => "",
"srilink" => "",
"copyright" => htmlReady($GLOBALS['UNI_NAME_CLEAN']
. " ({$GLOBALS['UNI_CONTACT']})"),
"author" => "",
"defaultadr" => ''
);
get_default_generic_datafields($config, "user");
return $config;
}
/**
*
*/
function getDefaultConfig () {
if ($groups = get_all_statusgruppen($this->config->range_id))
$groups = '|' . implode('|', array_keys($groups));
else
$groups = '';
$config = array(
'name' => '',
'sort' => '|1|0|0|0|0',
'groupsalias' => '',
'groupsvisible' => $groups,
'nameformat' => '',
// 'nodatatext' => '',
'defaultadr' => ''
);
return $config;
}
function editGroups () {
$groups_db = get_all_statusgruppen($this->config->range_id);
if (!$groups_db)
return FALSE;
$title = _("Gruppen auswählen:");
$info = _("Wählen Sie die Statusgruppen aus, die ausgegeben werden sollen.");
$groups_config = $this->getValue("groups");
// this value is always necessary, even there is an error in the users inputs, so
// it isn't transfered via $_POST
$this->form_values[$this->element_name . "_groupsvisible"]
= $this->config->getValue($this->element_name, "groupsvisible");
// initialize groups if this value isn't set in the config file
if (!$groups_config) {
$groups_config = array_keys($groups_db);
}
$groups_aliases = $this->getValue("groupsalias");
$groups_visible = $this->getValue("groupsvisible");
if (!is_array($groups_visible))
$groups_visible = array();
if (!is_array($groups_aliases))
$groups_aliases = array();
if (sizeof(array_intersect(array_keys($groups_aliases),
array_keys($groups_db)))) {
foreach ($groups_config as $group_config) {
$groups[$group_config] = $groups_aliases[$group_config];
}
} else {
for ($i = 0; $i < sizeof($groups_config); $i++) {
$groups[$groups_config[$i]] = $groups_aliases[$i];
}
}
$this->css->resetClass();
$this->css->switchClass();
$out = "<tr><td><table width=\"100%\" border=\"0\" cellpadding=\"2\" cellspacing=\"0\">\n";
$out .= "<tr" . $this->css->getFullClass() . ">\n";
$out .= "<td width=\"42%\"><font size=\"2\"><b>" . _("Gruppenname") . "</b></font></td>\n";
$out .= "<td width=\"48%\"><font size=\"2\"><b>" . _("alternativer Gruppenname") . "</b></font></td>\n";
$out .= "<td width=\"1%\"><font size=\"2\"><b>" . _("Sichtbarkeit") . "</b></font></td>\n";
$out .= "<td width=\"9%\"><font size=\"2\"> </font></td>\n";
$out .= "</tr>\n";
$this->css->switchClass();
$i = 0;
foreach ($groups_db as $id => $name) {
// name of group
$out .= "<tr" . $this->css->getFullClass() . ">\n";
$out .= "<td nowrap=\"nowrap\"><font size=\"2\"> " . htmlReady($name) . "</font></td>";
// column headline
$out .= '<td nowrap="nowrap"><input type="text" name="'
. $this->element_name . '_groupsalias[' . $id . ']"';
$out .= "\" size=\"25\" maxlength=\"150\" value=\"";
$out .= $groups[$id] . "\">";
if ($this->faulty_values[$this->element_name . "_groupsalias"][$id])
$out .= $this->error_sign;
$out .= "</td>\n";
// visible
$out .= '<td align="center">'
. '<input type="hidden" name="'
. $this->element_name . '_show_group[' . $id . ']" value="0">'
. '<input type="checkbox" name="'
. $this->element_name . '_show_group[' . $id . ']" value="1"';
if (in_array($id, $groups_visible)) {
$out .= ' checked';
}
$out .= '></td>';
$out .= "<td> </td></tr>\n";
$this->css->switchClass();
$i++;
}
$out .= "</table>\n</td></tr>\n";
return $out;
}
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
// +---------------------------------------------------------------------------+
require_once 'lib/user_visible.inc.php';
global $_fullname_sql;
// [tlx] We are not inside a class definition, so where does $this refer to?
$range_id = $this->config->range_id;
//$all_groups = $this->config->getValue("Main", "groups");
if (!$all_groups = get_all_statusgruppen($range_id)) {
die($GLOBALS['EXTERN_ERROR_MESSAGE']);
} else {
$all_groups = array_keys($all_groups);
}
if (Request::get('visible_groups')) {
$group_ids = explode(',', Request::get('visible_groups'));
} else {
$group_ids = $this->config->getValue('Main', 'groupsvisible');
}
if (!$group_ids) {
die($GLOBALS['EXTERN_ERROR_MESSAGE']);
} else {
$group_ids = array_intersect($all_groups, $group_ids);
}
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;
}
