X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=WEB-INF%2Flib%2FttUser.class.php;h=e50d9a3ea2fe3a15ea413315c48b86a03a94fa30;hb=f05a2db179417c20c7d841f0363bca4988c8a2ca;hp=7a37109ebc7cc5db08aecf1245c01dc0147b9377;hpb=8b1efafeb5921f14235cf45cf58ef404700141aa;p=timetracker.git diff --git a/WEB-INF/lib/ttUser.class.php b/WEB-INF/lib/ttUser.class.php index 7a37109e..e50d9a3e 100644 --- a/WEB-INF/lib/ttUser.class.php +++ b/WEB-INF/lib/ttUser.class.php @@ -27,6 +27,7 @@ // +----------------------------------------------------------------------+ import('ttConfigHelper'); +import('ttGroupHelper'); class ttUser { var $login = null; // User login. @@ -379,14 +380,14 @@ class ttUser { if ($selected_group_id != $this->group_id) { // We are in one of subgroups, and a parent exists. // Get parent group info. - $sql = "select parent_id from tt_groups where org_id = $this->org_id and id = $selected_group_id"; + $sql = "select parent_id from tt_groups where org_id = $this->org_id and id = $selected_group_id and status = 1"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow(); $parent_id = $val['parent_id']; if ($parent_id) { // Get parent group name. - $sql = "select name from tt_groups where org_id = $this->org_id and id = $parent_id"; + $sql = "select name from tt_groups where org_id = $this->org_id and id = $parent_id and status = 1"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { $val = $res->fetchRow(); @@ -400,21 +401,25 @@ class ttUser { $groups[] = array('id'=>$selected_group_id,'name'=>$selected_group_name); // Add subgroups. - $sql = "select id, name from tt_groups where org_id = $this->org_id and parent_id = $selected_group_id"; + $sql = "select id, name from tt_groups where org_id = $this->org_id and parent_id = $selected_group_id and status = 1"; + //die($sql); $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { - $groups[] = array('id'=>$val['id'],'name'=>$val['name']); + $groups[] = $val; } } return $groups; } // getSubgroups obtains a list of immediate subgroups. - function getSubgroups() { + function getSubgroups($group_id = null) { $mdb2 = getConnection(); - $sql = "select id, name, description from tt_groups where org_id = $this->org_id and parent_id = ".$this->getActiveGroup();; + if (!$group_id) $group_id = $this->getActiveGroup(); + + $sql = "select id, name, description from tt_groups where org_id = $this->org_id". + " and parent_id = $group_id and status is not null order by upper(name)"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { @@ -504,10 +509,16 @@ class ttUser { if (!($this->can('manage_basic_settings') || $this->can('manage_advanced_settings') || $this->can('manage_features'))) return false; + // TODO: update the above for subgroup updates. + + $group_id = $fields['group_id']; + if ($group_id && !$this->isGroupValid($group_id)) return false; $mdb2 = getConnection(); + if (!$group_id) $group_id = $this->getActiveGroup(); if (isset($fields['name'])) $name_part = ', name = '.$mdb2->quote($fields['name']); + if (isset($fields['description'])) $description_part = ', description = '.$mdb2->quote($fields['description']); if (isset($fields['currency'])) $currency_part = ', currency = '.$mdb2->quote($fields['currency']); if (isset($fields['lang'])) $lang_part = ', lang = '.$mdb2->quote($fields['lang']); if (isset($fields['decimal_mark'])) $decimal_mark_part = ', decimal_mark = '.$mdb2->quote($fields['decimal_mark']); @@ -528,11 +539,11 @@ class ttUser { if (isset($fields['workday_minutes'])) $workday_minutes_part = ', workday_minutes = '.$mdb2->quote($fields['workday_minutes']); $modified_part = ', modified = now(), modified_ip = '.$mdb2->quote($_SERVER['REMOTE_ADDR']).', modified_by = '.$mdb2->quote($this->id); - $parts = trim($name_part.$currency_part.$lang_part.$decimal_mark_part.$date_format_part. + $parts = trim($name_part.$description_part.$currency_part.$lang_part.$decimal_mark_part.$date_format_part. $time_format_part.$week_start_part.$tracking_mode_part.$task_required_part.$project_required_part.$record_type_part. $bcc_email_part.$allow_ip_part.$plugins_part.$config_part.$lock_spec_part.$workday_minutes_part.$modified_part, ','); - $sql = "update tt_groups set $parts where id = $this->group_id"; + $sql = "update tt_groups set $parts where id = $group_id and org_id = $this->org_id"; $affected = $mdb2->exec($sql); if (is_a($affected, 'PEAR_Error')) return false; @@ -599,6 +610,14 @@ class ttUser { return true; } + // isGroupValid determines if a group is valid for user. + function isGroupValid($group_id) { + if ($group_id == $this->group_id) + return true; + else + return $this->isSubgroupValid($group_id); + } + // isSubgroupValid determines if a subgroup is valid for user. // A subgroup is valid if: // - user can manage_subgroups; @@ -633,4 +652,57 @@ class ttUser { return $max_rank; } + + // getUserPartForHeader constructs a string for user to display on pages header. + // It changes with "on behalf" attributes for both user and group. + function getUserPartForHeader() { + global $i18n; + if (!$this->id) return null; + + $user_part = htmlspecialchars($this->name); + $user_part .= ' - '.htmlspecialchars($this->role_name); + if ($this->behalf_id) { + $user_part .= ' '.$i18n->get('label.on_behalf').' '.htmlspecialchars($this->behalf_name).''; + } + if ($this->behalf_group_id) { + $user_part .= ', '.$i18n->get('label.on_behalf').' '.htmlspecialchars($this->behalf_group_name).''; + } else { + if ($this->group_name) // Note: we did not require group names in the past. + $user_part .= ', '.$this->group_name; + } + return $user_part; + } + + // setOnBehalfGroup sets on behalf group for the user in both the object and the session. + function setOnBehalfGroup($group_id) { + + // Unset things first. + $this->behalf_group_id = null; + $this->behalf_group_name = null; + unset($_SESSION['behalf_group_id']); + unset($_SESSION['behalf_group_name']); + + // Do not do anything if we don't have rights. + if (!$this->can('manage_subgroups')) return; + + // No need to set if the group is our home group. + if ($group_id == $this->group_id) return; + + // No need to set if the subgroup is not valid. + if (!$this->isSubgroupValid($group_id)) return; + + // We are good to set on behalf group. + $onBehalfGroupName = ttGroupHelper::getGroupName($group_id); + $_SESSION['behalf_group_id'] = $group_id; + $_SESSION['behalf_group_name'] = $onBehalfGroupName; + $this->behalf_group_id = $group_id; + $this->behalf_group_name = $onBehalfGroupName; + + // Question remains whether or not we need to adjust on behalf user. + // Adjusting for now. Test it and redesign if necessary. + unset($_SESSION['behalf_id']); + unset($_SESSION['behalf_name']); + $this->adjustBehalfId(); + return; + } }