function getSecondaryColumns($Options, $module, $ogReport = "")
{
if ($ogReport == "") {
if (ITS4YouReports::isStoredITS4YouReport() === true) {
$ogReport = ITS4YouReports::getStoredITS4YouReport();
} else {
$ogReport = new ITS4YouReports($recordid);
}
}
global $app_list_strings, $app_strings;
global $current_language;
$adb = PearDatabase::getInstance();
if (!isset($ogReport->module_list) || empty($ogReport->module_list)) {
$ogReport->initListOfModules();
}
if ($module != "") {
$secmodule = explode(":", $module);
for ($i = 0; $i < count($secmodule); $i++) {
$module_prefix = $secmodule[$i];
$secmodule_arr = explode("x", $secmodule[$i]);
$module_id = $secmodule_arr[0];
$field_id = isset($secmodule_arr[1]) && $secmodule_arr[1] != "" ? $secmodule_arr[1] : "";
$fieldname = $opt_fieldname = "";
$modulename = vtlib_getModuleNameById($module_id);
if ($field_id != "" && is_numeric($field_id)) {
$fieldname_row = $adb->fetchByAssoc($adb->pquery("SELECT fieldlabel FROM vtiger_field WHERE fieldid=?", array($field_id)), 0);
$fieldname = " " . $fieldname_row["fieldlabel"];
$opt_fieldname = " (" . vtranslate($fieldname_row["fieldlabel"], $ogReport->primarymodule) . ")";
} elseif ($field_id == "INV") {
$fieldname = " Inventory";
$opt_fieldname = " (Inventory)";
} elseif ($field_id == "MIF") {
$fieldname = " More Information";
$opt_fieldname = " (" . vtranslate('LBL_MORE_INFORMATION', "Users") . ")";
}
//$mod_strings = return_module_language($current_language, $modulename);
if (vtlib_isModuleActive($modulename)) {
$block_listed = array();
if (isset($_REQUEST["primarymoduleid"]) && $_REQUEST["primarymoduleid"] == 26) {
$campaignstatus_listed = false;
}
foreach ($ogReport->module_list[$modulename] as $key => $value) {
if (!isset($ogReport->sec_module_columnslist)) {
$ogReport->getSecModuleColumnsList($module);
}
if (isset($ogReport->sec_module_columnslist[$modulename . $fieldname][$value]) && !$block_listed[$value]) {
$block_listed[$value] = true;
$optgroup = $app_list_strings['moduleList'][$modulename] . " - " . vtranslate($value) . $opt_fieldname;
foreach ($ogReport->sec_module_columnslist[$modulename . $fieldname][$value] as $field => $fieldlabel) {
//if (isset($mod_strings[$fieldlabel]))
// $fieldlabel = $mod_strings[$fieldlabel];
$fieldlabel = vtranslate($fieldlabel, $modulename);
// s$Options[$module_id][$optgroup][] = array("value" => $field, "text" => $fieldlabel);
$Options[$module_prefix][$optgroup][] = array("value" => $field, "text" => $fieldlabel);
}
if ($campaignstatus_listed !== true && isset($_REQUEST["primarymoduleid"]) && $_REQUEST["primarymoduleid"] == 26 && in_array($modulename, array("Leads", "Contacts", "Accounts"))) {
$campaignrelstatus_option = "vtiger_campaignrelstatus_{$field_id}:campaignrelstatus:" . $modulename . "_campaignrelstatus:Status:V:{$field_id}";
$campaignrelstatus_label = vtranslate("Campaign") . " " . vtranslate("Status");
$Options[$module_prefix][$optgroup][] = array("value" => $campaignrelstatus_option, "text" => $campaignrelstatus_label);
$campaignstatus_listed = true;
}
}
}
$access_count_listed = false;
if ($_REQUEST["primarymoduleid"] != $_REQUEST["selectedmodule"] && $access_count_listed !== true && in_array($modulename, array("Calendar"))) {
$optgroup = $app_list_strings['moduleList'][$modulename] . " - " . vtranslate("Email Information", "ITS4YouReports");
$access_count_option = "access_count_{$field_id}:access_count:" . $modulename . "_access_count:Access Count:V:{$field_id}";
$access_count_label = vtranslate("Emails") . " " . vtranslate("Access Count");
$Options[$module_prefix][$optgroup][] = array("value" => $access_count_option, "text" => $access_count_label);
$access_count_listed = true;
} elseif ($access_count_listed !== true && in_array($modulename, array("Calendar"))) {
$optgroup = $app_list_strings['moduleList'][$modulename] . " - " . vtranslate("Email Information", "ITS4YouReports");
$access_count_option = "access_count:access_count:" . $modulename . "_access_count:Access Count:V";
$access_count_label = vtranslate("Emails") . " " . vtranslate("Access Count");
$Options[$module_prefix][$optgroup][] = array("value" => $access_count_option, "text" => $access_count_label);
$access_count_listed = true;
}
}
}
}
return $Options;
}
