/** gives the role info, role profile info and role user info details in an array for the specified role id
* @param $roleid -- role id:: Type integer
* @returns $return_data -- array contains role info, role profile info and role user info. This array is used to construct the detail view for the specified role id :: Type varchar
*
*/
function getStdOutput($roleid)
{
//Retreiving the related vtiger_profiles
$roleProfileArr = getRoleRelatedProfiles($roleid);
//Retreving the related vtiger_users
$roleUserArr = getRoleUsers($roleid);
//Constructing the Profile list
$profileinfo = array();
foreach ($roleProfileArr as $profileId => $profileName) {
$profileinfo[] = $profileId;
$profileinfo[] = $profileName;
$profileList .= '<a href="index.php?module=Settings&action=profilePrivileges&profileid=' . $profileId . '">' . $profileName . '</a>';
}
$profileinfo = array_chunk($profileinfo, 2);
//Constructing the Users List
$userinfo = array();
foreach ($roleUserArr as $userId => $userName) {
$userinfo[] = $userId;
$userinfo[] = $userName;
$userList .= '<a href="index.php?module=Settings&action=DetailView&record=' . $userId . '">' . $userName . '</a>';
}
$userinfo = array_chunk($userinfo, 2);
//Check for Current User
global $current_user;
$current_role = fetchUserRole($current_user->id);
$return_data = array('profileinfo' => $profileinfo, 'userinfo' => $userinfo);
return $return_data;
}
/** to get all the parent vtiger_groups of the specified group
* @params $groupId --> Group Id :: Type Integer
* @returns updates the parent group in the varibale $parent_groups of the class
*/
function getAllUserGroups($userid)
{
$adb = PearDatabase::getInstance();
$log = vglobal('log');
$log->debug("Entering getAllUserGroups(" . $userid . ") method...");
//Retreiving from the user2grouptable
$query = "select * from vtiger_users2group where userid=?";
$result = $adb->pquery($query, array($userid));
$num_rows = $adb->num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
$now_group_id = $adb->query_result($result, $i, 'groupid');
if (!in_array($now_group_id, $this->user_groups)) {
$this->user_groups[] = $now_group_id;
}
}
//Setting the User Role
$userRole = fetchUserRole($userid);
//Retreiving from the vtiger_user2role
$query = "select * from vtiger_group2role where roleid=?";
$result = $adb->pquery($query, array($userRole));
$num_rows = $adb->num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
$now_group_id = $adb->query_result($result, $i, 'groupid');
if (!in_array($now_group_id, $this->user_groups)) {
$this->user_groups[] = $now_group_id;
}
}
//Retreiving from the user2rs
$parentRoles = getParentRole($userRole);
$parentRolelist = array();
foreach ($parentRoles as $par_rol_id) {
array_push($parentRolelist, $par_rol_id);
}
array_push($parentRolelist, $userRole);
$query = "select * from vtiger_group2rs where roleandsubid in (" . generateQuestionMarks($parentRolelist) . ")";
$result = $adb->pquery($query, array($parentRolelist));
$num_rows = $adb->num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
$now_group_id = $adb->query_result($result, $i, 'groupid');
if (!in_array($now_group_id, $this->user_groups)) {
$this->user_groups[] = $now_group_id;
}
}
foreach ($this->user_groups as $grp_id) {
$focus = new GetParentGroups();
$focus->getAllParentGroups($grp_id);
foreach ($focus->parent_groups as $par_grp_id) {
if (!in_array($par_grp_id, $this->user_groups)) {
$this->user_groups[] = $par_grp_id;
}
}
}
$log->debug("Exiting getAllUserGroups method...");
}
/**
* this function takes in an array of values for an user and sanitizes it for export
* @param array $arr - the array of values
*/
function sanitizeValues($arr)
{
global $current_user, $adb;
$roleid = fetchUserRole($current_user->id);
foreach ($arr as $fieldlabel => &$value) {
$fieldInfo = $this->fieldsArr[$fieldlabel];
$uitype = $fieldInfo['uitype'];
$fieldname = $fieldInfo['fieldname'];
if ($uitype == 15 || $uitype == 16 || $uitype == 33) {
//picklists
if (empty($this->picklistValues[$fieldname])) {
$this->picklistValues[$fieldname] = getAssignedPicklistValues($fieldname, $roleid, $adb);
}
$value = trim($value);
} elseif ($uitype == 10) {
//have to handle uitype 10
$value = trim($value);
if (!empty($value)) {
$parent_module = getSalesEntityType($value);
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $k => $v) {
$displayValue = $v;
}
}
if (!empty($parent_module) && !empty($displayValue)) {
$value = $parent_module . "::::" . $displayValue;
} else {
$value = "";
}
} else {
$value = '';
}
}
}
return $arr;
}
/**
* this function takes in an array of values for an user and sanitizes it for export
* @param array $arr - the array of values
*/
function sanitizeValues($arr)
{
global $current_user, $adb;
$roleid = fetchUserRole($current_user->id);
$decimal = $current_user->currency_decimal_separator;
$numsep = $current_user->currency_grouping_separator;
foreach ($arr as $fieldlabel => &$value) {
$fieldInfo = $this->fieldsArr[$fieldlabel];
$uitype = $fieldInfo['uitype'];
$fieldname = $fieldInfo['fieldname'];
if ($uitype == 15 || $uitype == 16 || $uitype == 33) {
//picklists
if (empty($this->picklistValues[$fieldname])) {
$this->picklistValues[$fieldname] = getAssignedPicklistValues($fieldname, $roleid, $adb);
}
$value = trim($value);
} elseif ($uitype == 10) {
//have to handle uitype 10
$value = trim($value);
if (!empty($value)) {
$parent_module = getSalesEntityType($value);
$displayValueArray = getEntityName($parent_module, $value);
if (!empty($displayValueArray)) {
foreach ($displayValueArray as $k => $v) {
$displayValue = $v;
}
}
if (!empty($parent_module) && !empty($displayValue)) {
$value = $parent_module . "::::" . $displayValue;
} else {
$value = "";
}
} else {
$value = '';
}
} elseif ($uitype == 71 || $uitype == 72) {
$value = CurrencyField::convertToUserFormat($value, null, true);
} elseif ($uitype == 7 || $fieldInfo['typeofdata'] == 'N~O' || $uitype == 9) {
$value = number_format($value, 2, $decimal, $numsep);
}
}
return $arr;
}
/** Creates a file with all the user, user-role,user-profile, user-groups informations
* @param $userid -- user id:: Type integer
* @returns user_privileges_userid file under the user_privileges directory
*/
function createUserPrivilegesfile($userid)
{
global $root_directory;
$handle = @fopen($root_directory . 'user_privileges/user_privileges_' . $userid . '.php', "w+");
if ($handle) {
$newbuf = '';
$newbuf .= "<?php\n\n";
$newbuf .= "\n";
$newbuf .= "//This is the access privilege file\n";
$user_focus = new Users();
$user_focus->retrieve_entity_info($userid, "Users");
$userInfo = array();
$user_focus->column_fields["id"] = '';
$user_focus->id = $userid;
foreach ($user_focus->column_fields as $field => $value_iter) {
$userInfo[$field] = $user_focus->{$field};
}
if ($user_focus->is_admin == 'on') {
$newbuf .= "\$is_admin=true;\n";
$newbuf .= "\n";
$newbuf .= "\$user_info=" . constructSingleStringKeyValueArray($userInfo) . ";\n";
$newbuf .= "\n";
$newbuf .= "?>";
fputs($handle, $newbuf);
fclose($handle);
return;
} else {
$newbuf .= "\$is_admin=false;\n";
$newbuf .= "\n";
$globalPermissionArr = getCombinedUserGlobalPermissions($userid);
$tabsPermissionArr = getCombinedUserTabsPermissions($userid);
//$tabsPermissionArr=getCombinedUserTabsPermissions($userid);
$actionPermissionArr = getCombinedUserActionPermissions($userid);
$user_role = fetchUserRole($userid);
$user_role_info = getRoleInformation($user_role);
$user_role_parent = $user_role_info[$user_role][1];
$userGroupFocus = new GetUserGroups();
$userGroupFocus->getAllUserGroups($userid);
$subRoles = getRoleSubordinates($user_role);
$subRoleAndUsers = getSubordinateRoleAndUsers($user_role);
$def_org_share = getDefaultSharingAction();
$parentRoles = getParentRole($user_role);
$newbuf .= "\$current_user_roles='" . $user_role . "';\n";
$newbuf .= "\n";
$newbuf .= "\$current_user_parent_role_seq='" . $user_role_parent . "';\n";
$newbuf .= "\n";
$newbuf .= "\$current_user_profiles=" . constructSingleArray(getUserProfile($userid)) . ";\n";
$newbuf .= "\n";
$newbuf .= "\$profileGlobalPermission=" . constructArray($globalPermissionArr) . ";\n";
$newbuf .= "\n";
$newbuf .= "\$profileTabsPermission=" . constructArray($tabsPermissionArr) . ";\n";
$newbuf .= "\n";
$newbuf .= "\$profileActionPermission=" . constructTwoDimensionalArray($actionPermissionArr) . ";\n";
$newbuf .= "\n";
$newbuf .= "\$current_user_groups=" . constructSingleArray($userGroupFocus->user_groups) . ";\n";
$newbuf .= "\n";
$newbuf .= "\$subordinate_roles=" . constructSingleCharArray($subRoles) . ";\n";
$newbuf .= "\n";
$newbuf .= "\$parent_roles=" . constructSingleCharArray($parentRoles) . ";\n";
$newbuf .= "\n";
$newbuf .= "\$subordinate_roles_users=" . constructTwoDimensionalCharIntSingleArray($subRoleAndUsers) . ";\n";
$newbuf .= "\n";
$newbuf .= "\$user_info=" . constructSingleStringKeyValueArray($userInfo) . ";\n";
$newbuf .= "?>";
fputs($handle, $newbuf);
fclose($handle);
}
}
}
/** This function is to retreive the vtiger_profiles associated with the the specified user
* It takes the following input parameters:
* $userid -- The User Id:: Type Integer
* This function will return the vtiger_profiles associated to the specified vtiger_users in an Array in the following format:
* $userProfileArray=(profileid1,profileid2,profileid3,...,profileidn);
*/
function getUserProfile($userId)
{
$log = vglobal('log');
$log->debug("Entering getUserProfile(" . $userId . ") method ...");
$adb = PearDatabase::getInstance();
$roleId = fetchUserRole($userId);
$profArr = array();
$sql1 = "select profileid from vtiger_role2profile where roleid=?";
$result1 = $adb->pquery($sql1, array($roleId));
$num_rows = $adb->num_rows($result1);
for ($i = 0; $i < $num_rows; $i++) {
$profileid = $adb->query_result($result1, $i, "profileid");
$profArr[] = $profileid;
}
$log->debug("Exiting getUserProfile method ...");
return $profArr;
}
function getUserIDS($viewscope = "all_to_me")
{
global $log;
$log->debug("Entering getUserIDS() method ...");
global $current_user;
if (empty($viewscope)) {
$viewscope = "all_to_me";
}
$key = "sqluserids_" . $viewscope . "_" . $current_user->id;
$userIDS = getSqlCacheData($key);
if (!$userIDS) {
global $adb;
$sec_query = "";
$userIDS = '';
if ($viewscope == "all_to_me") {
$sec_query = "select id as userid from ec_users where status='Active'";
$result = $adb->getList($sec_query);
$userIDS .= '(';
$i = 0;
foreach ($result as $row) {
$userid = $row['userid'];
if ($i != 0) {
$userIDS .= ', ';
}
$userIDS .= $userid;
$i++;
}
if ($userIDS != '(') {
$userIDS .= ', ' . $current_user->id;
} else {
$userIDS .= $current_user->id;
}
$userIDS .= ')';
} elseif ($viewscope == "sub_user") {
if (!isset($current_user_parent_role_seq) || $current_user_parent_role_seq == "") {
$current_user_parent_role_seq = fetchUserRole($current_user->id);
}
$sec_query = "select ec_user2role.userid from ec_user2role inner join ec_users on ec_users.id=ec_user2role.userid inner join ec_role on ec_role.roleid=ec_user2role.roleid where ec_role.parentrole like '%" . $current_user_parent_role_seq . "::%'";
$result = $adb->getList($sec_query);
$userIDS .= '(';
$i = 0;
foreach ($result as $row) {
$userid = $row['userid'];
if ($i != 0) {
$userIDS .= ', ';
}
$userIDS .= $userid;
$i++;
}
$userIDS .= ')';
} elseif ($viewscope == "current_user") {
$userIDS .= '(' . $current_user->id;
$userIDS .= ')';
} elseif ($viewscope == "current_group") {
$sec_query .= "select ec_users2group.userid from ec_users2group where ec_users2group.groupid in " . getCurrentUserGroupList() . "";
$result = $adb->getList($sec_query);
$userIDS .= '(';
$i = 0;
foreach ($result as $row) {
$userid = $row['userid'];
if ($i != 0) {
$userIDS .= ', ';
}
$userIDS .= $userid;
$i++;
}
$userIDS .= ')';
} else {
$userIDS .= '(' . $viewscope . ')';
}
setSqlCacheData($key, $userIDS);
}
if ($userIDS == "()") {
$userIDS = "(-1)";
}
$log->debug("Exiting getUserIDS method ...");
return $userIDS;
}
function GetPicklistValues($username, $sessionid, $tablename)
{
global $current_user, $log, $adb;
if (!validateSession($username, $sessionid)) {
return null;
}
require_once "modules/Users/Users.php";
$seed_user = new Users();
$user_id = $seed_user->retrieve_user_id($username);
$current_user = $seed_user;
$current_user->retrieve_entity_info($user_id, 'Users');
require_once "include/utils/UserInfoUtil.php";
$roleid = fetchUserRole($user_id);
checkFileAccessForInclusion('user_privileges/user_privileges_' . $current_user->id . '.php');
require 'user_privileges/user_privileges_' . $current_user->id . '.php';
if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
$query = "select " . $adb->sql_escape_string($tablename) . " from vtiger_" . $adb->sql_escape_string($tablename);
$result1 = $adb->pquery($query, array());
for ($i = 0; $i < $adb->num_rows($result1); $i++) {
$output[$i] = decode_html($adb->query_result($result1, $i, $tablename));
}
} else {
if (isPermitted("HelpDesk", "EditView") == "yes" && CheckFieldPermission($tablename, 'HelpDesk') == 'true') {
$query = "select " . $adb->sql_escape_string($tablename) . " from vtiger_" . $adb->sql_escape_string($tablename) . " inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_" . $adb->sql_escape_string($tablename) . ".picklist_valueid where roleid=? and picklistid in (select picklistid from vtiger_" . $adb->sql_escape_string($tablename) . " ) order by sortid";
$result1 = $adb->pquery($query, array($roleid));
for ($i = 0; $i < $adb->num_rows($result1); $i++) {
$output[$i] = decode_html($adb->query_result($result1, $i, $tablename));
}
} else {
$output[] = 'Not Accessible';
}
}
return $output;
}
/**
* Function creates HTML to display number of Events, Todos and pending list in calendar under header(Eg:Total Events : 5, 2 Pending / Total To Dos: 4, 1 Pending)
* @param array $cal_arr - collection of objects and strings
* @param string $viewBox - string 'listview' or 'hourview'. if 'listview' means Events ListView.if 'hourview' means Events HourView.
*/
function get_cal_header_data(&$cal_arr, $viewBox, $subtab)
{
global $mod_strings, $cal_log, $current_user, $adb, $theme;
$cal_log->debug("Entering get_cal_header_data() method...");
global $current_user, $app_strings;
$date_format = $current_user->date_format;
$format = $cal_arr['calendar']->hour_format;
$hour_startat = timeString(array('hour' => date('H:i', time() + 5 * 60), 'minute' => 0), '24');
$hour_endat = timeString(array('hour' => date('H:i', time() + 60 * 60), 'minute' => 0), '24');
$time_arr = getaddEventPopupTime($hour_startat, $hour_endat, $format);
$temp_ts = $cal_arr['calendar']->date_time->ts;
//To get date in user selected format
$temp_date = $date_format == 'dd-mm-yyyy' ? date('d-m-Y', $temp_ts) : ($date_format == 'mm-dd-yyyy' ? date('m-d-Y', $temp_ts) : ($date_format == 'yyyy-mm-dd' ? date('Y-m-d', $temp_ts) : ''));
if ($current_user->column_fields['is_admin'] == 'on') {
$Res = $adb->pquery("select * from vtiger_activitytype", array());
} else {
$roleid = $current_user->roleid;
$subrole = getRoleSubordinates($roleid);
if (count($subrole) > 0) {
$roleids = $subrole;
array_push($roleids, $roleid);
} else {
$roleids = $roleid;
}
if (count($roleids) > 1) {
$Res = $adb->pquery("select distinct activitytype from vtiger_activitytype inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_activitytype.picklist_valueid where roleid in (" . generateQuestionMarks($roleids) . ") and picklistid in (select picklistid from vtiger_activitytype) order by sortid asc", array($roleids));
} else {
$Res = $adb->pquery("select distinct activitytype from vtiger_activitytype inner join vtiger_role2picklist on vtiger_role2picklist.picklistvalueid = vtiger_activitytype.picklist_valueid where roleid = ? and picklistid in (select picklistid from vtiger_activitytype) order by sortid asc", array($roleid));
}
}
$eventlist = '';
for ($i = 0; $i < $adb->num_rows($Res); $i++) {
$eventlist .= $adb->query_result($Res, $i, 'activitytype') . ";";
}
$headerdata = "";
$headerdata .= "\n\t\t\t<div style='display: block;' id='mnuTab'>\n\t\t\t<form name='EventViewOption' method='POST' action='index.php' style='display:inline;'>\n\t\t\t<input type='hidden' id='complete_view' name='complete_view' value='' />\n\t\t\t<table align='center' border='0' cellpadding='5' cellspacing='0' width='98%'>\n\t\t\t<tr><td colspan='3'> </td></tr>";
if (isPermitted("Calendar", "EditView") == "yes") {
$headerdata .= "<tr>\n\t\t\t\t<td>\n\t\t\t\t<table><tr><td class='calAddButton' style='cursor:pointer;height:30px' align='center' width='15%' onMouseOver='fnAddEvent(this,\"addEventDropDown\",\"" . $temp_date . "\",\"" . $temp_date . "\",\"" . $time_arr['starthour'] . "\",\"" . $time_arr['startmin'] . "\",\"" . $time_arr['startfmt'] . "\",\"" . $time_arr['endhour'] . "\",\"" . $time_arr['endmin'] . "\",\"" . $time_arr['endfmt'] . "\",\"" . $viewBox . "\",\"" . $subtab . "\",\"" . $eventlist . "\");'>\n\t\t\t\t\t" . $mod_strings['LBL_ADD'] . "\n\t\t\t\t\t<img src='" . vtiger_imageurl('menuDnArrow.gif', $theme) . "' style='padding-left: 5px;' border='0'>\n\t\t\t\t</td></tr></table> </td>";
} else {
$headerdata .= "<tr><td> </td>";
}
$headerdata .= "<td align='center' width='43%'><span id='total_activities'>";
//USER SELECT CUSTOMIZATION
$headerdata .= getEventInfo($cal_arr, 'listcnt');
$headerdata .= "</span></td>\n\t\t\t\t<td align='center' width='40%'><table border=0 cellspacing=0 cellpadding=2><tr><td class=small><b>" . $mod_strings['LBL_VIEW'] . " : </b></td><td>";
//USER SELECT CUSTOMIZATION
$view_options = getEventViewOption($cal_arr, $viewBox);
// User Select Customization
$view_options .= calendarview_getUserSelectOptions(calendarview_getSelectedUserId());
// END
$groups_view = "<span><b>Group : </b></span><select name=\"f_groups\">";
$groups_view .= "<option value=\"default_view\">-- none --</option>";
$user_groups = array();
$currrentUserid = calendarview_getSelectedUserId();
//Retreiving from the user2grouptable
$query = "select vtiger_groups.groupname from vtiger_users2group\n\t\tleft join vtiger_groups on (vtiger_users2group.groupid = vtiger_groups.groupid)\n\t\twhere vtiger_users2group.userid =?";
$result = $adb->pquery($query, array($currrentUserid));
$num_rows = $adb->num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
$user_groups[] = $adb->query_result($result, $i, 'groupname');
$groups_name = $adb->query_result($result, $i, 'groupname');
$groups_view .= "<option value=\"{$i}\">{$groups_name}</option>";
}
//Setting the User Role
$currentUserRole = fetchUserRole($currrentUserid);
//Retreiving from the vtiger_user2role
$query = "select vtiger_groups.groupname from vtiger_group2role\n\t\tleft join vtiger_groups on (vtiger_group2role.groupid = vtiger_groups.groupid)\n\t\twhere vtiger_group2role.roleid =?";
$result = $adb->pquery($query, array($currentUserRole));
$num_rows = $adb->num_rows($result);
for ($i = 0; $i < $num_rows; $i++) {
$groups_name = $adb->query_result($result, $i, 'groupname');
if (!in_array($groups_name, $user_groups)) {
$groups_view .= "<option value=\"{$i}\">{$groups_name}</option>";
}
}
$groups_view .= "</select>";
$groups_view .= $now_group_id;
$headerdata .= $view_options . $groups_view . "</td></tr></table>\n\t\t\t\t</td>\n\t\t\t</tr>\n\t\t</table></form>";
echo $headerdata;
$cal_log->debug("Exiting get_cal_header_data() method...");
}
