public static function getFieldsPanelHtml($database, $selectedModule, $isDynamicTable, $auditedReport, $autoRefresh, $disabledGeneralData) { global $mod_strings; $moduleFields = self::getFieldsSelectHtml($database, $selectedModule, null, $auditedReport); $moduleRelatedFields = self::getRelatedFieldsSelectHtml($database, $selectedModule, null, null, '', true, null, $auditedReport); //***********************// //***AlineaSol Premium***// //***********************// $breadcrumbTrailLink = asol_ReportsUtils::managePremiumFeature("multipleLinks", "reportFunctions.php", "getBreadcrumbTrailLink", null); $breadCrumbLinkBtn = $breadcrumbTrailLink !== false ? $breadcrumbTrailLink : ''; //***********************// //***AlineaSol Premium***// //***********************// return '<table> <tr> <td> <h4>' . $mod_strings['LBL_REPORT_MODULE_HEADER_LABEL'] . ' <span id="reportModulesTablesSpan">' . asol_ReportsManagementFunctions::getReportModuleTablesHtml($database, false, $selectedModule, $isDynamicTable, $auditedReport, $autoRefresh, true, $disabledGeneralData) . '</span></h4> </td> </tr> <tr> <td> <h4>' . $mod_strings['LBL_REPORT_FIELDS'] . '</h4> </td> </tr> <tr> <td> <div id="reportTableFieldsDiv"> ' . $moduleFields['html'] . ' </div> </td> </tr> <tr> <td> <input disabled type="button" title="' . $mod_strings['LBL_REPORT_ADD_FIELDS'] . '" class="button" id="addFieldsButton" name="addFieldsButton" value="' . $mod_strings['LBL_REPORT_ADD_FIELDS'] . '" onClick="' . $moduleFields['javascript'] . '"> <input type="button" title="' . $mod_strings['LBL_REPORT_SHOW_RELATED'] . '" class="button" style="visibility: hidden" id="show_related_button" name="show_related_button" value="' . $mod_strings['LBL_REPORT_SHOW_RELATED'] . '" onClick="getRelatedFields(false, null, null, null)"> </td> </tr> <tr> <td> <h4> ' . $mod_strings['LBL_REPORT_RELATED_FIELDS'] . $breadCrumbLinkBtn . ' </h4> </td> </tr> <tr> <td> <div id="reportTableRelatedFieldsDiv"> ' . $moduleRelatedFields['html'] . ' </div> </td> </tr> <tr> <td> <input type="button" title="' . $mod_strings['LBL_REPORT_ADD_RELATED_FIELDS'] . '" class="button" id="addRelatedFieldsButton" name="addRelatedFieldsButton" value="' . $mod_strings['LBL_REPORT_ADD_RELATED_FIELDS'] . '" onClick="' . $moduleRelatedFields['javascript'] . '"> <input type="button" title="' . $mod_strings['LBL_REPORT_SHOW_SECOND_RELATED'] . '" class="button" style="visibility: hidden" id="show_second_related_button" name="show_second_related_button" value="' . $mod_strings['LBL_REPORT_SHOW_SECOND_RELATED'] . '" onClick="getRelatedFields(true, null, null, null)"> </td> </tr> </table>'; }
require_once "modules/asol_Reports/include_basic/manageReportsFunctions.php"; $htmlTarget = $_REQUEST['htmlTarget']; $returnedHtml = ""; global $db, $mod_strings, $sugar_config, $current_user, $current_language, $timedate; $mod_strings = return_module_language($current_language, "asol_Reports"); $breadCrumbNavigation = isset($sugar_config['asolReportsBreadCrumbNavigation']) ? $sugar_config['asolReportsBreadCrumbNavigation'] : false; if ($htmlTarget == 'reportModuleTables') { $selectedDb = $_REQUEST['selectedDb']; $isSubQuery = $_REQUEST['isSubQuery'] == 'true' ? true : false; $selectedTable = isset($_REQUEST['selectedTable']) ? $_REQUEST['selectedTable'] : null; $isEditViewMode = isset($_REQUEST['isEditViewMode']) ? $_REQUEST['isEditViewMode'] == 'true' ? true : false : true; $noRestrictions = isset($_REQUEST['noRestrictions']) ? $_REQUEST['noRestrictions'] == 'true' ? true : false : false; $isDisabled = isset($_REQUEST['isDisabled']) ? $_REQUEST['isDisabled'] == 'true' ? true : false : false; $onChangeFunction = isset($_REQUEST['onChangeFunction']) ? $_REQUEST['onChangeFunction'] : null; $returnedHtml = asol_ReportsManagementFunctions::getReportModuleTablesHtml($selectedDb, $isSubQuery, $selectedTable, false, 0, 0, $isEditViewMode, $isDisabled, $noRestrictions, $onChangeFunction); } else { if ($htmlTarget == 'reportTableFields') { $selectedDb = $_REQUEST['selectedDb']; $selectedModule = $_REQUEST['selectedModule']; $selectedField = isset($_REQUEST['selectedField']) ? $_REQUEST['selectedField'] : null; $isEditViewMode = isset($_REQUEST['isEditViewMode']) ? $_REQUEST['isEditViewMode'] == 'true' ? true : false : true; $auditedReport = isset($_REQUEST['isAudited']) ? $_REQUEST['isAudited'] : 0; $isDisabled = isset($_REQUEST['isDisabled']) ? $_REQUEST['isDisabled'] == 'true' ? true : false : false; $treeMode = isset($_REQUEST['treeMode']) && $_REQUEST['treeMode'] == 'true' ? !$breadCrumbNavigation && true : false; $subQueryMode = isset($_REQUEST['subQueryMode']) ? $_REQUEST['subQueryMode'] == 'true' ? true : false : false; $moduleFields = asol_ReportsManagementFunctions::getFieldsSelectHtml($selectedDb, $selectedModule, $selectedField, $auditedReport, $isEditViewMode, $isDisabled, $treeMode, $subQueryMode); $returnedHtml = $moduleFields['html']; if ($isEditViewMode) { $returnedHtml .= '<script>$("#' . ($subQueryMode ? 'addSubFieldsButton' : 'addFieldsButton') . '").attr("onClick", "' . $moduleFields['javascript'] . '");</script>'; if ($selectedDb === '-1') {