|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/public_html/crm/modules/Settings/Groups/models/ |
Upload File : |
<?php
/*+***********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*************************************************************************************/
/**
* Roles Record Model Class
*/
class Settings_Groups_Member_Model extends Vtiger_Base_Model {
const MEMBER_TYPE_USERS = 'Users';
const MEMBER_TYPE_GROUPS = 'Groups';
const MEMBER_TYPE_ROLES = 'Roles';
const MEMBER_TYPE_ROLE_AND_SUBORDINATES = 'RoleAndSubordinates';
const GROUP_MODE = 'GROUPS';
const CUSTOM_VIEW_MODE = 'CV';
const REPORTS_VIEW_MODE = 'RP';
public static $groupTables = array(self::MEMBER_TYPE_USERS => array('table'=>'vtiger_users2group','index'=>'groupid','refIndex'=>'userid'),
self::MEMBER_TYPE_GROUPS => array('table'=>'vtiger_group2grouprel','index'=>'groupid','refIndex'=>'containsgroupid'),
self::MEMBER_TYPE_ROLES => array('table'=>'vtiger_group2role' ,'index'=>'groupid','refIndex'=>'roleid'),
self::MEMBER_TYPE_ROLE_AND_SUBORDINATES => array('table'=>'vtiger_group2rs' ,'index'=>'groupid','refIndex'=>'roleandsubid'));
public static $cvTables = array(self::MEMBER_TYPE_USERS => array('table'=>'vtiger_cv2users','index'=>'cvid','refIndex'=>'userid'),
self::MEMBER_TYPE_GROUPS => array('table'=>'vtiger_cv2group','index'=>'cvid','refIndex'=>'groupid'),
self::MEMBER_TYPE_ROLES => array('table'=>'vtiger_cv2role' ,'index'=>'cvid','refIndex'=>'roleid'),
self::MEMBER_TYPE_ROLE_AND_SUBORDINATES => array('table'=>'vtiger_cv2rs' ,'index'=>'cvid','refIndex'=>'rsid'));
public static $reportTables = array(self::MEMBER_TYPE_USERS => array('table'=>'vtiger_report_shareusers','index'=>'reportid','refIndex'=>'userid'),
self::MEMBER_TYPE_GROUPS => array('table'=>'vtiger_report_sharegroups','index'=>'reportid','refIndex'=>'groupid'),
self::MEMBER_TYPE_ROLES => array('table'=>'vtiger_report_sharerole' ,'index'=>'reportid','refIndex'=>'roleid'),
self::MEMBER_TYPE_ROLE_AND_SUBORDINATES => array('table'=>'vtiger_report_sharers' ,'index'=>'reportid','refIndex'=>'rsid'));
/**
* Function to get the Qualified Id of the Group Member
* @return <Number> Id
*/
public function getId() {
return $this->get('id');
}
public function getIdComponents() {
return explode(':', $$this->getId());
}
public function getMemberType() {
$idComponents = $this->getIdComponents();
if($idComponents && count($idComponents) > 0) {
return $idComponents[0];
}
return false;
}
public function getMemberId() {
$idComponents = $this->getIdComponents();
if($idComponents && count($idComponents) > 1) {
return $idComponents[1];
}
return false;
}
/**
* Function to get the Group Name
* @return <String>
*/
public function getName() {
return $this->get('name');
}
/**
* Function to get the Group Name
* @return <String>
*/
public function getQualifiedName() {
return $this->getMemberType().' - '.$this->get('name');
}
public static function getIdComponentsFromQualifiedId($id) {
return explode(':', $id);
}
public static function getQualifiedId($type, $id) {
return $type.':'.$id;
}
public static function getAllByTypeForGroup($groupModel, $type, $mode = self::GROUP_MODE) {
$db = PearDatabase::getInstance();
$members = array();
if($mode == self::GROUP_MODE) {
$tables = self::$groupTables;
}else if($mode == 'CV') {
$tables = self::$cvTables;
} else if($mode == 'RP'){
$tables = self::$reportTables;
}
if($type == self::MEMBER_TYPE_USERS) {
$tableName = $tables[self::MEMBER_TYPE_USERS]['table'];
$tableIndex = $tables[self::MEMBER_TYPE_USERS]['index'];
$refIndex = $tables[self::MEMBER_TYPE_USERS]['refIndex'];
$sql = "SELECT vtiger_users.id, vtiger_users.last_name, vtiger_users.first_name FROM vtiger_users
INNER JOIN $tableName ON $tableName.$refIndex = vtiger_users.id
WHERE $tableName.$tableIndex = ?";
$params = array($groupModel->getId());
$result = $db->pquery($sql, $params);
$noOfUsers = $db->num_rows($result);
for($i=0; $i<$noOfUsers; ++$i) {
$row = $db->query_result_rowdata($result, $i);
$userId = $row['id'];
$qualifiedId = self::getQualifiedId(self::MEMBER_TYPE_USERS, $userId);
$name = getFullNameFromArray('Users', $row);
$member = new self();
$members[$qualifiedId] = $member->set('id', $qualifiedId)->set('name', $name)->set('userId', $userId);
}
}
if($type == self::MEMBER_TYPE_GROUPS) {
$tableName = $tables[self::MEMBER_TYPE_GROUPS]['table'];
$tableIndex = $tables[self::MEMBER_TYPE_GROUPS]['index'];
$refIndex = $tables[self::MEMBER_TYPE_GROUPS]['refIndex'];
$sql = "SELECT vtiger_groups.groupid, vtiger_groups.groupname FROM vtiger_groups
INNER JOIN $tableName ON $tableName.$refIndex = vtiger_groups.groupid
WHERE $tableName.$tableIndex = ?";
$params = array($groupModel->getId());
$result = $db->pquery($sql, $params);
$noOfGroups = $db->num_rows($result);
for($i=0; $i<$noOfGroups; ++$i) {
$row = $db->query_result_rowdata($result, $i);
$qualifiedId = self::getQualifiedId(self::MEMBER_TYPE_GROUPS, $row['groupid']);
$name = $row['groupname'];
$member = new self();
$members[$qualifiedId] = $member->set('id', $qualifiedId)->set('name', $name)->set('groupId', $row['groupid']);
}
}
if($type == self::MEMBER_TYPE_ROLES) {
$tableName = $tables[self::MEMBER_TYPE_ROLES]['table'];
$tableIndex = $tables[self::MEMBER_TYPE_ROLES]['index'];
$refIndex = $tables[self::MEMBER_TYPE_ROLES]['refIndex'];
$sql = "SELECT vtiger_role.roleid, vtiger_role.rolename FROM vtiger_role
INNER JOIN $tableName ON $tableName.$refIndex = vtiger_role.roleid
WHERE $tableName.$tableIndex = ?";
$params = array($groupModel->getId());
$result = $db->pquery($sql, $params);
$noOfRoles = $db->num_rows($result);
for($i=0; $i<$noOfRoles; ++$i) {
$row = $db->query_result_rowdata($result, $i);
$qualifiedId = self::getQualifiedId(self::MEMBER_TYPE_ROLES, $row['roleid']);
$name = $row['rolename'];
$member = new self();
$members[$qualifiedId] = $member->set('id', $qualifiedId)->set('name', $name)->set('roleId', $row['roleid']);
}
}
if($type == self::MEMBER_TYPE_ROLE_AND_SUBORDINATES) {
$tableName = $tables[self::MEMBER_TYPE_ROLE_AND_SUBORDINATES]['table'];
$tableIndex = $tables[self::MEMBER_TYPE_ROLE_AND_SUBORDINATES]['index'];
$refIndex = $tables[self::MEMBER_TYPE_ROLE_AND_SUBORDINATES]['refIndex'];
$sql = "SELECT vtiger_role.roleid, vtiger_role.rolename FROM vtiger_role
INNER JOIN $tableName ON $tableName.$refIndex = vtiger_role.roleid
WHERE $tableName.$tableIndex = ?";
$params = array($groupModel->getId());
$result = $db->pquery($sql, $params);
$noOfRoles = $db->num_rows($result);
for($i=0; $i<$noOfRoles; ++$i) {
$row = $db->query_result_rowdata($result, $i);
$qualifiedId = self::getQualifiedId(self::MEMBER_TYPE_ROLE_AND_SUBORDINATES, $row['roleid']);
$name = $row['rolename'];
$member = new self();
$members[$qualifiedId] = $member->set('id', $qualifiedId)->set('name', $name)->set('roleId', $row['roleid']);
}
}
return $members;
}
/**
* Function to get Detail View Url of this member
* return <String> url
*/
public function getDetailViewUrl() {
list($type, $recordId) = self::getIdComponentsFromQualifiedId($this->getId());
switch ($type) {
case 'Users' : $recordModel = Users_Record_Model::getCleanInstance($type);
$recordModel->setId($recordId);
return $recordModel->getDetailViewUrl();
case 'RoleAndSubordinates' :
case 'Roles' : $recordModel = new Settings_Roles_Record_Model();
$recordModel->set('roleid', $recordId);
return $recordModel->getEditViewUrl();
case 'Groups' : $recordModel = new Settings_Groups_Record_Model();
$recordModel->setId($recordId);
return $recordModel->getDetailViewUrl();
}
}
/**
* Function to get all the groups
* @return <Array> - Array of Settings_Groups_Record_Model instances
*/
public static function getAllByGroup($groupModel,$mode = self::GROUP_MODE) {
$db = PearDatabase::getInstance();
$members = array();
$members[self::MEMBER_TYPE_USERS] = self::getAllByTypeForGroup($groupModel, self::MEMBER_TYPE_USERS,$mode);
$members[self::MEMBER_TYPE_GROUPS] = self::getAllByTypeForGroup($groupModel, self::MEMBER_TYPE_GROUPS,$mode);
$members[self::MEMBER_TYPE_ROLES] = self::getAllByTypeForGroup($groupModel, self::MEMBER_TYPE_ROLES,$mode);
$members[self::MEMBER_TYPE_ROLE_AND_SUBORDINATES] = self::getAllByTypeForGroup($groupModel, self::MEMBER_TYPE_ROLE_AND_SUBORDINATES,$mode);
return $members;
}
/**
* Function to get all the groups
* @return <Array> - Array of Settings_Groups_Record_Model instances
*/
public static function getAll($onlyActive=true) {
$members = array();
$allUsers = Users_Record_Model::getAll($onlyActive);
foreach($allUsers as $userId => $userModel) {
$qualifiedId = self::getQualifiedId(self::MEMBER_TYPE_USERS, $userId);
$member = new self();
$members[self::MEMBER_TYPE_USERS][$qualifiedId] = $member->set('id', $qualifiedId)->set('name', $userModel->getName());
}
$allGroups = Settings_Groups_Record_Model::getAll();
foreach($allGroups as $groupId => $groupModel) {
$qualifiedId = self::getQualifiedId(self::MEMBER_TYPE_GROUPS, $groupId);
$member = new self();
$members[self::MEMBER_TYPE_GROUPS][$qualifiedId] = $member->set('id', $qualifiedId)->set('name', $groupModel->getName());
}
$allRoles = Settings_Roles_Record_Model::getAll();
foreach($allRoles as $roleId => $roleModel) {
$qualifiedId = self::getQualifiedId(self::MEMBER_TYPE_ROLES, $roleId);
$member = new self();
$members[self::MEMBER_TYPE_ROLES][$qualifiedId] = $member->set('id', $qualifiedId)->set('name', $roleModel->getName());
$qualifiedId = self::getQualifiedId(self::MEMBER_TYPE_ROLE_AND_SUBORDINATES, $roleId);
$member = new self();
$members[self::MEMBER_TYPE_ROLE_AND_SUBORDINATES][$qualifiedId] = $member->set('id', $qualifiedId)->set('name', $roleModel->getName());
}
return $members;
}
}