current code from svn, revision 62608

1 files changed, 375 insertions, 0 deletions

diff --git a/lib/extern/modules/ExternModuleTemplatePersons.class.php b/lib/extern/modules/ExternModuleTemplatePersons.class.php
new file mode 100644
index 0000000..ce6290e
--- /dev/null
+++ b/lib/extern/modules/ExternModuleTemplatePersons.class.php
@@ -0,0 +1,375 @@
+<?
+# Lifter002: TODO
+# Lifter007: TODO
+# Lifter003: TODO
+# Lifter010: TODO
+/**
+* ExternModuleTemplatePersons.class.php
+*
+*
+*
+*
+* @author       Peter Thienel <thienel@data-quest.de>, Suchi & Berg GmbH <info@data-quest.de>
+* @access       public
+* @modulegroup  extern
+* @module       ExternModuleTemplatePersons
+* @package  studip_extern
+*/
+
+// +---------------------------------------------------------------------------+
+// This file is part of Stud.IP
+// ExternModuleTemplatePersons.class.php
+//
+// Copyright (C) 2007 Peter Thienel <pthienel@web.de>,
+// Suchi & Berg GmbH <info@data-quest.de>
+// +---------------------------------------------------------------------------+
+// This program is free software; you can redistribute it and/or
+// modify it under the terms of the GNU General Public License
+// as published by the Free Software Foundation; either version 2
+// of the License, or any later version.
+// +---------------------------------------------------------------------------+
+// This program is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// 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/extern/views/extern_html_templates.inc.php';
+require_once 'lib/user_visible.inc.php';
+
+class ExternModuleTemplatePersons extends ExternModule {
+
+    var $markers = [];
+
+    /**
+    *
+    */
+    function __construct ($range_id, $module_name, $config_id = NULL, $set_config = NULL, $global_id = NULL) {
+        $this->data_fields = [
+                'Nachname', 'Telefon', 'raum', 'Email', 'sprechzeiten'
+        ];
+        $this->registered_elements = [
+                'LinkInternTemplate',
+                'TemplateGeneric'
+        ];
+
+        $this->field_names =
+        [
+                _("Name"),
+                _("Telefon"),
+                _("Raum"),
+                _("E-Mail"),
+                _("Sprechzeiten")
+        ];
+
+        parent::__construct($range_id, $module_name, $config_id, $set_config, $global_id);
+    }
+
+    function setup () {
+        $this->elements['TemplateGeneric']->real_name = _("Template");
+        // Set internal link to module 'staff details'
+        $this->elements['LinkInternTemplate']->link_module_type = [2, 14];
+        $this->elements['LinkInternTemplate']->real_name = _("Verlinkung zum Modul MitarbeiterInnendetails");
+
+    }
+
+    function toStringEdit ($open_elements = '', $post_vars = '',
+            $faulty_values = '', $anker = '') {
+
+        $this->updateGenericDatafields('TemplateGeneric', 'user');
+        $this->updateGenericDatafields('TemplateGeneric', 'userinstrole');
+        $this->elements['TemplateGeneric']->markers = $this->getMarkerDescription('TemplateGeneric');
+
+        return parent::toStringEdit($open_elements, $post_vars, $faulty_values, $anker);
+    }
+
+    function getMarkerDescription ($element_name) {
+        $markers['TemplateGeneric'][] = ['<!-- BEGIN PERSONS -->', ''];
+
+        $markers['TemplateGeneric'][] = ['<!-- BEGIN NO-PERSONS -->', ''];
+        $markers['TemplateGeneric'][] = ['###NO-LECTURES-TEXT###', ''];
+        $markers['TemplateGeneric'][] = ['<!-- END NO-PERSONS -->', ''];
+
+        $markers['TemplateGeneric'][] = ['<!-- BEGIN GROUP -->', ''];
+        $markers['TemplateGeneric'][] = ['###GROUPTITLE###', ''];
+        $markers['TemplateGeneric'][] = ['###GROUPTITLE-SUBSTITUTE###', ''];
+        $markers['TemplateGeneric'][] = ['###GROUP-NO###', ''];
+
+        $markers['TemplateGeneric'][] = ['<!-- BEGIN PERSON -->', ''];
+        $markers['TemplateGeneric'][] = ['###FULLNAME###', ''];
+        $markers['TemplateGeneric'][] = ['###LASTNAME###', ''];
+        $markers['TemplateGeneric'][] = ['###FIRSTNAME###', ''];
+        $markers['TemplateGeneric'][] = ['###TITLEFRONT###', ''];
+        $markers['TemplateGeneric'][] = ['###TITLEREAR###', ''];
+        $markers['TemplateGeneric'][] = ['###PERSONDETAIL-HREF###', ''];
+        $markers['TemplateGeneric'][] = ['###USERNAME###', ''];
+        $markers['TemplateGeneric'][] = ['###IMAGE-URL-NORMAL###', _('Nutzerbild (groß)')];
+        $markers['TemplateGeneric'][] = ['###IMAGE-URL-MEDIUM###', _('Nutzerbild (mittel)')];
+        $markers['TemplateGeneric'][] = ['###IMAGE-URL-SMALL###', _('Nutzerbild (klein)')];
+        $markers['TemplateGeneric'][] = ['###PHONE###', ''];
+        $markers['TemplateGeneric'][] = ['###ROOM###', ''];
+        $markers['TemplateGeneric'][] = ['###EMAIL###', ''];
+        $markers['TemplateGeneric'][] = ['###EMAIL-LOCAL###', _("Der local-part der E-Mail-Adresse (vor dem @-Zeichen)")];
+        $markers['TemplateGeneric'][] = ['###EMAIL-DOMAIN###', _("Der domain-part der E-Mail-Adresse (nach dem @-Zeichen)")];
+        $markers['TemplateGeneric'][] = ['###HOMEPAGE-HREF###', ''];
+        $markers['TemplateGeneric'][] = ['###OFFICEHOURS###', ''];
+        $markers['TemplateGeneric'][] = ['###PERSON-NO###', ''];
+        $this->insertDatafieldMarkers('user', $markers, 'TemplateGeneric');
+        $this->insertDatafieldMarkers('userinstrole', $markers, 'TemplateGeneric');
+        $markers['TemplateGeneric'][] = ['<!-- END PERSON -->', ''];
+
+        $markers['TemplateGeneric'][] = ['<!-- END GROUP -->', ''];
+        $markers['TemplateGeneric'][] = ['<!-- END PERSONS -->', ''];
+
+        return $markers[$element_name];
+    }
+
+    function getContent ($args = NULL, $raw = FALSE) {
+        if ($raw) {
+            self::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 (count($query_order)) {
+            ksort($query_order, SORT_NUMERIC);
+            $query_order = ' ORDER BY ' . implode(',', $query_order);
+        } else {
+            $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, Home, ';
+            $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 = [$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 = [''];
+        }
+
+        // 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, Home, ';
+                $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 = [$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);
+                    $instituts_id = $this->config->range_id;
+
+                    if ($defaultaddress) {
+                        $query = 'SELECT ui.raum, ui.sprechzeiten, ui.Telefon, inst_perms,  Email, ';
+                        $query .= 'title_front, title_rear, Home, Institut_id, ';
+                        $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, Home, ';
+                            $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 = [$this->config->range_id];
+                            $statement2->execute($params);
+                            $db_out = $statement2->fetch(PDO::FETCH_ASSOC);
+                        } else {
+                            $instituts_id = $db_out['Institut_id'];
+                        }
+                    }
+                    $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(['link_args' => 'username=' . $db_out['username'] . ($grouping ? '&group_id=' . $group_id : '')]);
+                    $content['PERSONS']['GROUP'][$i]['PERSON'][$j]['USERNAME'] = $db_out['username'];
+
+                    if (Visibility::verify('picture', $row['user_id']) == 5) {
+                        $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']);
+                    $emails = explode('@', $content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL']);
+                    $content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL-LOCAL'] = array_shift($emails);
+                    $emails = explode('@', $content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL']);
+                    $content['PERSONS']['GROUP'][$i]['PERSON'][$j]['EMAIL-DOMAIN'] = array_pop($emails);
+                    if ($row['Home'] && Visibility::verify('homepage', $row['user_id'])) {
+                        $content['PERSONS']['GROUP'][$i]['PERSON'][$j]['HOMEPAGE-HREF'] = ExternModule::ExtHtmlReady(trim($row['Home']));
+                    }
+                    $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++;
+                        }
+
+                        $localEntries = DataFieldEntry::getDataFieldEntries([$db_out['user_id'], $instituts_id], 'userinstrole');
+                        if ($grouping) {
+                            $roleEntries = DataFieldEntry::getDataFieldEntries([$db_out['user_id'], $group_id], 'userinstrole');
+                            $roleEntries = array_filter($roleEntries, function($val) { return $val->getValue() !== 'default_value'; });
+                            $localEntries = $roleEntries + $localEntries;
+                        }
+                        $k = 1;
+                        foreach ($generic_datafields as $datafield) {
+                            if (isset($localEntries[$datafield]) &&
+                                    is_object($localEntries[$datafield])) {
+                                $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;
+    }
+
+    function printout ($args) {
+        if (!$language = $this->config->getValue("Main", "language"))
+            $language = "de_DE";
+        init_i18n($language);
+        echo $this->elements['TemplateGeneric']->toString(['content' => $this->getContent($args), 'subpart' => 'PERSONS']);
+
+    }
+
+    function printoutPreview () {
+        if (!$language = $this->config->getValue("Main", "language"))
+            $language = "de_DE";
+        init_i18n($language);
+
+        echo $this->elements['TemplateGeneric']->toString(['content' => $this->getContent(), 'subpart' => 'PERSONS', 'hide_markers' => FALSE]);
+
+    }
+
+}
+
+?>