/** Function to get permitted fields of current user of a particular module to find duplicate records --Pavani*/ function getMergeFields($module, $str) { global $adb, $current_user; $tabid = getTabid($module); if ($str == "available_fields") { $result = getFieldsResultForMerge($tabid); } else { //if($str == fileds_to_merge) $sql = "select * from vtiger_user2mergefields where tabid=? and userid=? and visible=1"; $result = $adb->pquery($sql, array($tabid, $current_user->id)); } $num_rows = $adb->num_rows($result); $user_profileid = fetchUserProfileId($current_user->id); $permitted_list = getProfile2FieldPermissionList($module, $user_profileid); $sql_def_org = "select fieldid from vtiger_def_org_field where tabid=? and visible=0"; $result_def_org = $adb->pquery($sql_def_org, array($tabid)); $num_rows_org = $adb->num_rows($result_def_org); $permitted_org_list = array(); for ($i = 0; $i < $num_rows_org; $i++) { $permitted_org_list[$i] = $adb->query_result($result_def_org, $i, "fieldid"); } require 'user_privileges/user_privileges_' . $current_user->id . '.php'; for ($i = 0; $i < $num_rows; $i++) { $field_id = $adb->query_result($result, $i, "fieldid"); foreach ($permitted_list as $field => $data) { if ($data[4] == $field_id and $data[1] == 0) { if ($is_admin == 'true' || in_array($field_id, $permitted_org_list)) { $field = "<option value=\"" . $field_id . "\">" . getTranslatedString($data[0], $module) . "</option>"; $fields .= $field; break; } } } } return $fields; }
function insertUser2mergefields($userid) { global $log, $adb; $log->debug("Entering insertUser2mergefields(" . $userid . ") method ..."); $log->info("in insertUser2mergefields " . $userid); //$this->db->database->SetFetchMode(ADODB_FETCH_ASSOC); $tab_res = $adb->query("SELECT distinct tabid FROM vtiger_tab"); $noOfTabs = $adb->num_rows($tab_res); for ($i = 0; $i < $noOfTabs; $i++) { $tab_id = $this->db->query_result($tab_res, $i, 'tabid'); $fld_result = getFieldsResultForMerge($tab_id); if ($fld_result != null) { $num_rows = $this->db->num_rows($fld_result); for ($j = 0; $j < $num_rows; $j++) { $field_id = $this->db->query_result($fld_result, $j, 'fieldid'); $data_type = explode("~", $this->db->query_result($fld_result, $j, 'typeofdata')); if ($data_type[1] == 'M') { $visible = 1; $this->db->query("insert into vtiger_user2mergefields values ({$userid}, {$tab_id}, {$field_id}, {$visible})"); } } } } $log->debug("Exiting insertUser2mergefields method ..."); }
function insertUser2mergefields($userid, $tabid) { global $log, $adb; $log->debug("Entering insertUser2mergefields(" . $userid . ") method ..."); $log->info("in insertUser2mergefields " . $userid); foreach ($tabid as $key => $tab_id) { $fld_result = getFieldsResultForMerge($tab_id); if ($fld_result != null) { $num_rows = $adb->num_rows($fld_result); for ($j = 0; $j < $num_rows; $j++) { $field_id = $adb->query_result($fld_result, $j, 'fieldid'); $data_type = explode("~", $adb->query_result($fld_result, $j, 'typeofdata')); if ($data_type[1] == 'M') { $visible = 1; } else { $visible = 2; } ExecuteQuery("insert into vtiger_user2mergefields values ({$userid}, {$tab_id}, {$field_id}, {$visible})"); } } } $log->debug("Exiting insertUser2mergefields method ..."); }