/**
* Function to get customfield entries
* @param string $module - Module name
* return array $cflist - customfield entries
*/
function getCFListEntries($module)
{
global $adb, $app_strings, $theme, $smarty, $log;
$tabid = getTabid($module);
if ($module == 'Calendar') {
$tabid = array(9, 16);
}
$theme_path = "themes/" . $theme . "/";
$image_path = "themes/images/";
$dbQuery = "select fieldid,columnname,fieldlabel,uitype,displaytype,block,vtiger_convertleadmapping.cfmid,tabid from vtiger_field left join vtiger_convertleadmapping on vtiger_convertleadmapping.leadfid = vtiger_field.fieldid where tabid in (" . generateQuestionMarks($tabid) . ") and vtiger_field.presence in (0,2) and generatedtype = 2 order by sequence";
$result = $adb->pquery($dbQuery, array($tabid));
$row = $adb->fetch_array($result);
$count = 1;
$cflist = array();
if ($row != '') {
do {
$cf_element = array();
$cf_element['no'] = $count;
$cf_element['label'] = getTranslatedString($row["fieldlabel"], $module);
$fld_type_name = getCustomFieldTypeName($row["uitype"]);
$cf_element['type'] = $fld_type_name;
$cf_tab_id = $row["tabid"];
if ($module == 'Leads') {
$mapping_details = getListLeadMapping($row["cfmid"]);
$cf_element[] = $mapping_details['accountlabel'];
$cf_element[] = $mapping_details['contactlabel'];
$cf_element[] = $mapping_details['potentiallabel'];
}
if ($module == 'Calendar') {
if ($cf_tab_id == '9') {
$cf_element['activitytype'] = getTranslatedString('Task', $module);
} else {
$cf_element['activitytype'] = getTranslatedString('Event', $module);
}
}
if ($module == 'Calendar') {
$cf_element['tool'] = ' <img style="cursor:pointer;" onClick="deleteCustomField(' . $row["fieldid"] . ',\'' . $module . '\', \'' . $row["columnname"] . '\', \'' . $row["uitype"] . '\')" src="' . vtiger_imageurl('delete.gif', $theme) . '" border="0" alt="' . $app_strings['LBL_DELETE_BUTTON_LABEL'] . '" title="' . $app_strings['LBL_DELETE_BUTTON_LABEL'] . '"/></a>';
}
$cflist[] = $cf_element;
$count++;
} while ($row = $adb->fetch_array($result));
}
return $cflist;
}
/**
* Function to get customfield entries for leads
* @param string $module - Module name
* return array $cflist - customfield entries
*/
function getCFLeadMapping($module)
{
global $adb, $app_strings, $theme, $smarty, $log;
$tabid = getTabid($module);
$theme_path = "themes/" . $theme . "/";
$image_path = "themes/images/";
$dbQuery = "SELECT fieldid,columnname,fieldlabel,uitype,displaytype,block,vtiger_convertleadmapping.cfmid,vtiger_convertleadmapping.editable,tabid FROM vtiger_convertleadmapping LEFT JOIN vtiger_field\n\t\t\t\tON vtiger_field.fieldid=vtiger_convertleadmapping.leadfid \n\t\t\t\tWHERE tabid IN (" . generateQuestionMarks($tabid) . ")\n\t\t\t\tAND vtiger_field.presence IN (0,2)\n\t\t\t\tAND generatedtype IN (1,2)\n\t\t\t\tAND vtiger_field.fieldname NOT IN('assigned_user_id','createdtime','modifiedtime','lead_no','modifiedby','campaignrelstatus')\n\t\t\t\tORDER BY vtiger_field.fieldlabel";
$result = $adb->pquery($dbQuery, array($tabid));
$row = $adb->fetch_array($result);
$count = 1;
$cflist = array();
if ($row != '') {
do {
$cf_element = array();
$cf_element['map']['no'] = $count;
$cf_element['map']['label'] = getTranslatedString($row["fieldlabel"], $module);
$fld_type_name = getCustomFieldTypeName($row["uitype"]);
$cf_element['map']['type'] = $fld_type_name;
$cf_tab_id = $row["tabid"];
$cf_element['cfmid'] = $row["cfmid"];
$cf_element['editable'] = $row["editable"];
if ($module == 'Leads') {
$mapping_details = getListLeadMapping($row["cfmid"]);
$cf_element['map'][] = $mapping_details['accountlabel'];
$cf_element['map'][] = $mapping_details['contactlabel'];
$cf_element['map'][] = $mapping_details['potentiallabel'];
}
$cflist[] = $cf_element;
$count++;
} while ($row = $adb->fetch_array($result));
}
return $cflist;
}
