quote($login); $sql .= " AND u.status = 1"; $res = $mdb2->query($sql); if (is_a($res, 'PEAR_Error')) { return; } $val = $res->fetchRow(); if ($val['id'] > 0) { $this->login = $val['login']; $this->name = $val['name']; $this->id = $val['id']; $this->team_id = $val['team_id']; $this->role = $val['role']; $this->client_id = $val['client_id']; $this->email = $val['email']; $this->lang = $val['lang']; $this->decimal_mark = $val['decimal_mark']; $this->date_format = $val['date_format']; $this->time_format = $val['time_format']; $this->week_start = $val['week_start']; $this->tracking_mode = $val['tracking_mode']; $this->project_required = $val['project_required']; $this->task_required = $val['task_required']; $this->record_type = $val['record_type']; $this->bcc_email = $val['bcc_email']; $this->team = $val['team_name']; $this->currency = $val['currency']; $this->plugins = $val['plugins']; $this->lock_spec = $val['lock_spec']; $this->workday_minutes = $val['workday_minutes']; $this->custom_logo = $val['custom_logo']; $this->config = $val['config']; $config_array = explode(',', $this->config); // Set user config options. $this->roles = in_array('roles', $config_array); $this->show_holidays = in_array('show_holidays', $config_array); $this->punch_mode = in_array('punch_mode', $config_array); $this->allow_overlap = in_array('allow_overlap', $config_array); $this->future_entries = in_array('future_entries', $config_array); $this->uncompleted_indicators = in_array('uncompleted_indicators', $config_array); // Set "on behalf" id and name. if (isset($_SESSION['behalf_id'])) { $this->behalf_id = $_SESSION['behalf_id']; $this->behalf_name = $_SESSION['behalf_name']; } // Set user rights. if ($this->role == ROLE_USER) { $this->rights = right_data_entry|right_view_charts|right_view_reports; // TODO: get customized rights from the database instead. // $this->rights_array[] = "data_entry"; // Enter time and expense records into Time Tracker. // $this->rights_array[] = "view_own_data"; // View own reports and charts. // $this->rights_array[] = "manage_own_settings"; // Edit own settings. // $this->rights_array[] = "view_users"; // View user names and roles in a group. } elseif ($this->role == ROLE_CLIENT) { $this->rights = right_view_reports|right_view_invoices; // TODO: how about right_view_charts, too? // $this->rights_array[] = "view_own_data"; // View own reports, charts, and invoices. // $this->rights_array[] = "manage_own_settings"; // Edit own settings. } elseif ($this->role == ROLE_COMANAGER) { $this->rights = right_data_entry|right_view_charts|right_view_reports|right_view_invoices|right_manage_team; // $this->rights_array[] = "data_entry"; // Enter time and expense records into Time Tracker. // $this->rights_array[] = "view_own_data"; // View own reports and charts. // $this->rights_array[] = "manage_own_settings"; // Edit own settings. // $this->rights_array[] = "view_users"; // View user names and roles in a group. // $this->rights_array[] = "on_behalf_data_entry";// Can enter data on behalf of lower roles. // $this->rights_array[] = "view_data"; // Can view data for lower roles. $this->rights_array[] = "override_punch_mode"; // Can input any start and finish times for self and lower roles. // TODO: get rights from the database instead. } elseif ($this->role == ROLE_MANAGER) { $this->rights = right_data_entry|right_view_charts|right_view_reports|right_view_invoices|right_manage_team|right_assign_roles|right_export_team; $this->rights_array[] = "override_punch_mode"; // Can input any start and finish times for self and lower roles. } elseif ($this->role == ROLE_SITE_ADMIN) { $this->rights = right_administer_site; } /* // TODO: redesign of user rights and roles is currently ongoing. // As we run our of bits for sure at some point, rights should be strings instead, // for example: "data_entry". // Also, we need rights editor page and team-customized roles. // Move this stuff from here to ttUser class. // // User access rights - bits that collectively define an access mask to the system (a role). // We'll have some bits here (1,2, etc...) reserved for future use. define('right_data_entry', 4); // Right to enter work hours and expenses. define('right_view_charts', 8); // Right to view charts. define('right_view_reports', 16); // Right to view reports. define('right_view_invoices', 32); // Right to view invoices. define('right_manage_team', 64); // Right to manage team. Note that this is not full access to team. define('right_assign_roles', 128); // Right to assign user roles. define('right_export_team', 256); // Right to export team data to a file. define('right_administer_site', 1024); // Admin account right to manage the application as a whole. // User roles. define('ROLE_USER', 4); // Regular user. define('ROLE_CLIENT', 16); // Client (to view reports and invoices). define('ROLE_COMANAGER', 68); // Team co-manager. Can do many things but not as much as team manager. define('ROLE_MANAGER', 324); // Team manager. Can do everything for a team. define('ROLE_SITE_ADMIN', 1024); // Site administrator. */ } } // The getActiveUser returns user id on behalf of whom current user is operating. function getActiveUser() { return ($this->behalf_id ? $this->behalf_id : $this->id); } // isAdmin - determines whether current user is admin (has right_administer_site). function isAdmin() { return (right_administer_site & $this->role); } // isManager - determines whether current user is team manager. function isManager() { return (ROLE_MANAGER == $this->role); } // isCoManager - determines whether current user is team comanager. function isCoManager() { return (ROLE_COMANAGER == $this->role); } // isClient - determines whether current user is a client. function isClient() { return (ROLE_CLIENT == $this->role); } // canManageTeam - determines whether current user is manager or co-manager. function canManageTeam() { return (right_manage_team & $this->role); } // isPluginEnabled checks whether a plugin is enabled for user. function isPluginEnabled($plugin) { return in_array($plugin, explode(',', $this->plugins)); } // getAssignedProjects - returns an array of assigned projects. function getAssignedProjects() { $result = array(); $mdb2 = getConnection(); // Do a query with inner join to get assigned projects. $sql = "select p.id, p.name, p.description, p.tasks, upb.rate from tt_projects p inner join tt_user_project_binds upb on (upb.user_id = ".$this->getActiveUser()." and upb.project_id = p.id and upb.status = 1) where p.team_id = $this->team_id and p.status = 1 order by p.name"; $res = $mdb2->query($sql); if (!is_a($res, 'PEAR_Error')) { while ($val = $res->fetchRow()) { $result[] = $val; } } return $result; } // isDateLocked checks whether a specifc date is locked for modifications. function isDateLocked($date) { if ($this->isPluginEnabled('lk') && $this->lock_spec) { // Override for managers. if ($this->canManageTeam()) return false; require_once(LIBRARY_DIR.'/tdcron/class.tdcron.php'); require_once(LIBRARY_DIR.'/tdcron/class.tdcron.entry.php'); // Calculate the last occurrence of a lock. $last = tdCron::getLastOccurrence($this->lock_spec, time()); $lockdate = new DateAndTime(DB_DATEFORMAT, strftime('%Y-%m-%d', $last)); if ($date->before($lockdate)) { return true; } } return false; } }