| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253 |
- <?php
- public function getPairsByRole($role)
- {
- return $this->loadExtension('cmmi')->getPairsByRole($role);
- }
- public function delete($table, $userID)
- {
- if(empty($userID)) return false;
- $this->dao->update(TABLE_USER)->set('deleted')->eq(1)->where('id')->eq($userID)->exec();
- $this->loadModel('action')->create('user', $userID, 'deleted', '', ACTIONMODEL::CAN_UNDELETED);
- $user = $this->getByID($userID, 'id');
- $this->loadModel('approval')->deleteApprovalUser($user->account);
- $this->loadModel('instance');
- if(method_exists($this->instance, 'saveWaitSyncData')) $this->instance->saveWaitSyncData('user', $userID, 'del');
- return true;
- }
- /**
- * Get all members for project/execution.
- *
- * @param int $objectID
- * @access public
- * @return array
- */
- public function getAllMembers($objectID)
- {
- if(defined('TUTORIAL')) return $this->loadModel('tutorial')->getTeamMembersPairs();
- $teams = $this->loadModel('project')->getTeamMemberPairs($objectID);
- $stakeholders = $this->dao->select('t1.user, t2.realname')->from(TABLE_STAKEHOLDER)->alias('t1')
- ->leftJoin(TABLE_USER)->alias('t2')->on('t1.user=t2.account')
- ->where('t1.deleted')->eq('0')
- ->andWhere('t1.objectID')->eq($objectID)
- ->orderBy('t1.id_desc')
- ->fetchPairs();
- $whitelist = $this->dao->select('t1.*, t2.realname')->from(TABLE_ACL)->alias('t1')
- ->leftJoin(TABLE_USER)->alias('t2')->on('t1.account=t2.account')
- ->where('t1.objectID')->eq($objectID)
- ->andWhere('t1.objectType')->eq('project,sprint')
- ->andWhere('t1.type')->eq('whitelist')
- ->fetchPairs();
- $users = arrayUnion($teams, $stakeholders, $whitelist);
- if(empty($users)) return array('' => '');
- return arrayUnion(array('' => ''), $users);
- }
|